ช่วยด้วยค่ะ php โค้ด แบ่งหน้า Error แก้ยังไง
โพสต์แล้ว: 02 มิ.ย. 2014, 14:26
<?php
$host="localhost";
$user="root";
$pass="1234";
$db_name="db_penalty";
$conn=mysql_connect($host,$user,$pass) or die("Connect Error!!");
mysql_select_db($db_name) or die("No DataBase Select!!");
$per_page = 5;
$pages_query = mysql_query("SELECT COUNT('id') FROM penalty ") or die("error");
$pages=ceil(mysql_result($pages_query,0)/$per_page);
if(!isset($_GET['page']) ) {
header("location: penalty.php?page=1");
}else{
$page = $_GET['page'];
}
$start = (($page - 1)*$per_page);
$colours = mysql_query("SELECT * FROM penalty LIMIT $start,$per_page");
while($row = mysql_fetch_assoc($colours)){
$colours = $row['colours'];
echo "$colours";
}
for($number=1;$number<=$page;$number++){
echo '<a href="?page='.$number.' ">'.$number.'</a>';
}
echo"<br>Current Page:$page";
?>
รันแล้ว มัน Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\penalty\admin\penalty.php:28) in C:\AppServ\www\penalty\admin\penalty.php on line 149
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\penalty\admin\penalty.php on line 157
Current Page:
แก้ยังไงค่ะ
$host="localhost";
$user="root";
$pass="1234";
$db_name="db_penalty";
$conn=mysql_connect($host,$user,$pass) or die("Connect Error!!");
mysql_select_db($db_name) or die("No DataBase Select!!");
$per_page = 5;
$pages_query = mysql_query("SELECT COUNT('id') FROM penalty ") or die("error");
$pages=ceil(mysql_result($pages_query,0)/$per_page);
if(!isset($_GET['page']) ) {
header("location: penalty.php?page=1");
}else{
$page = $_GET['page'];
}
$start = (($page - 1)*$per_page);
$colours = mysql_query("SELECT * FROM penalty LIMIT $start,$per_page");
while($row = mysql_fetch_assoc($colours)){
$colours = $row['colours'];
echo "$colours";
}
for($number=1;$number<=$page;$number++){
echo '<a href="?page='.$number.' ">'.$number.'</a>';
}
echo"<br>Current Page:$page";
?>
รันแล้ว มัน Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\penalty\admin\penalty.php:28) in C:\AppServ\www\penalty\admin\penalty.php on line 149
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\penalty\admin\penalty.php on line 157
Current Page:
แก้ยังไงค่ะ