Jump to content
Karaethon

php to mysql, INSERT problem

Recommended Posts

Posted (edited)

I'm being given an error by mysql, "Warning: mysqli_connect() expects parameter 1 to be string, object given in /storage/...", the relevant lines are

$code = $this->GenerateCode($num);
$enCoded = password_hash($code, PASSWORD_BCRYPT);
$query = "INSERT INTO `vaults` " .
"(`Alive`, `Contents`, `Code`, `digits`, `Winning_Player_ID`, `Won_Date`, `debug`)" .
"VALUES " .
"(CONV('1', 2, 10) + 0, '0', '{$enCoded}', '$num', NULL, NULL, '{$code}')";

Followed by the mysqli_connect($this->db, $query). 

Edited by Karaethon
syntax alignment

Share this post


Link to post
Share on other sites

the error is in the mysqli_connect statement call, not the posted code.

Share this post


Link to post
Share on other sites
Posted (edited)

Palm, Face, Face, Palm. Now that you've met....

I really should have caught that, parameter 1 is not the query.

ok. so...

$insert = mysqli_connect($this->db, $query);

I'm guessing it doesn't like "$this->db"?

Edited by Karaethon

Share this post


Link to post
Share on other sites
7 minutes ago, Karaethon said:

I'm guessing it doesn't like "$this->db"?

there's no guessing in programming. it is an exact science. you must know what the input parameters are, what the statement does, and what value is returned. mysqli_connect is NOT used to execute a query.

Share this post


Link to post
Share on other sites
Posted (edited)

Face, Palm, Palm, Face.

I didn't even catch that! ok, maybe I should take a mental health day for the rest of the day.

mysqli_query, not mysqli_connect... write that 500 times on the blackboard Karæthon.

 

Edited by Karaethon

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.