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 …
Read More »PHP 5.6 Tutorial
Understanding Relational Databases
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 …
Read More »Creating a new database in MYSQL
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 …
Read More »Creating a table in MYSQL database
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 …
Read More »Adding Data to a Table
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 …
Read More »Deleting Data from a Table
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 …
Read More »Reading data In MYSQL
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, …
Read More »Deleting Tables and Databases
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 …
Read More »Connecting PHP with 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 …
Read More »Inserting Records In PHP
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 …
Read More »Updating Records In PHP
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, …
Read More »Deleting Records In PHP and MYSQL
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 …
Read More »Sorting data and limiting data in PHP
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 …
Read More »Building a Member Registration Application form In PHP
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 …
Read More »Creating HTML forms In PHP
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 …
Read More »