在循环中将数据插入mysql数据库[重复]

Question

This question already has an answer here:

• Loop over an insert Query in PHP 4 answers

Im new to php and sql language and i got a question. I want to insert my data into the database while looping. So far, my code is like this.

for ($x = 0; $x <= 10; $x++) {
$sql="INSERT INTO exec (time, value) VALUES (now(), '34')";
}

However, when I execute this code, the data only insert into the database once and not 10 as I intended. I also want to add some delay around 10 seconds between each loop. Any help would be appreciated!

</div>

Answer 1

You need a connection to the database and the actual insert.

$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
$stmt = $dbh->prepare("INSERT INTO exec (time, value) VALUES (now(), 34)");
for ($x = 0; $x <= 10; $x++) {
   $stmt->execute();
   sleep(1);
}