$timeB $timeE\n";
}
$Replay = $_POST["group1"];
$HMS_Q = $_POST["group2"];
$BETA_Q = $_POST["group3"];
$HMS_COL = $_POST["group4"];
$HP = $_POST["hp"];
$HMS_P = $_POST["hms_p"];
$HMS_T = $_POST["hms_t"];
$B_rate = $_POST["B_rate"];
$d_time = $_POST["d_time"];
$Energy = $_POST["eng"];
$Current = $_POST["current"];
$Field = $_POST["field"];
$Fieldo = $_POST["Fieldo"];
$Target = $_POST["Target"];
$TargetPos = $_POST["Cell"];
$PolarizationB = $_POST["PBrun"];
$PolarizationE = $_POST["PErun"];
$Nevents = $_POST["Nevents"];
$ps1= $_POST["ps1"];
$ps2= $_POST["ps2"];
$ps3= $_POST["ps3"];
$ps4= $_POST["ps4"];
$ps5= $_POST["ps5"];
$st=true;
if (isset($_POST["InputData"])) {
if(empty($Run)){echo "
FILL RUN INFO\n"; $st=false;}
if(empty($timeB)){echo "
FILL TIME\n"; $st=false;}
if(empty($timeE)){echo "
FILL TIME\n"; $st=false;}
if(empty($HMS_P)||empty($HMS_T)){echo "
FILL HMS\n"; $st=false;}
if(empty($B_rate)){$B_rate=0; $st=false;}
if(empty($d_time)){echo "
FILL Dead time\n"; $st=false;}
if(empty($Energy)){echo "
FILL Energy\n"; $st=false;}
if(empty($Current)){echo "
FILL Current\n"; $st=false;}
if(empty($PolarizationB)||empty($PolarizationE)){echo "
FILL Polarization\n"; $st=false;}
if(empty($Nevents)){echo "
FILL Nevents\n"; $st=false;}
if(empty($ps1)||empty($ps2)||empty($ps3)||empty($ps4)||empty($ps5)){echo "
FILL PS\n"; $st=false;}
if($st){
$Coments= $_POST["coments"];
$raster = $_POST["raster"];
$rsize = $_POST["rsize"];
$COM= "Rater -$raster Size -$rsize HalF Plate -$HP : $Coments";
$con = mysql_connect("jmysql.jlab.org","hallc_sane","hcSANE08");
mysql_select_db("hallcweb",$con);
$sql = "INSERT INTO sane_run VALUES($Run, '$dateB'";
$sql = "$sql, '$dateE'";
$sql = "$sql, $Energy, $Current, $Field, '$Fieldo', '$Target', $B_rate";
$sql = "$sql, $HMS_P, $HMS_T, '$HMS_COL', $PolarizationB, $PolarizationE, $Nevents";
$sql = "$sql, $d_time, $ps1, $ps2, $ps3, $ps4, $ps5, '$Replay', 'HMS=$HMS_Q BETA=$BETA_Q', '$COM')";
echo "
$sql\n";
echo "
Filling Database\n";
$result = mysql_query($sql,$con);
}
}
else if (isset($_POST["GetData"])) {
$con = mysql_connect("jmysql.jlab.org","hallc_sane","hcSANE08");
mysql_select_db("hallcweb",$con);
$sql = "SELECT * FROM sane_run WHERE run_number>=$Run AND run_number<$Run_E";
$result = mysql_query($sql,$con);
print "\n";
print "\n";
while ($field = mysql_fetch_field($result)){
print " | $field->name | \n";
}
print "
\n\n";
while ($row = mysql_fetch_assoc($result)){
print "\n";
foreach ($row as $col=>$val){
print " | $val | \n";
}
print "
\n\n";
}
print "
\n";
}
else if (isset($_POST["UData"])) {
echo "Updating";
if(empty($Run)){echo "
FILL RUN INFO\n"; $st=false;}
if(empty($timeB)){echo "
FILL TIME\n"; $st=false;}
if(empty($timeE)){echo "
FILL TIME\n"; $st=false;}
if(empty($HMS_P)||empty($HMS_T)){echo "
FILL HMS\n"; $st=false;}
if(empty($B_rate)){$B_rate=0; $st=false;}
if(empty($d_time)){echo "
FILL Dead time\n"; $st=false;}
if(empty($Energy)){echo "
FILL Energy\n"; $st=false;}
if(empty($Current)){echo "
FILL Current\n"; $st=false;}
if(empty($PolarizationB)||empty($PolarizationE)){echo "
FILL Polarization\n"; $st=false;}
if(empty($Nevents)){echo "
FILL Nevents\n"; $st=false;}
if(empty($ps1)||empty($ps2)||empty($ps3)||empty($ps4)||empty($ps5)){echo "
FILL PS\n"; $st=false;}
if($st){
$Coments= $_POST["coments"];
$raster = $_POST["raster"];
$rsize = $_POST["rsize"];
$COM= "Rater -$raster Size -$rsize HalF Plate -$HP : $Coments";
$con = mysql_connect("jmysql.jlab.org","hallc_sane","hcSANE08");
mysql_select_db("hallcweb",$con);
$sql = "UPDATE sane_run Set start_time='$timeB' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set end_time='$timeE' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set energy='$Energy' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set current='$Current' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set field='$Field' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set orientation='$Fieldo' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set target='$Target' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set BC_rate='$B_rate' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set HMS_p='$HMS_P' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set HMS_theta='$HMS_T' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set HMS_collimator='$HMS_COL' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set pol_start='$PolarizationB' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set pol_stop='$PolarizationE' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set nevents='$Nevents' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set comp_dead_time='$d_time' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set ps1='$ps1' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set ps2='$ps2' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set ps3='$ps3' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set ps4='$ps4' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set ps5='$ps5' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set replay='$Replay' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set quality='HMS=$HMS_Q BETA=$BETA_Q' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
$sql = "UPDATE sane_run Set comment='$COM' WHERE run_number=$Run ";
$result = mysql_query($sql,$con);
echo "
$sql\n";
// $sql = "$sql, '$dateE'";
// $sql = "$sql, $Energy, $Current, $Field, '$Fieldo', '$Target', $B_rate";
// $sql = "$sql, $HMS_P, $HMS_T, '$HMS_COL', $PolarizationB, $PolarizationE, $Nevents";
// $sql = "$sql, $d_time, $ps1, $ps2, $ps3, $ps4, $ps5, '$Replay', 'HMS=$HMS_Q BETA=$BETA_Q', '$COM')";
// echo "
$sql\n";
// echo "
Filling Database\n";
// $result = mysql_query($sql,$con);
}
}
?>