Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <body>
  4. <?php
  5. $dbhost = 'localhost';
  6. $dbuser = '';
  7. $dbpass = '';
  8. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  9. if(! $conn )
  10. {
  11. die('Could not connect: ' . mysql_error());
  12. }
  13. $sql = 'SELECT emp_id, emp_name, emp_salary FROM employee';
  14.  
  15. mysql_select_db('test_db');
  16. $retval = mysql_query( $sql, $conn );
  17. if(! $retval )
  18. {
  19. die('Could not get data: ' . mysql_error());
  20. }
  21. while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
  22. {
  23. echo "EMP ID :{$row['emp_id']} <br> ".
  24. "EMP NAME : {$row['emp_name']} <br> ".
  25. "EMP SALARY : {$row['emp_salary']} <br> ".
  26. "--------------------------------<br>";
  27. }
  28. echo "Fetched data successfully\n";
  29. mysql_close($conn);
  30. ?>
  31. </body>
  32. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement