*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE `category` (`id` INT NOT NULL AUTO_INCREMENT , `category` VARCHAR(255) NOT NULL , `count` INT NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `products` ( `id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT , `category_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `description` TEXT NOT NULL , `count` INT NOT NULL , `repair_required` VARCHAR(255) NOT NULL , `status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL ) ENGINE = InnoDB; CREATE TABLE `date` (`id` INT NOT NULL AUTO_INCREMENT , `products_id` INT NOT NULL , `product_status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php //require "../config/connect.php"; $connect = &$mysqli; $id = 1; //$_POST['id']; $description = 'my description'; //$_POST['description']; $name = 'my name '; //$_POST['name']; $repair = $_POST['repair_required']; $prodID=(int)$_POST['products_id']; // var_dump($prodID); // var_dump($id); // var_dump($description); // var_dump($name); if (empty($name) && empty($description)) { echo "Заполните поле"; } else { // добавление товара mysqli_query($connect, "INSERT INTO `products` (`id`, `category_id`, `name`, `description`, `count`, `repair_required`, `status`, `date`) VALUES (NULL, '$id', '$name', '$description', 1, '$repair', 'На складе', NOW());"); // Добавление записи в его историю mysqli_query($connect, "INSERT INTO `date` (`id`, `products_id`, `product_status`, `date`) VALUES (NULL, '$prodID', 'Поступил на склад', NOW())"); // Возрват на главную страницу //header("location: /products.php?id=" . $id); }

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online