function sqlQuery($tp, $st, $ps = array(), $logIt = false, $pdo = null) { if (!is_array($ps)) { $ps = array($ps); } $ret = array(); $ret = sqlExec($tp, $st, $ps, $logIt, $pdo); $ret['rows'] = $ret['query']->fetchAll(PDO::FETCH_ASSOC); $ret['count'] = count($ret['rows']); $ret['ret'] = array(); $ret['ret']['status'] = $ret['status']; $ret['ret']['error'] = $ret['error'][2]; return $ret; }
/** * Gets the SQL back as objects * * @param object $db Target SQL connection * @param string $sql SQL to execute * * @return SQL objects */ function sqlObjs($db, $sql) { $res = sqlExec($db, $sql); $a = array(); if ($res !== false) { while ($obj = mysql_fetch_object($res)) { $a[] = $obj; } } return $a; }