Code: Select all
<?
$color1 = "#FF6103";
$color2 = "#FFA54F";
$row_count = 0;
mysql_connect("localhost","$username","$password") or die ("Unable to connect to MySQL server.");
$db = mysql_select_db("$database") or die ("Unable to select requested database.");
$limit = 1;
$query_count = "SELECT count(*) FROM assignments";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);
if(empty($page)){
$page = 1;
}
$limitvalue = $page * $limit - ($limit);
$query = "SELECT * FROM assignments $order LIMIT $limitvalue, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
while($row = mysql_fetch_array($result)){
$teacher=$rowї"teacher"];
$subject=$rowї"subject"];
$date = date("m-d-Y",$rowїdate]);
$assignment=$rowї"assignment"];
$row_color = ($row_count % 2) ? $color1 : $color2;
echo "
<tr onMouseOver="this.bgColor = '#E8E8E8'" onMouseOut = "this.bgColor = '$row_color'" bgcolor='$row_color'>
<td align='center' width='25%'>
$teacher</td>
<td align='center' width='25%'>
$subject</td>
<td align='center' width='25%'>
$date</td>
<td align='center' width='25%'>
$assignment</td>
</tr>
";
$row_count++;
}
?>
</table>
<br><br><p align="center">
<?
if($page != 1){
$pageprev = $page-1;
echo("<a href="homework.php?page=$pageprev&orderby=date&arrangement=DESC">PREV".$limit."</a> ");
}else{
echo("");
}
$numofpages = $totalrows / $limit;
for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." ");
}else{
echo("<a href="homework.php?page=$i&orderby=date&arrangement=DESC">$i</a> ");
}
}
if(($totalrows % $limit) != 0){
if($i == $page){
echo($i." ");
}else{
echo("<a href="homework.php?page=$i&orderby=date&arrangement=DESC">$i</a> ");
}
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page++;
echo("<a href="homework.php?page=$pagenext&orderby=date&arrangement=DESC">NEXT".$limit."</a>");
}else{
echo("");
}
mysql_free_result($result);
?>