Check PHP MySQL Connectivity: In this tutorial you will get to know about the connectivity of PHP and MySQL server. It also describes about the predefined objects which helps us to connect with the server.
Check PHP MySQL Connectivity: In this tutorial you will get to know about the connectivity of PHP and MySQL server. It also describes about the predefined objects which helps us to connect with the server.Check PHP MySQL Connectivity:
The first step of any kind of connectivity is to check whether the connectivity has been established or not. To check the connectivity we need to know three things: The host name, Username, and respective Password.
Usuaally Host name is localhost, Username is root and password is " " (blank, unless you have set it ). After getting all these details we can connect a PHP page with MySQL server.
Following piece of code will help you to check whether your PHP web page has been connected with MySQL server or not.
Code 1:
<?php
$con=mysql_connect("localhost","root", "");
if(!$con)
{
die('could not connect'. mysql_error());
}
mysql_select_db("roseindia",$con);
$result=mysql_query("select * from personal");
echo"<table border=1>";
echo"<tr><th>Employee ID</th><th>Address</th>";
while ($row=mysql_fetch_array($result))
{
echo"<tr>";
echo "<td>".$row['emp_id']."</td>"."<td>".$row['address']."</td>";
echo "</tr>";
}
echo"</table>";
mysql_close($con);
?>
Output:
Name |
Employee Id |
---|---|
emp01 | new d |
emp02 | new d |
emp03 | new d |
Little descriptions about the predefined objects:
die : It is a language construct and equivalent to exit(), outputs a message and terminates the program.
mysql_connect: Open a connection to a MySQL server.
mysql_error(): Returns the error message.
mysql_select_db: Select a MySQL database
mysql_query: It is a function which is used for send a sql query.
mysql_fetch_array: Fetch a result row of a query as an associative array.
mysql_close: Close MySQL connection.