PHP MySQLi Delete Record

So far, I have discussed about connection establishment, create table, insert record, read records (select statement), update record. In this article we are going to learn about delete a record. Following is the table which I am going to delete a record. This table name is emp_info emp_id emp_name emp_age 1 Raj 22 2 Rahul […]

PHP MySQLi Update Records

In some cases, we may want to update table data using update sql statement. Lets see how can we update. The table which I am using to update record is as below. The table name is emp_info emp_id emp_name emp_age 1 Raj 22 2 Rahul 24 3 Vivek 26 4 Ajay 28 5 Suraj 29 […]

PHP MySQLi Read Records (Select Statement)

So far we have learned how to establish connection with mysql database using mysqli, create table, insert record. In this tutorial, we are going to learn how to print records from the table. For this we are going to use sql select statement. The table from which I am going to fetch record is as […]

PHP MySQLi Insert Record

In previous tutorial, we have learned how to create a table using mysqli and php. In this article we are going to learn how to insert record into table. For reference look at the below table. emp_id emp_name emp_age 1 Raj 22 2 Rahul 24 3 Vivek 26 4 Ajay 28 5 Suraj 29 In […]

PHP MySQLi Create Table

The first job, in php database project can be creating a table. In this article, we will learn how to create a table in mysql database using php and mysqli. (See following table example) emp_id emp_name emp_age 1 Raj 22 2 Rahul 24 3 Vivek 26 4 Ajay 28 5 Suraj 29 Lets see how […]

PHP MySQLi Establish Connection

In this first article of PHP MySQLi Tutorial, we are going to learn how to establish database connection with mysql database. Before proceeding further, you must have following knowledge Basics of PHP MySQL commands (create table, insert row, select row, update row, delete row etc.) What is MySQLi? MySQLi is a php based library which […]