Parse error: syntax error, unexpected '>' in C:\wamp\www\new.php on line 38
| From: | Sashikanth Gurram | Date: | Sat, 14 Feb 2009 03:02:55 +0000 |
| Subject: | Parse error: syntax error, unexpected '>' in C:\wamp\www\new.php on line 38 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45954@lists.php.net to get a copy of this message | ||
Hi all,
I have pasted the PHP code I wrote below. I do not know why, but I am getting the parse error: unexpected '>'. It says the error is on line 38. The exact line on line 38 is
* echo"<tr>\n*Basically, I am trying to execute an sql query through PHP which tries to extract data from the mysql database and display the data in the browser. The query is running fine but I am getting the problems when I try to display the data in the browser. Can anyone help me with it? Thanks, Sashi <?php /* CONNECTS TO THE DATABASE*/ $host="******"; $user="******"; $password="*******"; $dbname="*********"; $cxn=mysqli_connect($host, $user, $password, $dbname); if (!$cxn=mysqli_connect($host, $user, $password, $dbname)) {
$error=mysqli_error($cxn);
echo "$error";
die();
}
else
{
echo "Connection established successfully";} $sql="select * FROM OCCUPANCY"; $data=mysqli_query($cxn,$sql); if (!$data=mysqli_query($cxn,$sql)) {
$error=mysqli_error($cxn);
echo "$error";
die();
}
else
{
echo "Query sent successfully";} echo "<br>"; echo "<h1>OCCUPANCY<h1>"; echo "<table cellspacing='5'>"; echo "<tr><td colspan='7'><hr /></td></tr>; while ($row=mysqli_fetch_array($data)) {
extract($row);
echo"<tr>\n
<td>$building</td>\n
<td>$parking_lot</td>\n
<td>$month</td>\n
<td>$day</td>\n
<td>$occupancy</td>\n
<td>$empty_spaces</td>\n
<td>$special_days</td>\n
</tr>\n";
echo "<tr><td colspan='7'><hr /></td></tr>\n";
}
echo"</table>\n";?> -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sashikanth Gurram Graduate Research Assistant Department of Civil and Environmental Engineering Virginia Tech Blacksburg, VA 24060, USA