Manual  /  Functions  /  Database Functions  /  dbTextSelectField

(Since version FH3 v1.2.6)

Arguments:

Name	Description
$title	Title of the field
$name	Name of the field
$table	The table where the values of this field should be fetched from
$field	String the field which is retrieved from the table and put into the select part of this textfield.
$extraSQL	Some extra SQL which will be included right achter the "FROM <table>" statement. With this you can order the items, join tables, etc.
$validator	This can either be the name of your own validation function or the constant name of a predefined validator function. For more information about validators see Validators. It is also possible to use a method as a validation function. In this case you should pass an array where the first item is the object and the second item the name of the method.
$extra	This can be extra information which will be included in the fields html tag. You can add for example some CSS or javascript.

Description:

With this field you have the possibility to present a user a selection from a table in your database to put in the textfield or type there own value

Example

<?php  // include the formhandler  include( 'FH3/class.dbFormHandler.php' );  // create new db formhandler object  $oForm = new dbFormHandler();  // set the database info (create a new connection)  $oForm -> dbInfo( 'database', 'table', 'mysql' );  $oForm -> dbConnect( 'localhost', 'username', 'password');  // new TextSelectfield  $oForm -> dbTextSelectField(    'Options from a table',    'saveInField',    'loadFromTable',    array( 'keyField', 'valueField' ),    ' ORDER BY `valueField`',    FH_NOT_EMPTY  );  // button to submit  $oForm -> submitButton();  // what to do when the form is saved  $oForm -> onSaved( 'FH_RUN' );  // show the form  $oForm -> flush();  // the function which is called when the data is saved  function FH_RUN( $iID, $aData )  {      echo "Your type or selected value '". $aData['saveInField'] ."' is saved!";  }  ?>

Comments