Exemplo n.º 1
0
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);
}
Exemplo n.º 2
0
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;
}