1. Home
2. How to insert 100 records in mysql procedure and loop in MySQL procedure not in PHP?

545 votes

0 answers

How to insert 100 records in mysql procedure and loop in MySQL procedure not in PHP?

Get the solution ↓↓↓

Solution:

You can build a multi-rowINSERT in your PHP code. Assuming your data is in$arr:

$sql = "INSERT INTO yourtable (...column list...) VALUES ";
$vsets = array();
foreach ($arr as $values) {
    $vsets[] = str_replace(array(',,', ',,'), ',NULL,', "(" . implode(',', $values) . ")");
}
$sql .= implode(',', $vsets);
echo $sql;
Copy code

Output:

INSERT INTO yourtable (...column list...) 
    VALUES (19287,1,1,101,224,0),(19285,0,1,101,2,0),
           (19289,1,1,72,23,0),(19290,NULL,1,106,3,0),
           (19291,0,1,230,76,0)
Copy code

Make sure you filter, validate or cast your data, to prevent any non-integers (or any SQL) from being injected into your queries.

Undefined asked

2023-03-31

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2023-03-31

Link To Source
Link To Answer People are also looking for solutions of the problem: target class [commandmakecommand] does not exist.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

130 php - INSERT INTO mysql only if input text is not empty - Codeigniter

233 mysql - PHP - getting the values that are only checked in a looped table after submitting

948 PHP and MYSQL: Inserting Foreign Key

554 PHP MySQL PDO lastInsertID causes fatal error

975 PHP/MySQL - Not posting to database

324 mysql - php converting all passwords in DB

449 php - mysql_connect(): No such file or directory

938 php - mysql Column name change using join

773 php - Trying to validate PayPal payment amount - MySQL IPN

721 How do I POST Json value and some other values to another url using PHP

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/