How to insert a variable in MySQLi statement?

Question

I am trying to insert data in a database using MYSQLi. If I use the following query, data is inserted;

INSERT INTO table (Name, Phone, Location) VALUES ('test', 'test', 'test')

Instead of the value 'test', I need the value of a variable inserted. However the following does not work.

$test = 'xxx';
if ($stmt = $mysqli->prepare("INSERT INTO table (Name, Phone, Location) VALUES (".$test.", 'aaa', 'bbb')")) {
   $stmt->execute();
   $stmt->close();
}

I have tried the bind_param command, but it didn't work.

$stmt->bind_param("ss", $name, $phone, $location);

How can I insert a variable directly?

Mihai Matei · Accepted Answer · 2013-04-11 09:46:34Z

3

In your case the code should be like this:

$test = 'xxx';

$stmt = $mysqli->prepare("INSERT INTO table (Name, Phone, Location) VALUES (?, 'aaa', 'bbb')");
$stmt->bind_param("s", $test);
$stmt->execute();
$stmt->close();

If you want to have 3 variables for this query:

$name = "My name";
$phone = "My phone number";
$location = "My location";

$stmt = $mysqli->prepare("INSERT INTO table (Name, Phone, Location) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $name, $phone, $location);
$stmt->execute();
$stmt->close();

answered Apr 11, 2013 at 9:46

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1334130 Over a year ago

So that was the error I have been making. I needed three "s" because there are three strings. Thank you so much. Will accept answer ASAP.

Collectives™ on Stack Overflow

How to insert a variable in MySQLi statement?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related