Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <link rel="stylesheet" type="text/css" href="style.css">
- </head>
- <body>
- <div id="naglowek">
- </div>
- <div id="menu">
- <input type="button" value="Strona glowna" onclick="location.href='index.php';"> <br />
- <input type="button" value="Rejestracja" onclick="location.href='rejestracja.php';"> <br />
- <input type="button" value="Przegladaj" onclick="location.href='przegladaj.php';"> <br />
- <input type="button" value="Kasowanie" onclick="location.href='kasowanie.php';">
- </div>
- <div id="tresc">
- <form method="post">
- <input type="submit" name="submit" value="Usun" > <br />
- <input type="text" name="usuwanie" placeholder="wpisz liczbę"> <br>
- <?php
- $wyn = $_POST['usuwanie'];
- require_once "db_config.php";
- $polaczenie = @mysqli_connect($db_host,$db_user,$db_pass,$db_name);
- if (mysqli_connect_errno()){
- }
- else{
- $kwerenda1="SELECT * FROM komis";
- $kwerenda2="DELETE FROM komis WHERE id = '$wyn'";
- if($wynik=$polaczenie->query($kwerenda1)){
- $tablica=array();
- if($wynik->num_rows){
- while ($wiersz= mysqli_fetch_assoc($wynik)){
- $tablica[] = $wiersz;
- }
- echo "<table border='1'><tr><td>Id</td><td>Marka</td><td>Model</td><td>Rocznik</td><td>Przebieg</td><td>Paliwo</td><td>Kolor</td><td>Moc </td></tr>";
- for($i=0;$i<sizeof($tablica);$i++){
- echo "<tr>";
- echo "<td>".$tablica[$i]['id']."</td>";
- echo "<td>".$tablica[$i]['marka']."</td>";
- echo "<td>".$tablica[$i]['model']."</td>";
- echo "<td>".$tablica[$i]['rok_prod']."</td>";
- echo "<td>".$tablica[$i]['przebieg']."</td>";
- echo "<td>".$tablica[$i]['paliwo']."</td>";
- echo "<td>".$tablica[$i]['kolor']."</td>";
- echo "<td>".$tablica[$i]['moc']."</td>";
- echo "</tr>";
- }
- echo "</table>";
- }
- }
- else{
- };
- if(isset($_POST['submit'])) {
- $wyn = $_POST['usuwanie'];
- if($wynik=$polaczenie->query($kwerenda2)){
- $tablica=array();
- if($wynik->num_rows){
- echo " ok <br />";
- while ($wiersz= mysqli_fetch_assoc($wynik)){
- $tablica[] = $wiersz;
- }
- }
- }
- }
- $polaczenie->close();
- }
- ?>
- </form>
- </div>
- <div id="stopka"><p> Strona by Patryk Kwinczak ™ </p></div>
- ®
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement