Fatal error: Call to a member function bind

Fatal error: Call to a member function bind_param() on boolean

karthika pommudu

6y2.1kPHP

Have a good day:)

I tried to insert the value via ajax to php but I receive the error (as mentioned yellow highlighting part),kinldy help me to clear this.

"post" id="user_form">

class="table-responsive">

class="table table-striped table-bordered" id="user_data">

First Name

Last Name

Details

Remove

"center">

"submit" name="insert" id="insert" class="btn btn-primary" value="Insert" />

"user_dialog" title="Add Data">

class="form-group">

Enter First Name

"text" name="first_name" id="first_name" class="form-control" />

"error_first_name" class="text-danger">

class="form-group">

Enter Last Name

"text" name="last_name" id="last_name" class="form-control" />

"error_last_name" class="text-danger">

class="form-group" align="center">

"hidden" name="row_id" id="hidden_row_id" />

"button" name="save" id="save" class="btn btn-info">Save

"action_alert" title="Action">

require_once "dbconnect.php";
//$query = "INSERT INTO internship (first_name, last_name) VALUES (:first_name, :last_name)";
for($count = 0; $count<count($_POST['hidden_first_name']); $count++)
{
$data = array
(
$first_name=$_POST['hidden_first_name'][$count],
$last_name=$_POST['hidden_last_name'][$count]
);
if($first_name!='')
{
echo "HI".$first_name;
echo $last_name;
$result1=$link->query("INSERT INTO internship(`first_name`, `last_name`) VALUES (`$first_name`, `$last_name`)");
$result1->bind_param('i', $first_name); // error here
$result1->execute();
if ($result1)
{
echo "Successfully";
}
else
{
echo "Failed";
}
/* $statement = $link->prepare("INSERT INTO internship (`id`,`first_name`, `last_name`) VALUES (``,`$first_name`, `$last_name`)");
//$statement->bind_param("s", $hidden_first_name);
$result = $statement->execute(); */
}
else
{
echo "I dont know you.";
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

karthika pommudu6y ago
I have changed my code $result1->bind_param('i', $first_name); into $result1->bind_param('ii', $first_name);

Its working fine:)
Roshan Rathod6y ago
then save and check please
if($first_name!='')
{
echo "HI".$first_name; //remove this
echo $last_name; // remove this
karthika pommudu6y ago
Thanks for your reply. I was tried your guidlance code still not working its shows some error.
Roshan Rathod6y ago
Do this :

$query = $this->db->conn->prepare('SELECT value, param FROM ws_settings WHERE name = ?');
$query->bind_param('s', $setting);