$cid = $_GET['c'];
$vartype = unserialize(mysql_result(mysql_query("SELECT setting_value FROM settings WHERE setting_owner = 'custom_vartype' AND setting_name='{$table}'"), 0));
}
$message[1] = 'New entry created successfully';
$message[2] = 'The entry edited successfully';
$message[3] = 'The entry deleted successfully';
$message[4] = 'Settings deleted successfully';
$message[5] = "I can't create new entry";
$message[6] = "I can't edit the entry";
$message[7] = "I can't delete the entry";
$message[8] = "I can't update settings";
if (isset($_GET['message']) && is_numeric($_GET['message'])) {
$not = '<div class="box success" onload="">' . $message[$_GET["message"]] . '</div>';
}
// Start Get Column Information
$field = getcolumns($table);
$ai = getai($table);
$column = count($field);
// Finish Get Column Information
if (!isset($_GET["settings"]) && !isset($_GET["new"]) && empty($_GET["edit"])) {
$sq = searchsql($field);
$howmany = mysql_result(mysql_query("SELECT COUNT(*) FROM {$table} {$sq}"), 0);
// The number of total rows
$pag = new Pagination($howmany, $list);
$pag->getpage();
if (isset($_GET["search"])) {
$search = $_GET["search"];
$ic .= "<a class='awesome light' style='float:left;'>'{$search}' Sorgusu için toplam {$howmany} kayıt bulundu.</a><a class='awesome light' style='float:left; margin-left:2px;' href='" . $_SERVER["SCRIPT_NAME"] . "'>x</a>";
} else {
$ic .= '<a class="button orange left" href="?c=' . $cid . '&new">Yeni Girdi Ekle</a>';
$ic .= "<a class='button purple leftmargin left' href='?c={$cid}&settings' >ℵ δ </a>";
function searchfor($db, $word, $dbname_select = array(), $table_select = array(), $column_select = array(), $view_columns = array(), $exclude = array())
{
$dbnames = array();
if (count($dbname_select) == 0) {
$dbnametmp = getdatabases($db);
//get all databases
foreach ($dbnametmp as $dbname) {
$dbnames[] = $dbname['Database'];
}
} else {
$dbnames = $dbname_select;
}
$data = array();
foreach ($dbnames as $dbname) {
$ecode = mysql_select_db($dbname, $db);
if (!$ecode) {
echo "Error: e002: Database not exist!\n";
die;
}
$tables = array();
if (count($table_select) == 0) {
$tabletmp = gettables($db, $dbname);
// get all tables in database
foreach ($tabletmp as $tablex) {
$tablename = $tablex['Tables_in_' . $dbname];
if (!in_array($tablename, $exclude)) {
$tables[] = $tablename;
}
}
} else {
$tables = $table_select;
}
$data = array();
foreach ($tables as $table) {
$columns = array();
if (count($column_select) == 0) {
$columnstmp = getcolumns($db, $dbname, $table);
foreach ($columnstmp as $columnx) {
$columns[] = $columnx['Field'];
}
} else {
$columns = $column_select;
}
$like = '';
for ($i = 0; $i < count($columns); $i++) {
$like .= " `" . $columns[$i] . "` like '%" . mysql_real_escape_string($word) . "%'";
if ($i != count($columns) - 1) {
$like .= " OR";
}
}
$order = '';
if (count($view_columns) > 0) {
$order = "ORDER BY";
for ($i = 0; $i < count($view_columns); $i++) {
$order .= " `" . $view_columns[$i] . "` ASC";
if ($i != count($view_columns) - 1) {
$order .= ",";
}
}
}
$query = "SELECT * FROM " . $table . " WHERE " . $like . " " . $order;
//print_r($query);
$sql = mysql_query($query);
if (!$sql) {
echo "Error: e003: Column not exist!\n";
die;
}
while ($sql && ($row = mysql_fetch_assoc($sql))) {
if (count($view_columns) > 0) {
foreach ($row as $key => $val) {
if (!in_array($key, $view_columns)) {
unset($row[$key]);
}
}
}
$data[$dbname][$table][] = $row;
}
}
}
return $data;
}
