首页中添加了updateentry.php链接，但是跳转之后又回到首页？

2012-04-24 03:22:03 234 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Verilog——反相器反相器代码： module inv( A, Y );//A,Y是端口 //定义端口属性 input A; output Y; //定义输入输出关系 assign Y=~A;//Y等于A的反 endmodule //inv是module的名字阅读详情

附inde.php代码和updateentry.php代码



<?php



require("header.php");



$sql="SELECT entries.*,categories.cat 

FROM entries,categories

WHERE entries.cat_id=categories.id

ORDER BY dateposted DESC

LIMIT 1;";

$result=mysql_query($sql);

$row=mysql_fetch_assoc($result);



echo"<h2><a href='viewentry.php?id=".$row['id']."'>".$row['subject']."</a></h2><br />";

echo"<i>In<a href='viewcat.php?id=".$row['cat_id']."'>".$row['cat']."</a>-posted on". date("D jS F Y g.iA",strtotime($row['dateposted']))."</i>";





if(isset($_SESSION['USERNAME'])==true){

	echo"[<a href='updateentry.php?id=".$row['id']."'>edit</a>]";

}





echo"<p>";

echo nl2br($row['body']);

echo"</p>";



echo"<p>";

$commsql="SELECT name 

FROM comments 

WHERE blog_id=".$row['id']."

ORDER BY dateposted;";

$commresult=mysql_query($commsql);

$numrows_comm=mysql_num_rows($commresult);

if($numrows_comm==0){

echo"<p>No comments.</p>";

}

else{

echo"(<strong>".$numrows_comm."</strong>)comments:";

$i=1;

while($commrow=mysql_fetch_assoc($commresult)){

echo"<a href='viewentry.php?id=".$row['id']."#comment".$i."'>".$commrow['name']."</a>";

$i++;

}

}

echo"</p>";







$prevsql = "SELECT entries.*,categories.cat FROM entries,categories

WHERE entries.cat_id=categories.id

ORDER BY dateposted DESC

LIMIT 1,5;";

$prevresult=mysql_query($prevsql);

$numrows_prev=mysql_num_rows($prevresult);

if($numrows_prev==o){

	echo"<p>No previous entries.</p>";

}

else{

	echo"<ul>";

	

	while($prevrow = mysql_fetch_assoc($prevresult)){

		echo"<li><a href='viewentry.php?id=" . $prevrow['id'] . "'>". $prevrow['subject'] ."</a></li>";

		

	}

}

echo"</ul>";



require("footer.php");



/*

$prevsql = "SELECT entries.*, categories.cat FROM entries, categories

WHERE entries.cat_id = categories.id

ORDER BY dateposted DESC

LIMIT 1, 5;";

$prevresult = mysql_query($prevsql);

$numrows_prev = mysql_num_rows($prevresult);



if($numrows_prev == 0) {

	echo "<p>No previous entries.</p>";

}

else {



	echo "<ul>";



	while($prevrow = mysql_fetch_assoc($prevresult)) {

		echo "<li><a href='viewentry.php?id=" . $prevrow['id'] . "'>" . $prevrow	['subject'] . "</a></li>";

	}

}



echo "</ul>";



require("footer.php");



*/

?>





<?php



session_start();

require("config.php");







if(isset($_SESSION['USERNAME']) == FALSE) {

	header("Location: " . $config_basedir);

}







$db = mysql_connect($dbhost, $dbuser, $dbpassword);

mysql_select_db($dbdatabase, $db);







if(isset($_GET['id']) == TRUE) {

	if(is_numeric($id) == FALSE) {

		$error = 1;

	}



	if($error == 1) {

		header("Location: " . $config_basedir);

	}

	else {

		$validentry = $_GET['id'];

	}

}

else {

	$validentry = 0;

}



if($_POST['submit']) {

	$sql = "UPDATE entries SET cat_id = " . $_POST['cat'] . ", subject = '" . $_POST['subject'] ."', body = '" . $_POST['body'] . "' WHERE id = " . $validentry . ";";

	mysql_query($sql);

	

header("Location: " . $config_basedir . "/viewentry.php?id=".$validentry);

	

}

else {



	require("header.php");



	$fillsql = "SELECT * FROM entries WHERE id = " . $validentry . ";";	

	$fillres = mysql_query($fillsql);

	$fillrow = mysql_fetch_assoc($fillres);



?>

<h1>Update Entry</h1>

<form action="<?php echo $SCRIPT_NAME . "?id=" . $validentry; ?>" method="post">



<table>

<tr>

	<td>Category</td>

	<td>

	<select name="cat">

	<?php

		$catsql = "SELECT * FROM categories;";

		$catres = mysql_query($catsql);

		while($catrow= mysql_fetch_assoc($catres)) {

			echo "<option value='" . $catrow['id'] . "'";

			

			if($catrow['id'] == $fillrow['cat_id']) {

				echo " selected";

			}

			

			echo ">" . $catrow['cat'] . "</option>";

		}

	?>

	</select>

	</td>

</tr>

<tr>

	<td>Subject</td>

	<td><input type="text" name="subject" value="<?php echo $fillrow['subject']; ?>"></td>

</tr>

<tr>

	<td>Body</td>

	<td><textarea name="body" rows="10" cols="50"><?php echo $fillrow['body']; ?></textarea></td>

</tr>

<tr>

	<td></td>

	<td><input type="submit" name="submit" value="Update Entry!"></td>

</tr>

</table>

</form>



<?php

}

require("footer.php");

?>