Mysql database doesn't connnect

Hosting Support
62

Which password permissions? The database permissions are looking fine from here (the password change API should be fixed now so it doesn’t break the database permissions anymore).

2 Likes
63

The Access denied confused me. thank you for this :slight_smile:

64

With how often the password was set, shared and changed, it might just be that the password in the scripts is not the right one.

1 Like
65

Password is right,only this error now:
Fatal error : Uncaught Error: Call to undefined method mysqli_result::fetch() in /home/vol15_8/epizy.com/epiz_24665691/htdocs/reacties.php:49 Stack trace: #0 {main} thrown in /home/vol15_8/epizy.com/epiz_24665691/htdocs/reacties.php on line 49

Line 49 is this: while ($row = $result->fetch(PDO::FETCH_ASSOC)) {

$query = “SELECT reacties.id, personen.naam, personen.email, reacties.reactie, reacties.datum
FROM personen, reacties
WHERE reacties.persoon_id = personen.id
ORDER BY reacties.datum”;
$result = $db->query($query);
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
echo “

Van:
” . $row[“naam”] . "
Op:
" . $row[“datum”] . “\n”;
echo “

” . $row[“reactie”] . “\n”;
echo “ \n”;
echo “
Verwijder

\n”;
}

66

Try to use $result->fetch_assoc() instead of $result->fetch(PDO::FETCH_ASSOC).

68

Uh oh! You forgot to close the other parenthesis! Correct this:

while ($row = $result->fetch_assoc() {

with this:

while ($row = $result->fetch_assoc()) {

!

1 Like
70

Remove array($reactie_id) from $stmt->execute().

72

Try to put this before $stmt->execute();:

$stmt->bind_param("i", $reactie_id);
74

Try to put this in the $query value:

DELETE * FROM reacties WHERE id = ?
76

I think $query had an invalid MySQL statement now, and mysqli::prepare returned a boolean with value false. What tables will you be going to delete for your comments?

1 Like
78

You can see them via your phpMyAdmin, by selecting the table on which you are going to delete the values.

1 Like
80

Then try to remove the * after DELETE on the SQL query. My bad.

1 Like
83

$stmt->execute();

Edit: you also did my previous mistake!

2 Likes
85

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.