Formitable Examples - Default Time Values

Time Example

Code

 <?PHP




include("Formitable.class.php"); 


$newForm = 
new Formitable( 
mysql_connect("server","user","pass"),"db","formitable_time" 
);



//set some default values

$newForm->setDefaultValue("day",date("l",(time() + (24 * 60 * 60))),true);


$newForm->setDefaultValue("time",date("H:i:s",(time() + (2 * 60 * 60))),true);


$newForm->setDefaultValue("date",date("Y/m/d",(time() + (31 * 24 * 60 * 60))),true);


$newForm->setDefaultValue("year",date("Y",(time() - (36 * 365 * 24 * 60 * 60))),true);


$newForm->setDefaultValue("timestamp",date("YmdHis",(time() + (4 * 365 * 24 * 60 * 60))),true);




//set up regular expressions for field validation

$newForm->registerValidation("required",".+","Input is required.");

$newForm->registerValidation("year_range","(19[8-9][0-9])|20[0-1][0-9]","Enter a valid year (1980-2019).");


$newForm->registerValidation("this_month",date("Y/m/")."[0-2][0-9]|[3][0-1]","Enter a day in this month.");



//set fields for validation using regexs above

$newForm->validateField("timestamp","required");


$newForm->validateField("year","year_range");

$newForm->validateField("date","this_month");




//output form if not submitted or there were errors on submit

if( !isset($_POST['submit']) ||

    (isset($_POST['submit']) && $newForm->submitForm() == -1) ){




    $newForm->openForm();

    $newForm->printField("day");

    $newForm->printField("time");


    $newForm->printField("date");

    $newForm->printField("year");

    $newForm->printField("timestamp");


    $newForm->closeForm();



}


?>

MySQL Table

CREATE TABLE formitable_time (
  `ID` tinyint(3) unsigned NOT NULL auto_increment,
  `time` time NOT NULL default '00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `year` year(4) NOT NULL default '0000',
  PRIMARY KEY  (`ID`)
);