Top
Home


<?php
  $dbhost = 'LOCALHOST';
  $dbuser = 'USER';
  $dbpass = 'PASSWORD';
  $db = 'DATABASE';
  
  $conn = mysql_connect($dbhost, $dbuser, $dbpass,$db);
  
  if(! $conn )
  {
     die('Could not connect: ' . mysql_error());
  }
  
  $sql = 'SELECT * FROM TABLE';
  mysql_select_db($db);
  $retval = mysql_query( $sql, $conn );
  
  if(! $retval )
  {
     die('Could not get data: ' . mysql_error());
  }
  
  while($row = mysql_fetch_array($retval, MYSQL_NUM))
  {
     echo "EMP ID :{$row[0]}  <br> ".
        "EMP NAME : {$row[1]} <br> ".
        "EMP SALARY : {$row[2]} <br> ".
        "--------------------------------<br>";
  }
  
  mysql_free_result($retval);
  echo "Here It Is!\n";
  
  mysql_close($conn);
?>