SQL stands for Structured Query Language.
MySQL runs on a server deamon where users on the same or even remote computers can connect.
Once connected you can select database if you have privileges to do so.
In this tutorial you will learn:
1. How to connect to MySQL.
2. Create a Table
3. Insert data in to you database.
4. Display database data in you browser.
5. Change data.
The Code:
Lets start off by connecting to MySQL:
<?php
$location = "localhost" ;
$username = "username" ;
$password = "password" ;
$database = "database" ;
$conn = mysql_connect ( "$location" , "$username" , "$password" );
if (! $conn ) die ( "Could not connect MySQL" );
mysql_select_db ( $database , $conn ) or die ( "Could not open database" );
?>
Read More...
Beginners guide to PHP and MySQL Categories : PHP , Beginner Guides , Databases , MySQL , Installation Counting - Creating a GIF based counter using PHP and MySQL Categories : Beginner Guides , PHP , To PHP , To MySQL , MySQL Counting - Creating a more sophisticated GIF based counter using PHP and MySQL Categories : Beginner Guides , MySQL , PHP , To PHP , To MySQL Beginners guide to PHP and MySQL - Creating a simple guest book Categories : Beginner Guides , To PHP , To MySQL , PHP , MySQL How To add paging (Pagination) with PHP and MySQL Categories : PHP , Beginner Guides , Databases , MySQL , HTML and PHP Counting - Creating a simple counter Categories : PHP , MySQL , Beginner Guides , To PHP , To MySQL Access vs. MySQL Categories : Databases , MySQL , MS Access How TO Install PHP, Apache and MySQL on Linux or Unix Categories : PHP , MySQL , Apache , Installation , Beginner Guides Descriptions of Common Data Types Categories : MySQL , Databases , PHP , PHP options/info , General Unicode and Other Funny Characters Categories : Databases , MySQL , Unicode Case Study: Handling MySQL Growth With a PHP Class Categories : Databases , MySQL , PHP MySQL Access Control System - Grant Tables Categories : Databases , MySQL , Security Creating an IE-Only Database Driven Menu System With PHP, MySQL and DHTML Categories : PHP , MySQL , Databases , DHTML Practical Date and Time examples with PHP and MySQL Categories : Databases , MySQL , PHP , Date/time PHP, MySQL and Authentication 101 Categories : PHP , Databases , MySQL , Authentication