Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case 'baza':
- $conn = mysql_connect('localhost', 'root', '') or die("Failed to connect to mysql: " . mysql_error());
- $db = mysql_select_db('mojabazadanych',$conn) or die("Failed to connect to mysql: " . mysql_error());
- $sql = "SELECT * FROM pracownicy";
- $data = mysql_query($sql,$conn);
- $num = mysql_num_rows($data);
- $onpage = 5;
- if ($num == 0) {
- echo "      <strong>Brak danych.</strong>";
- } else {
- if(!isset($_GET['strona'])) {
- $_GET['strona'] = 0;
- }
- mysqli_report(MYSQLI_REPORT_STRICT);
- $con = new mysqli('localhost', 'root', '', 'mojabazadanych');
- /* if(!isset($_GET['fraza'])) {
- $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
- } else {
- $phrase = $_GET['fraza'];
- $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy WHERE Nazwisko LIKE '%$phrase%' LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
- }
- */
- $result = $con->query("SELECT SQL_CALC_FOUND_ROWS * FROM pracownicy WHERE Nazwisko LIKE '%$phrase%' LIMIT ".$con->real_escape_string((int)$_GET['strona']*$onpage).",".$onpage);
- echo "<div style=overflow-x:auto>";
- echo "<table style='margin: 0 auto'>";
- echo "<tr>
- <th>ID</th>
- <th>Imie</th>
- <th>Nazwisko</th>
- <th>Nazwisko_panienskie</th>
- <th>Plec</th>
- <th>E_mail</th>
- <th>Kod_pocztowy</th>
- </tr>";
- while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
- echo "<tr>";
- echo "<td>" . $row['id'] . "</td>";
- echo "<td>" . $row['Imie'] . "</td>";
- echo "<td>" . $row['Nazwisko'] . "</td>";
- echo "<td>" . $row['Nazwisko_panienskie'] . "</td>";
- echo "<td>" . $row['Plec'] . "</td>";
- echo "<td>" . $row['E_mail'] . "</td>";
- echo "<td>" . $row['Kod_pocztowy'] . "</td>";
- echo "</tr>";
- }
- echo "</table>";
- echo "</div>";
- $SQL = "SELECT FOUND_ROWS() as Ilosc";
- $RES= $con->query($SQL);
- list($iloscWpisow) = mysqli_fetch_row($RES);
- if($_GET['strona']>0) {
- echo '<a href="?baza='.($_GET['strona']-1).'"><-</a> ';
- }
- for($i = 0;$i<=floor($iloscWpisow/$onpage);$i++) {
- echo '<a href="?baza='.($i).'">[ '.($i+1).' ]</a> ';
- }
- if($_GET['strona']<floor($iloscWpisow/$onpage)) {
- echo ' <a href="?baza='.($_GET['strona']+1).'">-></a>';
- }
- $con->close();
- }
- break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement