Temat: księgarnia - usuń
<body bgcolor="silver">
<form method="post">
<p>Autor: <input type="text" name="autor" value="" style="width:250px;"></p>
<p>Tytuł: <input type="text" name="tytul" value="" style="width:250px;"></p>
<p>Wydawnictwo: <select name="wydawnictwo" style="width:250px;">
<option>Helion</option>
<option>Nowa Era</option>
<option>WSiP</option>
</select></p>
<p><input type="submit" value="Dodaj"></p>
<hr>
<?php
if ($_POST)
{
if (!empty($_POST['usun'])) $usun = (int)$_POST['usun']; else $usun=0;
if (!empty($_POST['autor'])) $autor = $_POST['autor']; else $autor="";
if (!empty($_POST['tytul'])) $tytul = $_POST['tytul']; else $tytul="";
if (!empty($_POST['wydawnictwo'])) $wydawnictwo = $_POST['wydawnictwo']; else $wydawnictwo="";
//INSERT
$con = mysqli_connect('localhost', 'root', '', 'ksiegarnia');
$sql = "INSERT INTO ksiazki VALUES (NULL, '".$autor."', '".$tytul."', '".$wydawnictwo."');";
$wynik = mysqli_query($con, $sql);
mysqli_close($con);
//usun
$con = mysqli_connect('localhost', 'root', '', 'ksiegarnia');
$sql = "DELETE FROM ksiazki WHERE id='".$usun."'";
echo $usun;
$wynik = mysqli_query($con, $sql);
mysqli_close($con);
}
?>
<table bgcolor="white" border="1">
<tr>
<td>id</td>
<td>autor</td>
<td>tytul</td>
<td>wydawnictwo</td>
</tr>
<?php
//SELECT
$con = mysqli_connect('localhost', 'root', '', 'ksiegarnia');
$sql = 'SELECT * FROM ksiazki;';
$wynik = mysqli_query($con, $sql);
while ($res=mysqli_fetch_array($wynik))
{
echo "<tr>";
echo "<td><input type=radio name=usun value=".($res["id"])."></td>"."\n";
echo "<td>".($res["id"])."</td>";
echo "<td>".($res["autor"])."</td>";
echo "<td>".($res["tytul"])."</td>";
echo "<td>".($res["wydawnictwo"])."</td>";
echo "</tr>\n";
}
mysqli_close($con);
?>
</table>
</form>