This guide describes how to select data from a MySQL database table and sort the data by a specific column in ascending or descending order with ORDER by clause using PHP in XAMPP stack.
PHP MySQL
- PHP MySQLDatabaseLinuxMariaDBMySQLPHPPhpmyadminProgrammingXAMPP
PHP MySQL DELETE, TRUNCATE, DROP Table
By Sravan KumarBy Sravan Kumar 5.1K viewsThis explains how to perform DELETE, TRUNCATE, And DROP operations on a MySQL database table using PHP in XAMPP in Linux.
- PHP MySQLDatabaseLinuxMariaDBMySQLPHPProgrammingXAMPP
PHP MySQL Logical Operators
By Sravan KumarBy Sravan Kumar 1.1K viewsThis tutorial explains how to filter data from a MySQL database table using MySQL logical operators such as BETWEEN, IN, AND, OR etc., along with WHERE clause and SELECT query in PHP.
- PHP MySQLDatabaseLinuxMariaDBMySQLPHPProgrammingXAMPP
PHP MySQL LIKE Operator
By Sravan KumarBy Sravan Kumar 1.6K viewsThis guide explains how to select data from a table using MySQL LIKE operator and WHERE clause in a particular database using PHP in XAMPP.
- PHP MySQLDatabaseLinuxMariaDBMySQLPHPProgrammingXAMPP
PHP MySQL WHERE Clause
By Sravan KumarBy Sravan Kumar 1.5K viewsIn this guide, We will discuss how to select the records from a MySQL database based on specific conditions with the WHERE clause and the SELECT command using PHP in XAMPP stack.
- PHP MySQLDatabaseLinuxMariaDBMySQLPHPPhpmyadminProgrammingXAMPP
PHP MySQL Select Data
By Sravan KumarBy Sravan Kumar 3.1K viewsThis tutorial walks you through the steps to select data in a table from a MySQL database using PHP in XAMPP stack.
- PHP MySQLDatabaseLAMP StackLEMP StackLinuxMariaDBMySQLPHPPhpmyadminProgrammingXAMPP
How To Insert Data In MySQL Database Using PHP In XAMPP
By Sravan KumarBy Sravan Kumar 4.3K viewsThis guide explains how to insert data in MySQL database using PHP in XAMPP. We will see how to insert single and multiple records in a MySQL table.
- PHP MySQLDatabaseLAMP StackLEMP StackLinuxMariaDBMySQLPHPProgrammingXAMPP
Create MySQL Database And Table Using PHP In XAMPP
By Sravan KumarBy Sravan Kumar 13.2K viewsIn this guide, we will discuss how to create a MySQL database and table using PHP and also how to create the MySQL/MariaDB databases and tables via phpMyAdmin using XAMPP stack.