Inserting Data with PDO

PDO INSERT

Use prepare() and execute() to insert rows safely. Retrieve the auto-increment ID with lastInsertId().

Example

<?php
$stmt = $pdo->prepare(
    "INSERT INTO users (name, email, password, created_at)
     VALUES (:name, :email, :password, NOW())"
);

$stmt->execute([
    "name"     => $name,
    "email"    => $email,
    "password" => password_hash($plainPass, PASSWORD_BCRYPT),
]);

$newUserId = $pdo->lastInsertId();
echo "Created user with ID: " . $newUserId;

PHP

Full Editor

Pro Tip

Always hash passwords with password_hash() before storing — never store plain text passwords.

Related Resources

PHP Reference

Complete tag & property list

PHP How-To Guides

Step-by-step practical guides

PHP Exercises

Practice what you've learned