<?php

// phpMyEdit form example

// Validation trigger included below.

/*

   # Table schema

   CREATE TABLE `demo_colors` (
     `id` smallint(3) unsigned NOT NULL auto_increment,
     `name` char(20) NOT NULL default '',
     `hex` char(7) NOT NULL default '',
     PRIMARY KEY  (`id`),
     KEY `name` (`name`)
   ) TYPE=MyISAM;

*/

$opts = array();

$opts['tb'] = 'colors';

$opts['key'] = 'id';

$opts['key_type'] = 'int';

$opts['sort_field'] = array('name');

$opts['inc'] = 10;

$opts['options'] = 'ACPVDFL';

require_once('./inc/dbconn.php'); // Database logon + form navigation config + variables used by the page header

require_once('./inc/header2.php');

$opts['cgi']['append']['PME_sys_fl'] = 1; // Force search feature ON (version 5.6)

$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'];

$opts['fdd']['id'] = array(
  'css'        => array('postfix' => 'right-justify'),
  'default'    => '',
  'input'      => 'R',
  'name'       => 'Id',
  'options'    => 'VDFL',
  'select'     => 'T',
  'size|ACP'   => 3,
  'sort'       => true
);

$opts['fdd']['name'] = array(
  'default'    => '',
  'help|ACP'   => 'Limit 20 characters',
  'input'      => '',
  'maxlen'     => 20,
  'name'       => 'Name',
  'options'    => 'ACPVDFL',
  'select'     => 'T',
  'size|ACP'   => 20,
  'sqlw'       => 'TRIM("$val_as")',
  'sort'       => true,
  'help|ACP'   => 'Netscape color name'
);

$opts['fdd']['hex'] = array(
  'default'    => '',
  'help|ACP'   => 'Limit 7 characters',
  'input'      => '',
  'maxlen'     => 7,
  'name'       => 'Hex',
  'options'    => 'ACPVDFL',
  'select'     => 'T',
  'size|ACP'   => 7,
  'sqlw'       => 'TRIM("$val_as")',
  'sort'       => true,
  'help|ACP'   => 'Hexadecimal code'
);

// Set the name of the validation script used for INSERT, UPDATE

$opts['triggers']['insert']['before'] = './triggers/val/colors.php';

$opts['triggers']['update']['before'] = $opts['triggers']['insert']['before'];

require_once('./inc/phpMyEdit.class.php');

new phpMyEdit($opts);

require_once('./inc/footer2.php');

?>