RE: [PHP-DB] error
| From: | Bastien Koert | Date: | Tue, 28 Sep 2004 12:18:22 +0000 |
| Subject: | RE: [PHP-DB] error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36436@lists.php.net to get a copy of this message | ||
try checking for the value
if (isset($_POST["op"] != "addpost")) {
or to supress the error, use the '@' symbol in fron of the $_POST or $_GET
if (@$_POST["op"] != "addpost") {
Bastien
From: Remember14a@aol.com To: php-db@lists.php.net Subject: [PHP-DB] error Date: Tue, 28 Sep 2004 06:58:10 EDT Dear friends, Script writes to database, however gives this error while on internet web server, on local host doesn't give same error. Any guidance, please Thank you ----------------------------------------- Back to Main Notice: Undefined index: op in \\premfs15\sites\premium15\mrbushforpeace\webroot\replytopost.php on line 9 ------------------------------------------------------------------------------ ---- code of php script ------------------------------------------------------------------------------ ---- <a href="www.abcdefg.us">Back to Main</a> <?php //connect to server and select database; we'll need it soon $conn = mysql_connect("orf-mysql1.brinkster.com", "mrbushforpeace", "poilkjmnb") or die(mysql_error()); mysql_select_db("mrbushforpeace",$conn) or die(mysql_error()); //check to see if we're showing the form or adding the post if ($_POST["op"] != "addpost") { // showing the form; check for required item in query string if (!$_GET["post_id"]) {_________________________________________________________________ Don't just Search. Find! http://search.sympatico.msn.ca/default.aspx The new MSN Search! Check it out!header("Location: topiclist.php"); exit;} //still have to verify topic and post $verify = "select ft.topic_id, ft.topic_title from forum_posts as fp left join forum_topics as ft on fp.topic_id = ft.topic_id where fp.post_id = $_GET[post_id]"; $verify_res = mysql_query($verify, $conn) or die(mysql_error()); if (mysql_num_rows($verify_res) < 1) {//this post or topic does not exist header("Location: topiclist.php"); exit;} else {//get the topic id and title $topic_id = mysql_result($verify_res,0,'topic_id'); $topic_title = stripslashes(mysql_result($verify_res,0,'topic_title'));print " <html> <head> <title>Post Your Reply in $topic_title</title> </head> <body> <h1>Post Your Reply in $topic_title</h1> <form method=post action=\"$_SERVER[PHP_SELF]\"> <p><strong>Your E-Mail Address:</strong><br> <input type=\"text\" name=\"post_owner\" size=40 maxlength=150><P><strong>Post Text:</strong><br> <textarea name=\"post_text\" rows=8 cols=40 wrap=virtual></textarea><input type=\"hidden\" name=\"op\" value=\"addpost\"> <input type=\"hidden\" name=\"topic_id\" value=\"$topic_id\"><P><input type=\"submit\" name=\"submit\" value=\"Add Post\"></p></form> </body> </html>";} } else if ($_POST["op"] == "addpost") { //check for required items from form if ((!$_POST["topic_id"]) || (!$_POST["post_text"]) || (!$_POST["post_owner"])) {header("Location: topiclist.php"); exit;} //add the post $add_post = "insert into forum_posts values ('', '$_POST[topic_id]', '$_POST[post_text]', now(), '$_POST[post_owner]')"; mysql_query($add_post,$conn) or die(mysql_error()); //redirect user to topic exit; } ?>