/**
* Performs the request query as a prepared statement and returns the results in the format constant specified:
* DB_QQ_FULL Returns an indexed array of column named arrays for all rows returned.
* DB_QQ_SINGLE_ROW Returns a column named array of the first row returned
* DB_QQ_SINGLE_COLUMN Returns an indexed array of all row results in the first column
* DB_QQ_SINGLE_CELL Returns a string containing the first column of the first row
*
* @param string $query The SQL query to perform.
* @param array $data Array containing the bound parameters
* @param integer $mode Format to return the requested data as.
* @return array|string
* @static
*/
public static function PreparedQuery($query, $data, $mode = DB_QQ_FULL)
{
$pdo = self::Link();
self::$lastQuery = $query;
if (self::$query_callback && is_callable(self::$query_callback)) {
call_user_func(self::$query_callback, $query);
}
self::$lastResult = $pdo->prepare($query);
self::$lastResult->execute($data);
$c = self::TotalResults();
switch ((int) $mode) {
case DB_QQ_NONE:
return $c;
case DB_QQ_SINGLE_ROW:
return $c ? self::$lastResult->fetch(PDO::FETCH_ASSOC) : array();
case DB_QQ_SINGLE_COLUMN:
return $c ? self::$lastResult->fetchAll(PDO::FETCH_COLUMN, 0) : array();
case DB_QQ_SINGLE_CELL:
if ($c) {
$row = self::$lastResult->fetch(PDO::FETCH_NUM);
return $row[0];
} else {
return null;
}
case DB_QQ_FULL:
default:
return $c ? self::$lastResult->fetchAll(PDO::FETCH_ASSOC) : array();
}
}
