Backup Your MySQL Database Using PHP

One of the most important tasks any developer needs to do often is back up their MySQL database. In many cases, the database is what drives ...

PHP: Export Database Schema as XML

Sometimes it can be useful to have a dump of the current database schema. The script below reads the schema from a MySQL database and outpu...

Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely.

Connect to MS SQL Server database

Below is the code for connecting to a MSSQL Server database.

Retrieving data from the MYSQL database using PHP

In mysql, the SELECT command is used to retrieving data from the database.  We can get the single value or a array of values from the databa...

Connect PHP with MYSQL database

Mysql is mostly used with PHP for storage and retrieving purpose .Before you can access a data in a database, you need to create a connectio...