Adamhumbug Posted February 4, 2019 Share Posted February 4, 2019 Hi All, I have the following code which works fine: $mysqli = new mysqli("server", "user", "pass", "database"); if($mysqli->connect_error) { exit('Could not connect'); } $sql = "SELECT customer_contactname, customer_companyname, customer_phonenumber, customer_emailaddress, customer_address1, customer_address2, customer_city, customer_postcode FROM ssm_customer WHERE customer_id = ?"; $stmt = $mysqli->prepare($sql); $stmt->bind_param("s", $_GET['q']); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($ccontname, $ccompname, $cphoneno, $cemail, $cad1, $cad2, $ccity, $cpost); $stmt->fetch(); $stmt->close(); however, when i use my dbconn.php as an include rather than the top section of this code, i get the following error: function prepare() on null The error references the following $stmt = $mysqli->prepare($sql); In my database connection file, i am using the following: $conn = mysqli_connect($db_servername, $db_username, $db_password, $db_name); This seems to be the issue and i believe i am mixing procedural and object based but not sure why there should be a difference here? when i used my database connection file, i do change $mysqli->prepare to $conn->prepare Kind Regards Link to comment Share on other sites More sharing options...
requinix Posted February 4, 2019 Share Posted February 4, 2019 The problem isn't you mixing styles. The problem is you using $mysqli in one place and $conn in another. So yes, if you use your include then you need to change your $mysqli variables to $conn variables. Link to comment Share on other sites More sharing options...
gw1500se Posted February 4, 2019 Share Posted February 4, 2019 Never mind. Requinix beat me. Link to comment Share on other sites More sharing options...
Adamhumbug Posted February 4, 2019 Author Share Posted February 4, 2019 12 minutes ago, Adamhumbug said: when i used my database connection file, i do change $mysqli->prepare to $conn->prepare Hi Requinix, is there something that i am missing? Link to comment Share on other sites More sharing options...
Adamhumbug Posted February 4, 2019 Author Share Posted February 4, 2019 Actually, you were both correct and i had a spelling mistake when i changed the code over. Thanks both Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.