PHP/MySQL News with Comments - Adding comments

(Page 6 of 7 )

So, what’s left? We need to provide the backend for what happens when a user types in a comment. We will simply take the form input and insert it in the comments table. Then, provide a link back to the page they came from.

<?php function addComment($id) {     global $db;          /* insert the comment */     $query = "INSERT INTO news_comments " .              "VALUES('',$id,'{$_POST['name']}'," .              "'{$_POST['comment']}')";     mysql_query($query);          echo "Comment entered. Thanks!&lt;BR&gt;\n";     echo "&lt;a href=\"{$_SERVER['PHP_SELF']}" .          "?action=show&amp;id=$id\"&gt;Back&lt;/a&gt;\n"; } ?>

Next: Summing it up and final script >>
 

More Database Articles Articles
More By Matt Wade

Comments On: PHP/MySQL News with Comments

· dfsf    · Thanks for a great tutorial.    · hiI've search the web for ages to find a newssystem that does excatly what this...    · I seem to be getting the problem where it's not showing the news table at all and...    · sounds like it doesn't interact with your "news"-database as it...    · file loaded: http://luna-illusions.co.uk/weetom/newsscript.phpThere's no design...    · Hi.I just love this Tutorial and it works perfectly except for 1 thing. When you...    · Warning: mysql_connect() [function.mysql-connect]: Access denied for user...    · I've discovered a problem with this tutorial. The Comment can only be 500 Characters...    · Tutorial is nice, but previous one was better, this one is just final script cut...    · Hello Mr/Mrs Tutorial Creator (xD)I'm new toP and MySQL and I suck basically...   >>> Post your comment now!