Programming
Use Transactions With PHP PDO
A PDO transaction groups several database writes into one all-or-nothing unit. This tutorial builds the classic bank-transfer example: the debit and credit either both…
//
Tag: MySQL
Server Administration
Install WordPress Locally On Windows
Run WordPress on your own Windows machine with XAMPP, a free bundle of Apache, MariaDB, PHP, and phpMyAdmin. This tutorial installs the stack, creates…
Server Administration
Check Apache, MySql, and PHP versions
To further check Linux Apache MySQL PHP (LAMP) stack installation, the following can be made to know the exact installed version of each application.…
Database Administration
Restore MySQL backup from the terminal
Efficiently import MySql backup database records from an .sql file using the mysql command from the terminal. A quick and direct approach to restore…
Database Administration
Backup MySQL Database In Terminal
Import MySql database records into an .sql file from the terminal using the MySql command mysqldump, it is a quick and easy way to…
Programming
Access MySQL DB using PDO in PHP
Most, if not all new PHP server installations now a days include the PHP Data Objects API (PDO_MySQL), this extension is recommended if there’s…