function createAction() { $config = getConfig(); $params = $config['memcache']; $table = ['name' => 'item', 'dbname' => 'db_vktest', 'as' => 'i']; $item = handleRequest($_POST); $mysqli = db_mysqli_connect($table['dbname']); $queryInsert = "INSERT INTO item (name,description,price,url) VALUES (" . "'" . mysqli_real_escape_string($mysqli, $item['name']) . "'," . "'" . mysqli_real_escape_string($mysqli, $item['description']) . "'," . $item['price'] . "," . "'" . mysqli_real_escape_string($mysqli, $item['url']) . "'" . ")"; $resultInsert = mysqli_query($mysqli, $queryInsert); $resultError = mysqli_error($mysqli); db_mysqli_close($mysqli); if (!$resultInsert) { addAlert('danger', 'Произошла ошибка записи:' . $resultError); $url = 'http://' . $_SERVER['HTTP_HOST'] . "/"; header('Location: ' . $url); exit; } //another proc $pid = pcntl_fork(); if ($pid == 0) { changeCountItemsById(1, 1); exit(0); } addAlert('success', 'Продукт добавлен'); $url = 'http://' . $_SERVER['HTTP_HOST'] . "/"; header('Location: ' . $url); }
function deleteItemsByIds($ids) { $table = ['name' => 'item', 'dbname' => 'db_vktest', 'as' => 'i']; $mysqli = db_mysqli_connect($table['dbname']); $sqlQuery = "DELETE FROM item WHERE iditem IN (" . implode(',', $ids) . ')'; $result = mysqli_query($mysqli, $sqlQuery); $_return = $result; if (($deleteRows = mysqli_affected_rows($mysqli)) <= 0) { $_return = false; } var_dump($_return); var_dump($sqlQuery); var_dump($deleteRows); db_mysqli_close($mysqli); if ($_return) { $pid = pcntl_fork(); if ($pid == 0) { changeCountItemsById(1, $deleteRows * -1); exit; } } return $_return; }