How to insert Data into MySQL Database Using PHP Code

Опубликовано: 09 Июнь 2026
на канале: KITH Sophal

How to insert Data into MySQL Database Using PHP Code
ការបង្កើត MySQL Database Table និង Insert ដោយប្រើ PHP Code

See more videos by S O P H A L here : / @kithsophal

Start PHP Script:
$servername = "localhost"; $username = "username";
$password = "password"; $db = "dbname";
// Create connection
$conn = mysqli_connect($servername, $username, $password,$db);
// Check connection
if ($conn===false) {
die("Connection failed: " . mysqli_connect_error());
}
// Attempt create database query execution
$sql = "CREATE DATABASE demo";
if(mysqli_query($conn, $sql)){
echo "Database created successfully";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($conn);
End PHP Script:

// Attempt create Table query execution
$sql = "CREATE TABLE persons( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(30) NOT NULL, last_name VARCHAR(30) NOT NULL, email VARCHAR(70) NOT NULL UNIQUE )";

// Attempt Insert Into Table query execution
$sql = "INSERT INTO persons (first_name, last_name, email) VALUES ('Peter', 'Parker', '[email protected]’)”;

// Attempt Insert Into Table Multiple Record query execution
$sql = "INSERT INTO persons (first_name, last_name, email) VALUES ('John', 'Rambo', '[email protected]'), ('Clark', 'Kent', '[email protected]'), ('John', 'Carter', '[email protected]'), ('Harry', 'Potter', '[email protected]')";

Facebook: https://fb.com/sophal.official/
Support My Channel
Do LIKE | COMMENT | SHARE | SUBSCRIBE