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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

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.