Post and Comment Script

Submitted by: 
Language: 
Visitors have accessed this post 33511 times.

Hi guys,

In this code you will learn how to crate a Post and comment script which is very useful when you are developing a social networking site or any project that you want to put a Post and a comment system. Its design is from twitter bootstrap. Hope that you will like this code for more question email me at [email protected].

Thank you.

Database name: post in db folder

Sample code:

  1. <?php
  2. include('header.php');
  3. ?>
  4. <body>
  5. <br>
  6. <br>
  7. <div class="container">
  8. <form class="form-horizontal" method="POST">
  9. <div class="control-group">
  10. <div class="controls">
  11. <textarea rows="3" name="post_content" class="span6" placeholder="Whats on Your Mind"></textarea>
  12. </div>
  13. </div>
  14. <div class="control-group">
  15. <div class="controls">
  16. <button name="post" type="submit" class="btn btn-info"><i class="icon-share"></i>&nbsp;Post</button>
  17. </div>
  18. </div>
  19. <div class="control-group">
  20. <div class="controls">
  21. <table class="table table-bordered">
  22. <thead>
  23. </thead>
  24. <tbody>
  25. <?php
  26. $query=mysql_query("select * from post")or die(mysql_error());
  27. while($row=mysql_fetch_array($query)){
  28. $id=$row['post_id'];
  29. ?>
  30. <tr>
  31. <td><?php echo $row['content']; ?></td>
  32. <td width="50"><?php
  33. $comment_query=mysql_query("select * from comment where post_id='$id'")or die(mysql_error());
  34. $count=mysql_num_rows($comment_query);
  35. ?>
  36. <a href="#<?php echo $id; ?>" data-toggle="modal"><i class="icon-comments-alt"></i>&nbsp;<span class="badge badge-info"><?php echo $count; ?></span></a></td>
  37. <td width="40"><a class="btn btn-danger" href="delete_post.php<?php echo '?id='.$id; ?>"><i class="icon-trash"></i></a></td>
  38. </tr>
  39.  
  40. <!-- Modal -->
  41. <div id="<?php echo $id; ?>" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  42. <div class="modal-header"> </div>
  43. <div class="modal-body">
  44.  
  45. <!----comment -->
  46. <form method="POST">
  47. <input type="hidden" name="id" value="<?php echo $id; ?>">
  48. <textarea rows="3" name="comment_content" class="span6" placeholder="Your Comment Here"></textarea>
  49. <br>
  50. <br>
  51. <button name="comment" type="submit" class="btn btn-info"><i class="icon-share"></i>&nbsp;Comment</button>
  52. </form>
  53. <br>
  54. <br>
  55. <?php $comment=mysql_query("select * from comment where post_id='$id'")or die(mysql_error());
  56. while($comment_row=mysql_fetch_array($comment)){ ?>
  57. <div class="alert alert-success"><?php echo $comment_row['content']; ?></div>
  58. <?php } ?>
  59. <!--- end comment -->
  60.  
  61. </div>
  62. <div class="modal-footer">
  63. <button class="btn" data-dismiss="modal" aria-hidden="true">Close</button>
  64. </div>
  65. </div>
  66. <?php } ?>
  67. </tbody>
  68. </table>
  69. </div>
  70. </div>
  71. </form>
  72. </div>
  73. <?php
  74. if(isset($_POST['post'])){
  75. $post_content=$_POST['post_content'];
  76.  
  77.  
  78. mysql_query("insert into post (content) values('$post_content')")or die(mysql_error());
  79. header('location:index.php');
  80.  
  81.  
  82. }
  83. ?>
  84. <?php
  85. if(isset($_POST['comment'])){
  86. $comment_content=$_POST['comment_content'];
  87. $post_id=$_POST['id'];
  88.  
  89. mysql_query("insert into comment (content,post_id) values('$comment_content',$post_id)")or die(mysql_error());
  90. header('location:index.php');
  91.  
  92.  
  93. }
  94. ?>
  95. </body>
  96. </html>

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Dont work wast of time

is there pagination in the script

This is a great resource, and is definitely what I have been looking for! Thanks, and keep up the good work!

ahmed loves boys give him a new dad

just testting to see if it will work

thanks for this codes

Hello i have upgraded the script i added features which display the username, comment, profile picture on the post email me for a zip file at [email protected]

I really like the comment function

Just testing this for accuracy and workability. Great

excellent code I have seen.

ok thanks so much i get so pleasure and feel lucky!

Thanks to give this code...... Thank you very muchhhh...

Very good script....
jisu I wanna to ask you...why you have JS folder....when a delete that folder the script is working the same as before ::)))
BTW good job

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.