28. september 2003 - 00:13Der er
104 kommentarer og 1 løsning
Hjælp til at rette et forum til? mht. notices osv.
Hejsa! er der en som vil være så venlig at hjælpe med at rette et script til. Det første der skal rettes til er denne notice: Notice: Undefined variable: action in php on line 5: Line 5: if ($action=="add_two") {
hvis det er e færdigt script du har hentet tyder mere på at det ik er lavet rigtigt .. eller at du skal slå fra så den ikke kræver at variable er defineret før brug (aner jeg ikke hvor du gør.. men er der sikkert en anden linux-haj her der kan svare på)
define virkede ikke for mig :( Her er hele scriptet: <?php
require( './functions.php');
if ($action=="add_two") {
if ($name=="" or $email=="" or $password=="" or $post=="") { showheader("All the Fields Have Not Been Filled in"); echo "You Must Fill in all fields before proceeding"; showfooter(); exit; } $topicID = addtopic(); addpost(); showheader("Your Post has successfully been added"); echo "Your post was added, and your post password is $password.<P>You may go back now and view it"; showfooter(); } else { ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <P> <a href="index.php"><FONT COLOR="#000000">Return Back to Topics</a> </TD> </TR> </TABLE> <FORM METHOD=POST ACTION="<?php echo $PHP_SELF ?>"> <INPUT TYPE="hidden" name="action" value="add_two"> <table border=0 cellpadding=0 cellspacing=0 width="95%"> <TR><td bgcolor="#000000"> <table border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Topic Name:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="topicname" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="name" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</B></FONT></td> <td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE=""> </font></td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Password:</B> <BR><FONT SIZE="-2">This is used when you would like to edit or delete your post. </FONT></td><td> <INPUT TYPE="text" NAME="password" SIZE=13 VALUE=""> </font></td></tr>
<tr bgcolor="#C0C0C0"> <td valign=top> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT> <p><BR> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"> Posts appear exactly as you have submitted them. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting. </p></font> </td> <td> <TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr> </table> </td></tr></table> <P> <CENTER> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post"> <INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields"> <br> </CENTER> </FORM> <?php } ?>
detox, det virkede, men når jeg prøver at poste mit topic, siger den følgende: The page you are looking for cannot be displayed because the page address is incorrect. Men kan ikke se hvad problemet er i overstående script...?
Er det din egen server du arbejder på? For hvis det er, kan vi rette i php.ini så du ikke skal bruge define. Grunden til at fejlen kommer nu, er at apache er sat op til at alle variabler ska skal være sat, ellers vil den ikke godtage det. Det er ligesom i C :)
Find sektionen som hedder "Error handling and logging" i php.ini og ret linien som starter med "error_reporting..... " til flg "error_reporting = E_ALL & ~E_NOTICE"
den vil jo bare ikke finde den side den skal hen til..se evt. der hvor jeg har uploadet det, jeg vil helst ikke rette i min ini. fil tror ik det er problemet: se side det er på og prøv at submit: http://www.alt-muligt.dk/test2/add-topic.php
function addpost () { global $password,$email,$name,$post,$topicID; $timestamp = time(); $new_password = addslashes($password); $new_email = addslashes($email); $new_name = addslashes($name); $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("INSERT INTO posts VALUES ('NULL','$topicID','$new_name','$new_email','$new_password','$timestamp','$new_post')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function editpost () { global $postID,$post; $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("UPDATE posts SET post='$new_post' WHERE (ID='$postID')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function deletepost () { global $postID; $post_query = mysql_query("DELETE FROM posts WHERE (ID='$postID')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function addtopic () { global $topicname; $new_topicname = addslashes($topicname); $topic_query = mysql_query("INSERT INTO topics VALUES ('NULL','$new_topicname')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } return mysql_insert_id(); }
?>
og så er der selvfølge mysql connect delen i toppen af scriptet. :)
ja, du har brug for at 'oversætte' alle dine Post varibler. Prøv med:
<?php require( './functions.php'); if (isset($_POST['action']) && $_POST['action']=="add_two") { foreach ($_POST as $value) { if ($value == "") { showheader("All the Fields Have Not Been Filled in"); echo "You Must Fill in all fields before proceeding"; showfooter(); exit; } } $password = $_POST['password']; $email = $_POST['email']; $name = $_POST['name']; $post = $_POST['post']; $topicname = $_POST['topicname']; $topicID = addtopic(); addpost(); showheader("Your Post has successfully been added"); echo "Your post was added, and your post password is $password.<P>You may go back now and view it"; showfooter(); } else { ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <P> <a href="index.php"><FONT COLOR="#000000">Return Back to Topics</a> </TD> </TR> </TABLE> <FORM METHOD=POST ACTION=""> <INPUT TYPE="hidden" name="action" value="add_two"> <table border=0 cellpadding=0 cellspacing=0 width="95%"> <TR><td bgcolor="#000000"> <table border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Topic Name:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="topicname" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="name" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</B></FONT></td> <td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE=""> </font></td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Password:</B> <BR><FONT SIZE="-2">This is used when you would like to edit or delete your post. </FONT></td><td> <INPUT TYPE="text" NAME="password" SIZE=13 VALUE=""> </font></td></tr>
<tr bgcolor="#C0C0C0"> <td valign=top> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT> <p><BR> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"> Posts appear exactly as you have submitted them. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting. </p></font> </td> <td> <TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr> </table> </td></tr></table> <P> <CENTER> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post"> <INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields"> <br> </CENTER> </FORM> <?php } ?>
det virkede, men nu kan jeg ikke komme ind og poste på den.. CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:
Jeg kan godt selv lave den action fejl nu :) ; men det er de andre :/
<?php
require( './functions.php');
if ($action=="add_two") { if ($name=="" or $email=="" or $password=="" or $post=="") { showheader("All the Fields Have Not Been Filled in"); echo "You Must Fill in all fields before proceeding"; showfooter(); exit; } addpost(); showheader("Your Post has successfully been added"); echo "Your post was added, and your post password is $password.<P>You may go back now and view it"; showfooter(); } else { $topic_query = mysql_query("SELECT TopicName FROM topics WHERE (ID=$topicID)"); $topic = mysql_fetch_array($topic_query); ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <b>Topic Name: </b> <BR><?php echo $topic['TopicName'] ?> <P> <a href="view.php?topicID=<?php echo $topicID ?>"><FONT COLOR="#000000">Return Back to Topic Posts</a> </TD> </TR> </TABLE> <FORM METHOD=POST ACTION="<?php echo $PHP_SELF ?>"> <INPUT TYPE="hidden" name="action" value="add_two"> <INPUT TYPE="hidden" name="topicID" value="<?php echo $topicID ?>"> <INPUT TYPE="hidden" name="TopicName" value="<?php echo $topic['TopicName'] ?>"> <table border=0 cellpadding=0 cellspacing=0 width="95%"> <TR><td bgcolor="#000000"> <table border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="name" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</B></FONT></td> <td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE=""> </font></td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Password:</B> <BR><FONT SIZE="-2">This is used when you would like to edit or delete your post. </FONT></td><td> <INPUT TYPE="text" NAME="password" SIZE=13 VALUE=""> </font></td></tr>
<tr bgcolor="#C0C0C0"> <td valign=top> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT> <p><BR> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"> Posts appear exactly as you have submitted them. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting. </p></font> </td> <td> <TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr> </table> </td></tr></table> <P> <CENTER> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post"> <INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields"> <br> </CENTER> </FORM> <?php } ?>
ja, men jeg kan slet ikke se siden det samme som tidlgere, skal jeg bare gøre sådan her: } $password = $_POST['password']; $email = $_POST['email']; $name = $_POST['name']; $post = $_POST['post']; $topicname = $_POST['topicname']; $topicID = addtopic(); addpost();
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in functions.php on line 28 og Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in add-post.php on line 19
<?php require( './functions.php'); if (isset($_POST['action']) && $_POST['action']=="add_two") { foreach ($_POST as $value) { if (isset($value == "")) { showheader("All the Fields Have Not Been Filled in"); echo "You Must Fill in all fields before proceeding"; showfooter(); exit; } } $password = $_POST['password']; $email = $_POST['email']; $name = $_POST['name']; $post = $_POST['post']; $topicname = $_POST['topicname']; $topicID = addtopic(); addpost(); showheader("Your Post has successfully been added"); echo "Your post was added, and your post password is $password.<P>You may go back now and view it"; showfooter(); } else { ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <P> <a href="index.php"><FONT COLOR="#000000">Return Back to Topics</a> </TD> </TR> </TABLE> <FORM METHOD=POST ACTION=""> <INPUT TYPE="hidden" name="action" value="add_two"> <table border=0 cellpadding=0 cellspacing=0 width="95%"> <TR><td bgcolor="#000000"> <table border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Topic Name:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="topicname" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="name" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</B></FONT></td> <td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE=""> </font></td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Password:</B> <BR><FONT SIZE="-2">This is used when you would like to edit or delete your post. </FONT></td><td> <INPUT TYPE="text" NAME="password" SIZE=13 VALUE=""> </font></td></tr>
<tr bgcolor="#C0C0C0"> <td valign=top> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT> <p><BR> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"> Posts appear exactly as you have submitted them. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting. </p></font> </td> <td> <TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr> </table> </td></tr></table> <P> <CENTER> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post"> <INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields"> <br> </CENTER> </FORM> <?php } ?>
<?php require( './functions.php'); if (isset($_POST['action'] && $_POST['action']=="add_two") { foreach ($_POST as $value) { if ($value == "") { showheader("All the Fields Have Not Been Filled in"); echo "You Must Fill in all fields before proceeding"; showfooter(); exit; } } foreach ($_POST as $key=>$value) { $$key = $value; }
addpost(); showheader("Your Post has successfully been added"); echo "Your post was added, and your post password is $password.<P>You may go back now and view it"; showfooter(); } else { $topic_query = mysql_query("SELECT TopicName FROM topics WHERE ID=".$_GET['topicID']); $topic = mysql_fetch_array($topic_query); ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <b>Topic Name: </b> <BR><?php echo $topic['TopicName'] ?> <P> <a href="view.php?topicID=<?=$_GET['topicID']?>"><FONT COLOR="#000000">Return Back to Topic Posts</a> </TD> </TR> </TABLE> <FORM METHOD=POST ACTION=""> <INPUT TYPE="hidden" name="action" value="add_two"> <INPUT TYPE="hidden" name="topicID" value="<?=$_GET['topicID']?>"> <INPUT TYPE="hidden" name="TopicName" value="<?=$topic['TopicName']?>"> <table border=0 cellpadding=0 cellspacing=0 width="95%"> <TR><td bgcolor="#000000"> <table border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor="#C0C0C0"> <td > <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td> <INPUT TYPE="TEXT" NAME="name" SIZE=25> </td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</B></FONT></td> <td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE=""> </font></td></tr> <tr bgcolor="#C0C0C0"> <td> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Password:</B> <BR><FONT SIZE="-2">This is used when you would like to edit or delete your post. </FONT></td><td> <INPUT TYPE="text" NAME="password" SIZE=13 VALUE=""> </font></td></tr>
<tr bgcolor="#C0C0C0"> <td valign=top> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT> <p><BR> <FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"> Posts appear exactly as you have submitted them. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting. </p></font> </td> <td> <TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr> </table> </td></tr></table> <P> <CENTER> <INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post"> <INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields"> <br> </CENTER> </FORM> <?php } ?>
det virkede nu mangler jeg "kun" sådan så den vil vise siden hvis man vil ændre eller slette....vi lavede det før men forstod ikke helt hvordan du gjorde...
if (isset($_POST['action']) && $_POST['action']=="delete_two") { $post_query = mysql_query("SELECT * FROM posts WHERE (ID='$postID' AND Name='$name' AND Password='$password')"); if (mysql_num_rows($post_query) != 1) { showheader("UserName Error"); ?> <br><p><center><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">That Name/Pass combo is not correct, or the post does not belong to you</center></p> <?php showfooter(); exit; } $post = mysql_fetch_array($post_query); mysql_free_result($post_query);
detox, jeg smutter i send, er alt for træt nu, håber det er okay, jeg er meget taknemlig for din hjælp, håber du lige vil hjælpe med at få det sidste på plads :) ses
jeg har lige prøvet den: her er scriptet men det virker stadig ikke... den siger det med at den ikke vil vise siden og viser en masse underligt i adresselinien:
<?php require( './functions.php');
if (isset($_POST['action']) && $_POST['action']=="delete_two") { foreach ($_POST as $key=>$value) { $$key = $value; } $post_query = mysql_query("SELECT * FROM posts WHERE (ID='$postID' AND Name='$name' AND Password='$password')"); if (mysql_num_rows($post_query) != 1) { showheader("UserName Error"); ?> <br><p><center><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">That Name/Pass combo is not correct, or the post does not belong to you</center></p> <?php showfooter(); exit; } $post = mysql_fetch_array($post_query); mysql_free_result($post_query);
jeg er ikke sikker, du får den lige postet her: function showheader($title) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE> <?php echo $title ?> </TITLE> </HEAD>
<BODY BGCOLOR="#FFFFFF"> <?php }
function showfooter() { ?> </BODY> </HTML> <?php }
function addpost () { global $password,$email,$name,$post,$topicID; $timestamp = time(); $new_password = addslashes($password); $new_email = addslashes($email); $new_name = addslashes($name); $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("INSERT INTO posts VALUES ('NULL','$topicID','$new_name','$new_email','$new_password','$timestamp','$new_post')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function editpost () { global $postID,$post; $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("UPDATE posts SET post='$new_post' WHERE (ID='$postID')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function deletepost () { global $postID; $post_query = mysql_query("DELETE FROM posts WHERE (ID='$postID')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function addtopic () { global $topicname; $new_topicname = addslashes($topicname); $topic_query = mysql_query("INSERT INTO topics VALUES ('NULL','$new_topicname')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } return mysql_insert_id(); }
function addpost () { global $password,$email,$name,$post,$topicID; $timestamp = time(); $new_password = addslashes($password); $new_email = addslashes($email); $new_name = addslashes($name); $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("INSERT INTO posts VALUES ('NULL','$topicID','$new_name','$new_email','$new_password','$timestamp','$new_post')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function editpost () { global $postID,$post; $new_post = addslashes(nl2br(htmlspecialchars($post))); $insert = mysql_query("UPDATE posts SET post='$new_post' WHERE ID=$postID"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function deletepost () { global $postID; $post_query = mysql_query("DELETE FROM posts WHERE ID=$postID"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } }
function addtopic () { global $topicname; $new_topicname = addslashes($topicname); $topic_query = mysql_query("INSERT INTO topics VALUES ('NULL','$new_topicname')"); if (mysql_error() != "") { showheader("MySQL Error ".mysql_error()); ?> <br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> <?php showfooter(); exit; } return mysql_insert_id(); } ?>
That Name/Pass combo is not correct, or the post does not belong to you den får vist stadig ikke helt rigtig fat.
og så er der lige den her: Parse error: parse error, unexpected T_ELSEIF in \test2\edit-post.php on line 49: line 49: elseif (isset($_POST['action']) && $_POST['action']=="edit_three")
Men der må være noget galt i edit og delete.php fordi, den får vist ikke fat i databasen. Det problem havde vi også tideligere..kan bare ikke huske hvad du gjorde.. :(
if (isset($_POST['action']) && $_POST['action']=="delete_two") { foreach ($_POST as $key=>$value) { $$key = $value; } $post_query = mysql_query("SELECT * FROM posts WHERE (ID='$postID' AND Name='$name' AND Password='$password')"); if (mysql_num_rows($post_query) != 1) { showheader("UserName Error"); ?> <br><p><center><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">That Name/Pass combo is not correct, or the post does not belong to you</center></p> <?php showfooter(); exit; } $post = mysql_fetch_array($post_query); mysql_free_result($post_query);
if (isset($_POST['action']) && $_POST['action']=="delete_two") { foreach ($_POST as $key=>$value) { $$key = $value; } $post_query = mysql_query("SELECT * FROM posts WHERE ID=".$_GET['postID']." AND Name='$name' AND Password='$password'"); if (mysql_num_rows($post_query) != 1) { showheader("UserName Error"); ?> <br><p><center><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">That Name/Pass combo is not correct, or the post does not belong to you</center></p> <?php showfooter(); exit; } $post = mysql_fetch_array($post_query); mysql_free_result($post_query);
DEt virker, jubii, nu skal jeg bare fikse lidt link og sådan så man ikke skal trykke på tilbage knappen hver gang man har lavet noget. Mange tusind tak for hjælpen, det kan være der kommer mere til det, da jeg gerne vil have tidspunkt for hvornår posts og topic er oprettet:
Ok, velbekommen. Det var osse en ordentlig omgang, men godt det virker c",)
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.