PHP and MySQL with CRUD Operations: Create, Read, Update, Delete

Create Web Application using PHP and MySQL. How to connect to mysql database using PHP. How to fill HTML table from database using PHP. How to perform CRUD operations using PHP and MySQL.

********************************

Source code on Patreon: https://www.patreon.com/posts/php-and-mysql-84465280

********************************
Install XAMPP: https://youtu.be/BLY4nEyGe5M
********************************
SQL Queries:
CREATE TABLE clients (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR (100) NOT NULL,
email VARCHAR (200) NOT NULL UNIQUE,
phone VARCHAR(20) NULL,
address VARCHAR(200) NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO clients (name, email, phone, address)
VALUES
(‘Bill Gates’, ‘bill.gates@microsoft.com’, ‘+123456789’, ‘New York, USA’),
(‘Elon Musk’, ‘elon.musk@spacex.com’, ‘+111222333’, ‘Florida, USA’),
(‘Will Smith’, ‘will.smith@gmail.com’, ‘+111333555’, ‘California, USA’),
(‘Bob Marley’, ‘bob@gmail.com’, ‘+111555999’, ‘Texas, USA’),
(‘Cristiano Ronaldo’, ‘cristiano.ronaldo@gmail.com’, ‘+32447788993’, ‘Manchester, England’),
(‘Boris Johnson’, ‘boris.johnson@gmail.com’, ‘+4499778855’, ‘London, England’);
***************************

Source: https://www.youtube.com/watch?v=NqP0-UkIQS4

Leave a Reply

Your email address will not be published. Required fields are marked *