SQLite3::query(): misuse of aggregate function sum() in C:\OSPanel\domains\localhost\pr0\us.php on line 45
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<form action="<?php print $SERVER['PHP_SELF'] ?>" method="POST">
<table border="1" cellpadding="5">
<tr>
<td align="center"><b>Удалить</b></td>
<td align="center"><b>Товар</b></td>
<td align="center"><b>Цена</b></td>
</tr>
<?php
$dbname="products.db";
$db = new SQLite3('products.db');
$values= $_POST['price'];
if (!$db) exit("Не удалось создать базу данных!");
$result = $db->query('select * from Tovar') or die(mysql_error());
while($row = $result->fetchArray()) {
?>
<tr>
<td><input type="checkbox" name="del" value="$id"></td>
<td><?php echo $row[tovar] ?></td>
<td><input value="<?php echo $row[price] ?>"></td>
</tr>
<?php }
if (!empty ($_POST['del'])){
foreach ($_POST['del'] as $val) {
$db->exec("DELETE FROM Tovar WHERE id = '$val'");
}
}
if (!empty ($_POST['add_tovar']) && !empty ($_POST['add_price'])){
$db->query("INSERT INTO Tovar (tovar, price) values ('add_tovar','add_price')");
}
$db->close();
?>
<tr>
<td></td>
<td><input type="text" name="add_tovar" value="" /></td>
<td><input type="text" name="add_price" value="" /></td>
</tr>
<tr>
<td colspan="3">
<input type="submit" value="Записать" name="zapis">
</td>
</tr>
</table>
</form>
</body>
</html>