Exemplos de executeReader em PHP

Exemplo n.º 1

Arquivo: mysql.php Projeto: ricain59/fortaff

function getTableSelected($table, $fields, $where, $orderBy)
{
    $sql = "SELECT " . implode(", ", $fields) . " FROM " . $table;
    if ($where !== "") {
        $sql .= " WHERE " . $where . " ";
    }
    if ($orderBy !== "") {
        $sql .= " ORDER BY " . $orderBy . " ";
    }
    return executeReader($sql);
}

Exemplo n.º 2

Arquivo: mysql.php Projeto: ricain59/fortaff

function getTableDistinct($table, $column, $where, $orderBy)
{
    $sql = "SELECT DISTINCT " . $column . " FROM " . $table . " ";
    if ($where !== "") {
        $sql .= " WHERE " . $where . " ";
    }
    if ($orderBy !== "") {
        $sql .= " ORDER BY " . $orderBy . " ";
    }
    return executeReader($sql);
}

Exemplo n.º 3

Arquivo: mysql_old.php Projeto: ricain59/fortaff

function getTable($table, $where, $orderBy)
{
    $sql = "SELECT * FROM " . $table . " ";
    if ($where !== "") {
        $sql .= " WHERE " . $where . " ";
    }
    if ($orderBy !== "") {
        $sql .= " ORDER BY " . $orderBy . " ";
    }
    return executeReader($sql);
}

Exemplo n.º 4

Arquivo: mysql.php Projeto: ricain59/fortaff

function getNumberGr($table, $where, $orderBy, $limit, $column, $order)
{
    $sql = "SELECT " . $column . " FROM " . $table . " ";
    if ($where !== "") {
        $sql .= " WHERE " . $where . " ";
    }
    if ($orderBy !== "") {
        $sql .= " ORDER BY " . $orderBy . " " . $order;
    }
    if ($limit !== "") {
        $sql .= " LIMIT " . $limit;
    }
    return executeReader($sql);
    //return $sql;
}