php to mysql, INSERT problem

[Karaethon]

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 March 23, 2019 by Karaethon
syntax alignment

[mac_gyver]

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

[Karaethon]

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 March 23, 2019 by Karaethon

[mac_gyver]

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.

[Karaethon]

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 March 23, 2019 by Karaethon