Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once "connect.php";
- $polaczenie = @new mysqli($host, $db_user, $db_password, $db_name);
- if ($polaczenie->connect_errno!=0)
- {
- echo "Error: ".$polaczenie->connect_errno;
- }
- else {
- if(isset($_POST['pole'])){ $pole = $_POST['pole']; }
- $sql = "SELECT $pole FROM przyjaciele";
- $sql_wynik = mysqli_query($polaczenie, $sql) or die ("nie da się senior");
- echo "<table border=1>";
- echo "<tr>
- <th>id</th>
- <th>imie</th>
- <th>nazwisko</th>
- <th>miasto</th>
- <th>data_ur</th>
- </tr>";
- if($pole == 'id'){
- while($row = mysqli_fetch_array($sql_wynik)){
- $id = $row['id'];
- echo "<tr><td>$id</td><td></td><td></td><td></td><td></td></tr>";
- }
- echo "</table>";
- }
- elseif($pole == 'imie'){
- while($row = mysqli_fetch_array($sql_wynik)){
- $imie = $row['imie'];
- echo "<tr><td></td><td>$imie</td><td></td><td></td><td></td></tr>";
- }
- echo "</table>";
- }
- elseif($pole == 'nazwisko'){
- while($row = mysqli_fetch_array($sql_wynik)){
- $nazwisko = $row['nazwisko'];
- echo "<tr><td></td><td></td><td>$nazwisko</td><td></td><td></td></tr>";
- }
- echo "</table>";
- }
- elseif($pole == 'miasto'){
- while($row = mysqli_fetch_array($sql_wynik)){
- $miasto = $row['miasto'];
- echo "<tr><td></td><td></td><td></td><td>$miasto</td><td></td></tr>";
- }
- echo "</table>";
- }
- elseif($pole == 'data_ur'){
- while($row = mysqli_fetch_array($sql_wynik)){
- $data_ur = $row['data_ur'];
- echo "<tr><td></td><td></td><td></td><td></td><td>$data_ur</td></tr>";
- }
- echo "</table>";
- }
- else {
- echo "i po co senior Ci ta *?<br>Tabelke pokaże z grzeczności";
- }
- mysqli_free_result($sql_wynik);
- $polaczenie->close();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement