Insert multiple rows in to table using php

Question

Am trying to insert multiple rows in to table using php:

<?php

$host = "localhost";
$username = "mysql_username";
$password = "mysql_password";
$dbname = "employee";
$con = mysqli_connect($host, $username, $password, $dbname) or die('Error in Connecting: ' . mysqli_error($con));

$st = mysqli_prepare($con, 'INSERT INTO emp(name, gender, designation) VALUES (?, ?, ?)');
// bind variables to insert query params
mysqli_stmt_bind_param($st, 'sss', $name, $gender, $designation);

for ($x = 0; $x <= 3; $x++) {       
    $name = 'tom';
    $gender = 'male';
    $designation = 'developer';
    mysqli_execute($st);
}

//close connection
mysqli_close($con);

?>

But the rows that i want to insert are not saved in database. Are there any mistakes in my code ?

Actually I want the for loop from json array, I just test using for loop for knowing it is worked or not.

Note: mysqli_execute() is deprecated and will be removed. (from php.net/manual/en/function.mysqli-execute.php) take a look at php.net/manual/en/mysqli-stmt.execute.php instead which is probably the correct method you need to use — apokryfos
– apokryfos, Commented Apr 8, 2016 at 8:21
this line: mysqli_stmt_bind_param($st, 'sss', $name, $gender, $designation); should be just before the mysqli_execute? — Ardit Meti
– Ardit Meti, Commented Apr 8, 2016 at 8:23

Shri Suresh · Accepted Answer · 2016-04-08 09:06:50Z

1

I think the code is right, but try this:

<?php
$host       = "localhost";
$username   = "mysql_username";
$password   = "mysql_password";
$dbname     = "employee";
$con = mysqli_connect($host, $username, $password, $dbname) or die('Error in Connecting: ' . mysqli_error($con));

$st = mysqli_prepare($con, 'INSERT INTO emp(name, gender, designation) VALUES (?, ?, ?)');

for ($x = 0; $x <= 3; $x++) {

    $name = 'tom';
    $gender = 'male';
    $designation = 'developer';

    // bind variables to insert query params
    mysqli_stmt_bind_param($st, 'sss', $name, $gender, $designation);
    mysqli_execute($st);
}

//close connection
mysqli_close($con);
?>

The mysqli_stmt_bind_param($query, 'is',…) means the first value is an integer (i) and the next value is a string (s). Feel free to adjust to best fit your actual data types.

edited Apr 8, 2016 at 9:06

Shri Suresh

4731 gold badge5 silver badges20 bronze badges

answered Apr 8, 2016 at 8:29

user4990969

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

Collectives™ on Stack Overflow

Insert multiple rows in to table using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related