PHP s_db_exec Examples

Example #1

File: devinc.mdb2.php Project: anjestar/SHFramework

function _s_db_delete($table, $v1)
{
    if (s_bad_string($table, $table, true) || !($v1 = is_array($v1) && isset($v1["id"]) ? intval($v1["id"]) : $v1) || s_bad_id($v1)) {
        return s_err_arg();
    }
    if (defined("APP_DB_PREFIX")) {
        //替换表名:"%s_user:update" => "201204disney_user:update"
        $table = sprintf($table, APP_DB_PREFIX, true);
    }
    $sql = "update `{$table}` set `status`=-1 where `id`= {$v1}";
    return s_db_exec($sql);
}

Example #2

File: devinc.mdb2.php Project: anjestar/SHFramework

function _s_db_delete($table, $v1)
{
    if (s_bad_string($table, $table, true) || !($v1 = is_array($v1) && isset($v1["id"]) ? intval($v1["id"]) : $v1) || s_bad_id($v1)) {
        return s_err_arg();
    }
    $prev = defined("APP_DB_PREFIX") ? APP_DB_PREFIX . "_" : "";
    $sql = "update `{$prev}{$table}` set `status`=-1 where `id`= {$v1}";
    return s_db_exec($sql);
}