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 Address

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

Class:- exAddress.php
Copy - Quick copy

<?php
/**
 * Address - exAddress.php 
 * 
 * Account or delivery address for the user
 * 
 * 
 * DO NOT EDIT THIS CLASS. MAKE CHANGES TO usrExAddress.php INSTEAD
 * IF YOU NEED EXTRA FIELDS REGENERATE exAddress.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
 * usrWdzEncrypt.php - Empty Encryption class which extends wdzEncrypt so that you can 
 * dsEncryptInfo.php - This stores all the data needed for the encryption class
 * 
 * @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 'exAddress'
 */
class exAddress extends wdz3BaseClass {

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

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

/**
      * Address Line 1
      *
      * Address - Line 1(Encrypted)
      * @var string
      */
     protected $exaAddress1;

/**
      * Address Line 2
      *
      * Address - Line 2(Encrypted for security)
      * @var string
      */
     protected $exaAddress2;

/**
      * Address Line 3
      *
      * Address - Line 3
      * @var string
      */
     protected $exaAddress3;

/**
      * Address Line 4
      *
      * Address - Line 4
      * @var string
      */
     protected $exaAddress4;

/**
      * Address Line 5
      *
      * Address - Line 5
      * @var string
      */
     protected $exaAddress5;

/**
      * Postcode
      *
      * Address - Postcode
      * @var string
      */
     protected $exaPostCode;

/**
      * Country
      *
      * Country
      * @var string
      */
     protected $exaCountry;

/**
      * Account Address
      *
      * Simple flag to identify an account address
      * @var string
      */
     protected $exaAccAddress;

/**
      * Date
      *
      * Date of last use
      * @var string
      */
     protected $exaDate;

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

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

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

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

/**
      * Encryption
      * Encrypts data
      * @var object
      */
      public $encryption;

// ----- 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 exaId - Primary Id
      */
     function getExaId() {
          return $this->exaId;
     }

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

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

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

/**
      * Get Address Line 1
      *
      * @return string exaAddress1
      */
     function getExaAddress1() {
          return $this->encryption->decrypt($this->exaAddress1);
     }

/**
      * Set Address Line 1
      *
      * @param string $p
      */
     function setExaAddress1( $p ) { 
          $this->exaAddress1 = $this->encryption->encrypt($p);
     }

/**
      * Get Address Line 2
      *
      * @return string exaAddress2
      */
     function getExaAddress2() {
          return $this->encryption->decrypt($this->exaAddress2);
     }

/**
      * Set Address Line 2
      *
      * @param string $p
      */
     function setExaAddress2( $p ) { 
          $this->exaAddress2 = $this->encryption->encrypt($p);
     }

/**
      * Get Address Line 3
      *
      * Address - Line 3
      *
      * @return string exaAddress3 - Address Line 3
      */
     function getExaAddress3() {
          return $this->exaAddress3;
     }

/**
      * Set Address Line 3
      *
      * Address - Line 3
      *
      * @param string $p - Address Line 3
      */
     function setExaAddress3( $p ) { 
          $this->exaAddress3 = $p;
     }

/**
      * Get Address Line 4
      *
      * Address - Line 4
      *
      * @return string exaAddress4 - Address Line 4
      */
     function getExaAddress4() {
          return $this->exaAddress4;
     }

/**
      * Set Address Line 4
      *
      * Address - Line 4
      *
      * @param string $p - Address Line 4
      */
     function setExaAddress4( $p ) { 
          $this->exaAddress4 = $p;
     }

/**
      * Get Address Line 5
      *
      * Address - Line 5
      *
      * @return string exaAddress5 - Address Line 5
      */
     function getExaAddress5() {
          return $this->exaAddress5;
     }

/**
      * Set Address Line 5
      *
      * Address - Line 5
      *
      * @param string $p - Address Line 5
      */
     function setExaAddress5( $p ) { 
          $this->exaAddress5 = $p;
     }

/**
      * Get Postcode
      *
      * Address - Postcode
      *
      * @return string exaPostCode - Postcode
      */
     function getExaPostCode() {
          return $this->exaPostCode;
     }

/**
      * Set Postcode
      *
      * Address - Postcode
      *
      * @param string $p - Postcode
      */
     function setExaPostCode( $p ) { 
          $this->exaPostCode = $p;
     }

/**
      * Get Country
      *
      * Country
      *
      * @return string exaCountry - Country
      */
     function getExaCountry() {
          return $this->exaCountry;
     }

/**
      * Set Country
      *
      * Country
      *
      * @param string $p - Country
      */
     function setExaCountry( $p ) { 
          $this->exaCountry = $p;
     }

/**
      * Get Account Address
      *
      * Simple flag to identify an account address
      *
      * @return string exaAccAddress - Account Address
      */
     function getExaAccAddress() {
          return $this->exaAccAddress;
     }

/**
      * Set Account Address
      *
      * Simple flag to identify an account address
      *
      * @param string $p - Account Address
      */
     function setExaAccAddress( $p ) { 
          $this->exaAccAddress = (strtolower($p) == "yes") ? "Yes" : "No";
     }

/**
      * Is Account Address
      *
      * @return boolean
      */
     function isExaAccAddress() {
          return (strtolower($this->exaAccAddress) == "yes")? true : false;
     }

/**
      * Get Date
      *
      * Date of last use
      *
      * @return string exaDate - Date
      */
     function getExaDate() {
          return $this->exaDate;
     }

/**
      * Set Date
      *
      * Date of last use
      *
      * @param string $p - Date
      */
     function setExaDate( $p ) { 
          $this->exaDate = $p;
     }

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

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

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

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

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

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

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

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

/**
      * Initialise the properties to default values
      */
     function initialise() {
    
          $this->exaId          = null;
          $this->exaExuKey      = '';
          $this->exaAddress1    = '';
          $this->exaAddress2    = '';
          $this->exaAddress3    = '';
          $this->exaAddress4    = '';
          $this->exaAddress5    = '';
          $this->exaPostCode    = '';
          $this->exaCountry     = '-1';
          $this->exaAccAddress  = 'No';
          $this->exaDate        = date('Y-m-d');
          $this->exaSpare1      = '';
          $this->exaSpare2      = '';
          $this->exaSpare3      = '';
          $dsEncryptInfo        = new dsEncryptInfo("exAddress");
          $this->encryption     = new usrWdzEncrypt($dsEncryptInfo);

}

/**
      * Check if a record with the primary key exists
      * @return TRUE if there is a record, else false
      */
     function exists() { 
          $sql = "SELECT 1 FROM `exAddress` WHERE `exaId` = :exaId";
          $stmt = $this->pdo->prepare( $sql );
          $data = [ 'exaId' => $this->exaId ];
          $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->exaId = $id;
          }

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

$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->exaId = $id;
               }
          }
     }

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

$sql = "UPDATE `exAddress`
                    SET
                    `exaId`         = :exaId,
                    `exaExuKey`     = :exaExuKey,
                    `exaAddress1`   = :exaAddress1,
                    `exaAddress2`   = :exaAddress2,
                    `exaAddress3`   = :exaAddress3,
                    `exaAddress4`   = :exaAddress4,
                    `exaAddress5`   = :exaAddress5,
                    `exaPostCode`   = :exaPostCode,
                    `exaCountry`    = :exaCountry,
                    `exaAccAddress` = :exaAccAddress,
                    `exaDate`       = :exaDate,
                    `exaSpare1`     = :exaSpare1,
                    `exaSpare2`     = :exaSpare2,
                    `exaSpare3`     = :exaSpare3
                    WHERE `exaId` = :exaId";

$data = [ 
                    'exaId'          => $this->exaId,
                    'exaExuKey'      => $this->exaExuKey,
                    'exaAddress1'    => $this->exaAddress1,
                    'exaAddress2'    => $this->exaAddress2,
                    'exaAddress3'    => $this->exaAddress3,
                    'exaAddress4'    => $this->exaAddress4,
                    'exaAddress5'    => $this->exaAddress5,
                    'exaPostCode'    => $this->exaPostCode,
                    'exaCountry'     => $this->exaCountry,
                    'exaAccAddress'  => $this->exaAccAddress,
                    'exaDate'        => $this->exaDate,
                    'exaSpare1'      => $this->exaSpare1,
                    'exaSpare2'      => $this->exaSpare2,
                    'exaSpare3'      => $this->exaSpare3
                  ];

$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 `exAddress` (
                    `exaExuKey`,
                    `exaAddress1`,
                    `exaAddress2`,
                    `exaAddress3`,
                    `exaAddress4`,
                    `exaAddress5`,
                    `exaPostCode`,
                    `exaCountry`,
                    `exaAccAddress`,
                    `exaDate`,
                    `exaSpare1`,
                    `exaSpare2`,
                    `exaSpare3`
               ) VALUES (
                    :exaExuKey,
                    :exaAddress1,
                    :exaAddress2,
                    :exaAddress3,
                    :exaAddress4,
                    :exaAddress5,
                    :exaPostCode,
                    :exaCountry,
                    :exaAccAddress,
                    :exaDate,
                    :exaSpare1,
                    :exaSpare2,
                    :exaSpare3
               );";
    
          $this->insertStatement = $this->pdo->prepare( $sql );
     }

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

$data = [ 
                    'exaExuKey'      => $this->exaExuKey,
                    'exaAddress1'    => $this->exaAddress1,
                    'exaAddress2'    => $this->exaAddress2,
                    'exaAddress3'    => $this->exaAddress3,
                    'exaAddress4'    => $this->exaAddress4,
                    'exaAddress5'    => $this->exaAddress5,
                    'exaPostCode'    => $this->exaPostCode,
                    'exaCountry'     => $this->exaCountry,
                    'exaAccAddress'  => $this->exaAccAddress,
                    'exaDate'        => $this->exaDate,
                    'exaSpare1'      => $this->exaSpare1,
                    'exaSpare2'      => $this->exaSpare2,
                    'exaSpare3'      => $this->exaSpare3
                  ];

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

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

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

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

$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( `exaId` ) as `recordCount` FROM `exAddress` where $this->whereClause ;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT count( `exaId` ) as `recordCount` FROM `exAddress`;";
               $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 `exaDate`";
    
          // Construct the SQL and prepare the data
          //
          if($this->whereClause != "" && count($this->data)>0){
               $sql = "SELECT `exaId` FROM `exAddress` where $this->whereClause$sortClause;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT `exaId` FROM `exAddress`$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['exaId'];
               }
          }

// 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 `exaDate`";
    
          if($this->whereClause != "" && count($this->data)>0){
               $sql = "SELECT  `exaId` FROM `exAddress` where $this->whereClause$sortClause limit $s, $rc;";
               $data = $this->data;
          }
          else{
               $sql = "SELECT  `exaId` FROM `exAddress`$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 `exAddress` where `exaId`=:exaId;";  
               $miniStmt = $this->pdo->prepare( $miniSql );

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

foreach($results as $miniData){

$miniStmt->execute($miniData);
                    $newResults[$miniData['exaId']] = $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 `exAddress` WHERE `exaId` = :exaId;";
    
          $stmt = $this->pdo->prepare( $sql );
    
          if($className == "stdClass"){
               $stmt->setFetchMode( PDO::FETCH_CLASS, $className );
          }
          else{
               $stmt->setFetchMode( PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, "usrExAddress", array( $this->pdo ));
          }

if(is_array($idArr)){
               foreach($idArr as $id ){
                    
                    $data = [ 'exaId' => $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 `exaId` FROM `exAddress` 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 'exaExuKey'
      * 
      * @param string $exaExuKey - 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 rtvByExaExuKey( $exaExuKey, $className='' ) {

// Construct the SQL and prepare the data
          //
          $sql = "SELECT * FROM `exAddress` 
                    WHERE `exaExuKey` = :exaExuKey
                    ORDER BY `exaDate`, `exaId`;";

$data = [ 'exaExuKey' => $exaExuKey ];
          $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, 'usrExAddress', 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;
     }

/**
      * Toggles exaAccAddress - Account Address
      */
     function toggleExaAccAddress(){

$newVal = ($this->isExaAccAddress())?"No":"Yes";
         $this->setExaAccAddress($newVal);
         $this->update();

}

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

$vars = array();

$vars['exaId']          = $this->getExaId();
          $vars['exaExuKey']      = $this->getExaExuKey();
          $vars['exaAddress1']    = $this->getExaAddress1();
          $vars['exaAddress2']    = $this->getExaAddress2();
          $vars['exaAddress3']    = $this->getExaAddress3();
          $vars['exaAddress4']    = $this->getExaAddress4();
          $vars['exaAddress5']    = $this->getExaAddress5();
          $vars['exaPostCode']    = $this->getExaPostCode();
          $vars['exaCountry']     = $this->getExaCountry();
          $vars['exaAccAddress']  = $this->getExaAccAddress();
          $vars['exaDate']        = $this->getExaDate();
          $vars['exaSpare1']      = $this->getExaSpare1();
          $vars['exaSpare2']      = $this->getExaSpare2();
          $vars['exaSpare3']      = $this->getExaSpare3();
          $vars['exaTs']          = $this->getExaTs();

return $vars;

}

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

$errors = array();

if(isset($vars['exaId'])){
               $this->setExaId(html_entity_decode($vars['exaId'], ENT_QUOTES));
          }
          if(isset($vars['exaExuKey'])){
               $this->setExaExuKey(html_entity_decode($vars['exaExuKey'], ENT_QUOTES));
          }
          if(isset($vars['exaAddress1'])){
               $this->setExaAddress1(html_entity_decode($vars['exaAddress1'], ENT_QUOTES));
          }
          if(isset($vars['exaAddress2'])){
               $this->setExaAddress2(html_entity_decode($vars['exaAddress2'], ENT_QUOTES));
          }
          if(isset($vars['exaAddress3'])){
               $this->setExaAddress3(html_entity_decode($vars['exaAddress3'], ENT_QUOTES));
          }
          if(isset($vars['exaAddress4'])){
               $this->setExaAddress4(html_entity_decode($vars['exaAddress4'], ENT_QUOTES));
          }
          if(isset($vars['exaAddress5'])){
               $this->setExaAddress5(html_entity_decode($vars['exaAddress5'], ENT_QUOTES));
          }
          if(isset($vars['exaPostCode'])){
               $this->setExaPostCode(html_entity_decode($vars['exaPostCode'], ENT_QUOTES));
          }
          if(isset($vars['exaCountry'])){
               $this->setExaCountry(html_entity_decode($vars['exaCountry'], ENT_QUOTES));
          }
          if(isset($vars['exaAccAddress'])){
               $this->setExaAccAddress(html_entity_decode($vars['exaAccAddress'], ENT_QUOTES));
          }
          if(isset($vars['exaDate'])){
               $this->setExaDate(html_entity_decode($vars['exaDate'], ENT_QUOTES));
          }
          if(isset($vars['exaSpare1'])){
               $this->setExaSpare1(html_entity_decode($vars['exaSpare1'], ENT_QUOTES));
          }
          if(isset($vars['exaSpare2'])){
               $this->setExaSpare2(html_entity_decode($vars['exaSpare2'], ENT_QUOTES));
          }
          if(isset($vars['exaSpare3'])){
               $this->setExaSpare3(html_entity_decode($vars['exaSpare3'], ENT_QUOTES));
          }

$this->chgCrt();

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

return $errors;

}

User class:- usrExAddress.php
Copy - Quick copy

<?php
/**
 * User class for Address - usrExAddress.php 
 *
 * Desc: Account or delivery address for the user
 *
 * @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
 * exAddress.php - Class for Address
 * usrWdzEncrypt.php - Empty Encryption class which extends wdzEncrypt so that you can 
 * dsEncryptInfo.php - This stores all the data needed for the encryption class
 * 
 * 
 * IF YOU NEED EXTRA FIELDS REGENERATE exAddress.php at {@link https://web-d-zine.co.uk/ https://web-d-zine.co.uk/}
 * 
 *
 * Manage data for SQL table 'exAddress'
 */
class usrExAddress extends exAddress {
    
     /* ----- Property summary ------------------
      * exaId         int        Primary Id
      * exaExuKey     string     Key
      * exaAddress1   string     Address Line 1
      * exaAddress2   string     Address Line 2
      * exaAddress3   string     Address Line 3
      * exaAddress4   string     Address Line 4
      * exaAddress5   string     Address Line 5
      * exaPostCode   string     Postcode
      * exaCountry    string     Country
      * exaAccAddress string     Account Address
      * exaDate       string     Date
      * exaSpare1     string     Spare 1
      * exaSpare2     string     Spare 2
      * exaSpare3     string     Spare 3
      * exaTs         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:- pnlExAddress.php
Copy - Quick copy

<?php
/**
 * Panel for Address - pnlExAddress.php
 *
 * Desc: Account or delivery address for the user
 * 
 * @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
 * exAddress.php - Class for Address
 * usrHandle.php - Looks after how the data is handled
 * wdzInput.php - Extracts data from $_GET and $_POST
 * wdzAbstractPanel.php - Stores data about the panel
 * usrWdzEncrypt.php - Empty Encryption class which extends wdzEncrypt so that you can 
 * dsEncryptInfo.php - This stores all the data needed for the encryption class
 * 
 */
/**
 * Display data for SQL table 'exAddress'
 */
class pnlExAddress extends wdzAbstractPanel {

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

/**
      * The contructor for pnlExAddress
      *
      * @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", "exaId", "display", "exuId" );
          $this->searches      = array('SCHexaExuKey', 'SCHexaPostCode');
          $this->operations    = array("=", "=");

$this->idField       = "exaId";
          $this->editForm      = "frmExAddress";
          $this->reportForm    = "rptExAddress";
          $this->searchForm    = "schExAddress";

$this->deleteTitle   = "Address deletion";
          $this->listTitle     = "Managing Addresss";
          $this->editTitle     = "Editing Address";
          $this->reportTitle   = "Address";
          $this->addText       = "Add a new Address";
          
          $this->sortOrder     = "`exaDate`";
          $this->blockName     = "exaCb";
          $this->delCheckbox   = "exaDel";
          $this->mode          = "exaMode";
          $this->parentId      = "";
          $this->anchor        = "pnlExAddress";
          $this->project       = "Web-D-ZineE";

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

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

// Sort out the handles
          //
          $this->tableName     = 'exAddress';
          $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: $this->is($info->exaAccAddress) 
               //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;
               $info->exaAddress1    = $this->dataObj->encryption->decrypt($info->exaAddress1);
               $info->exaAddress2    = $this->dataObj->encryption->decrypt($info->exaAddress2);

}

$navLinkBar = $navLink->getNavBar();

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

$panel = new dsDisplayPanel($data, $this->handle, $url, 'exaId', $this->mode, $this->tableName."-".$this->listName);
          $panel->allowSort = $this->allowSort;
          $panel->convert('exaCountry', $category->keyValue('COUNTRY'));
          $panel->convert('exaAccAddress', $category->keyValue('NO_YES'));

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 "toggle":
                         $fieldName = ucFirst($this->input->extract("field"));
                         if($this->hasAccess("edit") && array_search($fieldName, array("ExaAccAddress"))!==false){
                              $function = "toggle".$fieldName;
                              $this->dataObj->$function();
                              $url->deleteParameter($this->mode);
                              $url->deleteParameter("field");
                              $url->deleteParameter($this->idField);
                              header( "Location: " . $url->rtvUrl()."#panel" );
                              exit;
                         }
                         break;

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->getExaId());
                              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['exaExuKey'] = ($this->SCHexaExuKey != null)?$this->SCHexaExuKey:$this->input->extract('SCHexaExuKey');

}

// 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";
          }

$arr["View Address"]="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;
     
     }

}

SQL:-
Copy - Quick copy

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

--
-- Table structure for table `exAddress`
--

CREATE TABLE `exAddress` (
     `exaId` int(11) NOT NULL COMMENT 'Primary Id',
     `exaExuKey` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Parent Key',
     `exaAddress1` text COLLATE utf8_unicode_ci COMMENT 'Line 1',
     `exaAddress2` text COLLATE utf8_unicode_ci COMMENT 'Address 2',
     `exaAddress3` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Line 3',
     `exaAddress4` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Address 4',
     `exaAddress5` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Address 5',
     `exaPostCode` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'post code',
     `exaCountry` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-1',
     `exaAccAddress` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No' COMMENT 'Flag',
     `exaDate` date COLLATE utf8_unicode_ci NOT NULL,
     `exaSpare1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Spare field',
     `exaSpare2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Spare field',
     `exaSpare3` text COLLATE utf8_unicode_ci COMMENT 'Spare field',
     `exaTs` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Address';

--
-- Indexes for table `exAddress`
--

ALTER TABLE `exAddress`
     ADD PRIMARY KEY (`exaId`),
     ADD KEY `exaExuKey` (`exaExuKey`, `exaId`),
     ADD KEY `exaPostCode` (`exaPostCode`, `exaId`),
     ADD KEY `exaSort` (`exaDate`),
     ADD KEY `exaOrder` (`exaExuKey`);

--
-- AUTO_INCREMENT for table `exAddress`
--

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

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

--
-- List display for table `exAddress`
--

DELETE FROM `wdzHandle` where `whdWpjKey`='Web-D-ZineE' and `whdMajor`='exAddress' 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', 'exAddress', 'list', '0', 'exaId', 'Edit', 'The Primary Id is used in back end systems to retrieve the record', 'Yes', 'No', 'key', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '5', 'exaExuKey', 'Key', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '10', 'exaAddress1', 'Address Line 1', 'Address - Line 1(Encrypted)', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '15', 'exaAddress2', 'Address Line 2', 'Address - Line 2(Encrypted for security)', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '20', 'exaAddress3', 'Address Line 3', 'Address - Line 3', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '25', 'exaAddress4', 'Address Line 4', 'Address - Line 4', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '30', 'exaAddress5', 'Address Line 5', 'Address - Line 5', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '35', 'exaPostCode', 'Postcode', 'Address - Postcode', 'Yes', 'No', 'postcode', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '40', 'exaCountry', 'Country', 'Country', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '45', 'exaAccAddress', 'Account Address', 'Simple flag to identify an account address', 'Yes', 'No', 'toggle', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '50', 'exaDate', 'Date', 'Date of last use', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '55', 'exaSpare1', 'Spare 1', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '60', 'exaSpare2', 'Spare 2', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'list', '65', 'exaSpare3', 'Spare 3', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', '');

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

--
-- Deletion display for table `exAddress`
--

DELETE FROM `wdzHandle` where `whdWpjKey`='Web-D-ZineE' and `whdMajor`='exAddress' 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', 'exAddress', 'delete', '0', 'exaId', 'Id', 'The Primary Id is used in back end systems to retrieve the record', 'Yes', 'No', '', '', 'iconCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '5', 'exaExuKey', 'Key', 'The key is used to group children records together', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '10', 'exaAddress1', 'Address Line 1', 'Address - Line 1(Encrypted)', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '15', 'exaAddress2', 'Address Line 2', 'Address - Line 2(Encrypted for security)', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '20', 'exaAddress3', 'Address Line 3', 'Address - Line 3', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '25', 'exaAddress4', 'Address Line 4', 'Address - Line 4', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '30', 'exaAddress5', 'Address Line 5', 'Address - Line 5', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '35', 'exaPostCode', 'Postcode', 'Address - Postcode', 'Yes', 'No', 'postcode', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '40', 'exaCountry', 'Country', 'Country', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '45', 'exaAccAddress', 'Account Address', 'Simple flag to identify an account address', 'Yes', 'No', 'boolean', '', 'iconCol', 'Yes', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '50', 'exaDate', 'Date', 'Date of last use', 'Yes', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '55', 'exaSpare1', 'Spare 1', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '60', 'exaSpare2', 'Spare 2', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', ''),
(NULL, 'Web-D-ZineE', 'exAddress', 'delete', '65', 'exaSpare3', 'Spare 3', 'Used for expansion', 'No', 'No', '', '', 'titleCol', '', '', '', '', '');

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

--
-- Search form for `exAddress`
--

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

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', 'schExAddress', '1st form format for schExAddress', 'en', 'post', 'No', '', 'No', 'submit', 'back', '', '', '', '', 'Yes', '', '', '');

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

--
-- Main form for `exAddress`
--

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

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', 'frmExAddress', '1st form format for frmExAddress', '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', 'frmExAddress', 'exaId', 'Yes', '0', 'firstCol', 'Primary Id', '', 'hidden', '', '', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaExuKey', 'Yes', '5', 'firstCol', 'Key', '', 'text', '', '', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAddress1', 'Yes', '10', 'firstCol', 'Address Line 1', '', 'text', '', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAddress2', 'Yes', '15', 'firstCol', 'Address Line 2', '', 'text', '', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAddress3', 'Yes', '20', 'firstCol', 'Address Line 3', '', 'text', '', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAddress4', 'Yes', '25', 'firstCol', 'Address Line 4', '', 'text', '', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAddress5', 'Yes', '30', 'firstCol', 'Address Line 5', '', 'text', '', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaPostCode', 'Yes', '35', 'firstCol', 'Postcode', '', 'text', '', '', 'No', '', 'postcode', '',  '', '', '', '', 'postcode=google', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaCountry', 'Yes', '40', 'firstCol', 'Country', '', 'select', 'category=COUNTRY; start=Choose Country;', '', 'No', '', 'REGEXP', '/^([A-Z_0-9]+)$/i',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaAccAddress', 'Yes', '45', 'firstCol', 'Account Address', '', 'select', 'category=NO_YES; start=Choose Account Address;', '', 'No', '', 'BOOLEAN', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaDate', 'Yes', '50', 'firstCol', 'Date', '', 'date', '', '', 'No', '', 'date', '',  '', '', '', '', 'date=function=datePicker.php,format=Y-m-d,start=today,end=+5 year,no=Sun@@Sat;', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaSpare1', 'No', '55', 'firstCol', 'Spare 1', '', 'text', '', '', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaSpare2', 'No', '60', 'firstCol', 'Spare 2', '', 'text', '', '', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'exaSpare3', 'No', '65', 'firstCol', 'Spare 3', '', 'textarea', '', 'mceEditor', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'frmExAddress', 'submit', 'Yes', '70', 'buttonDiv', 'Edit', 'labelSpace', 'submit', 'Add=Add; Del=Confirm Delete;', '', 'No', '', '', '',  '', '', '', '', '', '', '', '', '');

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

--
-- Main report for `exAddress`
--

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

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', 'rptExAddress', '1st form format for rptExAddress', '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', 'rptExAddress', 'exaId', 'No',                '0', 'firstCol', 'Primary Id', '', '',           '', 'normalText', 'No', '', 'INT', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaExuKey', 'Yes', '5', 'firstCol', 'Key', '', 'text', '', 'normalText', 'No', '', 'unique', '11',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAddress1', 'Yes', '10', 'firstCol', 'Address Line 1', '', 'text', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAddress2', 'Yes', '15', 'firstCol', 'Address Line 2', '', 'text', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAddress3', 'Yes', '20', 'firstCol', 'Address Line 3', '', 'text', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAddress4', 'Yes', '25', 'firstCol', 'Address Line 4', '', 'text', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAddress5', 'Yes', '30', 'firstCol', 'Address Line 5', '', 'text', '', 'normalText', 'No', '', '', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaPostCode', 'Yes', '35', 'firstCol', 'Postcode', '', 'text', '', 'normalText', 'No', '', 'postcode', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaCountry', 'Yes', '40', 'firstCol', 'Country', '', 'select', 'category=COUNTRY; start=Choose Country;', 'normalText', 'No', '', 'REGEXP', '/^([A-Z_0-9]+)$/i',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaAccAddress', 'Yes', '45', 'firstCol', 'Account Address', '', 'select', 'category=NO_YES; start=Choose Account Address;', 'normalText', 'No', '', 'BOOLEAN', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaDate', 'Yes', '50', 'firstCol', 'Date', '', 'date', '', 'normalText', 'No', '', 'date', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaSpare1', 'No', '55', 'firstCol', 'Spare 1', '', 'text', '', 'normalText', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaSpare2', 'No', '60', 'firstCol', 'Spare 2', '', 'text', '', 'normalText', 'No', '', '-1', '',  '', '', '', '', '', '', '', '', ''),
(null, 'Web-D-ZineE', 'rptExAddress', 'exaSpare3', 'No', '65', '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 Address

Class:- exAddress.phpCopy - Quick copy

User class:- usrExAddress.phpCopy - Quick copy

Panel:- pnlExAddress.phpCopy - Quick copy

SQL:- Copy - Quick copy

Minor Change

Class:- exAddress.php
Copy - Quick copy

User class:- usrExAddress.php
Copy - Quick copy

Panel:- pnlExAddress.php
Copy - Quick copy

SQL:-
Copy - Quick copy