Programming
Get the Last Inserted ID With PHP PDO
Get the last inserted ID with PHP PDO by calling lastInsertId() right after an INSERT. This tutorial captures the AUTO_INCREMENT id of a new…
//
Tag: MySQL
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…
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…