Comment system php source code how to#
Comment system php source code code#

All comments and replies display below the content on the single post like a blog system. After that, we create a single post page like a blog system in PHP. First of all, display all the posts from the MySQL database.

The first part is for comment and the second part is for reply. We separate the comment system into two parts. The connection file is used to make the connection between PHP and to MYSQL database. We will create a PHP PDO connection file. `cm_message` longtext CHARACTER SET utf8 NOT NULL,Īfter that, create a connection file. Here, we will use Bootstrap, jquery, AJAX, and PHP PDO prepared statements.įirst of all, we create two tables – posts and comments.

Comment system php source code how to#

In this tutorial, you will learn how to create a comment system using PHP, AJAX, and MYSQL database.

How to create a comment system in PHP, AJAX with MYSQL database.

Comment system php source code code#

You can download the source code for the comment system in PHP. This is a complete comment and reply system in PHP, AJAX, jQuery, PHP PDO, and MYSQL database. Create a comment system in PHP, AJAX, and MYSQL. The comment system is used to help readers on the website and readers can ask their questions. For this post_id filed we will use auto increment property of MySQL table.Comments are more important for a website. For each record once added we will generate one unique post id ( post_id). We will maintain this status filed with two values, ns(not seen) or fresh posting and second value is apv( approved ). By default all posting are to be approved by site admin. We will maintain one more filed and call it as status filed which will tell us where the posting is approved by site admin or not. It also has to store the unique page number or page name by which we can identify which comment or posting belongs to which page. This main cmt_post table will have fields to store the name, email address, data of post and comment. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 UNIQUE KEY `post_id` (`post_id`,`p_name`) `status` varchar(4) NOT NULL default 'ns', `email` varchar(50) NOT NULL,`dtl` text NOT NULL, `p_name` varchar(10) NOT NULL,`dt` date NOT NULL, `post_id` int(5) NOT NULL auto_increment, Let us first discuss about the main table, we call it cmt_post. If this script is used as a part of an existing system then this admin table is not required. We will use one table only for these records and one more table to store site admin login information. We will use MySQL database to store the postings of the visitors. Here while displaying we will not display the email address of the poster and we will only display name and the comment. One is there name, second one is there email address and third one is there comment or post. We will ask the visitors to enter three fields at the posting form. Where in a forum topic can be any thing within permitted areas of the forum. Here postings are focused to the main topic presented by the author. The process of posting became very simple as a single form is used. First here any one can post without becoming member or signing up but usually in a forum postings are allowed after signup. You can compare this with a forum but there are many differences here. This script can be further extended to have main posting by site admin, so it can be used as Blogging script and you can run you own blog within your site. Blog pages are somewhat similar to this script. Over time this system itself became a FAQ ( frequently asked questions ) page as over the subject lot of discussion became available at one place. Author of the article can post answer to specific questions raised by readers. Such a provision adds lot of value to the main content as replies and questions are both available at one place. Below such postings there will be the form which you can use and post your comments. You must have seen such comments at blog pages posted by visitors are displayed at the end of the page. After reading an article or news or any tutorial on a website, the visitor can post his or her comments at the end.