Joomla - Component: Adding Comment ( Create Table )


After build front end component, may be your visitor want to leave comment about your posting. May be they have different opinion. Don't worry. It will make your site more attractive.

This tutorial will show step by step how to add comment function in your component. Let's do it!

  1. Create "comment.php" within joomla/administrator/components/com_hello/tables. Enter following code:
    <?
    defined( '_JEXEC' ) or die( 'Restricted access' );
    
    class TableComment extends JTable
    {
      var $id 		= null;
      var $hello_id 	= null;
      var $user_id 	= null;
      var $full_name	= null;
      var $comment_date = null;
      var $comment_text = null;
    	
      function __construct (&$db)
      {
        parent::__construct( '#__hello_comment' , 'id', $db);
      }
    }
    ?>
    
  2. Add "jos_hello_comment" table. It have 6 fields.
    Click Go button.
  3. Enter fields like following images:
  4. Set primary key on id field:
  5. Click Save button.

    If you prefer SQL command, you can execute the following code:

    CREATE TABLE `jos_hello_comment` (
    `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `hello_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 
    ) ENGINE = MYISAM ;
    
    


Series this article:
Joomla - Component: Create Hello World Component on Front End
Joomla - Component: Create Hello World Component on Back End
Joomla - Component: Registering Your Component in database
Joomla - Component: Create Component Link for Front End
Joomla - Component: Creating Toolbars
Joomla - Component: Available Toolbar Buttons
Joomla - Component: Creating the Database Table
Joomla - Component: Creating Form Input Data at Back End
Joomla - Component: Saving Data to Database
Joomla - Component: Creating a List Screen
Joomla - Component: Creating Advance List Screen
Joomla - Component: Editing Data
Joomla - Component: Deleting Data
Joomla - Component: Updating publish state
Joomla - Component: Hello From Database at Front End
Joomla - Component: a Hello page
Joomla - Component: Generating Friendly Links
Joomla - Component: Adding Comment ( Create Table )
Joomla - Component: Adding Comment (Create Form)
Joomla - Component: Adding Comment ( Insert Data )
Joomla - Component: Adding Comment ( Displaying Comments )
Joomla: Fast Road to Understand Component Programming

Bookmark and Share Tag: joomla, cms Category: PHP Framework Post : November 13th 2007 Read: 53,369

advertisements


blog comments powered by Disqus