Book Image

Learning Joomla! 1.5 Extension Development

Book Image

Learning Joomla! 1.5 Extension Development

Overview of this book

Table of Contents (17 chapters)
Learning Joomla! 1.5 Extension Development
Credits
About the Author
About the Reviewer
Preface

Adding comments


Most visitors will take our word for it when we say that a restaurant is great (or that it isn't). However, there may be a few who disagree. Why not give them the opportunity to leave comments about their experiences with the restaurant? We'll need a place to store these comments, so enter the following SQL command into your database console:

CREATE TABLE `jos_reviews_comments` (
`id` int(11) NOT NULL auto_increment,
`review_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`full_name` varchar(50) NOT NULL,
`comment_date` datetime NOT NULL,
`comment_text` text NOT NULL,
PRIMARY KEY (`id`)
)

If you're using phpMyAdmin, pull up the following screen and enter jos_reviews_comments as the table name and 6 in the Number of fields section:

After clicking Go, a grid is displayed. Fill in the details so that it looks like the following screen:

Make sure that you make the field id into an automatically-incremented primary key:

We also want to add another database class to handle...