You are here

Home
Key Features
Press the Go WDZ Button

Press the Go WDZ Button

In "Data Tables" there are a few tables associated with a shop. Once you press the "Go WDZ" Button, then all the code and forms that you require go into the designer studio, so that you can modify all the forms and the lists that you require as well as obtain the code needed. Click on the edit icon to view, the lists and forms. In the demo system you can edit your lists and forms here, while the other three modes show, the list views, the panel view and the code.

Code and sql for Comment

This is the generated code which can be downloaded along with the base class in the paid for version. EXIT

Class:- exComment.php
Copy - Quick copy

<?php
/**
 * Comment - exComment.php 
 * 
 * Looks after the comments a user makes about a product. This is also an example of a xref table where the parents are in different tables
 * 
 * 
 * DO NOT EDIT THIS CLASS. MAKE CHANGES TO usrExComment.php INSTEAD
 * IF YOU NEED EXTRA FIELDS REGENERATE exComment.php at {@link https://web-d-zine.co.uk/ https://web-d-zine.co.uk/}
 *
 * 
 * Dependencies on other classes
 * -----------------------------
 * wdz3BaseClass.php - Base class for some basic functions
 * 
 * 
 * @package Example Shop
 * @subpackage class
 * 
 * @author Web-D-Zine <support@web-d-zine.co.uk>
 * @author Co author with Example Author <shop@example.com>
 * @copyright Copyright (C) Web-D-Zine 2024
 * @copyright Copyright (C) Example Author
 * @version 1.0 - Creation date: 16-Jul-2024
 * 
 * {@internal
 * Assumptions
 * -----------
 * 
 * 
 * Modification list
 * -----------------
 * Mod.   By    When        Comment
 * ---    --    ------      -------
 * 
 * }
 * /
/**
 * Manage data for SQL table 'exComment'
 */
class exComment extends wdz3BaseClass {

/**
      * Primary Id
      *
      * The Primary Id is used in back end systems to retrieve the record
      * @var int
      */
     protected $excId;

/**
      * Key
      *
      * The key is used to group children records together
      * @var string
      */
     protected $excExuKey;

/**
      * Product Id
      *
      * External Id by which a record can be retrieved but not edited
      * @var int
      */
     protected $excExpProductId;

/**
      * Key(11)
      *
      * The key is used to group children records together
      * @var string
      */
     protected $excKey;

/**
      * Comment
      *
      * Comment
      * @var string
      */
     protected $excComment;

/**
      * Icons
      *
      * Icons such as heart etc.
      * @var string
      */
     protected $excIcons;

/**
      * Stars
      *
      * Looks after the number of starts a comment has
      * @var int
      */
     protected $excStars;

/**
      * Spare 1
      *
      * Used for expansion
      * @var string
      */
     protected $excSpare1;

/**
      * Spare 2
      *
      * Used for expansion
      * @var string
      */
     protected $excSpare2;

/**
      * Spare 3
      *
      * Used for expansion
      * @var string
      */
     protected $excSpare3;

/**
      * Timestamp
      *
      * Shows the time that the record was last updated
      * @var string
      */
     protected $excTs;

// ----- Constructor -----------------------------------------------------
     /**
      * Database object handler
      * @param object - $pdo A PDO database connector
      */
     function __construct( $pdo ) {
    
          parent::__construct( $pdo );
          $this->initialise();
          $this->prepareInsert();

}

// ----- Gets / Sets -----------------------------------------------------

/**
      * Get Primary Id
      *
      * The Primary Id is used in back end systems to retrieve the record
      *
      * @return int excId - Primary Id
      */
     function getExcId() {
          return $this->excId;
     }

/**
      * Set Primary Id
      *
      * The Primary Id is used in back end systems to retrieve the record
      *
      * @param int $p - Primary Id
      */
     function setExcId( $p ) { 
          $this->excId = (int) $p;
     }

/**
      * Get Key
      *
      * The key is used to group children records together
      *
      * @return string excExuKey - Key
      */
     function getExcExuKey() {
          return $this->excExuKey;
     }

/**
      * Set Key
      *
      * The key is used to group children records together
      *
      * @param string $p - Key
      */
     function setExcExuKey( $p ) { 
          $this->excExuKey = $p;
     }

/**
      * Get Product Id
      *
      * External Id by which a record can be retrieved but not edited
      *
      * @return int excExpProductId - Product Id
      */
     function getExcExpProductId() {
          return $this->excExpProductId;
     }

/**
      * Set Product Id
      *
      * External Id by which a record can be retrieved but not edited
      *
      * @param int $p - Product Id
      */
     function setExcExpProductId( $p ) { 
          $this->excExpProductId = (int) $p;
     }

/**
      * Get Key(11)
      *
      * The key is used to group children records together
      *
      * @return string excKey - Key(11)
      */
     function getExcKey() {
          return $this->excKey;
     }

/**
      * Set Key(11)
      *
      * The key is used to group children records together
      *
      * @param string $p - Key(11)
      */
     function setExcKey( $p ) { 
          $this->excKey = $p;
     }

/**
      * Get Comment
      *
      * Comment
      *
      * @return string excComment - Comment
      */
     function getExcComment() {
          return $this->excComment;
     }

/**
      * Set Comment
      *
      * Comment
      *
      * @param string $p - Comment
      */
     function setExcComment( $p ) { 
          $this->excComment = $p;
     }

/**
      * Get Icons
      *
      * Icons such as heart etc.
      *
      * @return string excIcons - Icons
      */
     function getExcIcons() {
          return $this->excIcons;
     }

/**
      * Set Icons
      *
      * Icons such as heart etc.
      *
      * @param string $p - Icons
      */
     function setExcIcons( $p ) { 
          $this->excIcons = $p;
     }

/**
      * Get Stars
      *
      * Looks after the number of starts a comment has
      *
      * @return int excStars - Stars
      */
     function getExcStars() {
          return $this->excStars;
     }

/**
      * Set Stars
      *
      * Looks after the number of starts a comment has
      *
      * @param int $p - Stars
      */
     function setExcStars( $p ) { 
          $this->excStars = (int) $p;
     }

/**
      * Get Spare 1
      *
      * Used for expansion
      *
      * @return string excSpare1 - Spare 1
      */
     function getExcSpare1() {
          return $this->excSpare1;
     }

/**
      * Set Spare 1
      *
      * Used for expansion
      *
      * @param string $p - Spare 1
      */
     function setExcSpare1( $p ) { 
          $this->excSpare1 = $p;
     }

/**
      * Get Spare 2
      *
      * Used for expansion
      *
      * @return string excSpare2 - Spare 2
      */
     function getExcSpare2() {
          return $this->excSpare2;
     }

/**
      * Set Spare 2
      *
      * Used for expansion
      *
      * @param string $p - Spare 2
      */
     function setExcSpare2( $p ) { 
          $this->excSpare2 = $p;
     }

/**
      * Get Spare 3
      *
      * Used for expansion
      *
      * @return string excSpare3 - Spare 3
      */
     function getExcSpare3() {
          return $this->excSpare3;
     }

/**
      * Set Spare 3
      *
      * Used for expansion
      *
      * @param string $p - Spare 3
      */
     function setExcSpare3( $p ) { 
          $this->excSpare3 = $p;
     }

/**
      * Get Timestamp
      *
      * Shows the time that the record was last updated
      *
      * @return string excTs - Timestamp
      */
     function getExcTs() {
          return $this->excTs;
     }

// ----- Methods ---------------------------------------------------------

/**
      * Initialise the properties to default values
      */
     function initialise() {
    
          $this->excId            = null;
          $this->excExuKey        = '';
          $this->excExpProductId  = '0';
          $this->excKey           = '';
          $this->excComment       = '';
          $this->excIcons         = '';
          $this->excStars         = '0';
          $this->excSpare1        = '';
          $this->excSpare2        = '';
          $this->excSpare3        = '';

}

/**
      * Check if a record with the primary key exists
      * @return TRUE if there is a record, else false
      */
     function exists() { 
          $sql = "SELECT 1 FROM `exComment` WHERE `excId` = :excId";
          $stmt = $this->pdo->prepare( $sql );
          $data = [ 'excId' => $this->excId ];
          $stmt->execute( $data );
          return (bool) $stmt->fetchColumn();
     }

/**
      * Populate the current object based on the key
      * @param mixed $id The ID to use, might not be present
      */
     function rtv( $id='*none' ) {
    
          if ( $id != '*none' ) {
               $this->excId = $id;
          }

$sql = "SELECT * FROM `exComment` WHERE `excId` = :excId";
          $data = [ 'excId' => $this->excId ];

$stmt = $this->pdo->prepare( $sql );
          $stmt->execute($data);

$row = $stmt->fetch( PDO::FETCH_ASSOC );
          $this->sqlResult = $stmt->errorinfo();
          $this->success = ($row !== false );
          
          if ($row) {
               foreach( $row as $name => $value ) {
                    $this->{$name} = $value;
               }
          }
          else {
               $this->initialise();
               if ( $id != '*none' ) {
                    $this->excId = $id;
               }
          }
     }

/**
      * Update a record in the database determined by the ID number
      */
     function update() {

$sql = "UPDATE `exComment`
                    SET
                    `excId`           = :excId,
                    `excExuKey`       = :excExuKey,
                    `excExpProductId` = :excExpProductId,
                    `excKey`          = :excKey,
                    `excComment`      = :excComment,
                    `excIcons`        = :excIcons,
                    `excStars`        = :excStars,
                    `excSpare1`       = :excSpare1,
                    `excSpare2`       = :excSpare2,
                    `excSpare3`       = :excSpare3
                    WHERE `excId` = :excId";

$data = [ 
                    'excId'            => $this->excId,
                    'excExuKey'        => $this->excExuKey,
                    'excExpProductId'  => $this->excExpProductId,
                    'excKey'           => $this->excKey,
                    'excComment'       => $this->excComment,
                    'excIcons'         => $this->excIcons,
                    'excStars'         => $this->excStars,
                    'excSpare1'        => $this->excSpare1,
                    'excSpare2'        => $this->excSpare2,
                    'excSpare3'        => $this->excSpare3
                  ];

$stmt = $this->pdo->prepare( $sql );

$this->success = $stmt->execute($data);
          $this->sqlResult = $stmt->errorinfo();
     }

/**
      * Prepare the statement so that you can insert a record or records into the database
      */
     function prepareInsert() {
    
          $sql = "INSERT INTO `exComment` (
                    `excExuKey`,
                    `excExpProductId`,
                    `excKey`,
                    `excComment`,
                    `excIcons`,
                    `excStars`,
                    `excSpare1`,
                    `excSpare2`,
                    `excSpare3`
               ) VALUES (
                    :excExuKey,
                    :excExpProductId,
                    :excKey,
                    :excComment,
                    :excIcons,
                    :excStars,
                    :excSpare1,
                    :excSpare2,
                    :excSpare3
               );";
    
          $this->insertStatement = $this->pdo->prepare( $sql );
     }

/**
      * Insert a record into the database
      */
     function insert() {

do{
               $this->excKey = $this->nearUniqueCode(11);
          } while ($this->valueIsInUse( 'excKey', $this->excKey ));

$data = [ 
                    'excExuKey'        => $this->excExuKey,
                    'excExpProductId'  => $this->excExpProductId,
                    'excKey'           => $this->excKey,
                    'excComment'       => $this->excComment,
                    'excIcons'         => $this->excIcons,
                    'excStars'         => $this->excStars,
                    'excSpare1'        => $this->excSpare1,
                    'excSpare2'        => $this->excSpare2,
                    'excSpare3'        => $this->excSpare3
                  ];

$this->success = $this->insertStatement->execute($data);
          $this->sqlResult = $this->insertStatement->errorinfo();

if ( $this->wasSuccessful() ) {
               $this->excId = $this->pdo->lastInsertId();
          }
         
     }

/**
      * Delete a record from the database
      */
     function delete() {

$sql = "DELETE FROM `exComment` WHERE `excId` = :excId";
  
          $stmt = $this->pdo->prepare( $sql );
          $data = [ 'excId' => $this->excId ];

$stmt->execute($data);

$this->success = $stmt->rowCount();
          $this->sqlResult = $stmt->errorinfo();

}

// ----- Methods needed for the panel ------------------------------------------

/**
      * Fetches the maximum record count
      * 
      */
     function fetchMaxRecordCount() {

// Construct the SQL and prepare the data
          //
          if($this->whereClause != "" && count($this->data)>0){
               $sql = "SELECT count( `excId` ) as `recordCount` FROM `exComment` where $this->whereClause ;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT count( `excId` ) as `recordCount` FROM `exComment`;";
               $data = array();
          }

$stmt = $this->pdo->prepare( $sql );
          $stmt->execute( $data );

// Attempt to fetch the query results
          //
          $stmt->setFetchMode( PDO::FETCH_ASSOC );
          $results = $stmt->fetch();

// Something was returned if the result set has more than zero entries
          //
          $this->success = $results;
          $this->sqlResult = $stmt->errorinfo();

if($this->returnedSomething()){
               return $results['recordCount'];
          }
          else{
               return 0;
          }
     }

/**
      * Fetches the ids for a particular sort order
      * @param string $sortOrder
      */
     function getListOfIdCodesFor($sortOrder="") {
    
          $arr = array();
          $sortClause = ($sortOrder != "")?" ORDER BY $sortOrder":" ORDER BY `excExuKey`, `excExpProductId`";
    
          // Construct the SQL and prepare the data
          //
          if($this->whereClause != "" && count($this->data)>0){
               $sql = "SELECT `excId` FROM `exComment` where $this->whereClause$sortClause;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT `excId` FROM `exComment`$sortClause;";
               $data = array();
          }

$stmt = $this->pdo->prepare( $sql );
          $stmt->execute( $data );
    
          // Attempt to fetch the query results
          //
          $stmt->setFetchMode( PDO::FETCH_ASSOC );
          $results = $stmt->fetchAll();
    
          if(count($results)>0){
               foreach($results as $row){
                    $arr[] = $row['excId'];
               }
          }

// Something was returned if the result set has more than zero entries
          //
          $this->success = count($arr)>0;
          $this->sqlResult = $stmt->errorinfo();

return $arr;

}

/**
      * Returns a block of data according to a where clause
      *
      * @param int $startAt
      * @param int $recordCount
      * @param string $sortOrder
      * @param string $className
      * @return array of data
      */
     function fetchBlock($startAt, $recordCount, $sortOrder='', $className=''){
    
          $s  = (int) $startAt;
          $rc = (int) $recordCount;

$sortClause = ($sortOrder != "")?" ORDER BY $sortOrder":" ORDER BY `excExuKey`, `excExpProductId`";
    
          if($this->whereClause != "" && count($this->data)>0){
               $sql = "SELECT  `excId` FROM `exComment` where $this->whereClause$sortClause limit $s, $rc;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT  `excId` FROM `exComment`$sortClause limit $s, $rc;";
               $data = array();
          }

$stmt = $this->pdo->prepare( $sql );
          $stmt->execute($data);

// Fetch the initial results
          //
          $stmt->setFetchMode( PDO::FETCH_ASSOC );
          $results = $stmt->fetchAll();

if(count($results)>0){
    
               $miniSql = "SELECT * FROM `exComment` where `excId`=:excId;";  
               $miniStmt = $this->pdo->prepare( $miniSql );

if($className == "stdClass"){
                    $miniStmt->setFetchMode( PDO::FETCH_CLASS, "stdClass" );
               }
               else{
                    $miniStmt->setFetchMode( PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, "usrExComment", array( $this->pdo ));
               }

foreach($results as $miniData){

$miniStmt->execute($miniData);
                    $newResults[$miniData['excId']] = $miniStmt->fetch();

}
               $this->success = (count($newResults) > 0 );
               $this->sqlResult = $miniStmt->errorinfo();
    
               return $newResults;
          }
    
          $this->success = (count($results) > 0 );
          $this->sqlResult = $stmt->errorinfo();
            
          return $results;
            
     }

/**
      * Fetch objects by their id
      *
      * @param array $idArr
      * @param string $className
      * @return array
      */
     function rtvByIds( $idArr, $className ='' ){
    
          $arr = array();
    
          $sql = "SELECT * FROM `exComment` WHERE `excId` = :excId;";
    
          $stmt = $this->pdo->prepare( $sql );
    
          if($className == "stdClass"){
               $stmt->setFetchMode( PDO::FETCH_CLASS, $className );
          }
          else{
               $stmt->setFetchMode( PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, "usrExComment", array( $this->pdo ));
          }

if(is_array($idArr)){
               foreach($idArr as $id ){
                    
                    $data = [ 'excId' => $id ];
                    $stmt->execute( $data );
                    $arr[$id] = $stmt->fetch();
               }
          }

$this->success   = (count($arr) > 0 );
          $this->sqlResult = $stmt->errorinfo();        
          return $arr;

}

// ----- In Use Method ------------------------------------------

/**
      * Find out if a value is already in use
      *
      * @param string $fieldName
      * @param string $fieldValue
      * @return boolean
      */
     function valueIsInUse( $fieldName, $fieldValue ='' ){
    
          $flag = false;

if($fieldValue != ""){
    
               $sql = "SELECT `excId` FROM `exComment` WHERE `$fieldName`=:$fieldName;";
    
               $stmt = $this->pdo->prepare( $sql );

$data = [ $fieldName => $fieldValue];

$stmt->execute( $data );
    
               $stmt->setFetchMode( PDO::FETCH_ASSOC );

$results = $stmt->fetch();

$flag   = ($results !==false );
          }
          return $flag;
     }

// ----- Other Generated User Methods ------------------------------------------

/**
      * Retrieve objects for key 'excExuKey'
      * 
      * @param string $excExuKey - The key to use for the retrieve
      * @param string $className - Alternate class name
      * @return mixed $results - Array of objects containing retrieved data or false
      */
     function rtvByExcExuKey( $excExuKey, $className='' ) {

// Construct the SQL and prepare the data
          //
          $sql = "SELECT * FROM `exComment` 
                    WHERE `excExuKey` = :excExuKey
                    ORDER BY `excExuKey`, `excExpProductId`, `excId`;";

$data = [ 'excExuKey' => $excExuKey ];
          $stmt = $this->pdo->prepare( $sql );
          $stmt->execute( $data );

// Attempt to fetch the query results
          //
          if($className == "stdClass"){
               $stmt->setFetchMode( PDO::FETCH_CLASS, "stdClass" );
          }
          else{
               $stmt->setFetchMode( PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'usrExComment', array( $this->pdo ));
          }
          $results = $stmt->fetchAll();

// Something was returned if the result set has more than zero entries
          //
          $this->success = (count($results) > 0 );
          $this->sqlResult = $stmt->errorinfo();

return $results;
     }

/**
      * Retrieve objects for key 'excExpProductId'
      * 
      * @param int $excExpProductId - The key to use for the retrieve
      * @param string $className - Alternate class name
      * @return mixed $results - Array of objects containing retrieved data or false
      */
     function rtvByExcExpProductId( $excExpProductId, $className='' ) {

// Construct the SQL and prepare the data
          //
          $sql = "SELECT * FROM `exComment` 
                    WHERE `excExpProductId` = :excExpProductId
                    ORDER BY `excExuKey`, `excExpProductId`, `excId`;";

$data = [ 'excExpProductId' => $excExpProductId ];
          $stmt = $this->pdo->prepare( $sql );
          $stmt->execute( $data );

// Something was returned if the result set has more than zero entries
          //
          $this->success = (count($results) > 0 );
          $this->sqlResult = $stmt->errorinfo();

return $results;
     }

/**
      * Retrieve object for unique key 'excKey'
      * 
      * @param string $excKey - The key to use for the retrieve
      * @param string $className - Alternate class name
      * @return mixed $results - Object containing retrieved data or false
      */
     function rtvByExcKey( $excKey, $className='' ) {

// Construct the SQL and prepare the data
          //
          $sql = "SELECT * FROM `exComment` 
                    WHERE `excKey` = :excKey;";
          $data = [ 'excKey' => $excKey ];
          $stmt = $this->pdo->prepare( $sql );
          $stmt->execute( $data );

// Something was returned if the results are not false
          //
          $this->success = ($results !==false );
          $this->sqlResult = $stmt->errorinfo();

return $results;
     }

/**
     * Load the $vars array from exComment
     * 
     * @return array
     */
     function loadDataSet(){

$vars = array();

$vars['excId']            = $this->getExcId();
          $vars['excExuKey']        = $this->getExcExuKey();
          $vars['excExpProductId']  = $this->getExcExpProductId();
          $vars['excKey']           = $this->getExcKey();
          $vars['excComment']       = $this->getExcComment();
          $vars['excIcons']         = $this->getExcIcons();
          $vars['excStars']         = $this->getExcStars();
          $vars['excSpare1']        = $this->getExcSpare1();
          $vars['excSpare2']        = $this->getExcSpare2();
          $vars['excSpare3']        = $this->getExcSpare3();
          $vars['excTs']            = $this->getExcTs();

return $vars;

}

/**
     * Save the $vars array to exComment
     * 
     * @param array $vars
     * 
     * @return array - Errors
     */
     function saveDataSet( $vars ){

$errors = array();

if(isset($vars['excId'])){
               $this->setExcId(html_entity_decode($vars['excId'], ENT_QUOTES));
          }
          if(isset($vars['excExuKey'])){
               $this->setExcExuKey(html_entity_decode($vars['excExuKey'], ENT_QUOTES));
          }
          if(isset($vars['excExpProductId'])){
               $this->setExcExpProductId(html_entity_decode($vars['excExpProductId'], ENT_QUOTES));
          }
          if(isset($vars['excKey'])){
               $this->setExcKey(html_entity_decode($vars['excKey'], ENT_QUOTES));
          }
          if(isset($vars['excComment'])){
               $this->setExcComment(html_entity_decode($vars['excComment'], ENT_QUOTES));
          }
          if(isset($vars['excIcons'])){
               $this->setExcIcons(html_entity_decode($vars['excIcons'], ENT_QUOTES));
          }
          if(isset($vars['excStars'])){
               $this->setExcStars(html_entity_decode($vars['excStars'], ENT_QUOTES));
          }
          if(isset($vars['excSpare1'])){
               $this->setExcSpare1(html_entity_decode($vars['excSpare1'], ENT_QUOTES));
          }
          if(isset($vars['excSpare2'])){
               $this->setExcSpare2(html_entity_decode($vars['excSpare2'], ENT_QUOTES));
          }
          if(isset($vars['excSpare3'])){
               $this->setExcSpare3(html_entity_decode($vars['excSpare3'], ENT_QUOTES));
          }

$this->chgCrt();

if($this->failed()){
               $errors[]=$this->getSqlError();
          }

return $errors;

}

User class:- usrExComment.php
Copy - Quick copy

<?php
/**
 * User class for Comment - usrExComment.php 
 *
 * Desc: Looks after the comments a user makes about a product. This is also an example of a xref table where the parents are in different tables
 *
 * @package Example Shop
 * @subpackage usrClass
 * 
 * @author Example Author
 * @copyright Copyright (C) Web-D-Zine 2024
 * @copyright Copyright (C) Example Author
 * @version 1.0 - Creation date: 16-Jul-2024
 * 
 * {@internal
 * Assumptions
 * -----------
 *

* Modification list
 * -----------------
 * Mod.   By    When        Comment
 * ---    --    ------      -------
 * 
 * 
 * }
 * 
 * Dependencies on other classes
 * -----------------------------
 * wdz3BaseClass.php - Base class for some basic functions
 * exComment.php - Class for Comment
 * 
 * 
 * 
 * IF YOU NEED EXTRA FIELDS REGENERATE exComment.php at {@link https://web-d-zine.co.uk/ https://web-d-zine.co.uk/}
 * 
 *
 * Manage data for SQL table 'exComment'
 */
class usrExComment extends exComment {
    
     /* ----- Property summary ------------------
      * excId           int        Primary Id
      * excExuKey       string     Key
      * excExpProductId int        Product Id
      * excKey          string     Key(11)
      * excComment      string     Comment
      * excIcons        string     Icons
      * excStars        int        Stars
      * excSpare1       string     Spare 1
      * excSpare2       string     Spare 2
      * excSpare3       string     Spare 3
      * excTs           string     Timestamp
      * ------------------------------------------ */

// ----- Constructor -----------------------------------------------------
     /**
      * Database object handler
      * @param object $pdo A PDO database connector
      */
     function __construct( $pdo ) {
          parent::__construct( $pdo );
     }

// ----- User methods go below here --------------------------------------

}

Panel:- pnlExComment.php
Copy - Quick copy

<?php
/**
 * Panel for Comment - pnlExComment.php
 *
 * Desc: Looks after the comments a user makes about a product. This is also an example of a xref table where the parents are in different tables
 * 
 * @package Example Shop
 * @subpackage panel
 * @author Web-D-Zine <support@web-d-zine.co.uk>
 * @author Co author with Example Author <shop@example.com>
 * @copyright Copyright (C) Web-D-Zine 2024
 * @copyright Copyright (C) Example Author
 * @version 1.0 - Creation date: 16-Jul-2024
 * 
 * 
 * {@internal
 * Assumptions
 * -----------
 * 
 *
 * Modification list
 * -----------------
 * Mod.   By    When        Comment
 * ---    --    ------      -------
 * 
 * 
 * 
 * }
 * 
 * Dependencies on other classes
 * -----------------------------
 * wdz3BaseClass.php - Base class for some basic functions
 * exComment.php - Class for Comment
 * usrHandle.php - Looks after how the data is handled
 * wdzInput.php - Extracts data from $_GET and $_POST
 * wdzAbstractPanel.php - Stores data about the panel
 * 
 * 
 */
/**
 * Display data for SQL table 'exComment'
 */
class pnlExComment extends wdzAbstractPanel {

// ===== Constructor =====================================================

/**
      * The contructor for pnlExComment
      *
      * @param object $pdo - The connection to the database
      * @param object $userProfile - The users profile
      * @param string $lang - The language for forms
      */ 
     function __construct( $pdo, $userProfile, $lang='en' ) {

parent::__construct( $pdo, $userProfile, $lang );

$this->hiddens       = array("code", "excId", "display", "exuId", "expId" );
          $this->searches      = array('SCHexcExuKey', 'SCHexcExpProductId', 'SCHexcKey');
          $this->operations    = array("=", "=", "=");

$this->idField       = "excId";
          $this->editForm      = "frmExComment";
          $this->reportForm    = "rptExComment";
          $this->searchForm    = "schExComment";

$this->deleteTitle   = "Comment deletion";
          $this->listTitle     = "Managing Comments";
          $this->editTitle     = "Editing Comment";
          $this->reportTitle   = "Comment";
          $this->addText       = "Add a new Comment";
          
          $this->sortOrder     = "`excExuKey`, `excExpProductId`";
          $this->blockName     = "excCb";
          $this->delCheckbox   = "excDel";
          $this->mode          = "excMode";
          $this->parentId      = "";
          $this->anchor        = "pnlExComment";
          $this->project       = "Web-D-ZineE";

$this->dataObj       = new usrExComment( $pdo );

// Allow sort
          //
          $this->allowSort     = $this->hasAccess('sort');

// Sort out the handles
          //
          $this->tableName     = 'exComment';
          $this->listName      = 'list';
          $this->delName       = 'delete';

$this->handle        = $this->handleObj->fetchHandleFor($this->tableName, $this->listName, $this->mode, $this->hasAccess('edit'));

$this->handle['style'] = ['Display'=>'style'];
          $this->handle['flag']  = ['Display'=>'flag:delete:'.$this->delCheckbox];

if($this->hasAccess('delete-single')){
               $this->handle['delete']           = ['Title'=>'Del','Display'=>'key', 'alt'=>'', 'cssClass'=>'iconCol', 'icon'=>'icon=./images/del.png', $this->mode=>'delete'];
          }

$this->delHandle     = $this->handleObj->fetchHandleFor($this->tableName, $this->delName);

if($this->hasAccess('delete-multiple')){
               $this->handle[$this->delCheckbox]    = ['Title'=>'Del','Display'=>'checkbox', 'alt'=>'', 'cssClass'=>'iconCol', 'icon'=>'', $this->mode=>$this->delCheckbox];
               $this->delHandle[$this->delCheckbox] = ['Title'=>'Del','Display'=>'checkbox', 'alt'=>'', 'cssClass'=>'iconCol', 'icon'=>'', $this->mode=>$this->delCheckbox];
          }

}

// ===== Function definitions ============================================

/**
      *
      * Displays a list of data using a panel
      *
      */
     function displayList() {

$form     = $nextCombo = "";
          $navLink  = new wdzNavLinkBar($this->blockName);
          $category = new usrWdzCategoryDtl($this->pdo);
          $url      = $this->combinedUrl();
          $nUrl     = clone $url;

// Initialise the search criteria
          //
          $this->dataObj->initialiseDataDef();

// Are there any searches to be dealt with
          //
          if(count($this->searches)>0){
    
               foreach($this->searches as $pos=>$val){
        
                    $value = ($this->$val != null)?$this->$val:$this->input->extract($val);
                    $action = (isset($this->operations[$pos]) && $this->operations[$pos] !="" )?$this->operations[$pos]:"=";
                    $modValue = substr($val,3);

$this->dataObj->addDataDef($modValue, $action, $value);

}

// If you have more complex requirements then you can clearDataDef then process that group
               //
               $this->dataObj->prepareData("and", "and");
    
          }

// What is the sort order
          //
          $sortOrder = $this->sortOrder;

if($this->is($this->allowSort)){
               if($this->input->extract("sortAsc") !=""){
    
                    $nUrl->addParameter("sortAsc", $this->input->extract("sortAsc"));
                    $sortOrder = "`".$this->input->extract("sortAsc")."`";
    
               }
               else if($this->input->extract("sortDsc") !=""){
    
                    $nUrl->addParameter("sortDsc", $this->input->extract("sortDsc"));
                    $sortOrder = "`".$this->input->extract("sortDsc"). "` desc";
    
               }
          }

// The block count can also come from an external source
          //
          $recordCount = (defined("NAVLINK_REC_COUNT"))? NAVLINK_REC_COUNT:100;

// Which block of data are we looking at
          //
          if ( $this->input->extract($this->blockName) != "" ) {
               $startAt = intval( $this->input->extract($this->blockName) ) * $recordCount;
          }
          else{
               $startAt = 0; 
          }

$maxRecordCount = $this->dataObj->fetchMaxRecordCount();

$data = $this->dataObj->fetchBlock($startAt, $recordCount, $sortOrder, "stdClass");

if($maxRecordCount>240000){
               $code = array_keys($data);
          }
          else{
               $code = $this->dataObj->getListOfIdCodesFor($sortOrder);
          }

if($this->parentId !="" && $this->parentId == $_SESSION[SESS_TYPE]){
               $_SESSION[SESS_ALT_IDS] =$code;
               $_SESSION[SESS_ALT_TYPE]=$this->idField;
          }
          else{
               $_SESSION[SESS_IDS] = $code;
               $_SESSION[SESS_TYPE]= $this->idField;
               $_SESSION[SESS_ALT_IDS] ="";
               $_SESSION[SESS_ALT_TYPE]="";
          }

$navLink->setBlockSize( $recordCount );
          $navLink->setMaxPages( $maxRecordCount);

$navLink->setBaseUrl( $nUrl );

//$exObj = new usrXXXXXXXXXX( $this->pdo ); // XXXXXXXXXX to be replaced with class name of choice
          //Change the data to meet your needs
          //
          //foreach($data as $pos=>$info){
               //Example for 'Display'=>'flag:delete:'.$this->delCheckbox
               //Conditions available: $exObj->valueIsInUse("YYYYYYYYYY", $info->ZZZZZZZZZZ) //Where YYYYYYYYYY is the fields name and YYYYYYYYYY is the fields value
               //Conditions available:  
               //if($exObj->valueIsInUse("YYYYYYYYYY",$info->ZZZZZZZZZZ)){
                    // If there are two flags indicated in the initial statement make sure that you have the two flags
                    // You can flag as many coloumns as you need to meet your requirement
                    //$info->flag = 'false:false';// Change to false:true or true:false if the contitions for single-delete and multiple-delete are different
               //}
               //else{
                    //$info->flag = '';// If the flag is blank then the default of true is applied to all flags
               //}
               //Add styling if required
               //if($someCondition){
                    //$info->style = 'just the style needed for some condition';
               //}
               //else{
                    //$info->style = "";
               //}
               //$data[$pos] = $info;

//}

$navLinkBar = $navLink->getNavBar();

if(!$this->dataObj->isSearch()){
               unset($this->handle['arrows']);
          }

$panel = new dsDisplayPanel($data, $this->handle, $url, 'excId', $this->mode, $this->tableName."-".$this->listName);
          $panel->allowSort = $this->allowSort;

if($navLinkBar !=''){
               $form .= "<div class='navLink'>\n" . $navLinkBar . "</div>\n";
          }

$form .= "<form action='". strip_tags($_SERVER['PHP_SELF'])."' method='post' >";
          if($this->hasAccess('add')){
               $form .= "$nextCombo<input name='$this->mode'   type='submit' value='$this->addText' >";
          }
          if($this->hasAccess('delete-multiple') && isset($this->handle[$this->delCheckbox])){
               $form .= "<input name='submit' type='submit' value='Delete selected' >";
          }
          $form .= $panel->displayPanel();
          $form .= $this->combinedHiddens( ) ;
          $form .= "</form>";

if($navLinkBar !=''){
               $form .= "<div class='navLink'>\n" . $navLinkBar . "</div>\n";
          }
          return $form;
     }

/**
      *
      * Edit the main item currently selected from the list screen
      */
     function editMain( ) {

// Initialise the code
          $txt        = "";

$id         = $this->input->extract($this->idField);
          $mode       = $this->input->extract($this->mode);

$this->dataObj->rtv($id);
          if($this->dataObj->returnedNothing() && $mode!= $this->addText ){
               return $this->noAccess();
          }

$initialVars= $this->dataObj->loadDataSet();

$this->contentHeader = $this->editTitle;

$url        = $this->combinedUrl();

if($mode != ""){
    
               switch($mode){

case "confirm":
                         if($this->hasAccess('delete-single')){
                              $this->dataObj->delete();
                              $url->deleteParameter($this->mode);
                              $url->deleteParameter($this->idField);
                              header( "Location: " . $url->rtvUrl()."#panel" );
                              exit;
                         }
                         break;
                
                    case "delete":
                         $this->contentHeader = $this->deleteTitle;
                         break;
                        
                    case $this->addText:
                         $this->contentHeader = $this->addText;
                         break;
                                
                    default:
                         // Do nothing
                         break;
               }
          }
                                    
          $formMode   = ($mode == $this->addText)?"add":$mode;

$editForm = new wdzLibForm( $this->pdo, $this->editForm, $this->userProfile->getProfile(), $this->lang );
          if($editForm->failed()){
    
               return $editForm->displayErrors();

}

$editForm->setFormMode( $formMode );

// Change various variables like text that is in html format and simple arrays
          // Example array('fieldName'=>'html');
          $changeVars = array();
          $editForm->setChangeVars($changeVars);
          $vars = $editForm->fetchAllUrlData();

// Determine if an edit is occuring or an update to the database
          //
          if ( $editForm->wasSubmitted() || $vars['jsSubmit'] != '') {

if( $editForm->isAddMode() ){
        
                    //if( Some test on $vars['FIELD_NAME']){
            
                         //$fromTo = array( );
                         //$message = $editForm->message->rtvMessage('errorMsg', $this->editForm, '???', $this->lang);
            
                         //$errMsg  = ($message != "")?
                                   //$editForm->generateMessage( $message, $fromTo ):
                                   //$editForm->generateDefaultMessage('errorMsg', $this->editForm, '???', __LINE__);
            
                         //$editForm->logError($errMsg, 'FIELD_NAME');
            
                    //}
               }

if ( $editForm->hasValidated() ) {

$error = $this->dataObj->saveDataSet($vars);
    
                    if(count($error)>0){
                         foreach($error as $errMsg)
                              $editForm->logError($errMsg, "form", $this->editForm);
                    }
                    else{
                         $url = $this->combinedUrl();
                         if($vars['jsSubmit'] !=""){
                              // Override the url
                              //
                              $params = unserialize(base64_decode($vars['jsSubmit']));
                              $url->clearParameters();
                              foreach($params as $key=>$value){
                                   $url->addParameter($key, $value);
                              }
                         }
                         else{
                              if($editForm->isAddMode())
                                   $url->addParameter($this->idField, $this->dataObj->getExcId());
                              else
                                   $url->deleteParameter($this->idField);
                         }
                         $url->deleteParameter($this->mode);
                         header( "Location: " . $url->rtvUrl() );
                         exit;

} // End of no errors
               } // End of has validated
          } // End of was submitted

// Sort out additional initial variables
          if ( $editForm->isAddMode() ) {
               // $initialVars[] = "";
               $initialVars['excExuKey'] = ($this->SCHexcExuKey != null)?$this->SCHexcExuKey:$this->input->extract('SCHexcExuKey');
               $initialVars['excExpProductId'] = ($this->SCHexcExpProductId != null)?$this->SCHexcExpProductId:$this->input->extract('SCHexcExpProductId');

}

// Sort out the free text variables
          //
          // $initialVars[] = "";

foreach ( $this->hiddens as $val ){
               $editForm->addHiddenField( $val, $vars[$val] );
          }
                  
          foreach ( $this->searches as $val ){
               $value = ($this->$val != null)?$this->$val:$vars[$val];
               $editForm->addHiddenField( $val, $value );
          }

$mode = ($mode=="delete")?"confirm":$this->input->extract($this->mode);
          $editForm->addHiddenField( $this->mode, $mode );
          $editForm->addHiddenField( 'jsSubmit', '' );

$editAccess = $this->hasAccess('edit');
          $txt .= $editForm->displayForm($initialVars, $editAccess);

return $txt;

}

/**
      *
      * Displays information
      */
     function displayMain( ) {
    
          // Initialise the code
          $txt        = "";

$initialVars= $this->dataObj->loadDataSet();

$this->contentHeader = $this->reportTitle;

$report = new wdzLibReport( $this->pdo, $this->reportForm, $this->userProfile->getProfile(), $this->lang );
          if($report->failed()){
    
               return $report->displayErrors();

}

// Sort out the free text variables
          //
          // $initialVars[] = "";

$txt .= $report->displayReport($initialVars);

return $txt;

}

/**
      *
      * Switches between the main screens
      */
     function editItem(){

$mode       = $this->input->extract($this->mode);
          if($mode != ""){
               return $this->editMain();
          }

$id         = $this->input->extract($this->idField);
          $this->dataObj->rtv($id);
          if($this->dataObj->returnedNothing()){
               return $this->noAccess();
          }

$display    = $this->input->extract("display");

$url        = $this->combinedUrl();
          $count      = 0;
          $formDisp   = $formName = $childIdNm = "";
          $arr        = array();
          if($this->hasAccess('edit')){
               $arr["Main Information"] = array("function"=>"editMain", "form"=>$this->editForm);
          }
          else{
               $arr["Main Information"] = "editMain";
          }
          if($this->hasAccess('panel', 'pnlExDialogue')){
               if($this->hasAccess('edit', 'pnlExDialogue')){
                    $arr['Edit Dialogue']= array('function'=>'editExDialogue', 'form'=>'frmExDialogue', 'childId'=>'exdId');
               }
               else{
                    $arr['Edit Dialogue']= 'editExDialogue';
               }
          }

$arr["View Comment"]="displayMain";
          $txt        = "<div id='tabArea'>\n";
          $txt       .= "<ul class='tabMenu'>\n";

foreach($arr as $name=>$information){

$childId = $form = "";

if(is_array($information)){
                    $function = (isset($information['function']))? $information['function']:"";
                    $form     = (isset($information['form']))?$information['form']:"";
                    if(isset($information['childId']) && $information['childId'] !='')
                         $childId   = $information['childId'];

}
               else{
                    $function = $information;
               }

$strippedName = strip_tags($name);

$url->addParameter("display", $strippedName );
 		 
               $currentTab = ($display == $strippedName || ($display == "" && $count == 0) );
 		 
               $class  = ($currentTab)?"tabA currentA":"tabA";
	 
               $txt   .= "<li><a href='".$url->rtvAmpUrl()."' class='$class'>$name</a></li>\n";

$formDisp.= ($currentTab && $function != "")?$this->$function():"";
               $formName.= ($currentTab)?$form:"";
               $childIdNm.= ($currentTab)?$childId:"";

$count++;

}
     	
          $url->deleteParameter("display");
          $url->deleteParameter($this->idField);
          $txt.= "<li><a href='".$url->rtvAmpUrl()."' class='tabA'>Exit</a></li>\n";
          $txt.= "</ul>\n";
          $txt.= "</div>\n";
          $txt.= "<div class='formDiv'>\n";
          $url->addParameter("display", $display);
          $submit = ($formName != "")?"onclick=\"document.getElementById('jsSubmit').value='XXXXX'; myForm = document.getElementById('$formName').submit(); return false;\"":"";
          $childIdValue = ($childIdNm != "")?$this->input->extract($childIdNm):"";
          $txt.= displayThread($url, $this->idField, $id, $submit, $childIdNm, $childIdValue, $this->hasAccess('edit'));

$txt.= $formDisp;
          $txt.= "</div>\n";
     
          return $txt;
     
     }

/**
      *
      * Edit the child Dialogue
      *
      * @return string
      */
     function editExDialogue(){

$txt = '';

$pnl = new pnlExDialogue($this->pdo, $this->userProfile, $this->lang );
          $pnl->SCHexdExcKey= $this->dataObj->getExcKey();
          $pnl->searchForm = '';
          $pnl->parentId   = $this->idField;
          $childId = $this->input->extract($pnl->idField);
          if($childId != ''){
               // Check that the user has access
               //
               $pnl->dataObj->initialiseDataDef();
               $pnl->dataObj->addDataDef('exdExcKey', '=', $this->dataObj->getExcKey());
               $pnl->dataObj->prepareData('and', 'and');
               $code = $pnl->dataObj->getListOfIdCodesFor($pnl->sortOrder);

if(array_search($childId, $code)!==false){
                    $txt.= $pnl->editMain();
               }
               else{
                    $txt.= $this->noAccess();
               }
          }
          else{
               $txt.= $pnl->getContent();
          }
          if($pnl->contentHeader !=''){
               $this->contentHeader = $pnl->contentHeader;
          }

return $txt;

}

SQL:-
Copy - Quick copy

-- --------------------------------------------------------

--
-- Table structure for table `exComment`
--

CREATE TABLE `exComment` (
     `excId` int(11) NOT NULL COMMENT 'Primary Id',
     `excExuKey` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Parent Key',
     `excExpProductId` int(11) NOT NULL DEFAULT '0' COMMENT 'External Id',
     `excKey` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Parent Key',
     `excComment` text COLLATE utf8_unicode_ci COMMENT 'Comment',
     `excIcons` text COLLATE utf8_unicode_ci COMMENT 'Icons',
     `excStars` int(11) NOT NULL DEFAULT '0',
     `excSpare1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Spare field',
     `excSpare2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Spare field',
     `excSpare3` text COLLATE utf8_unicode_ci COMMENT 'Spare field',
     `excTs` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Comments';

--
-- Indexes for table `exComment`
--

ALTER TABLE `exComment`
     ADD PRIMARY KEY (`excId`),
     ADD KEY `excExuKey` (`excExuKey`, `excId`),
     ADD KEY `excExpProductId` (`excExpProductId`, `excId`),
     ADD UNIQUE KEY `excKey` (`excKey`),
     ADD KEY `excOrder` (`excExuKey`, `excExpProductId`);

--
-- AUTO_INCREMENT for table `exComment`
--

ALTER TABLE `exComment`
MODIFY `excId` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Id';

-- --------------------------------------------------------

--
-- List display for table `exComment`
--

DELETE FROM `wdzHandle` where `whdWpjKey`='Web-D-ZineE' and `whdMajor`='exComment' and `whdMinor`='list';
INSERT INTO `wdzHandle` (`whdId`, `whdWpjKey`, `whdMajor`, `whdMinor`, `whdSequence`, `whdCode`, `whdName`, `whdHdrTitle`, `whdInUse`, `whdSort`, `whdDisplay`, `whdTitle`, `whdCssClass`, `whdIcon`, `whdParameter`, `whdSpare1`, `whdSpare2`, `whdSpare3`) VALUES 
(NULL, 'Web-D-ZineE', 'exComment', 'list', '0', 'excId', 'Edit', 'The Primary Id is used in back end systems to retrieve the record', 'Yes', 'No', 'key', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '5', 'excExuKey', 'Key', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '10', 'excExpProductId', 'Product Id', 'External Id by which a record can be retrieved but not edited', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '15', 'excKey', 'Key(11)', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '20', 'excComment', 'Comment', 'Comment', 'Yes', 'No', 'limit_40_more', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '25', 'excIcons', 'Icons', 'Icons such as heart etc.', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '30', 'excStars', 'Stars', 'Looks after the number of starts a comment has', 'Yes', 'No', 'stars_5', '', 'titleCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '35', 'excSpare1', 'Spare 1', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '40', 'excSpare2', 'Spare 2', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'list', '45', 'excSpare3', 'Spare 3', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Deletion display for table `exComment`
--

DELETE FROM `wdzHandle` where `whdWpjKey`='Web-D-ZineE' and `whdMajor`='exComment' and `whdMinor`='delete';
INSERT INTO `wdzHandle` (`whdId`, `whdWpjKey`, `whdMajor`, `whdMinor`, `whdSequence`, `whdCode`, `whdName`, `whdHdrTitle`, `whdInUse`, `whdSort`, `whdDisplay`, `whdTitle`, `whdCssClass`, `whdIcon`, `whdParameter`, `whdSpare1`, `whdSpare2`, `whdSpare3`) VALUES 
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '0', 'excId', 'Id', 'The Primary Id is used in back end systems to retrieve the record', 'Yes', 'No', '', '', 'iconCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '5', 'excExuKey', 'Key', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '10', 'excExpProductId', 'Product Id', 'External Id by which a record can be retrieved but not edited', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '15', 'excKey', 'Key(11)', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '20', 'excComment', 'Comment', 'Comment', 'Yes', 'No', 'limit_40_more', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '25', 'excIcons', 'Icons', 'Icons such as heart etc.', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '30', 'excStars', 'Stars', 'Looks after the number of starts a comment has', 'Yes', 'No', 'stars_5', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '35', 'excSpare1', 'Spare 1', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '40', 'excSpare2', 'Spare 2', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exComment', 'delete', '45', 'excSpare3', 'Spare 3', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Search form for `exComment`
--

delete from `wdzForm` where `wfmWpjKey`='Web-D-ZineE' and `wfmFormName`='schExComment';
delete from `wdzFormField` where `wffWpjKey`='Web-D-ZineE' and `wffWfmFormName`='schExComment';

INSERT INTO `wdzForm` (`wfmId`, `wfmWpjKey`, `wfmFormName`, `wfmDescription`, `wfmLang`, `wfmMethod`, `wfmUpload`, `wfmAction`, `wfmAnchor`, `wfmButtonName`, `wfmLocation`, `wfmAutocomplete`, `wfmCssClass`, `wfmAttributes`, `wfmEventAttributes`, `wfmExport`, `wfmSpare1`, `wfmSpare2`, `wfmSpare3`) VALUES
(null, 'Web-D-ZineE', 'schExComment', '1st form format for schExComment', 'en', 'post', 'No', '', 'No', 'submit', 'back', '', '', '', '', 'Yes', '', '', '');

-- --------------------------------------------------------

--
-- Main form for `exComment`
--

delete from `wdzForm` where `wfmWpjKey`='Web-D-ZineE' and `wfmFormName`='frmExComment';
delete from `wdzFormField` where `wffWpjKey`='Web-D-ZineE' and `wffWfmFormName`='frmExComment';

INSERT INTO `wdzForm` (`wfmId`, `wfmWpjKey`, `wfmFormName`, `wfmDescription`, `wfmLang`, `wfmMethod`, `wfmUpload`, `wfmAction`, `wfmAnchor`, `wfmButtonName`, `wfmLocation`, `wfmAutocomplete`, `wfmCssClass`, `wfmAttributes`, `wfmEventAttributes`, `wfmExport`, `wfmSpare1`, `wfmSpare2`, `wfmSpare3`) VALUES
(null, 'Web-D-ZineE', 'frmExComment', '1st form format for frmExComment', 'en', 'post', 'No', '', 'No', 'submit', 'back', '', '', '', '', 'Yes', '', '', '');

INSERT INTO `wdzFormField` (`wffId`, `wffWpjKey`, `wffWfmFormName`, `wffFieldName`, `wffInUse`, `wffSequence`, `wffDivClass`, `wffLabel`, `wffLabelClass`, `wffType`, `wffExtra`, `wffCssClass`, `wffRequired`, `wffReadOnly`, `wffValidation`, `wffValidationExtra`, `wffErrorMsg`, `wffAttributes`, `wffEventAttributes`, `wffInformation`, `wffAddBlock`, `wffAccess`, `wffSpare1`, `wffSpare2`, `wffSpare3`) VALUES
(null, 'Web-D-ZineE', 'frmExComment', 'excId', 'Yes', '0', 'firstCol', 'Primary Id', '', 'hidden', '', '', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excExuKey', 'Yes', '5', 'firstCol', 'Key', '', 'text', '', '', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excExpProductId', 'Yes', '10', 'firstCol', 'Product Id', '', 'text', '', '', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excKey', 'Yes', '15', 'firstCol', 'Key(11)', '', 'text', '', '', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excComment', 'Yes', '20', 'firstCol', 'Comment', '', 'textarea', '', 'mceEditor', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excIcons', 'Yes', '25', 'firstCol', 'Icons', '', 'textarea', '', 'mceEditor', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excStars', 'Yes', '30', 'firstCol', 'Stars', '', 'number', '', '', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excSpare1', 'No', '35', 'firstCol', 'Spare 1', '', 'text', '', '', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excSpare2', 'No', '40', 'firstCol', 'Spare 2', '', 'text', '', '', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'excSpare3', 'No', '45', 'firstCol', 'Spare 3', '', 'textarea', '', 'mceEditor', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExComment', 'submit', 'Yes', '50', 'buttonDiv', 'Edit', 'labelSpace', 'submit', 'Add=Add; Del=Confirm Delete;', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Main report for `exComment`
--

delete from `wdzForm` where `wfmWpjKey`='Web-D-ZineE' and `wfmFormName`='rptExComment';
delete from `wdzFormField` where `wffWpjKey`='Web-D-ZineE' and `wffWfmFormName`='rptExComment';

INSERT INTO `wdzForm` (`wfmId`, `wfmWpjKey`, `wfmFormName`, `wfmDescription`, `wfmLang`, `wfmMethod`, `wfmUpload`, `wfmAction`, `wfmAnchor`, `wfmButtonName`, `wfmLocation`, `wfmAutocomplete`, `wfmCssClass`, `wfmAttributes`, `wfmEventAttributes`, `wfmExport`, `wfmSpare1`, `wfmSpare2`, `wfmSpare3`) VALUES
(null, 'Web-D-ZineE', 'rptExComment', '1st form format for rptExComment', 'en', 'post', 'No', '', 'No', 'submit', 'back', '', '', '', '', 'Yes', '', '', '');

INSERT INTO `wdzFormField` (`wffId`, `wffWpjKey`, `wffWfmFormName`, `wffFieldName`, `wffInUse`, `wffSequence`, `wffDivClass`, `wffLabel`, `wffLabelClass`, `wffType`, `wffExtra`, `wffCssClass`, `wffRequired`, `wffReadOnly`, `wffValidation`, `wffValidationExtra`, `wffErrorMsg`, `wffAttributes`, `wffEventAttributes`, `wffInformation`, `wffAddBlock`, `wffAccess`, `wffSpare1`, `wffSpare2`, `wffSpare3`) VALUES
(null, 'Web-D-ZineE', 'rptExComment', 'excId', 'No',                '0', 'firstCol', 'Primary Id', '', '',           '', 'normalText', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excExuKey', 'Yes', '5', 'firstCol', 'Key', '', 'text', '', 'normalText', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excExpProductId', 'Yes', '10', 'firstCol', 'Product Id', '', 'text', '', 'normalText', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excKey', 'Yes', '15', 'firstCol', 'Key(11)', '', 'text', '', 'normalText', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excComment', 'Yes', '20', 'firstCol', 'Comment', '', 'textarea', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excIcons', 'Yes', '25', 'firstCol', 'Icons', '', 'textarea', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excStars', 'Yes', '30', 'firstCol', 'Stars', '', 'number', '', 'normalText', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excSpare1', 'No', '35', 'firstCol', 'Spare 1', '', 'text', '', 'normalText', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excSpare2', 'No', '40', 'firstCol', 'Spare 2', '', 'text', '', 'normalText', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExComment', 'excSpare3', 'No', '45', 'firstCol', 'Spare 3', '', 'textarea', '', 'normalText', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', '');

Minor Change

The only minor change between the code produced and what you see here, is that the edit facilities have been used to modify the lists

Press the Go WDZ Button

Code and sql for Comment

Class:- exComment.phpCopy - Quick copy

User class:- usrExComment.phpCopy - Quick copy

Panel:- pnlExComment.phpCopy - Quick copy

SQL:- Copy - Quick copy

Minor Change

Class:- exComment.php
Copy - Quick copy

User class:- usrExComment.php
Copy - Quick copy

Panel:- pnlExComment.php
Copy - Quick copy

SQL:-
Copy - Quick copy