/** * 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; }