Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2017
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. <?php
  2. $name;
  3. if(isset($_REQUEST['surname'])) {
  4. $name = $_REQUEST['surname'];
  5. } else {
  6. echo "podaj cos <br>";
  7. }
  8.  
  9.  
  10. $Host='127.0.0.1';
  11. $DBase='oswiata';
  12. $FUser='root';
  13. $FPass='';
  14.  
  15.  
  16. function polacz( $host,$dbase,$user, $pass ) {
  17. @$pol=mysql_connect( $host, $user, $pass );
  18. if( !$pol ) {
  19. echo 'BÅ‚ad polaczenia z Serwerem Bazy Danych';
  20. exit();
  21. } else {
  22. @mysql_select_db( $dbase );
  23. if( mysql_errno() ) {
  24. echo mysql_errno() . ': '. mysql_errno();
  25. echo mysql_error();
  26. exit();
  27. }
  28. }
  29. return $pol;
  30. }
  31.  
  32. $idpol=polacz($Host, $DBase, $FUser, $FPass);
  33.  
  34. @$wyniki=mysql_db_query($DBase, "SELECT * FROM pracownicy WHERE nazwisko like '$name%'", $idpol);
  35.  
  36.  
  37. if( $wyniki ) {
  38.  
  39. $index = 0;
  40.  
  41. echo "<table border=1>";
  42. while($wiersz=mysql_fetch_row($wyniki)) {
  43. $color;
  44. if ($index%2 == 0) {
  45. $color = "#dcdde5";
  46. } else {
  47. $color = "#c0c6e0";
  48. }
  49. $index++;
  50.  
  51. echo "<tr style=\"background-color: $color\">";
  52. echo "<td>$wiersz[0]</td><td>$wiersz[1]</td><td>$wiersz[2]</td><td>$wiersz[3]</td><td>$wiersz[4]</td>";
  53. echo "</tr>";
  54. }
  55. echo "</table>";
  56. } else {
  57. echo "Brak";
  58. }
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement