How to Connect a MySQL Database With WampServer to PHP | PHP Tutorials

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

118

#PHP #MySQL #WampServer #PHPTutorials
ការបង្កើត File Connection តាមរយៈ mysqli_connect()

How to Connect a MySQL Database With WampServer to PHP | PHP Tutorials

YouTube Channel : / @kithsophal

#SQLStatement
1. Create Database
$sql = "CREATE DATABASE demo";

2. Creating Table:
$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 )";

3. Inserting Data:
$sql = "INSERT INTO persons (first_name, last_name, email) VALUES ('Peter', 'Parker', '[email protected]’)”;

4. Inserting Data Multiple Row:
$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]')";

Website: http://it.isophal.com/
System Online: http://isophal.com/exam/
Facebook Page : / sophal81

Mr. SOPHAL, Founder, isophal.com
Email: [email protected]