debian as server | autocomplete ajax json | how to disply system time in php | Post.Php for facebook
 


 

10 posts with tag "mysql"


Debian 9 Stretch RC3 Dedicated Web Server Setup Step by Step. Time for PHP7 and MariaDB

Detailed instructions to create a LAMP server using Debian 9 Stretch RC3. Prepare your server for php7 and MariaDB.

Debian 8 Jessie Dedicated Web Server Setup Step by Step

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.

How and When To Enable MySQL Logs

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

Dynamically Bind Params in Prepared Statements with MySQLi

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 Feed

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

How to Create a jquery-ui Autocomplete Step by Step

Detailed instructions to create a jquery-ui autocomplete using php and Mysql as server side technologies. Support for prepared statements.

Debian 7 Wheezy Dedicated Web Server Setup Step by Step

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.

Is it time to Remove MySQL in favor of MariaDB in Production Servers?

Recently, many popular Linux distributions have moved from MySQL to MariaDB. Think if you have to move to MariaDB in your production servers.

How to Use PHP Improved MySQLi extension (and Why You Should)

PHP MySQL extension is deprecated. PHP MySQLi extension is Object Oriented, supports Transactions and protects from SQL Injection, using Prepared Statements.

MySQL in a Nutshell

Using MySQL command line client and mysqldump to perform the most important tasks for everyday use, every administrator or web developer needs to know.