Insert Data in MySQL PHP

Example:-

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "portal";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO student (firstname, lastname, email)
VALUES ('Pradeep', 'Kumar', 'p@gmail.com')";

if (mysqli_query($conn, $sql)) {
  echo "New record created successfully";
} else {
  echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>

Output

New record created successfully

See in Fig:-

Insert Multiple Records Into MySQL Database

mysqli_multi_query() is used for Insert Multiple Records See in Example.

Example:-

 <?php  
$servername = "localhost";  
$username = "root";  
$password = "";  
$dbname = "portal";  
// Create connection  
$conn = mysqli_connect($servername, $username, $password, $dbname);  
// Check connection  
if (!$conn) {  
  die("Connection failed: " . mysqli_connect_error());  
}  
  
$sql = "INSERT INTO student (firstname, lastname, email)  
VALUES ('Priyanka', 'Kumari', 'p@gmail.com')";  
$sql = "INSERT INTO student (firstname, lastname, email)  
VALUES ('Riki', 'Ponting', 'r@gmail.com')"; 
$sql  = "INSERT INTO student (firstname, lastname, email)
VALUES ('Mary', 'Moe', 'mary@gmial.com');";
  
 if (mysqli_multi_query($conn, $sql)) {  
  echo "New record created successfully";  
} else {  
  echo "Error: " . $sql . "<br>" . mysqli_error($conn);  
}  
mysqli_close($conn);  
?>  

See in Fig:-

Next TopicDelete Data From MySQL in PHP

← prev next →

MYSQL Database

PHP Programs

PHP Projects

Insert Data in MySQL PHP

Insert Multiple Records Into MySQL Database