dbselect-field.inc.php

Go to the documentation of this file.

<?php
class DbSelectField extends SelectField
{
    function __construct($name, &$parentForm, array $attribs = array())
    {
        if(!array_key_exists('query', $attribs))
            throw new Exception('Query not set');

        $query = $attribs['query'];
        unset($attribs['query']);

        $attribs['options'] = array();
        parent::__construct($name, $parentForm, $attribs);
        $this->options = $this->queryToValues($query);
    }

    function queryToValues($query)
    {
        $dbConn = $this->parentForm->dbConn;
        $res =& $dbConn->query($query);
        $ret = array();

        while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
        {
            if(!array_key_exists('value', $row) || !array_key_exists('title', $row))
                throw new InvalidQueryException("Query did not include columns 'value' & 'title'");

            $ret[$row['value']] = $row['title'];
        }

        return $ret;
    }
}
?>

---