PHP-MySQL

PHP-Database Programs

Following are the various PHP  programs to demonstrate Database  connections.

1. PHP Program to demonstrates whether the connection to mysql database is active or not.

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db = 'mars_db';
$conn = mysql_connect($dbhost,$dbuser,$dbpass);

if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
else
{
echo 'Connected successfully';
}
?>

The above program will show following output.

2. PHP Program to create database from localhost.

<?php
$con=mysqli_connect("localhost","root","");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="CREATE DATABASE demo_12";

if (mysqli_query($con,$sql))
  {
  echo "Database demo_12 created successfully";
  }
else
  {
  echo "Error creating database: " . mysqli_error();
  }
?>

The above program produces following output.

3. PHP Program to create a table in database from localhost.

<?php
$con=mysqli_connect("localhost","root","","demo_12");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="CREATE TABLE emp_ret(FirstName CHAR(30),LastName CHAR(30),Age INT)";

if (mysqli_query($con,$sql))
  {
  echo "Table emp_ret created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error();
  }
?>

The above program will have a following output.

4. PHP Program to connect MS Access Database using ODBC Data source. [Click here to create DSN (Data Source Naming) for MS Access.]

<html>
<body>
<h3 style="background-color:yellow"> Connecting to Ms 

Access Database using PHP </h3>
<hr>
<?php
$conn=odbc_connect('acc_php','','');
if (!$conn)
 {
exit("Connection Failed: " . $conn);
}
$sql="SELECT * FROM Cust";
$rs=odbc_exec($conn,$sql);

if (!$rs)
{
exit("Error in SQL");
}
echo "<table border=1><tr>";
echo "<th>Customer Code</th>";
echo "<th>Customer Name</th>";
echo "<th>Address</th></tr>";
while (odbc_fetch_row($rs))
  {
  $c_code=odbc_result($rs,"ccode");
  $c_name=odbc_result($rs,"cname");
  $c_addr=odbc_result($rs,"caddr");
  echo "<tr><td>$c_code</td>";
  echo "<td>$c_name</td>";
  echo "<td>$c_addr</td></tr>";
  }
odbc_close($conn);
echo "</table>";
?>
</body>
</html>

The above program produces following output.

 

SKB

Leave a Reply

Your email address will not be published. Required fields are marked *