<?php
#create form object
$staff = new Formitable($db, 'sionapros_users');
#set primary key field
$staff->setPrimaryKey('identifier');
#set encryption key
$staff->setEncryptionKey("g00D_3nCr4p7");
#set identifier field
$staff->setIdentifier('identifier');
#unique username
$staff->uniqueField('username', "This Username already exists");
$staff->forceTypes(array('identifier', 'password', 'reg_date'), array('hidden', 'password', 'hidden'));
$staff->forceTypes(array('change_password', 'account_status'), array('hidden', 'hidden'));
#custom labels
$staff->labelFields(array('firstname', 'lastname'), array('First Name *', 'Last Name *'));
$staff->labelFields(array('username', 'password'), array('User Name *', 'Password *'));
//set up regular expressions for field validation
$staff->registerValidation("required", ".+", "Field MUST be filled in please.");
#$staff->setDateField('account_expiry_date');
$staff->setPasswordField('password');
//set up fields for validation using regexs above
$staff->validateField("firstname", "required");
$staff->validateField("lastname", "required");
$staff->validateField("username", "required");
$staff->validateField("password", "required");
#set default values
$staff->setDefaultValue('reg_date', date("Y-m-d H:i:s"));
$staff->setDefaultValue('change_password', 'Yes');
$staff->setDefaultValue('account_status', 'Active');
//set all output to be returned instead of printed
Don't forget to try <a href="<?php
echo $_SERVER['PHP_SELF'];
?>
?ID=1">retrieving a record</a>.
</div>
<div class="boxed">
<?php
/*** change the following variables ***/
$user = "******";
$pass = "******";
$DB = "database";
//include class, create new Formitable, set primary key field name
include "../Formitable.class.php";
$newForm = new Formitable(@mysql_connect("localhost", $user, $pass), $DB, "formitable_demo");
$newForm->setPrimaryKey("ID");
$newForm->setEncryptionKey("g00D_3nCr4p7");
//hide primary key field, force a few field types
$newForm->hideField("ID");
$newForm->forceTypes(array("foods", "day_of_week"), array("checkbox", "radio"));
//get data pairs from another table
$newForm->normalizedField("toon", "formitable_toons", "ID", "name", "pkey ASC");
//set custom field labels
$newForm->labelFields(array("f_name", "l_name", "description", "pets", "foods", "color", "day_of_week", "b_day", "toon"), array("First Name", "Last Name", "About Yourself", "Your Pets", "Favorite Foods", "Favorite Color", "Favorite Day", "Your Birthday", "Favorite Cartoon"));
//set some default values
$newForm->setDefaultValue("pets", "Dog");
$newForm->setDefaultValue("color", "Blue");
$newForm->setDefaultValue("toon", "3");
$newForm->setDefaultValue("foods", "pizza,salad");
$newForm->setDefaultValue("day_of_week", date("l"));
//set up regular expressions for field validation
<?php
#create form object
$profile = new Formitable($db, 'sionapros_users');
#set primary key field
$profile->setPrimaryKey('identifier');
$profile->setEncryptionKey("EHm1C_3nCr4p7");
$persNoSQL = "SELECT identifier FROM sionapros_users WHERE username = '******'loginUsername']}'";
$res = $db->execute($persNoSQL);
#retrieve profile's data
$profile->getRecord($res[0]['identifier']);
#hide primary key field
$profile->hideField('identifier');
#customiszing form
$profile->hideField('reg_date');
$profile->hideField('identifier');
$profile->hideField('username');
$profile->hideField('password');
$profile->hideField('change_password');
$profile->hideFields(array('account_status'));
#custom labels
$profile->labelFields(array('firstname', 'lastname'), array('First Name *', 'Last Name *'));
//set up regular expressions for field validation
$profile->registerValidation("required", ".+", "Input is required.");
//set up fields for validation using regexs above
$profile->validateField("firstname", "required");
$profile->validateField("lastname", "required");
#set default values
#submit msg
$profile->msg_updateSuccess = "Your Profile was updated successfully.";
//set all output to be returned instead of printed
<?php
$id = $_REQUEST['id'];
#$faq = new Allergy($db);
#create form object
$faq = new Formitable($db, 'sionapros_faqs');
$faq->setPrimaryKey('id');
$faq->getRecord($id);
$faq->forceTypes(array('id', 'done_by', 'reg_date', 'category'), array('hidden', 'hidden', 'hidden', 'select'));
#custom labels
$faq->labelFields(array('faq_qn', 'faq_ans', 'category'), array('Question *', 'Answer *', 'Category *'));
//set up regular expressions for field validation
$faq->registerValidation("required", ".+", "Field MUST be filled in please.");
//set up fields for validation using regexs above
$faq->registerValidation("required", ".+", "Field MUST be filled in please.");
//set up fields for validation using regexs above
$faq->validateField("faq_qn", "required");
$faq->validateField("faq_ans", "required");
$faq->validateField("category", "required");
#set default values
$faq->setDefaultValue('done_by', $_SESSION['loginUsername']);
#normalized field
$faq->normalizedField("category", "sionapros_categories", "id", "value", "id ASC");
//set all output to be returned instead of printed
$faq->returnOutput = true;
if (!isset($_POST['submit']) || isset($_POST['submit']) && $faq->submitForm(false) == -1) {
$faqForm = $faq->printForm();
$smarty->assign('faq', $faqForm);
} else {
$smarty->assign('updateMsg', $faq->submitMsg);
#unset prevPath
<?php
#get the ward_no
$news_no = $_REQUEST['news_no'];
#create form object
$news = new Formitable($db, 'sionapros_news');
#set primary key field
$news->setPrimaryKey('news_no');
$news->setEncryptionKey("eoeeuye_eeeoi");
$news->getRecord($news_no);
$news->forceType('news_no', 'hidden');
$news->forceType('photo', 'hidden');
$news->forceType('category', 'select');
$news->hideFields(array('photo_desc', 'reg_date', 'username'));
$news->setDateField('pub_date');
#$news->forceTypes(array('status'), array('select'));
#custom labels
$news->labelFields(array('title', 'summary', 'detail', 'category', 'pub_date'), array('Title *', 'News Summary*', 'Details *', 'Category *', 'Publication Date *'));
//set up regular expressions for field validation
$news->registerValidation("required", ".+", "Field MUST be filled in please.");
//set up fields for validation using regexs above
$news->validateField("title", "required");
$news->validateField("summary", "required");
$news->validateField("category", "required");
$news->validateField("pub_date", "validateDate");
$news->normalizedField("category", "sionapros_categories", "id", "value", "id ASC");
//set all output to be returned instead of printed
$news->returnOutput = true;
if (!isset($_POST['submit']) || isset($_POST['submit']) && $news->submitForm(false) == -1) {
$newsForm = $news->printForm();
$smarty->assign('news', $newsForm);
</head>
<body>
<div id="content">
<?php
// Displays program record as a form (via Formitable), for editing and exporting to HTML
require_once 'conf.php';
session_start();
$admin = $_SESSION['admin'];
//include class, create new Formitable, set primary key field name
include "include/Formitable.class.php";
$myconn = mysql_connect($prDbhost, $prDbusername, $prDbpassword);
mysql_query("SET NAMES 'utf8'", $myconn);
mysql_query("SET CHARACTER SET 'utf8'", $myconn);
// initialize Formitable
$newForm = new Formitable($myconn, $prDbname, $prTable);
$newForm->setPrimaryKey("id");
// if form has been submitted, call Formitable submit method
if (isset($_POST['submit'])) {
// if not admin, skip (don't update) the following fields
if (!$admin) {
$skipped = array('emails1', 'schnip', 'dimo', 'sch1', 'sch2');
$newForm->skipFields($skipped);
}
$newForm->submitForm();
} else {
//retrieve a record for update if GET var is set
if (isset($_GET['id'])) {
$newForm->getRecord($_GET['id']);
} else {
die("Error...(no get var)");
}
<body>
<?php
/*** change the following variables ***/
$user = "******";
$pass = "******";
$DB = "db";
require "Formitable.class.php";
require_once 'C:\\apachefriends\\xampp\\htdocs\\anyDB2\\examples\\connect.inc.php';
if (strstr($_SERVER['SERVER_NAME'], "local")) {
$server = "localhost";
} else {
$server = "localhost";
}
$newForm = new Formitable($db, "formitable_users");
//set the field name of primary key
$newForm->setPrimaryKey("UserID");
//force a few field types
$newForm->forceTypes(array("UserType", "WkDays", "Occupation", "Address", "Address2", "City", "Password"), array("select", "checkbox", "text", "text", "text", "text", "password"));
//retrieve normalized data from another table
$newForm->normalizedField("UserType", "field_data", "ID", "name", "ID ASC", "type='user'");
$newForm->normalizedField("NewsLetter", "field_data", "ID", "name", "ID DESC", "type='yn'");
$newForm->normalizedField("Donation", "field_data", "ID", "name", "ID ASC", "type='donate'");
$newForm->normalizedField("recurring_Method", "field_data", "ID", "name", "ID ASC", "type='recurring'");
$newForm->normalizedField("Donation_Type", "field_data", "ID", "name", "ID ASC", "type='dtype'");
$newForm->normalizedField("NamePosted", "field_data", "ID", "name", "ID DESC", "type='yn'");
$newForm->normalizedField("volunteer", "field_data", "ID", "name", "ID ASC", "type='volunteer'");
$newForm->normalizedField("gender", "field_data", "ID", "name", "ID ASC", "type='gender'");
$newForm->normalizedField("WkDays", "field_data", "ID", "name", "ID ASC", "type='days'");
$newForm->normalizedField("StateCode", "states", "Code", "Name", "Name ASC");
//set custom field labels
$newForm->labelFields(array("FName", "MName", "LName", "UserType", "FindUs", "NewsLetter", "volunteer", "Donation", "NamePosted", "WkDays", "PostalCode", "StateCode", "TelePhone", "Mobile", "Facsimile", "Details"), array("First Name", "Middle Name", "Last Name", "I am a", "How did you find us?", "Subscribe to our newsletter?", "I want to Volunteer", "I would like to donate", "Add name to Sponsors page?", "I can work these days", "Zip Code", "State", "Home Phone", "Cell Phone", "FAX", "Personal Message"));
<?php
#create form object
$staff = new Formitable($db, 'sionapros_newsletter_receipient');
#set primary key field
$staff->setPrimaryKey('id');
#set encryption key
$staff->setEncryptionKey("g00D_3nCr4p7");
#set identifier field
$staff->setIdentifier('id');
#unique username
$staff->uniqueField('email', "This Email Address already exists");
$staff->forceTypes(array('id'), array('hidden'));
#custom labels
$staff->labelFields(array('fname', 'lname', 'email'), array('First Name *', 'Last Name *', 'Email Address *'));
//set up regular expressions for field validation
$staff->registerValidation("required", ".+", "Field MUST be filled in please.");
#$staff->setDateField('account_expiry_date');
$staff->setPasswordField('password');
//set up fields for validation using regexs above
$staff->validateField("firstname", "required");
$staff->validateField("lastname", "required");
$staff->validateField("email", "required");
//set all output to be returned instead of printed
$staff->returnOutput = true;
//test for last page and no errors to submit form, otherwise start form
if (@$_POST['formitable_multipage'] != "end" || isset($staff->errMsg)) {
$staffOpen = $staff->openForm();
$smarty->assign('staffOpen', $staffOpen);
} else {
$staff->submitForm(false);
