How to insert a row into a database

Short answer

Pass the values separately from the query — in execute():

<?php
 
$pdo = new PDO('sqlite::memory:');
$pdo->exec('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)');
 
$statement = $pdo->prepare('INSERT INTO users (name, email) VALUES (:name, :email)');
$statement->execute(['name' => 'Anna', 'email' => 'anna@example.com']);
 
echo $pdo->lastInsertId();

Output:

Several rows

One prepared statement is run in a loop:

<?php
 
$pdo = new PDO('sqlite::memory:');
$pdo->exec('CREATE TABLE tags (id INTEGER PRIMARY KEY, title TEXT)');
 
$statement = $pdo->prepare('INSERT INTO tags (title) VALUES (?)');
 
foreach (['php', 'sql', 'css'] as $title) {
    $statement->execute([$title]);
}
 
echo $pdo->query('SELECT COUNT(*) FROM tags')->fetchColumn();

Output:

Thanks for reading!

Short answer

Several rows

Functions used in this recipe

Thanks for reading!