ORM::raw_execute PHP Method

raw_execute() public static method

Useful for queries that can't be accomplished through Idiorm, particularly those using engine-specific features.
public static raw_execute ( string $query, array $parameters = [], string $connection_name = self::DEFAULT_CONNECTION ) : boolean
$query string The raw SQL query
$parameters array Optional bound parameters
$connection_name string Which connection to use
return boolean Success
    public static function raw_execute($query, $parameters = array(), $connection_name = self::DEFAULT_CONNECTION)
    {
        self::_setup_db($connection_name);
        return self::_execute($query, $parameters, $connection_name);
    }

Usage Example

Example #1
1
        $items[] = $item["result"];
    }
    echo implode(";", $items);
});
$app->post('/genv/payhulu', function ($request, $response) {
    $uid = $_SESSION['uid'];
    $amount = $this->request->getParam("amount");
    try {
        ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
        ORM::get_db()->beginTransaction();
        //减去余额
        $sql = vsprintf("UPDATE %s SET `balance` = balance-%d WHERE `uid` = %d and `balance`>=%d ", array(table("members_points"), $amount, $uid, $amount));
        ORM::raw_execute($sql);
        //增加积分;
        $sql = vsprintf("UPDATE %s SET `points` = points+%d WHERE `uid` = %d   ", array(table("members_points"), $amount, $uid));
        ORM::raw_execute($sql);
        echo ORM::get_last_query();
        //
        //        Order::deduct_stock($order['coohua_id'], $order['product_id'], $order['order_code']);
        //        ORM::raw_execute("UPDATE `order` SET `check` = 5 WHERE `order_code` = ? and `check`=4 ", array($order['order_code']));
        ORM::get_db()->commit();
        ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
    } catch (Exception $e) {
        //dump($e);
        ORM::get_db()->rollBack();
    }
});
function listDir($dir)
{
    if (is_dir($dir)) {
        if ($dh = opendir($dir)) {
All Usage Examples Of ORM::raw_execute
ORM