public function fetchKeysValues($key, $value)
{
$query = data::select($key . ', ' . $value, $this->tableName, $this->where, $this->order, $this->limit);
//data::debug();
$array = array();
while ($r = mysql_fetch_object($query)) {
$array[$r->{$key}] = $r->{$value};
}
return $array;
}
public function createComponentFromTable($tableName)
{
$return = NULL;
$count = data::select('COUNT(*) AS TOTAL', $tableName, NULL, NULL, 1) or $return = false;
$count = $count->fetch();
if ($count['TOTAL'] == 0) {
data::insert($tableName, array('id'), array(1));
}
//TODO: Fix ID for primary key.
$result = data::select('*', $tableName, NULL, NULL, 1) or $return = false;
if ($return === false) {
return false;
}
$total = $result->columnCount();
$fields = array();
for ($x = 0; $x < $total; $x++) {
$meta = $result->getColumnMeta($x);
//var_export($meta); echo "------------------<br />\n";
$type = in_array('primary_key', $meta['flags']) ? 'id' : $this->getTypeFromMeta($meta, $tableName, $meta['name']);
array_push($fields, new Field($meta['name'], $type));
}
if ($count['TOTAL'] == 0) {
data::delete($tableName);
}
$newComponent = new cmp_interface($tableName, new fieldSet($fields));
$newComponent->name = $tableName;
return $newComponent;
}