PHP MySQL INSERT Data: Add Records to Database with Examples

Tutorial

Forum

PHP

PHP Basic Tutorial

Modify Strings

Concatenate Strings

Slicing Strings

Escape Characters

PHP If...Else...Elseif

PHP If...Else

PHP Shorthand If

PHP Nested If

PHP Switch

PHP Loops

While Loop

Do While Loop

For Loop

Foreach Loop

Indexed Arrays

Associative Arrays

Create Arrays

Access Arrays

Update Array Items

Add Array Items

Remove Array Items

Sorting Arrays

Multidimensional Arrays

Array Functions

PHP Forms

MySQL Connection

PHP Advanced

PHP File Create/Write

PHP OOP

PHP Static Properties

PHP Interview

MySQL Insert Data

❮ Previous

Next ❯

To insert data into a MySQL database using PHP, you can use MySQLi (Procedural & Object-Oriented) or PDO.

The INSERT INTO statement is used to add new records to a MySQL table

Syntax:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

The following examples add a new record to the "users" table:

Example (MySQLi Procedural)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase"; // Change to your database name

// Create connection

$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Insert query

$sql = "INSERT INTO users (name, email, password) VALUES ('John Doe', 'john@example.com', '123456')";

if (mysqli_query($conn, $sql)) {

echo "New record inserted successfully. Last inserted ID is: " . mysqli_insert_id($conn);

} else {

echo "Error: " . $sql . "<br>" . mysqli_error($conn);

}

// Close connection

mysqli_close($conn);

Example (MySQLi Object-oriented)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Insert query

$sql = "INSERT INTO users (name, email, password) VALUES ('John Doe', 'john@example.com', '123456')";

if ($conn->query($sql) === TRUE) {

echo "New record inserted successfully. Last inserted ID is: " . $conn->insert_id;

} else {

echo "Error: " . $sql . "<br>" . $conn->error;

}

// Close connection

$conn->close();

Example (PDO)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase";

try {

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// Set PDO error mode to exception

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Insert query with placeholders

$sql = "INSERT INTO users (name, email, password) VALUES (:name, :email, :password)";

// Prepare statement

$stmt = $conn->prepare($sql);

// Bind parameters

$stmt->bindParam(':name', $name);

$stmt->bindParam(':email', $email);

$stmt->bindParam(':password', $password);

// Values to insert

$name = "John Doe";

$email = "john@example.com";

$password = "123456";

// Execute the query

$stmt->execute();

// Get last inserted ID

echo "New record inserted successfully. Last inserted ID is: " . $conn->lastInsertId();

} catch (PDOException $e) {

echo "Error: " . $e->getMessage();

}

// Close connection

$conn = null;

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.