function rowsToDropDown($rows, $textColumns = null, $valueColumn = null)
{
if (!$rows || !is_array($rows) || !count($rows)) {
return "No Results";
}
$columns = array_keys(reset($rows));
setIfNull($valueColumn, $columns[0]);
setIfNull($textColumns, $columns[1]);
if (!is_array($textColumns)) {
$textColumns = explode(" ", $textColumns);
}
$result = "<select>\n";
// output data of each row
foreach ($rows as $row) {
$value = @$row[$valueColumn];
$result .= $value || $value == 0 ? "<option value='{$value}'>" : "<option>";
$sep = "";
$prev = "";
foreach ($textColumns as $key) {
$sep = isset($row[$prev]) ? " " : "";
$value = isset($row[$key]) ? $row[$key] : $key;
$result .= $sep . $value . $sep;
$prev = $key;
}
$result .= "</option>\n";
}
$result .= "</select>\n";
return $result;
}
private static function sqlWhere(&$params = null)
{
$sql = "";
$sep = "WHERE";
setIfNull($params, $_REQUEST);
//TODO: list of reserved keywords. check if params are valid columm names
unset($params["debug"]);
unset($params["table"]);
unset($params["group_by"]);
unset($params["order_by"]);
unset($params["limit"]);
$where = arrayExtract($params, "where");
foreach ($params as $key => $param) {
$sql .= " {$sep} " . SqlManager::sqlCondition($params, $key, true);
$sep = "AND";
}
if ($where) {
$sql .= " {$sep} {$where}";
}
return $sql;
}
