default value – PHP Database Form https://phpdatabaseform.com Generate web form from database. Simple. Fri, 26 Dec 2014 16:06:00 +0000 en-US hourly 1 https://wordpress.org/?v=7.0.4 set_default() https://phpdatabaseform.com/docs/set_default/ Fri, 18 Jul 2014 18:07:42 +0000 http://phpdatabaseform.com/?p=340 set_default(mixed $col, string $default) : $this

Set control default value for a field

Parameters

mixed $col
  • Database table column name
string $default
  • Default value
]]> Set Default Value https://phpdatabaseform.com/examples/set-default-value/ Mon, 14 Jul 2014 16:47:46 +0000 http://phpdatabaseform.com/?p=314 During data entry, sometimes you need to have default value for certain fields such as date and time, or arbitiry text. Use set_default() method to set default text.

Note that you can only set default text when entering new data. You cannot set default value when editing existing data on a form.

$dbForm = new C_DatabaseForm("SELECT * FROM Employees", "EmployeeID", "Employees");
$dbForm -> set_label("EmployeeID", "Employee ID");
$dbForm -> set_label("LastName", "Last Name");
$dbForm -> set_label("FirstName", "First Name");
$dbForm -> set_label("BirthDay", "DOB");
$dbForm -> set_hide("Extension");
$dbForm -> set_hide("hireDate");
$dbForm -> set_placeholder('Title', 'official job title');
$dbForm -> add_group_header("EmployeeID", "Basic Info");
$dbForm -> add_group_header("Email", "Contact Info");
$dbForm -> add_tooltip("BirthDate", "Enter employee birth date"); // tooltip supports HTML as well
$dbForm -> set_readonly(array('EmployeeID, LastName'));
$dbForm -> set_ctrltype('Notes', 'wysiwyg');
$dbForm -> set_ctrltype("Country", "autocomplete", "SELECT Code, Name FROM Country");
$dbForm -> set_ctrltype("ReportsTo", "select", "SELECT EmployeeID, LastName FROM Employees");
$dbForm -> set_ctrltype('Email', 'email');
$dbForm -> set_ctrltype('Gender', 'radio', 'M:MMM;F:FFF;Y:YYY;Z:ZZZ');
$dbForm -> set_ctrltype('IsActive', 'checkbox', '1:0');  // single key value pair only
$dbForm -> set_ctrltype('Shift', 'checkboxlist', 'Regular:Regular;Gravy Yard:Gravy Yard');
$dbForm -> set_ctrltype('SSN', 'password');
$dbForm -> set_editrule("SSN", "SSN_validate"); // validate format with javascript
$dbForm -> set_maxlength("FirstName", 12);
$dbForm -> set_default('Title', 'N/A');
$dbForm -> display();

Sample Output (default value only applies during adding new record):

default_value

Live demo

]]>