moduleinfo.php

自制国外大学学校计算机学院网站

<?php
$host = "co-project.lboro.ac.uk";
$user = "group04";
$password = "grp55dnv";
$database = "group04";
$connection = mysql_connect($host,$user,$password) or die("Could not connect to the server");
$db = mysql_select_db($database,$connection) or die("Couldn't select database");
$q=$_GET["q"];
$query= "SELECT * FROM module_info WHERE module_name = '".$q."'";
$result = mysql_query($query);

/*echo "<table border='1'>
<tr>
<th>Module Code</th>
<th>Module Name</th>
<th>Lecturer</th>
<th>Year</th>
<th>Semester</th>
<th>Credits</th>
<th>Description</th>
</tr>";*/

while($row = mysql_fetch_array($result)){
	echo "<form>";
	echo "<b>Module Code: </b>".$row['module_code']."<br /><br />";
	echo "<b>Module Name: </b>".$row['module_name']."<br /><br />";
	echo "<b>Lecturer: </b>".$row['lecturer']."<br /><br />";
	echo "<b>Year: </b>".$row['2']."<br /><br />";
	echo "<b>Semester: </b>".$row['semester']."<br /><br />";
	echo "<b>Credits: </b>".$row['credits']."<br /><br />";
	echo "<b>Description: </b>".$row['description']."<br />";
	echo "<b>...........................................................................";
	echo "...................................................</b><br />";
	/*echo "<tr>";
	echo "<td>" . $row['module_code'] . "</td>";
	echo "<td>" . $row['module_name'] . "</td>";
	echo "<td>" . $row['lecturer'] . "</td>";
	echo "<td>" . $row['year'] . "</td>";
	echo "<td>" . $row['semester']."</td>";
	echo "<td>" . $row['credits'] . "</td>";
	echo "<td>" . $row['description'] . "</td>";
	echo "</tr>";*/
}
//echo "</table>";
?>