Mysql database doesn't connnect

Hosting Support
34

WHAT? Not $stmt->var_dump! var_dump($result) is correct

edit: you went wrong , i did not mean $result = $stmt->var_dump($result); change this line to var_dump($result);

1 Like
35

$result = $stmt->get_result();
var_dump($result)
$row = $result->fetch_assoc();

Parse error : syntax error, unexpected ‘$row’ (T_VARIABLE) in /home/vol15_8/epizy.com/epiz_24665691/htdocs/verwerk.php on line 107

36

use

var_dump($result);
$row = $result->fetch_assoc();

remove $result = $stmt->get_result(); at this time!

1 Like
38

remove $row = $result->fetch_assoc();

What is the value for var_dump($result);? please tell it or i cannot guess the problem
my bad. add $result = $stmt->get_result(); before var_dump :roll_eyes:

1 Like
40

it means $result is returning null. Oh. you did not closed the previous $stmt. add $stmt->close() below$persoon_id = $db->lastInsertId();

1 Like
41

Is $stmt->close() not a function? I think not.

1 Like
42

it is :neutral_face:

1 Like
43

This gives Parse error : syntax error, unexpected ‘}’ in /home/vol15_8/epizy.com/epiz_24665691/htdocs/verwerk.php on line 118

$persoon_id = $db->lastInsertId();
$stmt->close()
}

44

is not that $stmt->close();? oh no replace this with previous one.

1 Like
45

No it loads but gives this again:
bool(false)

46

then replace var_dump($stmt) with var_dump($result)

48

Try to put $result = $stmt->get_result(); before $stmt->store_result();?

1 Like
49

It is now confused like spaghetti noodles

they aren’t same. you should try the answer above me.

51

note: Never Forgot semicolon after every line

use var_dump($result); instead

For half hour. i leave you alone.

1 Like
53

I think that function works only in PDO. Try to replace lastInsertId() with insert_id to use it with MySQLi Object-Oriented.

1 Like
55

Uh oh (again)! You posted the hosting account password again! Change it to something else, then change the database password with the new one before I continue helping you!

56

Why not hiding it? He’ll have to wait for hours for DB password changing because the api about that is bugged.
Or hide it or someone will access it.

AND IT IS A FATAL THAT YOU’RE SHARING YOUR PASSWORD. AND FATALS MUST NOT BE IGNORED

Edit: I think i replied to above person mistaken (not about quote one)

1 Like
57

Changed it now, cant get into my file manager now for some reason.

59

I think we should also start with the prepared statements, so go at the first posts of the topic and do the prepared statements step again.

1 Like
61

It has lot of bugs yet. On both SQL and php codes. Before we start helping you. We’ll need to wait till admin changes password permissions for you.

Also try to upgrade your knowledge about php.

1 Like