I am following a tutoral from book on creating a blogging CMS and as somtimes happens I have hit a rut. I was creating a page for adding a article to the database. I managed that but then editing the post seems to be the problem, it won't retreave the old information and put it back in to the form fields. I did a bit of fishing around to see what the problem might be. I was told that placing this bit of code into the main code would find out what the problem is:
if (!$result) {
echo mysql_error();
exit;
}
This is what is came up with
Unknown column 'post_id' in 'where clause'
This is the whole code for addpost.php any help with the problem would be good.
<?php
// If magic quotes is tuned on then strip slashes
if (get_magic_quotes_gpc()) {
foreach ($_POST as $key => $value) {
$_POST[$key] = stripslashes($value);
}
}
// Extract form submission
$title = (isset($_POST["title"]))?$_POST["title"]:"";
$postdate = (isset($_POST["postdate"]))?$_POST["postdate"]:"";
$summary = (isset($_POST["summary"]))?$_POST["summary"]:"";
$post = (isset($_POST["post"]))?$_POST["post"]:"";
$submitAdd = (isset($_POST["submitAdd"]))?$_POST["submitAdd"]:"";
// Open connection to database
include("../db_connect.php");
// Prepare data for database
$db_title = addslashes($title);
$db_postdate = addslashes($postdate);
$db_summary = addslashes($summary);
$db_post = addslashes($post);
// If form has been submitted, insert post into database
if ($submitAdd) {
$sql = "INSERT INTO posts
(title,postdate,summary,post)
VALUES ('$db_title', '$db_postdate', '$db_summary', '$db_post')";
$result = mysql_query($sql);
if (!$result) {
$message = "Failed to insert post. MySQL said " . mysql_error();
} else {
$message = "Successfully inserted post '$title'.";
}
}
// Get post_id from query string
$post_id = (isset($_REQUEST["post_id"]))?$_REQUEST["post_id"]:"";
// If post_id is a number get post from database
if (preg_match("/^[0-9]+$/", $post_id)) {
$editmode = true;
// If form has been submitted, update post
if (isset($_POST["submitUpdate"])) {
$sql = "UPDATE posts SET
title='$db_title',
postdate='$db_postdate',
summary='$db_summary',
post='$db_post'
WHERE post_id = $post_id";
$result = mysl_query($sql);
if (!$result) {
$message = "Failed to post. MySQL said " . mysql_error();
} else {
$message = "Successfully update post '$title'.";
}
}
$sql = "SELECT title, postdate, summary, post FROM posts WHERE post_id=$post_id";
$result = mysql_query($sql);
if (!$result) {
echo mysql_error();
exit;
}
$mypost = mysql_fetch_array($result);
if($mypost) {
$title = $mypost["title"];
$postdate = $mypost["postdate"];
$summary = $mypost["summary"];
$post = $mypost["post"];
} else {
$message = "No post matching that post_id.";
}
} else {
$editmode = false;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add a Post - Blog CMS</title>
</head>
<body>
<h1>Add a Post</h1>
<?php
if (isset($message)) {
echo "<p class='message'>$message</p>";
}
?>
<form method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>">
<p>Title: <input type="text" name="title" size="40" value="<?php if (isset($title)) {echo $title;} ?>" /></p>
<p>Date/Time: <input type="text" name="postdate" size="40" value="<?php if (isset($postdate)) {echo $postdate;} ?>" /> yyyy-mm-dd hh:mm:ss </p>
<p>Summary:<br />
<textarea name="summary" rows="5" cols="60"><?php if (isset($summary)) {echo $summary;} ?></textarea></p>
<p>Post:<br />
<textarea name="post" rows="20" cols="60"><?php if (isset($post)) {echo $post;} ?></textarea></p>
<p>
<?php
switch ($editmode) {
case true:
echo "<input type='hidden' name='post_id' value='$post_id' />";
echo "<input type='Submit' name='submitUpdate' value='Update post' />";
break;
case false:
echo "<input type='Submit' name='submitAdd' value='Add post' />";
break;
}
?>
</p>
</form>
</body>
</html>
