Exemplos de fetAll em PHP

Exemplo n.º 1

Arquivo: admin.inc.php Projeto: wangmingguang/E_commerce_sites

function getAllAdmin()
{
    $sql = "select id,username,email from imooc_admin";
    $rows = fetAll($sql);
    return $rows;
}

Exemplo n.º 2

Arquivo: page.func.php Projeto: wangmingguang/E_commerce_sites

$sql = "select * from imooc_admin";
$totalRows = getResultNum($sql);
$pageSize = 2;
//每页显示的条数
$totalPage = ceil($totalRows / $pageSize);
//总页码数
@($page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1);
if ($page < 1 || !is_numeric($page)) {
    $page = 1;
}
if ($page > $totalPage) {
    $page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select * from imooc_admin limit {$offset},{$pageSize}";
$rows = fetAll($sql);
foreach ($rows as $row) {
    echo "编号： " . $row['id'] . '<br/>';
    echo "管理员名称： " . $row['username'] . '<hr/>';
}
echo showPage($page, $totalPage);
echo "<hr/>";
echo showPage($page, $totalPage, "cid=5&pid=6");
function showPage($page, $totalPage, $where = null, $sep = '&nbsp;')
{
    $where = $where == null ? null : "&" . $where;
    //$where参数可以显示子类
    $url = $_SERVER['PHP_SELF'];
    //获取当前页面的路径
    $index = $page == 1 ? "首页" : "<a href='{$url}?page=1{$where}'>首页</a>";
    $last = $page == $totalPage ? "尾页" : "<a href='{$url}?page={$totalPage}{$where}'>尾页</a>";