PHPize Online / SQLize Online  /  SQLtest Online

<?php $_POST['save'] = 1; $_POST['name'] = 'Name1'; $_POST['product'] = 'Product1'; $_POST['price'] = 100; $_POST['email'] = 'no@mail.com'; $_POST['uid'] = 'e8bf6202-5033-11eb-ae93-0242ac130002'; if(isset($_POST['save'])) { $name = $_POST['name']; $product = $_POST['product']; $price = $_POST['price']; $email = $_POST['email']; $uid = $_POST['uid']; mysqli_begin_transaction($mysqli); try { /* Добавление значений */ $stmt = mysqli_prepare($mysqli, "INSERT INTO tovar (name,product,price,email) VALUES (?, ?, ?, ?)"); mysqli_stmt_bind_param($stmt, 'ssss', $name, $product, $price, $email); mysqli_stmt_execute($stmt); $stmt = mysqli_prepare($mysqli, "UPDATE shtuck SET sht = sht - 1 WHERE id=?"); mysqli_stmt_bind_param($stmt, 's', $uid); mysqli_stmt_execute($stmt); /* Если код достигает этой точки без ошибок, фиксируем данные в базе данных. */ mysqli_commit($mysqli); } catch (mysqli_sql_exception $exception) { mysqli_rollback($mysqli); throw $exception; } mysqli_close($mysqli); } $query = "SELECT * FROM tovar;"; $stmt = $pdo->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($rows); $query = "SELECT * FROM shtuck;"; $stmt = $pdo->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($rows);