How to use a for loop to insert multiple records in a database table

Question

I have simplified my problem into the following code:

$sql_abc = "CREATE TABLE $tbl_abc(
    x INTEGER(255)
)
";

echo "About to execute $sql_abc";
if (mysqli_query($conn, $sql_abc)) {
    echo "Table $sql_abccreated successfully<br>";
} else {
    echo "Error creating table: " . mysqli_error($conn) . "<br>";
}

for ($x = 1; $x <= 10; $x++) {
    $sql_abc = "INSERT INTO $tbl_abc VALUES ($x)";
}

if (mysqli_query($conn, $sql_abc)) {
        echo "New records created successfully<br>";
    } else {
        echo "Error: " . $sql_abc. "<br>" . mysqli_error($conn);
    }

I am trying to get 10 records in the table, with each incrementing by one in the 'x' field.

However, all I see is:

Please advise. Thank you.

you need to put the actual insert statement in the for loop, so each time it increments the $x it should also execute the insert statement as well, right now the loop completes it's iterations and the insert statement only executes for the last value of $x because your insert statement is after the for loop — Umer Abbas
– Umer Abbas, Commented Dec 14, 2020 at 4:20
Could you please suggest an edit to the code to fix it? Is $sql_abc = "INSERT INTO $tbl_abc VALUES ($x)"; not currently in the for ($x = 1; $x <= 10; $x++) loop? Thank you! — Bob
– Bob, Commented Dec 14, 2020 at 4:23
please share complete code so I can fix it for you. Show where you execute the "INSERT INTO $tbl_abc VALUES ($x)" query string ? — Umer Abbas
– Umer Abbas, Commented Dec 14, 2020 at 4:26
A good practice will be to handle connection error only once when you first make the db connection, you don't need to check the connection every time you execute a query. — Umer Abbas
– Umer Abbas, Commented Dec 14, 2020 at 4:38

Umer Abbas · Accepted Answer · 2020-12-14 04:33:55Z

2

Here is how you can do that.

for ($x = 1; $x <= 10; $x++) {
    
    $sql_abc = "INSERT INTO $tbl_abc VALUES ($x)";

    //this query will execute for each value of $x
    mysqli_query($conn, $sql_abc);
}

answered Dec 14, 2020 at 4:33

Umer Abbas

1,8763 gold badges16 silver badges21 bronze badges

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

2 Comments

Bob Over a year ago

Thank you so much. I'm only starting out with php now and am unfamiliar with how to execute the queries!

Umer Abbas Over a year ago

No worries, Just search about the best way to handle db connections and learn best coding practices. Have a good day.

Collectives™ on Stack Overflow

How to use a for loop to insert multiple records in a database table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related