PHP MYSQLI Call to a member function bind_param()

Question

my code is

$query1 = "SELECT `user_id` FROM `it_user` WHERE (user_email_address = ? AND user_mobile_number_verified = NULL)";
          $stmt1 = $mysqli->prepare($query1);
          $stmt1->bind_param("s",$email);
          $stmt1->execute();
          if ($stmt1->affected_rows == 1) {
            //set registration flag to 1 stating that the users mobile number is already verified

            echo '<meta http-equiv="refresh" content="0; URL=\'../signin/\'"/>';
          }
          else
          {
            $registration_flag = 2;  
            //redirect user to error page
            //echo '<meta http-equiv="refresh" content="0; URL=\'../error/\'"/>'; 
          }

i am getting this error ::

Call to a member function bind_param() on a non-object in ***** on line 62

where as my email variable is working corrrect and also the query.

`user_mobile_number_verified = NULL` This is not prepared statement — Chay22, Apr 25 '16 at 06:58
Use IS NULL to check null as `user_mobile_number_verified IS NULL` — Saty, Apr 25 '16 at 07:01
Post your full code?? include your connection ans how you get `$email` — Saty, Apr 25 '16 at 07:12
There was an error in `prepare()`. **Output that error.** `echo $mysqli->error`. — deceze, Apr 25 '16 at 07:40

Ravi Hirani · Answer 1 · 2016-04-25T07:32:54.570

0

Use NULL safe operator and write code as below:-

  $mobile = NULL; // NOTE: no quotes - using php NULL
  $query1 = "SELECT `user_id` FROM `it_user` WHERE user_email_address = ? AND user_mobile_number_verified <=> ?";
  $stmt1 = $mysqli->prepare($query1);
  $stmt1->bind_param("s",$email);
  $stmt1->bind_param($mobile);
  $stmt1->execute();

Hope it will help you :-)

edited Apr 25 '16 at 07:32

answered Apr 25 '16 at 07:10

Ravi Hirani

6,511
1
27
42

Call to a member function bind_param() on a non-object – Ankitesh Jha Apr 25 '16 at 07:14
Check updated answer. – Ravi Hirani Apr 25 '16 at 07:20
okay, i am almost on the verge of broking now... :( – Ankitesh Jha Apr 25 '16 at 07:25
$mobile = NULL; // NOTE: no quotes - using php NULL $query1 = "SELECT `user_id` FROM `it_user` WHERE user_email_address = ? AND user_mobile_number_verified <=> ?)"; $stmt1 = $mysqli->prepare($query1); $email = "jhaankitesh@hotmail.com"; $stmt1->bind_param("s",$email); $stmt1->bind_param($mobile); $stmt1->execute(); this also didnt work – Ankitesh Jha Apr 25 '16 at 07:25
What error are you receiving? – Ravi Hirani Apr 25 '16 at 07:33
Call to a member function bind_param() on a non-object – Ankitesh Jha Apr 25 '16 at 08:16

PHP MYSQLI Call to a member function bind_param()

1 Answers1