// polacz.php

<?php
        session_start();
    $host = 'localhost';
    $user = 'root';
    $pass = '';
    $db = 'samochody';
    $conn = mysql_connect($host, $user, $pass);
    $sql = 'CREATE DATABASE IF NOT EXISTS samochody';
    $baza=mysql_query($sql);
    if(!$conn){
        die('Wystapil blad: '.mysql_error());
    }
    else{
        $dba = @mysql_select_db($db, $conn);
        if(!$dba){
            die('Wystapil blad: '.mysql_error());
        }
        else{
            $tableName = 'Sprzedane';
            $sql_2= 'CREATE TABLE '.$tableName.' (id int(8) NOT NULL, marka varchar(32), data date,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))';
            mysql_query($sql_2);
            }
        }

    ?>

//zad.php

<style type="text/css">
/* <![CDATA[ */
table tr td { border: 1px solid black; border-radius: 20px; background: gray; text-align: center; padding: 3px; }
/* ]]> */
</style>

<?php
    REQUIRE("polacz.php");
    $order = $_GET['order'];
    $mod = $_GET['mod'];
    $data = mysql_query("SELECT * FROM Sprzedane ORDER BY ".(($order) ? $order : 'id ASC'));

    if(!$mod){
        echo "<table>";
        echo "<tr>";
        echo "<td>ID<br><a href='?zad=2&order=id asc'>rosnaco</a> <a href='?zad=2&order=id desc'>malejaco</a></td>";
        echo "<td>marka<br><a href='?zad=2&order=marka asc'>rosnaco</a> <a href='?zad=2&order=marka desc'>malejaco</a></td>";
        echo "<td>data<br><a href='?zad=2&order=data asc'>rosnaco</a> <a href='?zad=2&order=data desc'>malejaco</a></td>";
        echo "</tr>";
        while($d = mysql_fetch_array($data)){
            echo "<tr>";
            echo "<td>".$d['id']."</td>";
            echo "<td>".$d['marka']."</td>";
            echo "<td>".$d['data']."</td>";
            echo "</tr>";
        }
        echo "</table>";

        echo "<br><a href='?zad=2&mod=1'>Modyfikuj</a><br>";
    } else {
        echo "<table>";
        echo "<tr>";
        echo "<td>ID<br><a href='?zad=2&order=id asc&mod=1'>rosnaco</a> <a href='?zad=2&order=id desc&mod=1'>malejaco</a></td>";
        echo "<td>marka<br><a href='?zad=2&order=marka asc'>rosnaco</a> <a href='?zad=2&order=marka desc'>malejaco</a></td>";
        echo "<td>data<br><a href='?zad=2&order=data asc'>rosnaco</a> <a href='?zad=2&order=data desc'>malejaco</a></td>";
        echo "<td>Modyfikuj</td>";
        echo "<td>Usun</td>";
        echo "</tr>";
        while($d = mysql_fetch_array($data)){
            echo "<form action='?zad=2&mod=1' method='post'>";
            echo "<tr>";
            echo "<td><input type='text' name='id' value='".$d['id']."' readonly></td>";
            echo "<td><input type='text' name='marka' value='".$d['marka']."'></td>";
            echo "<td><input type='text' name='data' value='".$d['data']."'</td>";
            echo "<td><input type='submit' value='Modyfikuj' name='mod2'></td>";
            echo "<td><input type='submit' value='Usun' name='del'></td>";
            echo "</tr>";
            echo "</form>";
        }
        echo "</table>";

        $id = htmlspecialchars(trim($_POST['id']));
        $marka = htmlspecialchars(trim($_POST['marka']));
        $data = htmlspecialchars(trim($_POST['data']));
        $mod2 = htmlspecialchars(trim($_POST['mod2']));
        $del = htmlspecialchars(trim($_POST['del']));

        if($_POST){
            if($id && $marka && $data ){
                if($mod2){
                    echo "UPDATE Sprzedane SET marka='".$marka."', data='".$data."' WHERE id='".$id."'";
                    mysql_query("UPDATE Sprzedane SET marka='".$marka."', data='".$data."' WHERE id='".$id."'") or die(mysql_error());
                    header('Location: ?zad=2&mod=1');
                } else {
                    mysql_query("DELETE FROM Sprzedane WHERE id='".$id."'") or die(mysql_error());
                    header('Location: ?zad=2&mod=1');
                }
            }
        }

        echo "<br><a href='?zad=2'>Wyswietl</a><br>";
    }

    echo "<br><br>Dodaj dane:<br>";

    echo "<form action='?zad=2&mod=".$mod."' method='post'>";

    echo "<table>";
    echo "<tr>";
    echo "<td>id</td>";
    echo "<td>marka</td>";
    echo "<td>data</td>";
    echo "</tr>";
    echo "<tr>";
    echo "<td><input type='text' name='id'></td>";
    echo "<td><input type='text' name='marka'></td>";
    echo "<td><input type='text' name='data'></td>";
    echo "<td><input type='submit' name='add' value='Dodaj'></td>";
    echo "</tr>";
    echo "</table>";

    echo "</form>";
    $id = htmlspecialchars(trim($_POST['id']));
    $marka = htmlspecialchars(trim($_POST['marka']));
    $data = htmlspecialchars(trim($_POST['data']));
    $add = htmlspecialchars(trim($_POST['add']));

    if($_POST){
            if($id &&$marka && $data && $add){
                mysql_query("INSERT INTO Sprzedane SET id='".$id."', marka='".$marka."', data='".$data."'");
                header('Location: ?zad=2&mod='.$mod);
            }
        }
?>