Category: Mysql

Simple php pagination using php and mysql

In this tutorial, we are going to discuss how to implement PHP pagination using PHP and MySQL with simple PHP code. In our previous tutorial, we have seen how to add,edit and delete records from database using PHP and MySQL .If we add more records the number of rows increases and they all display at

MYSQL Insert Select Update and Delete Queries Examples

This tutorial will explain how to write MYSQL Insert Select Update and Delete Queries Examples and how to access MYSQL database using PHP. PHP has the built-in functions to connect the MYSQL database and to retrieve, update and delete the data from MYSQL database. Accessing MYSQL database from PHP is very easy using the following

Sql query to insert all countries into database

Sql query to insert all countries in the world into a database I couldn’t find the query to run, so I created my own SQL query. Here it is, ‘tbl_countries’ is the table name and ‘name’ is the column name. You should have a table ‘tbl_countries’ in the database to run the below query.

How to install Apache XAMPP on Windows

This article will explain how to install Apache XAMPP on Windows. XAMPP is a free open source software that provides an easy way for web designers and developers to install PHP based software like WordPress, Drupal, Joomla, and others on Windows, Mac OS X, and Linux. If you’re a web developer, designer, or a person

How to connect to MySQL database using PHP

This example shows you to how to connect to MySQL database using PHP. Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to