21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
$db = mysql_connect('localhost','root','crixalis') or die("无法连接数据库") ;
mysql_select_db('moviesite',$db) or die(mysql_error($db)) ;
$query = 'SELECT movie_name,movie_tear,movie_director,movie_leadactor,movie_type
FROM
movie
ORDER BY
movie_name ASC,
movie_year DESC' ;
$result = mysql_query($query,$db) or die(mysql_error($db)) ;
$num_movies = mysql_num_rows($result) ;
$table = <<<ENDHTML
<div style="text-align: center;">
<h2>Movie Review Database</h2>
<table border="1" cellpadding="2" cellspacing="2"
style="width: 70%;margin-left:auto;margin-right:auto;">
<tr>
<th>Movie Title</th>
<th>Year of Release</th>
<th>Movie Lead Actor</th>
<th>Movie Director</th>
<th>Movie Type</th>
</tr>
ENDHTML;
while($row=mysql_fetch_assoc($result)){
extract($row) ;
$table .= <<<ENDHTML
<tr>
<td>$movie_name</td>
<td>$movie_year</td>
<td>$movie_director</td>
<td>$movie_leadactor</td>
<td>$movie_type</td>
</tr>
ENDHTML ;
}
$table .= <<<ENDHTML
</table>
<p>$num_movies Movies</p>
</div>
ENDHTML ;
?>
Parse error: syntax error, unexpected $end in D:\Program Files\WEB\Apache\htdocs\Table\table2.php on line 43