10 posts with tag "MySQL"
Detailed instructions to create a LAMP server using Debian 9 Stretch RC3. Prepare your server for php7 and MariaDB.
Dedicated server setup, using Debian 8 Jessie step by step. It is a Hetzner EX40 server. Apache, php, MySQL, memcached. Basic monitoring and security tools.
October 21st, 2013 264,001
Logs is the best place to start troubleshooting. Concerning MySQL (or MariaDB), you need to refer to: General query Log, Error Log and Slow Query Log
October 13th, 2013 201,786
Fortunately, it is possible to use prepared statements with MySQL and PHP using MySQLi extension. But, how to bind params, if their number is variable?
A Simple PHP Class to Create RSS 2.0 Feed. This post covers RSS version 2.0. In simple words, an rss feed consists of a CHANNEL and channel ITEMS. You can
Detailed instructions to create a jquery-ui autocomplete using php and Mysql as server side technologies. Support for prepared statements.
Dedicated server setup, using Debian 7 Wheezy step by step. It is a Hetzner EX4S server. Apache, php, MySQL, memcached. Basic monitoring and security tools.
Recently, many popular Linux distributions have moved from MySQL to MariaDB. Think if you have to move to MariaDB in your production servers.
PHP MySQL extension is deprecated. PHP MySQLi extension is Object Oriented, supports Transactions and protects from SQL Injection, using Prepared Statements.
Using MySQL command line client and mysqldump to perform the most important tasks for everyday use, every administrator or web developer needs to know.