Database

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.

This explains how to perform DELETE, TRUNCATE, And DROP operations on a MySQL database table using PHP in XAMPP in Linux.

This 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.

This guide explains how to select data from a table using MySQL LIKE operator and WHERE clause in a particular database using PHP in XAMPP.

In 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.

This tutorial walks you through the steps to select data in a table from a MySQL database using PHP in XAMPP stack.

This 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.

In 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.

In this tutorial, we will learn what is XAMPP stack and how to install XAMPP in Linux. Next, we will discuss how to start or restart XAMPP server and how to access XAMPP test page, phpMyAdmin dashboard. Finally, we will see how to secure XAMPP installation and remove XAMPP if it is not required anymore.

In this article, we will learn about Snowflake Role based Access Control (RBAC) and how to create custom roles and grant access to the roles from Snowflake WebUI and using SnowSQL CLI client.