Getting Error while using PHP Prepared Statement for Insert "Call to a member function bind_param() on a non-object"

Question

I'm using php prepared statement to insert into mysql database, but I'm getting:

Call to a member function bind_param() on a non-object

while trying to insert, I tried in Google and everywhere else, but I am still stuck!

$loc=$_POST['location'];
$name=$_POST['name'];
$chname=$_POST['chname'];
$address=$_POST['address'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$plan=$_POST['plan'];

$stmt = $con->prepare("INSERT INTO clinic_registration (location, clinic_name, chief_doctor,clinic_address,clinic_phone,clinic_email,clinic_plan,clinic_username,clinic_password) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");

$stmt->bind_param("ssssisiss",$loc,$name,$chname,$address,$phone,$email,$plan,$name,$name);

$stmt->execute();

Probably because your connection is not working (`$con`). Hard to tell from this. — Rasclatt, Sep 22 '15 at 07:27
`$con` probably contains nothing. You forgot to initialize the PDO. I guess. Hard to tell. — Realitätsverlust, Sep 22 '15 at 07:28
possible duplicate of [Call to a member function bind\_param() on a non-object](http://stackoverflow.com/questions/4488035/call-to-a-member-function-bind-param-on-a-non-object) — Rasclatt, Sep 22 '15 at 07:29
Well it can't be too fine if it doesn't recognize it as an object...try `var_dump($con);` See if it's boolean or something else. — Rasclatt, Sep 22 '15 at 07:31
Oh yeah, `mysqli`, the `$stmt` might be boolean. One of the two — Rasclatt, Sep 22 '15 at 07:33
after successful execution of query i'M trying to redirect using head{location:login.php} but i'm getting headers already sent errors how to overcome — Sagar, Sep 22 '15 at 07:42

score 0 · Accepted Answer · answered Sep 22 '15 at 07:30

0

check the connection

<?php
$con= new mysqli('localhost', 'my_user', 'my_password', 'world');

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

answered Sep 22 '15 at 07:30

Abdulla Nilam

36,589
17
64
85

@Sagar happy to help :) – Abdulla Nilam Sep 22 '15 at 07:53

Getting Error while using PHP Prepared Statement for Insert "Call to a member function bind_param() on a non-object"

1 Answers1