Comment: Manage a comment system using an SQL database

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
57%				Total: 3,049		All time: 1,194 This week: 42

Version		License		PHP version		Categories
`comment` 1.0.0		GNU Lesser Genera...		4.0		Databases, Content management

Description

Author

Peter Klauer

This class can be used to manage a generic comments system. It could be used to add comments to a blog, a guest book, etc..

The comments are stored in an SQL database table. The class can install the table and associated indexes. Currently it supports MySQL and Microsoft SQL server.

The class can add new comments, update an existing comment, generate HTML forms to submit a comment and show the comments summary.

It works fine with PHP versions 4 and greater.

Innovation Award

July 2006
Number 5

Prize: One downloadable copy of PhpED Professional

The possibility to post comments about the content that is published in Web site pages is very interesting.

It helps attracting more users that are able to participate in the site communities in a relevant way, even if it is just by letting them express their opinions.

This package provides a generic solution that could be used to let the users post comments about articles, blog posts, reviews, in guest books, etc..

Manuel Lemos

Peter Klauer

Name:	Peter Klauer `<contact>`
Classes:	18 packages by Peter Klauer
Country:	Germany
Age:	66
All time rank:	35	2 in Germany
Week rank:	195	8 in Germany

Innovation award

Nominee: 3x

Recommendations

What is the best PHP guestbook class?
I want to query a database and add names to a guestbook

Example


<html>


<head><title>Comment class example using mysql</title>





<?PHP





include '../includes/class_comment.php';


include '../includes/class_sqltable.php';





#


# ... connect here to your sql server


#


$sqlconnection = mysql_connect('myserver','myusername','mypassword');


if (!$sqlconnection) { die('Could not connect: ' . mysql_error()); }


mysql_select_db('mydatabase');





$sqltable = new sqltable( );


$sqltable->SQLTYPE = 'mysql';





$sqltable->install();





# $id_for and $code_for are the arguments.


# $sqltable is the table from above


# the empty string is the path to the css directory


# NOTE: $code_for is never allowed to have more than 8 characters.


#





$comment = new comment(0,'example',$sqltable, '../' );


$comment->SQLTYPE = 'mysql';





#


# MYSQL:


# install() will create the "comments" sql table under normal conditions and mysql.


#


# MSSQL:


# it will fail normally under mssql. Just copy the text from the mssql_query() of


# the install() function into your SQL Query Analyzer if the following install() fails.


# And then execute it with administrators rights. Don't forget to give


# the correct privileges to the freshly created table "comments"


#





$comment->install(); // Preparing, checking for sql table "comments", writing cssfile if not existing





?>





</head><body>





<h1>This is an example</h1>


This is some simple page which can be commented.


If the script is showing this text, then the comment class is properly installed.


<BR>


<BR>


<big>Congratulations!</big>





<BR>


<BR>


And here may come some comments, which may be re-edited by the author as long


as the internet connection does not change.





<BR>


<BR>





<div align=center><div style="text-align:left;width:80%;margin:0 auto">





<?php





#


# some optional options:


#





# $comment->debug = false; //true; // show additional info if true





# maybe we put some finedivs around the comment parts? (package ...)


# $comment->before_insert = $roundinput2->gettop(); // for example only, the finediv class is not initiated in this script


# $comment->after_insert = $roundinput2->getbottom();


# $comment->before_comments = $finediv->gettop();


# $comment->after_comments = $finediv->getbottom();





# $comment->showcomments = true; // Show the comments from start, don't wait on a mouseclick.





# $comment->prevent_multiple = false; // true by default





# $comment->prevent_spam = false; // allow links? Is true by default and changes input to $say_nolinks if a link is found





#


# to use in other languages, you may like to change


# all the "say_xxxx" text strings here like so for German text:


#





/*


  $comment->say_comment    = 'Kommentar:<br><img src="images/writing2.gif" alt="Hand h�lt Feder">';


  $comment->say_comments   = 'Kommentare';


  $comment->say_addcomment = 'Einen Kommentar hinzuf�gen';


  $comment->say_submit     = 'Abschicken';


  $comment->say_nickname   = 'Name/Alias:';


  $comment->say_update     = '�ndern';


  $comment->say_updated    = 'Eintrag ge�ndert.';


  $comment->say_close      = 'Schlie�en (X)';


*/





$comment->put();





?>


</div></div>


</body></html>

Files (6)

File	Role	Description
`css` (1 file)
`class_comment.php`	Class	Show the comments
`class_comment_admin.php`	Aux.	Use this class to validate the comments or to delete them
`test_comment.php`	Example	How to implement the comment class
`License_LGPL-3.0.txt`	Lic.	LGPL License
`CHANGELOG.txt`	Doc.	Changes

Files (6)

css

File	Role	Description
`comment.css`	Aux.	Default CSS file

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	comment-2011-05-02.zip 19KB
	comment-2011-05-02.tar.gz 17KB
	Install with Composer

Needed packages

Class	Download	Why it is needed	Dependency
SQL Table	.zip .tar.gz	Sqltable is needed to display the comment entries.	Required

Version Control

Unique User Downloads

Download Rankings

Total:	3,049
This week:	0

All time:	1,194
This week:	42

User Ratings

User Comments (2)

	All time
Utility:	85%
Consistency:	75%
Documentation:	-
Examples:	75%
Tests:	-
Videos:	-
Overall:	57%
Rank:	1601

well done 15 years ago (Naga Subrahmanyam)	52%
Excellent 15 years ago (kishore kumar)	70%

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.