/**
  * dbTextSelectField::dbTextSelectField()
  *
  * Public constructor: create a new dbTextSelectField object
  *
  * @param object &$oForm: the form where the TextSelectfield is located on
  * @param string $sName: the name of the datefield
  * @param object $oDb: object of the database handler
  * @param string $sTable: the table to get the fields from
  * @param mixed $sField: array of string with the name of the field which data we should get
  * @param string $sExtraSQL: extra SQL statements
  * @return dbTextSelectField
  * @access public
  * @since 22-10-2008
  * @author Johan Wiegel
  */
 function dbTextSelectField(&$oForm, $sName, &$oDb, $sTable, $sField, $sExtraSQL = null, $sMask = null)
 {
     // generate the query to retrieve the records
     $sQuery = 'SELECT ' . $sField . ' FROM ' . $oDb->quote($sTable) . ' ' . $sExtraSQL;
     $this->_aOptions = array();
     // execute the query
     $sql = $oDb->query($sQuery);
     // query succeeded
     if ($sql) {
         while ($row = $oDb->getRecord($sql)) {
             $this->_aOptions[] = $row[$sField];
         }
     } else {
         trigger_error("Error, could not retrieve records.<br '. FH_XHTML_CLOSE .'>\n" . "Error message: " . $oDb->getError() . "<br '. FH_XHTML_CLOSE .'>\n" . "Query: " . $sQuery, E_USER_WARNING);
     }
     // call the constructor of the selectfield
     parent::TextSelectField($oForm, $sName, $this->_aOptions);
 }
示例#2
0
 /**
  * FormHandler::textSelectField()
  *
  * Creates a textSelectfield on the form
  *
  * @param string $title: The title of the field
  * @param string $name: The name of the field
  * @param array $aOptions : the options for the select part
  * @param string $validator: The validator which should be used to validate the value of the field
  * @param int $size: The size of the field
  * @param int $maxlength: The allowed max input of the field
  * @param string $extra: CSS, Javascript or other which are inserted into the HTML tag
  * @return void
  * @access public
  * @author Johan wiegel
  * @since 22-10-2008
  */
 function textSelectField($title, $name, $aOptions, $validator = null, $size = null, $maxlength = null, $extra = null)
 {
     require_once FH_INCLUDE_DIR . 'fields/class.TextField.php';
     require_once FH_INCLUDE_DIR . 'fields/class.TextSelectField.php';
     // create the field
     $fld = new TextSelectField($this, $name, $aOptions);
     if (!empty($validator)) {
         $fld->setValidator($validator);
     }
     if (!empty($size)) {
         $fld->setSize($size);
     }
     if (!empty($maxlength)) {
         $fld->setMaxlength($maxlength);
     }
     if (!empty($extra)) {
         $fld->setExtra($extra);
     }
     // register the field
     $this->_registerField($name, $fld, $title);
 }