editnews.php

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

<?php
	include("database_access.php");
	$q = $_GET['q'];
	$query = "SELECT * FROM news WHERE headline='".$q."'";
	$result = mysql_query($query) or die("Could not execute query.");
	$num_row = mysql_num_rows($result);
	echo "<b>The selected news information are shown below:</b><br /><br />";
	echo "<form name = \"edit_new\" method=\"GET\"><table border='1'>";
	for($i=0;$i<$num_row;$i++){
		$row = mysql_fetch_array($result);
		echo "<table border='5'>";
		echo "<tr><td><b>ID:</b></td><td><input type=\"text\" id=\"id".$i."\" readonly = true size=\"40\" value=\"".$row['id']."\"></td></tr>";
		echo "<tr><td><b>Headline:</b></td><td><input type=\"text\" id=\"headline".$i."\" size=\"40\" value=\"".$row['headline']."\"></td></tr>";
		echo "<tr><td><b>Publish Date:</b></td><td><input type=\"text\" id=\"date_published".$i."\" size=\"40\" value=\"".$row['date_published']."\"></td></tr>";
		echo "<tr><td><b>Story:</b></td><td><textarea id=\"story".$i."\" rows=\"10\" cols=\"40\">".$row['story']."</textarea></td></tr>";
		echo "<tr><td><b>Picture:</b></td><td><textarea id=\"picture".$i."\" rows=\"5\" cols=\"40\">".$row['picture']."</textarea></td></tr>";
		echo "</table>";
		echo "<br /><input type =\"submit\" onclick=\"requested_info('".$i."')\" value=\"Save\"><br /><br />";
	}
	echo "</form>";

?>