\n"; echo "Time (GMT+1): $tm
\n"; } function query($query){ // Connecting, selecting database ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); $mysqli = new mysqli("wudas2l", "guest","","detectors"); // Performing SQL query $result = $mysqli->query($query); // Printing results in HTML echo "\n"; $line = $result->fetch_array(MYSQLI_ASSOC); echo "\t\n"; echo "\t\t\n"; //wyswietlana nazwa kolumny zawierajacej numey wierszy foreach (array_keys($line) as $col_value) { echo "\t\t\n"; } echo "\t\n"; $i=0; do { echo "\t\n"; $i++; echo "\t\t\n"; //wstawia numeracje wyswietlanych wierszy foreach ($line as $col_value) { if($col_value!=null) echo "\t\t\n"; else echo "\t\t\n"; } echo "\t\n"; }while ($line = $result->fetch_array(MYSQLI_ASSOC)); echo "

#	$col_value
$i	$col_value	$\"\"$

\n"; // Free resultset $result->free(); // Closing connection $mysqli->close(); } ?> "; $doGo=$_GET["doGo"]; if(!$doGo){ ?>

Please choose from the following options and click "Show!".

$\"BACK\"/$

"; switch ($choice) { case 1: query(" SELECT date, channel, number AS detector, position, phi, theta FROM (SELECT * FROM (SELECT electronics AS channel,localisation.number,DATE_FORMAT(`date and time`,'%Y-%m-%d') AS date,localisation FROM localisation INNER JOIN (SELECT number, MAX(`date and time`) AS date FROM localisation GROUP BY number) AS newest ON localisation.number=newest.number AND localisation.`date and time`=newest.date) AS miejsca WHERE localisation LIKE '%eagle%') AS frame, (SELECT name,position,phi,theta FROM eagle_position_angle) as angle where localisation=name ORDER BY channel ;"); break; case 2: query(" select number,`serial number`,model,`Nordball_acs_fit` AS `NB ACS` FROM detectors limit 23 ;"); break; case 3: query(" SELECT number as Detector, MAX(`time stop`) AS `last annealed` FROM annealing GROUP BY number ORDER BY number ;"); break; case 4: query(" SELECT channel,localisation AS location,frame.number AS detector,date,`FWHM [keV]`,`energy [keV]`,`where measured`,`when measured` FROM (SELECT * FROM (SELECT electronics AS channel,localisation.number,DATE_FORMAT(`date and time`,\"%Y-%m-%d\") AS date,localisation FROM localisation INNER JOIN (SELECT number, MAX(`date and time`) AS date FROM localisation GROUP BY number) AS newest ON localisation.number=newest.number AND localisation.`date and time`=newest.date) AS miejsca WHERE localisation LIKE \"%eagle%\") AS frame, (SELECT DATE_FORMAT(`date and time`,\"%y/%m/%d\") as `when measured`,`energy resolution`.number,`FWHM [keV]`,`energy [keV]`, `source`,`where measured`,cps AS `C/s`,notes FROM `energy resolution` INNER JOIN (SELECT number,MAX(`date and time`) AS dateEn FROM `energy resolution` GROUP BY number) AS newestEn ON `energy resolution`.number=newestEn.number AND `energy resolution`.`date and time`=newestEn.dateEn) as energy WHERE energy.number=frame.number ORDER BY channel; ;"); break; case 5: query(" SELECT channel,localisation AS location,frame.number AS detector,date,`high voltage [kV]` FROM (SELECT * FROM (SELECT electronics AS channel,localisation.number,DATE_FORMAT(`date and time`,\"%Y-%m-%d\") AS date,localisation FROM localisation INNER JOIN (SELECT number, MAX(`date and time`) AS date FROM localisation GROUP BY number) AS newest ON localisation.number=newest.number AND localisation.`date and time`=newest.date) AS miejsca WHERE localisation LIKE \"%eagle%\") AS frame, (SELECT `high voltage`.number,`date and time`, `high voltage [kV]` FROM `high voltage` INNER JOIN (SELECT number,MAX(`date and time`) AS dateHV FROM `high voltage` GROUP BY number) as newestHV ON `high voltage`.number=newestHV.number AND `high voltage`.`date and time`=newestHV.dateHV) AS hv WHERE hv.number=frame.number ORDER BY channel ;"); break; case 6: query(" SELECT DATE_FORMAT(date,\"%Y-%m-%d\") AS since,localisation.number, `localisation` AS `current localisation`,electronics AS `SMAN channel` FROM localisation INNER JOIN (SELECT number, MAX(`date and time`) AS date FROM localisation GROUP BY number) AS newest ON localisation.number=newest.number AND localisation.`date and time`=newest.date ORDER BY localisation .number ;"); break; case 7: query(" SELECT position,phi,theta from eagle_position_angle ORDER BY position ;"); break; } if ($doGo) echo "

$\"BACK\"/$

"; /* echo "

BACK

"; */ ?>