'; elseif($_GET['PME_sys_operation'] == "PME_op_Change") echo '
'; else echo '
'; echo "

Garden Club Database Edit

"; $opts['headingField'] = '7'; // the field number to be used as the header in Change and View $opts['hn'] = 'localhost'; $opts['un'] = '*****'; $opts['pw'] = '*****'; $opts['db'] = '*****'; $opts['tb'] = '*****'; $opts['key'] = 'id'; $opts['key_type'] = 'int'; $opts['sort_field'] = array('id'); $opts['inc'] = 18; $opts['options'] = 'ACPVDF'; $opts['multiple'] = '4'; $opts['navigation'] = 'DBG'; $opts['display'] = array( 'form' => true, 'query' => true, 'sort' => true, 'time' => false, 'tabs' => true ); $opts['js']['prefix'] = 'PME_js_'; $opts['dhtml']['prefix'] = 'PME_dhtml_'; $opts['cgi']['prefix']['operation'] = 'PME_op_'; $opts['cgi']['prefix']['sys'] = 'PME_sys_'; $opts['cgi']['prefix']['data'] = 'PME_data_'; $opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'] . '-UTF8'; $opts['fdd']['id'] = array( 'name' => 'ID', 'select' => 'T', 'options' => '', // auto increment 'maxlen' => 10, 'default' => '0', 'sort' => true ); $opts['fdd']['Status'] = array( 'name' => 'Status', 'css|CVDPA' => array('postfix' => 'B'), 'select' => 'O', 'values' => array('Renewed','New','Inactive','Honorary','Deceased','Moved Away'), 'maxlen' => 12, 'sort' => true, 'banner' => 'Membership Status' ); $opts['fdd']['Type'] = array( 'name' => 'Type', 'css|CVDPA' => array('postfix' => 'B'), 'select' => 'O', 'values' => array('Individual','Couple'), 'maxlen' => 3, 'sort' => true, ); $opts['fdd']['PaymentType'] = array( 'name' => 'Payment Method', 'css|CVDPA' => array('postfix' => 'B'), 'select' => 'O', 'options' => 'CPVDA', 'values' => array('Check','Cash','Complimentary','Not Current'), 'maxlen' => 3, 'sort' => true, ); $opts['fdd']['PaymentDate'] = array( 'name' => 'Last Payment Date', 'css|CVDPA' => array('postfix' => 'B'), 'options' => 'CVPDA', 'select' => 'A', 'maxlen' => 24, 'sort' => true, ); $opts['fdd']['ValidDate'] = array( 'name' => 'Membership Valid Until', 'css|CVDPA' => array('postfix' => 'B'), 'options' => 'CVPDA', 'select' => 'A', 'maxlen' => 24, 'sort' => true, ); $opts['fdd']['FirstNameA'] = array( 'name' => 'First Name', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'maxlen' => 24, 'sort' => true, 'banner' => 'First Member Data' ); $opts['fdd']['LastNameA'] = array( 'name' => 'Last Name', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'maxlen' => 24, 'sort' => true ); $opts['fdd']['ActivitiesA'] = array( 'name' => 'Activites', 'select' => 'C', 'css|CVPDA' => array('postfix' => 'A'), 'options' => 'CVPAD', 'values' => array('Ways&Means','Tour','Programs','Civic','Membership','Welcome','Calling','Publicity','WEB Site','Email'), 'maxlen' => 12, 'sort' => true ); $opts['fdd']['BoardPositionA'] = array( 'name' => 'Board Position', 'options' => 'CVPDA', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'O', 'values' => array('None','President','President Elect','1st Vice President','2nd Vice President','Recording Secretary','Treasurer','Corresponding Secretary'), 'maxlen' => 12, 'sort' => true ); $opts['fdd']['MasterGardenerA'] = array( 'name' => 'Master Gardener', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'O', 'options' => 'CVPAD', 'values' => array('Yes','No'), 'maxlen' => 3, 'sort' => true ); $opts['fdd']['FirstNameB'] = array( 'name' => 'First Name', 'css|CVDPA' => array('postfix' => 'B'), 'select' => 'T', 'maxlen' => 24, 'sort' => true, 'banner' => 'Second Member Data' ); $opts['fdd']['LastNameB'] = array( 'name' => 'Last Name', 'css|CVPDA' => array('postfix' => 'B'), 'select' => 'T', 'maxlen' => 24, 'sort' => true ); $opts['fdd']['ActivitiesB'] = array( 'name' => 'Activites', 'options' => 'CVPDA', 'css|CVPDA' => array('postfix' => 'B'), 'select' => 'C', 'values' => array('Ways&Means','Tour','Programs','Civic','Membership','Welcome','Calling','Publicity','WEB Site','Email'), 'maxlen' => 12, 'sort' => true ); $opts['fdd']['BoardPositionB'] = array( 'name' => 'Board Position', 'options' => 'CVPDA', 'css|CVPDA' => array('postfix' => 'B'), 'select' => 'O', 'values' => array('None','President','President Elect','1st Vice President','2nd Vice President','Recording Secretary','Treasurer','Corresponding Secretary'), 'maxlen' => 12, 'sort' => true ); $opts['fdd']['MasterGardenerB'] = array( 'name' => 'Master Gardener', 'options' => 'CVPDA', 'css|CVPDA' => array('postfix' => 'B'), 'select' => 'O', 'values' => array('Yes','No'), 'maxlen' => 3, 'sort' => true, ); $opts['fdd']['Phone'] = array( 'name' => 'Phone', 'css|CVPDA' => array('postfix' => 'A'), 'options' => 'VLCPDA', 'select' => 'T', 'maxlen' => 32, 'sort' => true, 'banner' => 'Contact Information' ); $opts['fdd']['Address'] = array( 'name' => 'Address', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'options' => 'VCPDA', 'maxlen' => 32, 'sort' => true ); $opts['fdd']['City'] = array( 'name' => 'City', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'maxlen' => 32, 'sort' => true ); $opts['fdd']['State'] = array( 'name' => 'State', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'maxlen' => 3, 'sort' => true ); $opts['fdd']['postalCode'] = array( 'name' => 'PostalCode', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'A'), 'select' => 'T', 'maxlen' => 12, 'sort' => true ); $opts['fdd']['Email'] = array( 'name' => 'Email', 'select' => 'T', 'css|CVPDA' => array('postfix' => 'A'), 'maxlen' => 42, 'sort' => true ); $opts['fdd']['suggestions'] = array( 'name' => 'Program Suggestions', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'B'), 'textarea' => array('rows' => '3','cols' => '97'), 'select' => 'T', 'maxlen' => 500, 'sort' => true, 'banner' => 'Feedback' ); $opts['fdd']['interests'] = array( 'name' => 'Special Interests', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'B'), 'textarea' => array('rows' => '3','cols' => '97'), 'select' => 'T', 'maxlen' => 500, 'sort' => true ); $opts['fdd']['Notes'] = array( 'name' => 'My Notes', 'options' => 'VCPDA', 'css|CVPDA' => array('postfix' => 'B'), 'textarea' => array('rows' => '2','cols' => '97'), 'select' => 'T', 'maxlen' => 500, 'sort' => true ); require_once 'phpMyEdit.class.php'; new phpMyEdit($opts); echo "
"; ?>