Advertisement
qiTsuk

Virkende-ish

Mar 9th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1. <?php
  2.  
  3. $host = '127.0.0.1';
  4. $port = '3306';
  5. $server = $host . ':' . $port;
  6. $user = 'root';
  7. $password = '';
  8.  
  9. $link = mysql_connect ($server, $user, $password);
  10. if (!$link)
  11. {
  12.     die('Error: Could not connect: ' . mysql_error());
  13. }
  14.  
  15. $database = 'mysql';
  16.  
  17. mysql_select_db($database);
  18.  
  19. $query = 'select * from user';
  20.  
  21. $result = mysql_query($query);
  22.  
  23. if (!$result)
  24. {
  25.     $message = 'ERROR:' . mysql_error();
  26.     return $message;
  27. }
  28. else
  29. {
  30.     $i = 0;
  31.     echo '<html><body><table><tr>';
  32.     while ($i < mysql_num_fields($result))
  33.     {
  34.         $meta = mysql_fetch_field($result, $i);
  35.         echo '<td>' . $meta->name . '</td>';
  36.         $i = $i + 1;
  37.     }
  38.     echo '</tr>';
  39.    
  40.     $i = 0;
  41.     while ($row = mysql_fetch_row($result))
  42.     {
  43.         echo '<tr>';
  44.         $count = count($row);
  45.         $y = 0;
  46.         while ($y < $count)
  47.         {
  48.             $c_row = current($row);
  49.             echo '<td>' . $c_row . '</td>';
  50.             next($row);
  51.             $y = $y + 1;
  52.         }
  53.         echo '</tr>';
  54.         $i = $i + 1;
  55.     }
  56.     echo '</table></body></html>';
  57.     mysql_free_result($result);
  58. }
  59.  
  60. mysql_close ($link);
  61. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement