Example to show php connecting to mysql db.

PHP MySQL connect.php

<?php
  /* source: www.w3schools.com */
  $con = mysql_connect("localhost","peter","abc123");
  
  if (!$con){
    die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("my_db", $con);

  $result = mysql_query("SELECT * FROM Persons");

  echo "<table border='1'>
  <tr>
    <th>Firstname</th>
    <th>Lastname</th>
  </tr>";

  while($row = mysql_fetch_array($result)){
    echo "<tr>";
    echo "<td>" . $row['FirstName'] . "</td>";
    echo "<td>" . $row['LastName'] . "</td>";
    echo "</tr>";
  }
  echo "</table>";

  mysql_close($con);
?>