Skip to main content

Posts

Showing posts with the label how to make simple curd using php

PHP Mysql CRUD Operation Example

Hi Guys, Today, In this tutorial you'll give how to build a CRUD application with PHP and MySQL. What is CRUD CRUD(Create, Read, Update, and Delete) is an acronym for Create, Read, Update, and Delete. CRUD operations are simply data manipulation for database.In this tutorial we'll create a simple PHP application to perform all these operations on a MySQL database table at one place. Creating the Database Table Execute the following SQL query to create a table named users inside your MySQL database. We will use this table for all of our future operations. CREATE TABLE users ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, fullname VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL, salary INT(10) NOT NULL ); Creating the Config File Database Configuration config.php <?php /* Database credentials. Assuming you are running MySQL server with default setting (user 'root' with no password) */ define('DB_SERVER', 'localhost')