Karaethon Posted March 23, 2019 Share Posted March 23, 2019 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). Link to comment Share on other sites More sharing options...
mac_gyver Posted March 23, 2019 Share Posted March 23, 2019 the error is in the mysqli_connect statement call, not the posted code. Link to comment Share on other sites More sharing options...
Karaethon Posted March 23, 2019 Author Share Posted March 23, 2019 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"? Link to comment Share on other sites More sharing options...
mac_gyver Posted March 23, 2019 Share Posted March 23, 2019 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 comment Share on other sites More sharing options...
Karaethon Posted March 23, 2019 Author Share Posted March 23, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.