Database Connections Methods in PHP 5

Introduction :

On the previous lesson i explained about PHP basics and its advantages and dis-advantages . On this lesson we are going to learn about a function called "mysql_connect" This function will allow us to connect our PHP program with the back-end Mysql Database . 

Example for Mysql_Connect() Function :

$conn=mysql_connect("hostname", "username ", "password"); 

The above code will help you to connect your PHP program with Mysql Database .

Hostname :

Hostname was indicating the server . If you are running both Mysql Database and Php program in the same server . Then the host name will be "localhost" .

Username :

Username indicating the "Username" Of your Mysql Database . If the "Username" Was incorrect , The program can't access to Database .

Password :

Every Database have a password which set by the administrator of the password . If the password was incorrect , PHP Program can't access to your database .

Full Functioned Example for Mysql_Connect() Function :

<?php
 
       $user = "root";
       $pwd = " ";
       $host = "localhost";
       $conn = @mysql_connect($host, $user, $pwd);
       if($conn)
       {
       echo "Successfully connected";
       }
       else
       {
       echo"connection fail";
       }
 
  ?>

The above code will help you to connect your PHP Program with Mysql Database . Just create a new Php page on your server and try the code . Don't forget to change the variable with your database details  .

If the connection establish with you database by the code . Then "Successfully Connected" Message will show on the screen . If it was not , Then the "Connection Fail" Message will show .

If the connection was failed , Try to check the variable that you assigned for $user , $pwd , $host  .

PHP 5 Mysqli_Connect() Function :

$con = mysqli_connect("localhost","my_user","my_password","my_db");

In PHP 5 the Mysql_Connect() method was changed to Mysqli_Connect() method . All other things was same as before .

Suggested Article for PHP Developers .

• Chapter 3 : Execution of Mysql Query Using PHP .
• Chapter 4 : Fetch Data From Database Using PHP .
• Chapter 5 : Update Data of Database Using PHP .

I hope you well enjoyed this article . If you have any doubts or suggestions about this article . Please let us know by using the comment box given below . Thanks