Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.55 KB | None | 0 0
  1. case 'baza':
  2. $conn = mysql_connect('localhost', 'root', '') or die("Failed to connect to mysql: " . mysql_error());
  3. $db = mysql_select_db('mojabazadanych',$conn) or die("Failed to connect to mysql: " . mysql_error());
  4. $sql = "SELECT * FROM pracownicy";
  5. $data = mysql_query($sql,$conn);
  6. $num = mysql_num_rows($data);
  7.  
  8. $onpage = 5;
  9.  
  10. if ($num == 0) {
  11. echo "&nbsp &nbsp &nbsp <strong>Brak danych.</strong>";
  12. } else {
  13. if(!isset($_GET['strona'])) {
  14. $_GET['strona'] = 0;
  15. }
  16. mysqli_report(MYSQLI_REPORT_STRICT);
  17. $con = new mysqli('localhost', 'root', '', 'mojabazadanych');
  18. /* if(!isset($_GET['fraza'])) {
  19. $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
  20. } else {
  21. $phrase = $_GET['fraza'];
  22. $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy WHERE Nazwisko LIKE '%$phrase%' LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
  23. }
  24. */
  25. $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy WHERE Nazwisko LIKE '%$phrase%' LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
  26.  
  27. echo "<div style=overflow-x:auto>";
  28. echo "<table style='margin: 0 auto'>";
  29. echo "<tr>
  30. <th>ID</th>
  31. <th>Imie</th>
  32. <th>Nazwisko</th>
  33. <th>Nazwisko_panienskie</th>
  34. <th>Plec</th>
  35. <th>E_mail</th>
  36. <th>Kod_pocztowy</th>
  37. </tr>";
  38. while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
  39. echo "<tr>";
  40. echo "<td>" . $row['id'] . "</td>";
  41. echo "<td>" . $row['Imie'] . "</td>";
  42. echo "<td>" . $row['Nazwisko'] . "</td>";
  43. echo "<td>" . $row['Nazwisko_panienskie'] . "</td>";
  44. echo "<td>" . $row['Plec'] . "</td>";
  45. echo "<td>" . $row['E_mail'] . "</td>";
  46. echo "<td>" . $row['Kod_pocztowy'] . "</td>";
  47. echo "</tr>";
  48. }
  49. echo "</table>";
  50. echo "</div>";
  51. $SQL = "SELECT FOUND_ROWS() as Ilosc";
  52. $RES= $con->query($SQL);
  53. list($iloscWpisow) = mysqli_fetch_row($RES);
  54. if($_GET['strona']>0) {
  55. echo '<a href="?baza='.($_GET['strona']-1).'"><-</a> ';
  56. }
  57.  
  58. for($i = 0;$i<=floor($iloscWpisow/$onpage);$i++) {
  59. echo '<a href="?baza='.($i).'">[ '.($i+1).' ]</a> ';
  60. }
  61. if($_GET['strona']<floor($iloscWpisow/$onpage)) {
  62. echo ' <a href="?baza='.($_GET['strona']+1).'">-></a>';
  63. }
  64.  
  65. $con->close();
  66. }
  67. break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement