Did you know?

if you register at Hamid School you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!

Are you Confused? Click here to learn how to use hamid school

PHP MySQL Connect to a Database

The free MySQL Database is very often used with PHP.

Connecting to a MySQL Database

Before you can access and work with data in a database, you must create a connection to the database.

In PHP, this is done with the mysql_connect() function.

Syntax

mysql_connect(servername,username,password);

Note: There are more available parameters, but the ones listed above are the most important.

Example

In the following example we store the connection in a variable ($con) for later use in the script. The "die" part will be executed if the connection fails:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

?>

Closing a Connection

The connection will be closed as soon as the script ends. To close the connection before, use the mysql_close() function.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

mysql_close($con);
?>

• Introduction to PHP
• PHP Installation
• PHP Syntax
• PHP Variables
• PHP String
• PHP Operators
• PHP If...Else Statements
• PHP Switch Statement
• PHP Arrays
• PHP Looping
• PHP Functions
• PHP Forms and User Input
• PHP $_GET
• PHP $_POST
• PHP Date
• PHP Include File
• PHP File Handling
• PHP File Upload
• PHP Cookies
• PHP Sessions
• PHP Sending E-mails
• PHP Secure E-mails
• PHP Error Handling
• PHP Exception Handling
• PHP Filter
• PHP MySQL Introduction
• PHP MySQL Create Database and Tables
• PHP MySQL Insert Into
• PHP MySQL Select
• PHP MySQL The Where Clause
• PHP MySQL Order By Keyword
• PHP MySQL Update
• PHP MySQL Delete From
• PHP Database ODBC

Did you know?

if you register at Hamid School you can learn web programming and designing for free and also you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!