PHP 5.6 Tutorial

Introduction to MYSQL Database Management System (DBMS) is used to store, retrieve, and modify the data. A good database engine serves as connector between you and your data, organizing and cataloging the data for quick …

A relational database is a database system that allows data to be associated and grouped by common attributes. Basically, a relational database arranges data into tables, where each table is divided into rows and columns …

Here, you will learn how to create a new database in MySql, add a table to the database, and add data to the table. You will also learn how to query databases and tables, update …

Creating a table in MYSQL database As you know, tables are used to store data. Here, we will create a very simple table Courses containing three fields :Course id (the primary key),Course name (the name …

Adding Data to a Table To insert the data in a Table related to the courses use the SQL INSERT statement. INSERT INTO table VALUES (value1, value2, …); This inserts values into each of the …

Deleting Data from a Table To delete rows, you use the DELETE statement. If you add a WHERE clause, you can choose which row or rows to delete; otherwise all the data in the table …

Reading data In MYSQL Here , we will study how to read data from the database. To read the data from the database use the SELECT statement. To send SQL statements to the MySQL server, …

Deleting Tables and Databases To delete a table entirely, use the DROP TABLE statement. Similarly, you can delete an entire database with DROP DATABASE . Here, we will show you how to DROP TABLE mysql …

Connecting PHP with MYSQL Here, you will learn how PHP Script communicates with MySql. At the time of writing, PHP provides two main ways to connect to MySQL databases: i)mysqli (MySQL improved) — This extension is …

Inserting Records In PHP Here, you will how to insert a row of data. INSERT INTO table VALUES ( value1 , value2 , … ); If a user wants to Inserting Records In PHP only …

As with inserting new records, updating records via the PHP script is simply a case of using PDO::query() .if a user is passing literal values in the UPDATE statement, or PDO::prepare() with placeholders. For example, …

Deleting Records In PHP and MYSQL Deleting rows of data in PHP is a similar to updating process. mysql > DELETE FROM fruit WHERE id = 2; Query OK, 1 row affected To delete rows …

 Sorting data and limiting data in PHP Sorting data In PHP, the sort() function is used to sort an indexed array in ascending order and rsort() function is used to sort an indexed array in …

Building a Member Registration Application Form In PHP Here, we will create a simple registration form in PHP and mysql. Registration form is created for all online small website to a big websites. Registration means …

Creating HTML forms In PHP An HTML form or Web form is simply a collection of HTML elements inserted within a standard Web page. By adding different types of elements, you can create different form …