HTML_QuickForm_select::loadQuery() – Queries a database and loads the options from the results


require_once 'HTML/QuickForm/select.php';

mixed HTML_QuickForm_select::loadQuery ( mixed &$conn , string $sql , string $textCol = null , string $valueCol = null , mixed $values = null )


If no column names are specified the first two columns of the result are used as the text and value columns respectively.


mixed &$conn

Either an existing DB connection or a valid dsn

string $sql

SQL query string

string $textCol

(optional) Name of column to display as the OPTION text

string $valueCol

(optional) Name of column to use as the OPTION value

mixed $values

(optional) Array or comma delimited string of selected values


throws PEAR_Error


since 1.1

This function can not be called statically.

Loads the options from DB_result object (Previous) Sets the select mutiple attribute (Next)
Last updated: Sat, 16 Feb 2019 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report.
View this page in:
  • English

User Notes:

There are no user contributed notes for this page.