Howi.In

Database Connections Methods in PHP 5

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-4sRKW7_Un_o/VfRN9wLjvKI/AAAAAAAAG_I/WZ1KeMPYB8Y/s1600/learn%2Bphp%2Bintro%2B-min.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="PHP 5 Mysql Database Connection Methods " border="0" src="http://1.bp.blogspot.com/-4sRKW7_Un_o/VfRN9wLjvKI/AAAAAAAAG_I/WZ1KeMPYB8Y/s1600/learn%2Bphp%2Bintro%2B-min.png" title="PHP 5 Mysql Database Connection Methods " /></a></div>
<h2 style="text-align: left;">
Introduction :</h2>
<div>
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 "<b>mysql_connect</b>" This function will allow us to connect our PHP program with the back-end Mysql Database . </div>
<h4 style="text-align: left;">
Example for Mysql_Connect() Function :</h4>
<pre class="brush: js;">$conn=mysql_connect("hostname", "username ", "password"); </pre>
The above code will help you to connect your PHP program with Mysql Database .<br />
<h4 style="text-align: left;">
Hostname :</h4>
<div>
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" .</div>
<h4 style="text-align: left;">
Username :</h4>
<div>
Username indicating the "<b>Username</b>" Of your Mysql Database . If the "<b>Username</b>" Was incorrect , The program can't access to Database .</div>
<h4 style="text-align: left;">
Password :</h4>
<div>
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 .</div>
<h4 style="text-align: left;">
Full Functioned Example for Mysql_Connect() Function :</h4>
<pre class="brush: js;"><?php
 
       $user = "root";
       $pwd = " ";
       $host = "localhost";
       $conn = @mysql_connect($host, $user, $pwd);
       if($conn)
       {
       echo "Successfully connected";
       }
       else
       {
       echo"connection fail";
       }
 
  ?></pre>
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  .<br />
<br />
If the connection establish with you database by the code . Then "<b>Successfully Connected</b>" Message will show on the screen . If it was not , Then the "<b>Connection Fail</b>" Message will show .<br />
<br />
If the connection was failed , Try to check the variable that you assigned for <b>$user</b> , <b>$pwd</b> , <b>$host  </b>.<br />
<h4 style="text-align: left;">
PHP 5 Mysqli_Connect() Function :</h4>
<pre class="brush: js;">$con = mysqli_connect("localhost","my_user","my_password","my_db");</pre>
In PHP 5 the <b>Mysql_Connect() </b>method was changed to <b>Mysqli_Connect()</b> method . All other things was same as before .<br />
<h4 style="text-align: left;">
Suggested Article for PHP Developers .</h4>
<div>
<ul style="text-align: left;">
<li>Chapter 3 : <a href="http://www.howi.in/2015/10/execute-mysql-query-in-php.html" target="_blank">Execution of Mysql Query Using PHP .</a></li>
<li>Chapter 4 : Fetch Data From Database Using PHP .</li>
<li>Chapter 5 : Update Data of Database Using PHP .</li>
</ul>
<div>
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 </div>
</div>
</div>

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...

+ Read more »