editcourse.php

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

 <?php
	include("database_access.php");
	$q = $_GET['q'];
	$query = "SELECT * FROM course_info WHERE course_code = '".$q."'";
	$result = mysql_query($query) or die("Could not execute query.");
	$num_rows=mysql_num_rows($result);
	echo "<b>The selected course information are shown below:</b><br /><br />";
	echo "<form name = \"edit_course\" method=\"GET\"><table border='1'>";

	for($i=0;$i<$num_rows;$i++){
		$row = mysql_fetch_array($result);
		echo "<table border='5'>";
		echo "<tr><td><b>Inner Code:</b></td><td><input type=\"text\" id=\"inner_code".$i."\" readonly = true size=\"40\" value=\"".$row['inner_code']."\"></td></tr>";
		echo "<tr><td><b>Course Code:</b></td><td><input type=\"text\" id=\"course_code".$i."\" size=\"40\" value=\"".$row['course_code']."\"></td></tr>";
		echo "<tr><td><b>Course Title:</b></td><td><input type=\"text\" id=\"course_title".$i."\" size=\"40\" value=\"".$row['course_title']."\"></td></tr>";
		echo "<tr><td><b>Course Name:</b></td><td><input type=\"text\" id=\"course_name".$i."\" size=\"40\" value=\"".$row['course_name']."\"></td></tr>";
		echo "<tr><td><b>Length:</b></td><td><input type=\"text\" id=\"length".$i."\" size=\"40\" value=\"".$row['length']."\"></td></tr>";
		echo "<tr><td><b>Module Name:</b></td><td><input type=\"text\" id=\"module_name".$i."\" size=\"40\" value=\"".$row['module_name']."\"></td></tr>";
		echo "<tr><td><b>Full/Part:</b></td><td><input type=\"text\" id=\"full_or_part".$i."\" size=\"40\" value=\"".$row['full_or_part']."\"></td></tr>";
		echo "</table>";
		echo "<input type =\"submit\" value=\"Save\" onclick = \"requested_info('".$i."')\"><br /><br />";
	}
	echo "</form>";
?>