Jump to content

php to mysql, INSERT problem


Recommended Posts

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
Link to post
Share on other sites

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
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.

Link to post
Share on other sites

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
Link to post
Share on other sites
This thread is more than a year old.

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.