Advertisement
Guest User

Untitled

a guest
Mar 27th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?
  2. $username="nazwa użtkownika";
  3. $password="chasło użytkownika";
  4. $database="nazwa bazy danych";
  5.  
  6. mysql_connect('localhost',$username,$password);
  7. @mysql_select_db($database) or die("Nie odnaleziono bazy danych");
  8. $query="SELECT * FROM contacts";
  9. $result=mysql_query($query);
  10.  
  11. $num=mysql_numrows($result);
  12.  
  13. mysql_close();
  14.  
  15. echo "<b><center>Struktura bazy danych</center></b><br><br>";
  16.  
  17. $i=0;
  18. while ($i < $num) {
  19.  
  20. $first=mysql_result($result,$i,"first");
  21. $last=mysql_result($result,$i,"last");
  22. $phone=mysql_result($result,$i,"phone");
  23. $mobile=mysql_result($result,$i,"mobile");
  24. $fax=mysql_result($result,$i,"fax");
  25. $email=mysql_result($result,$i,"email");
  26. $web=mysql_result($result,$i,"web");
  27.  
  28. 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>";
  29.  
  30. $i++;
  31. }
  32.  
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement