Programming Languages

PHP MySQL INSERT Data

Insert new records into MySQL database

MySQLi Insert (Procedural)

$sql = "INSERT INTO users (name, email) VALUES ('John', '[email protected]')"; # SQL insert
if (mysqli_query($conn, $sql)) { # execute query
    echo "New record created"; # success message
} else { # handle error
    echo "Error: " . mysqli_error($conn); # show error
}

MySQLi Insert (OOP)

$sql = "INSERT INTO products (name, price) VALUES ('Laptop', 999.99)"; # insert query
if ($conn->query($sql) === TRUE) { # check success
    $last_id = $conn->insert_id; # get last inserted ID
} else { # error handling
    echo "Error: " . $conn->error; # display error
}

PDO Insert

$sql = "INSERT INTO users (name, email) VALUES ('Jane', '[email protected]')"; # SQL statement
$pdo->exec($sql); # execute insert
$lastId = $pdo->lastInsertId(); # get last ID