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