");
printf("%s
", mysql_error());
die("");
}
printf("%s
", $table);
printf("");
$query = "EXPLAIN ";
$query .= $table;
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
$numcols = mysql_num_fields($result);
printf("%d x %d
", $numrows, $numcols);
printf("");
for ($i=0; $i<$numrows; $i++)
{
$row = mysql_fetch_row($result);
printf("| %s | ", $row[0]);
}
printf("
");
$query = "SELECT * FROM ";
$query .= $table;
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
$numcols = mysql_num_fields($result);
printf("%d x %d
", $numrows, $numcols);
while ($row = mysql_fetch_row($result))
{
printf("");
foreach ($row as $entry)
{
printf("| %s | ", $entry);
}
printf("
");
}
printf("
");
mysql_free_result($result);
mysql_close($db_id);
}
*/
function EnumQuery($name)
{
$var = $name . "Enum";
$txt = "";
switch ($_GET[$var])
{
case 0: $txt .= ""; break;
case 1: $txt .= $name . "='yes' AND "; break;
case 2: $txt .= $name . "='no' AND "; break;
case 3: $txt .= ""; break;
}
return $txt;
}
function PrintEnumMenu($name, $text)
{
$var = $name . "Enum";
if ($_GET[$name]=="On")
$checked = "checked";
else
$checked = "";
printf(" %s\n", $name, $checked, $text);
printf("
");
printf(" \n");
printf(" \n");
}
function StatusQuery($name)
{
$var = $name . "Status";
$txt = "";
switch ($_GET[$var])
{
case 0: $txt .= ""; break;
case 1: $txt .= "NOT (IsNull(" . $name . ") OR " . $name . "='1970-01-01 00:00:00') AND "; break;
case 2: $txt .= "IsNull(" . $name . ") AND "; break;
case 3: $txt .= $name ."='1970-01-01 00:00:00' AND "; break;
case 4: $txt .= ""; break;
}
return $txt;
}
function PrintStatusMenu($name, $text)
{
$var = $name . "Status";
if ($_GET[$name]=="On")
$checked = "checked";
else
$checked = "";
printf(" %s\n", $name, $checked, $text);
printf("
");
printf(" \n");
printf(" \n");
}
function PrintLimitsMenu($limits, $rms, $alias)
{
foreach($limits as $key => $element)
{
printf("| %s | \n", $alias[$key]);
$mean=$key . "Mean";
$limitmean=$_GET[$mean];
printf(" | \n", $key, $limitmean);
if ($rms[$key]=="yes")
{
$rms2=$key . "Rms";
$limitrms=$_GET[$rms2];
printf(" | \n", $key, $limitrms);
}
else
printf("
| \n");
printf("
\n");
}
}
function PrintPullDown($db, $table, $name, $index, $descr)
{
$db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error:
");
printf("%s
", mysql_error());
die("");
}
$query = "SELECT " . $index . ", " . $name . " FROM " . $db . "." . $table . " ORDER BY " . $name;
$result = mysql_query($query);
if (!$result)
{
printf("-N/A-");
return;
}
$numrows = mysql_num_rows($result);
if ($_GET[$name]=="On")
$checked = "checked";
else
$checked = "";
printf(" %s\n", $name, $checked, $table, $descr);
printf("
\n");
printf(" \n");
printf(" \n", $index);
mysql_free_result($result);
mysql_close($db_id);
}
function GetMin($field, $table, $db)
{
$db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error:
");
printf("%s
", mysql_error());
die("");
}
$query = "SELECT MIN(" . $field . ") FROM " . $db . "." . $table;
$result = mysql_query($query);
if (!$result)
return "0";
$row = mysql_fetch_row($result);
$min = $row[0];
mysql_free_result($result);
mysql_close($db_id);
return $min;
}
function GetMax($field, $table, $db)
{
$db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error:
");
printf("%s
", mysql_error());
die("");
}
$query = "SELECT MAX(" . $field . ") FROM " . $db . "." . $table;
$result = mysql_query($query);
if (!$result)
return "0";
$row = mysql_fetch_row($result);
$max = $row[0];
mysql_free_result($result);
mysql_close($db_id);
return $max;
}
/*
function GetMin()
{
$db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error:
");
printf("%s
", mysql_error());
die("");
}
$query = "SELECT MIN(fRunNumber) FROM MyMagic.RunData";
$result = mysql_query($query);
if (!$result)
return "0";
$row = mysql_fetch_row($result);
$min = $row[0];
mysql_free_result($result);
mysql_close($db_id);
return $min;
}
function GetMax()
{
$db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!");
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error:
");
printf("%s
", mysql_error());
die("");
}
$query = "SELECT MAX(fRunNumber) FROM MyMagic.RunData";
$result = mysql_query($query);
if (!$result)
return "0";
$row = mysql_fetch_row($result);
$max = $row[0];
mysql_free_result($result);
mysql_close($db_id);
return $max;
}
*/
function PrintText($result0)
{
header("Content-type: application/octet");
header("Content-Disposition: attachment; filename=query-result.txt");
while ($row0 = mysql_fetch_assoc($result0))
{
foreach ($row0 as $key => $element)
printf("%s\t", $element);
printf("\n");
}
}
function Checkbox($value, $text)
{
if ($_GET[$value]=="On")
$checked = "checked";
else
$checked = "";
printf(" %s | \n", $value, $checked, $text);
}
function CheckWhere($column, $_GET)
{
foreach ($_GET as $key => $element)
{
if ($key==$column)
{
if ($element>0)
printf ("FIXED: %s
", $column);
return $element;
}
}
return 0;
}
function CheckGroup($column, $_GET)
{
foreach ($_GET as $key => $element)
{
if ($key==$column)
{
//if ($element==-1)
// printf ("GROUP: %s
", $column);
return $element;
}
}
return 0;
}
function CheckStatusGroup($column, $_GET)
{
foreach ($_GET as $key => $element)
if ($key==$column)
if ($element==4)
return -1;
return 0;
}
function CheckEnumGroup($column, $_GET)
{
foreach ($_GET as $key => $element)
if ($key==$column)
if ($element==3)
return -1;
return 0;
}
function CreateMenu($rows)
{
$menu = "";
if (empty($_GET["fNumResults"]))
return;
if ($_GET["fNumStart"]!=0)
{
$uri = $_SERVER["REQUEST_URI"];
$pos = strpos($uri, "fNumStart");
$amp3=FALSE;
if ($pos!=FALSE)
{
$amp1 = substr($uri, 0, $pos-1);
$amp2 = substr($uri, $pos);
$amp3 = strchr($amp2, "&");
$uri = $amp1;
}
$pos = $_GET["fNumStart"]-$rows;
if ($pos<0)
$pos=0;
$uri .= "&fNumStart=" . $pos;
if ($amp3!=FALSE)
$uri .= $amp3;
$menu .= "<<< Prev\n";
}
$menu .= " --- ";
$menu .= $_GET["fNumStart"];
$menu .= " --- \n";
if ($rows==$_GET["fNumResults"])
{
$uri = $_SERVER["REQUEST_URI"];
$pos = strpos($uri, "fNumStart");
$amp3=FALSE;
if ($pos!=FALSE)
{
$amp1 = substr($uri, 0, $pos-1);
$amp2 = substr($uri, $pos);
$amp3 = strchr($amp2, "&");
$uri = $amp1;
}
$uri .= "&fNumStart=" . ($_GET["fNumStart"]+$rows);
if ($amp3!=FALSE)
$uri .= $amp3;
$menu .= "Next >>>\n";
}
return $menu;
}
function RemoveSortBy($rows)
{
$menu = "";
$uri = $_SERVER["REQUEST_URI"];
$pos = strpos($uri, "fSortBy");
$amp3=FALSE;
if ($pos!=FALSE)
{
$amp1 = substr($uri, 0, $pos-1);
$amp2 = substr($uri, $pos);
$amp3 = strchr($amp2, "&");
$uri = $amp1;
}
return $uri;
}
function FindAlias($alias, $search)
{
foreach ($alias as $key => $element)
if ($element==$search)
return $key;
return "";
}
function PrintMagicTable($result0, $alias, $rightalign, $limits, $rms, $_GET)
{
$col = FALSE;
$first = TRUE;
$menu = CreateMenu(mysql_num_rows($result0));
printf("\n\n%s
\n", $menu);
printf("
\n");
while ($row0 = mysql_fetch_assoc($result0))
{
if ($first)
{
printf(" \n");
$first = FALSE;
foreach ($row0 as $key => $element)
{
$col = FindAlias($alias, $key);
$ord="%2B";
$issort = "";
if (!empty($_GET["fSortBy"]) && substr($_GET["fSortBy"], 0, -1)==$col)
{
if (substr($_GET["fSortBy"], -1)=="+")
{
$ord="-";
$issort=" 
";
}
else
$issort=" 
";
}
printf(" %s%s | \n",
RemoveSortBy($_SERVER["REQUEST_URI"]), $col, $ord, $key, $issort);
}
printf("
\n\n");
}
if (!$col)
printf(" \n");
else
printf("
\n");
$col = !$col;
foreach ($row0 as $key => $element)
{
if (empty($rightalign[$key]))
printf(" | ");
else
printf(" | ");
if (!(empty($limits) && empty($rms)))
{
foreach($limits as $key2 => $element2)
{
$mean=$key2 . "Mean";
$rms2=$key2 . "Rms";
if ($key==$alias[$element2] && !empty($_GET[$mean]))
{
if ($rms[$key2]=="yes")
{
if (!empty($_GET[$rms2]))
{
$min=$_GET[$mean] - $_GET[$rms2];
$max=$_GET[$mean] + $_GET[$rms2];
if ($min < $element && $element < $max)
printf("");
else
printf("");
}
}
else
{
if ($rms[$key2]=="min")
{
if ($_GET[$mean] <= $element)
printf("");
else
printf("");
}
if ($rms[$key2]=="max")
{
if ($_GET[$mean] >= $element)
printf("");
else
printf("");
}
}
}
}
}
printf(" %s | \n", str_replace("&ws;", " ", str_replace(" ", " ", $element)));
}
printf("
\n");
}
printf("
\n");
/*
$info = mysql_info();
if (!empty($info))
printf("%s
\n", $info);
*/
printf("Number of displayed results: %d
\n", mysql_num_rows($result0));
printf("%s\n", $menu);
printf("
\n");
printf("
\n");
printf("| \n");
}
?>
|