PHP remember user (cookie)

[Joveice]

1 minute ago, leonfagan71 said:

it should print the SQL error onto the page.

Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in script.php:87 Stack trace: #0 {main} thrown in script.php on line 87

 

[leonfagan71]

15 minutes ago, Joveice said:

I don't see whats wrong, could you help?

Okay, the issue here sounds like a MySQL query failing.

could you pop single quotes before and after the question marks in the values area?

like VALUES ('?', '?', '?', '?',..........

[Joveice]

2 minutes ago, leonfagan71 said:

Okay, the issue here sounds like a MySQL query failing.

could you pop single quotes before and after the question marks in the values area?

like VALUES ('?', '?', '?', '?',..........

same error again

[leonfagan71]

5 minutes ago, Joveice said:

Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in script.php:87 Stack trace: #0 {main} thrown in script.php on line 87

 

Another thing sorry, I personally just use the variables in the query like::

mysqli_query($link, "INSERT INTO `batman` (`name`, `cool`, `level`) VALUES ('{$name}', '{$coolval}', '$level');");

[Joveice]

Just now, Joveice said:

same error again

THO it created the table in the database

[Joveice]

6 minutes ago, Joveice said:

THO it created the table in the database

and removing the ' from everything in prepare created a table and displayed this

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in script.php on line 95

 

[leonfagan71]

12 minutes ago, Joveice said:

THO it created the table in the database

that means that the mysqli_query has now succeeded.

 

Next thing to look at is the bind params bit.

INSERT INTO `newmatch` (`uid`, `t1p1`, `t1p2`, `t1p3`, `t1p4`, `t1p5`, `rank`, `date`) VALUES ('{$username}','{$player1}','{$player2}','{$player3}','{$player4}','{$player5}','{$option2}','{$date}');

can you put this into the prepare line and comment out the line with bind_param.

 

if any of the fields are blank on the database, please let me know which ones.

 

Cheers,

Leon.

[Joveice]

6 minutes ago, leonfagan71 said:

that means that the mysqli_query has now succeeded.

 

Next thing to look at is the bind params bit.

INSERT INTO `newmatch` (`uid`, `t1p1`, `t1p2`, `t1p3`, `t1p4`, `t1p5`, `rank`, `date`) VALUES ('{$username}','{$player1}','{$player2}','{$player3}','{$player4}','{$player5}','{$option2}','{$date}');

can you put this into the prepare line and comment out the line with bind_param.

 

if any of the fields are blank on the database, please let me know which ones.

 

Cheers,

Leon.

Notice: Undefined variable: username in script.php on line 86

Notice: Undefined variable: date in script.php on line 86

and uid and date is empty, (when I removed all ' they where also filled

[leonfagan71]

1 minute ago, Joveice said:

Notice: Undefined variable: username in script.php on line 86

Notice: Undefined variable: date in script.php on line 86

and uid and date is empty, (when I removed all ' they where also filled

Cool, that will explain it then.. the $date and $username are being defined after the bind_param and that is why it was failing, if you move the $date and the $username to before the prepare then it should work, then you may be able to put bind_param back in if you really want to.

 

[Joveice]

No idea again, but now it works

[leonfagan71]

1 minute ago, Joveice said:

No idea again, but now it works

Might be worth moving lines 89-90 to before the prepare statement, 85.