Ejemplo n.º 1
0
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;
}