dlyaNadyushki

<html>
<head >
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Создание базы данных</title>
</head>
<body>
<div  style="width: 800px; padding-top: 1%;height: 500px; border: 3px solid #000000;">
<i style="font-size:30px;font-family:arial">Создание базы данных</i>
<br><hr></hr><br>
<table border=1;>
<tr align=center><td>&nbsp id &nbsp </td> <td>&nbsp Название &nbsp </td> <td>&nbsp Цена &nbsp </td> <td>&nbsp Количество &nbsp </td> <td>&nbsp Дата &nbsp </td> </tr>

<?php


$sqlhost ="localhost";$sqluser="root";$sqlpass="root";$bd="42";

$bd=mysql_connect($sqlhost,$sqluser,$sqlpass);
mysql_select_db(42,$bd) or die ("Нет базы".mysql_error());

mysql_set_charset('utf8');
$ss='select * from tab42 ORDER BY id';
$res=mysql_query($ss);

while (list($id, $name, $cost, $kol, $date)=mysql_fetch_row($res))
{
echo "<tr align=center><td> $id </td> <td>$name</td> <td>$cost</td> <td>$kol</td> <td>$date</td> </tr>";
}

echo "</table>";
mysql_close($bd);
?>

<br>
<form action="add.php" method="POST">
<input type="text" size="10"  name="id">
<input type="text" size="10" name="name">
<input type="text" size="10" name="cost">
<input type="text" size="10" name="kol">
<input type="text" size="10" name="date">
<input  id = "k1" type="submit" name="a" value="Добавить">
</form>
<form action="delete.php" method="POST">
<input  id = "k2" type="submit" name="delete" value="Удалить">
</form>
<form action="change.php" method="POST">
<input type="text" size="10"  name="id">
<input type="text" size="10" name="name">
<input type="text" size="10" name="cost">
<input type="text" size="10" name="kol">
<input type="text" size="10" name="date">
<input  id = "k3" type="submit" name="Change" value="Изменить">
</form>
</div>
</body>
</html>