/**
* Returns an associative array of records from a query.
*
* @param $query
*/
function query($query)
{
switch (strtolower(substr(trim($query), 0, 6))) {
case 'select':
$this->_db->setQuery($query);
$results = $this->_db->loadAssocList();
return $results;
break;
case 'insert':
case 'update':
$this->_db->setQuery($query);
$result = $this->_db->query();
return $result;
break;
}
return false;
}
/**
* Funzione per eseguire una query e restituire i risultati come array associativo
* @param string Testo della query
* @return array
* FUNZIONE CHIAMATA DAL MODULO DEVE ESSERE SEMPRE IMPLEMENTATA QUI
*/
public function queryList($q)
{
$this->db->setQuery($q);
return $this->db->loadAssocList();
}
/**
* Load a associative array of associative database rows or column values.
*
* @param string $key The name of a field on which to key the result array
* @param string $column [optional] column name. If not null: Instead of the whole row, only this column value will be in the result array
* @return array If $key is null: Sequential array of returned records/values, Otherwise: Keyed array
*
* @throws \RuntimeException
*/
public function loadAssocList($key = null, $column = null)
{
return $this->_nullToArray($this->_db->loadAssocList($key, $column));
}
/**
* Execute a query to the database and get an array of the result set rows from the database query where each row is an associative array
*
* The result returned by this method is the same as the one returned by JDatabase::loadAssocList()
* Generally used for SELECT operations
*
* @param string $query The query to be executed
* @param string $key The name of a field on which to key the result array
*
* @return array The results of the query
*
* @throws RuntimeException
*
* @since 1.0.0
*/
public function queryAssocList($query, $key = '')
{
// query database table
$this->_database->setQuery($query);
return $this->_database->loadAssocList($key);
}
/**
* Load a assoc list of database rows
*
* @param string The field name of a primary key
* @return array If <var>key</var> is empty as sequential list of returned records.
*/
function loadAssocList($key = null)
{
if ($key == '' || checkJversion() >= 0) {
$resultArray = $this->_db->loadAssocList($key);
return $this->_nullToArray($resultArray);
} else {
// mambo 4.5.2 - 4.6.2 has a bug in key:
if (!($cur = $this->query())) {
return null;
}
$array = array();
while (is_array($row = $this->m_fetch_assoc($cur))) {
if ($key) {
$array[$row[$key]] = $row;
// $row->key is not an object, but an array
} else {
$array[] = $row;
}
}
$this->m_free_result($cur);
return $array;
}
}
/**
* Returns a new configuration registry from a source configuration
* SQL table. This method uses the JDatabase object.
*
* @param JDatabase $handler Connected and active JDatabase object.
* @param string $table Database table to use.
*
* @return JRegistry Registry of configuration.
*
* @since 2.0
*/
protected static function createDBConfig(JDatabase $handler, $table)
{
// Create the registry with a default namespace of config
$registry = new JRegistry;
$query = $handler->getQuery(true);
// Do the SQL query ensuring only platform specific entries are returned
$query->select($query->quoteName('name'))
->select($query->quoteName('value'))
->from($query->quoteName($table))
->order($query->quoteName('id'));
$handler->setQuery($query);
// Load the SQL query into an associative array
$array = $handler->loadAssocList('name', 'value');
if (!is_null($array))
{
foreach ($array as $key => $value)
{
// Ensure compatibility between group.config and group:config
$registry->set(str_replace(':', '.', $key), $value);
$registry->set(str_replace('.', ':', $key), $value);
}
}
return $registry;
}
