IT工程師數位筆記本

                      <?php foreach($rows as $row):?>  //注意，這里的foreach($rows as $row)后面的是冒號不是逗號
                            <tr>
                                <!--這里的id和for里面的c1 需要循環出來-->
                                <td><input type="checkbox" id="c1" class="check"><label for="c1" class="label"><?php echo $row['id'];?></label></td>
                                <td>x</td>
                                <td>x</td>
                                <td align="center"><input type="button" value="修改" class="btn" ><input type="button" value="刪除" class="btn"  ></td>
                            </tr>
                        <?php endforeach ?>  

<?php
include '../include.php';
$rows=getAllAdmin();
if(!$rows) {
	alertMes("sorry,沒有管理員，請添加!","addAdmin.php");
	exit;
}

?>

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

function fetchAll($sql,$result_type=MYSQL_ASSOC){
	$result=mysql_query($sql);
	while(@$row=mysql_fetch_array($result,$result_type)){
		$rows[]=$row;
	}
	return $rows;
}

<?php

function alertMes($mes,$url) {
	echo "<script>alert('{$mes}');</script>";
	echo "<script>window.location='{$url}';</script>";
}


?>

 <?php if($rows>$pageSize):?>
       <tr>
         <td colspan="4"><?php echo showPage($page,$totalPage); ?></td>
       <tr>
 <?php endif;?>