/**
* Query data based on a column being equal to a certain value.
* Note: Limit 1 result
* @global DatabaseConnector $dbConn
* @param DatabaseColumnElement $column
* @return bool success
*/
public function loadFromColumnElement(DatabaseColumnElement $column)
{
global $dbConn;
// query setup
$column_names = array();
foreach ($this->columns as $col) {
$column_names[] = $col->getColumnName();
}
$select = implode(', ', $column_names);
// actual query
$query = $dbConn->executeQuery("\n SELECT {$select}\n FROM {$this->getTableName()}\n WHERE {$column->getColumnName()} = :val\n LIMIT 1\n ", array(":val" => $column->getValue()));
if (is_array($query) && count($query) > 0) {
$this->loadFromAssocArray($query[0]);
return true;
}
return false;
}
