PHP mysqli_query Function
This article explains how to use the mysqli_query function in PHP to perform a given query to a MySQL database. The function returns false on failure.
MySQL TIMESTAMP Type
This article explains the TIMESTAMP data type allows you to store date and time values in the format of TIMESTAMP as YYYY-MM-DD HH:MM:SS.
MySQL SYSDATE() Function
A guide on using the MySQL SYSDATE() function to get the current date and time with examples of its basic usage and using the function with the FSP parameter.
MySQL NOW() Function
A guide on how to use the MySQL NOW() function to fetch the current date and time when the system begins execution, like using the function with calculation.
MySQL IF Function
A guide on how to use the MySQL IF() function through the examples highlighting its usage, using the IF() function with the NULL values.
MySQL DAYOFWEEK Function
A guide on how to use the DAYOFWEEK() function in MySQL to return the index of a day from a given date with the syntax function and example.
MySQL CAST Function
A guide on how to use MySQL CAST() function to convert a value from one type to another with examples converting String to Int and String to Float.
MySQL Default
If you insert or update a row that does not include a value for that column, MySQL will use the defined default value instead of a NULL type.
MySQL Converts From One Time Zone to Another
Timezones are complex concepts that developers have to deal with. The convert_tz() function in MySQL enables us to convert from one timezone to another.
MySQL JSON Data Type
This guide demonstrates how to use JSON type to manage data in a MySQL database. JSON data type was introduced since MySQL 5.7.8 to store data as key value pairs in certain circumstances, while maintaining the rigid nature of the whole database.
MariaDB Basic Tutorial
Guide on how to install the MariaDB database server, its features, creating databases and tables, and performing various types of database-related common tasks.
How to Install LEMP Stack with phpMyAdmin in Arch Linux
Generally, the term LEMP stack can be broken down to Linux, Nginx, MySQL/MariaDB, and PHP modules. All these listed components have a priceless contribution in mimicking the behavior of a production server.
The post How to Install LEMP Stack with phpMy…