Untitled

<?php


$host='localhost';
$db='dtworek_praktyka';
$user='dtworek';
$pass='LzGH33';

//$mysqli = mysqli_connect($host, $user, $pass);
$mysqli = new mysqli("localhost", $user, $pass,$db);
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}

$query = "SELECT * FROM Praktyka ORDER BY data";
$result =$mysqli->query($query);
$tablica=array();
while($row=$result->fetch_array(MYSQLI_ASSOC))
    $tablica[]=$row;

/*$zapytanie = "INSERT INTO test (marka, model, kolor, pojemnosc, paliwo) VALUES ('$marka','$model','$kolor','$pojemnosc','$paliwo')" or die(mysql_error());
    // wykonaj zapytanie
    $wynik = mysql_query($zapytanie);
    // komunikat potwierdzający poprawne zapisanie danych w bazie
    if ($wynik) {
        echo 'Prawidłowo dodano do bazy danych';
    }
*/
//print_r($tablica[2]['tresc']); exit;
?>


<html>
<head>
 <script type="text/javascript">

    function zmien(id)
    {
        document.getElementById('tresc_'+id).innerHTML='<input value="'+document.getElementById('tresc_'+id).innerHTML+'"/>';

        document.getElementById('przycisk_'+id).innerHTML='zapisz';

    }


   </script>
</head>
<body bgcolor="aqua">
<i><font size="10">Formularz<br><br></font></i>
<form action="" method="post">

Temat zadania<br /><input required type="text" name="tresc" maxlength="50" size="50" /><br /><br /><br />
Data zadania<br /> <input name="data" required type="date" min="2018-01-30" max="2025-12-31"/><br /><br />
<input type="submit" value="Dodaj" name="dodaj" /><br /><br /><br />
</form>


<?php


if(isset($_POST['dodaj']))
{
    if($_POST['dodaj']=='Dodaj')
    {


        $tresc= $_POST['tresc'];
        $data= $_POST['data'];

        $query =("INSERT INTO Praktyka SET data='$data', tresc='$tresc'");
        $mysqli->query($query);

        header('Location: http://dtworek.poxi.pl/');
    }
}
?>
<table border="2" bgcolor="white" id="tblSort">
<tr>
<th>linia</th><th width="150" bgcolor="yellow" class="SSort">Data</th> <th width="500" bgcolor="lime">Zadanie</th><th width="100">Usuń</th>
</tr>
<?php
if(isset($_GET['usun']))
{
    $query = "DELETE from Praktyka WHERE id=".$_GET['usun'];
    if(!$mysqli->query($query))
        die('błąd zapytania '.$mysqli->error);

    header('Location: http://dtworek.poxi.pl/');

}

foreach($tablica as $mtablica)
{

    echo '<tr><td>'.$mtablica['id'].'</td><td>'.$mtablica['data'].'</td><td id="tresc_'.$mtablica['id'].'">'.$mtablica['tresc'].'</td><td>'.'<a href="/?usun='.$mtablica['id'].'"><button >usun</button></a>'.'<button onclick="javascript:zmien('.$mtablica['id'].');" id="przycisk_'.$mtablica['id'].' name="update"">zmien</button>'.'</td></tr>';
}
mysql_query('UPDATE `Praktyka` SET `name`="'.$_POST['ubdate'].'" WHERE `id`="'.$_POST['cos_z_formularza'].'"')
?>
</table>
</body>
</html>