Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Strona z tabela</title>
  4. <meta name="Costam" content="Ja"/>
  5. <meta http-equiv="Content-type" content="text/html' charset=windows-1250" />
  6. </head>
  7.  
  8. <body>
  9.  
  10. <?php
  11.  
  12.  
  13. $username = 'root';
  14. $password = 'korki';
  15. $database = 'users';
  16.  
  17. mysql_connect('localhost', $username, $password);
  18.  
  19. @mysql_select_db($database) or die("Nie odnaleziono bazy danych");
  20. $query="SELECT * FROM contacts";
  21. $result=mysql_query($query);
  22.  
  23. $num=mysql_numrows($result);
  24.  
  25. mysql_close();
  26.  
  27. echo "<b><center>Struktura bazy danych</center></b><br><br>";
  28.  
  29. $i=0;
  30. while ($i < $num) {
  31.  
  32. $first=mysql_result($result,$i,"first");
  33. $last=mysql_result($result,$i,"last");
  34. $phone=mysql_result($result,$i,"phone");
  35. $mobile=mysql_result($result,$i,"mobile");
  36. $fax=mysql_result($result,$i,"fax");
  37. $email=mysql_result($result,$i,"email");
  38. $web=mysql_result($result,$i,"web");
  39.  
  40. echo "<b>$first $last</b><br>telefon stacjonarny: $phone<br>Telefon komórkowy: $mobile<br>Fax: $fax<br>E-mail: $email<br>Strona WWW: $web<br><hr><br>";
  41.  
  42. $i++;
  43. }
  44.  
  45.  
  46.  
  47.  
  48.  
  49. ?>
  50.  
  51.  
  52.  
  53.  
  54. </body>
  55. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement