CREATE TABLE `yearly_reports` (
`id` int(11) NOT NULL auto_increment,
`name` char(10) NOT NULL,
`department` char(60) NOT NULL,
`pfno` char(10) NOT NULL,
`savings` varchar(255) NOT NULL,
`shares` varchar(255) NOT NULL,
`outloanbal` varchar(255) NOT NULL,
`loanrepaid` varchar(255) NOT NULL,
`loanint` varchar(255) NOT NULL,
`essenco` text NOT NULL,
`month` text NOT NULL,
`Year` varchar(234) NOT NULL,
`date` date NOT NULL,
`session` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
Now I have actually successfully inserted data into my table. I just want to display it neatly on a table. But I keep getting this error:
Parse error: syntax error, unexpected T_ECHO, expecting ',' or ';' in C:Year_Summary.php on line 48
Code: Select all
<?php
session_start();
if (!$_SESSION["adminok"])
{
//user not logged in, redirect to login page
header("Location:Admin_Login.php");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Year Summary</title>
</head>
<body>
<?php
echo ("<p>Admin | <a href='Monthly_Post.php'>Monthly Update</a> |<a href='Monthly_Summary.php'>Monthly Summary | <a href='Year_Summary.php'>Year Summary</a> | <a href='Logout.php'>Logout</a></p>");
?>
<?php
include ("cn.php");
//fetch our page number from the query string
//the URL should look something like
//name_meanings.php?page=4
$page = $_GET['page'];
//define how many records we want to show per page
$records_per_page = 15;
if(!filter_var($page, VALIDATE_INT, 1))
$page=1;
echo "<h3>Showing results for page $page</h3>";
//calculate the offset value to start counting from
//in the MySQL query. To do this, we multiply the page
//number, minus one, by the number of records we want
//to show per page
//e.g. for page 1 - Our starting record will be (1-1)*30
$offset = ($page-1) * $records_per_page;
$result = mysql_query("SELECT * FROM yearly_reports ORDER BY pfno ASC LIMIT $offset, $records_per_page");
if($row = mysql_fetch_array($result)){
do{
echo ("<table border='0' cellspacing='2' cellpadding='2'>");
echo ("<tr>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["pfno"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["name"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["department"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["loanint"]}</font></td>")
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["loanrepaid"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["outloanbal"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["savings"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["shares"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["essenco"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["month"]}</font></td>");
echo("<td><font face='Arial, Helvetica, sans-serif'> {$row["Year"]}</font></td>");
echo("</tr></br>");
} while($row = mysql_fetch_array($result));
}
echo "</table>";
echo "<p>Navigation</p>";
$count_result = mysql_query("SELECT (*) FROM yearly_reports");
$count_row = mysql_fetch_array($count_result);
//fetch the total number of rows in the table
$count = $count_row["COUNT(*)"];
//we will use this information to build our navigation list
for($i=1; $i<=$count/$records_per_page; $i++){
echo "<a href='Year_Summary.php?page=$i'>$i</a>";
//output a little symbol (|) to seperate the links
//but not for the last link
if($i!=$records_per_page)
echo " | ";
}
?>
</body>
</html>
Is there something missing here?