Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "123456";
  6. $dbname = "myDB";
  7.  
  8.  
  9. // Connecting, selecting database
  10. $link = mysql_connect($servername, $username, $password)
  11.  
  12. or die('Could not connect: ' . mysql_error());
  13. echo 'Connected successfully';
  14. mysql_select_db($dbname) or die('Could not select database');
  15.  
  16.  
  17. // Performing SQL query
  18. $query = 'SELECT * FROM WSWT';
  19. $result = mysql_query($query) or die('Query failed: ' . mysql_error());
  20.  
  21. // Printing results in HTML
  22. echo "<table>\n";
  23. while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  24. echo "\t<tr>\n";
  25. foreach ($line as $col_value) {
  26. echo "\t\t<td>$col_value</td>\n";
  27. }
  28. echo "\t</tr>\n";
  29. }
  30. echo "</table>\n";
  31.  
  32. // Free resultset
  33. mysql_free_result($result);
  34.  
  35. // Closing connection
  36. mysql_close($link);
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement