PHP/MySQL Tutorial: How to Use PHP and MySQL?

PHP is the most popular scripting language for web development. It is free, open source and server-side (the code is executed on the server). MySQL is a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). It is also free and open source. The combination of PHP and MySQL gives unmet options to create just about any kind of website - from small contact form to large corporate portal.

This PHP/MySQL tutorial is part of the rich collection of web hosting tutorials which SiteGround experts have prepared for you. Find out how to start your website, how to promote it, how to deal with cPanel, webmail and FTP.

PHP/MySQL Tutorial includes:

• A short introduction on what is PHP;
• What is MySQL and what are its benefits;
• Creating MySQL database and user - useful information for installing a PHP/MySQL script on your website;
• Removing MySQL database and user;
• Learn how to manage MySQL databases with phpMyAdmin - MySQL Backup/Restore functionality and how to use MySQL Access Host;
• Creating a database table;
• Connecting to the database;
• Querying the database;
• Displaying table data in HTML;
• Selecting individual records;
• How to use the MySQL GUI tools to backup, restore and execute queries on your database;
• Information about Zend Optimizer;
• Learn how to install Pear modules. 

You may use this tutorial for your own use. You may not distribute it in any form without the express permission of the publisher. You may provide a link to the publisher's web site, where this tutorial can be used from. This tutorial is provided free of charge and without any warranty of any kind.