" target="_blank"> |
Add new Aliquot Location |
|
|
|
| Sorry, as a guest you don't have permission for entering new data! If you want to search for existing DNA data please use the Search function! | "; }
else {
if($formSubmitSaveBox)
{
if(empty($formNewBox))
{ unset($formNewBox); }
else
{
$result= mysqli_query($GLOBALS["___mysqli_ston"], "SELECT ID_Aliquots_Box, Aliquots_Box FROM aliquots_box " .
"WHERE Aliquots_Box = '$formNewBox'");
if(mysqli_num_rows($result))
{
echo "Entry already exists!";
}
else
{
$result = "INSERT INTO aliquots_box (Aliquots_Box, Created_Who)" .
"VALUES ('$formNewBox','$log')";
$sql = mysqli_query($GLOBALS["___mysqli_ston"], $result);
#######################################Error 1###############################################################
if(!$sql)
{ $msg = $result."\n";
$msg .= "####Error 1####";
if($debug == '1') echo $msg;
trigger_error($msg, E_USER_ERROR);
/**
* calling Error message
*/
include ("Errorreport.php"); }
#############################################################################################################
else {
include("../config/ChangesAccepted.php"); }
}
}
}//if ($formSubmitSaveBox)
if($formSubmitSaveRack)
{
if(empty($formNewRack))
{ unset($formNewRack); }
else
{
$result= mysqli_query($GLOBALS["___mysqli_ston"], "SELECT ID_Aliquots_Rack, Aliquots_Rack FROM aliquots_rack " .
"WHERE Aliquots_Rack = '$formNewRack'");
if(mysqli_num_rows($result))
{
echo " Entry already exists!";
}
else
{
$result = "INSERT INTO aliquots_rack (Aliquots_Rack, Created_Who)" .
"VALUES ('$formNewRack','$log')";
$sql = mysqli_query($GLOBALS["___mysqli_ston"], $result);
#######################################Error 2###############################################################
if(!$sql)
{ $msg = $result."\n";
$msg .= "####Error 2####";
if($debug == '1') echo $msg;
trigger_error($msg, E_USER_ERROR);
/**
* calling Error message
*/
include ("Errorreport.php"); }
#############################################################################################################
else {
echo "Changes accepted!"; }
}
}
}//if ($formSubmitSaveRack)
if($formSubmitSaveFridge)
{
if(empty($formNewFridge))
{ unset($formNewFridge); }
else
{
$result= mysqli_query($GLOBALS["___mysqli_ston"], "SELECT ID_Aliquots_Fridge, Aliquots_Fridge FROM aliquots_fridge " .
"WHERE Aliquots_Fridge = '$formNewFridge'");
if(mysqli_num_rows($result))
{
echo " Entry already exists!";
}
else
{
$result = "INSERT INTO aliquots_fridge (Aliquots_Fridge, Created_Who)" .
"VALUES ('$formNewFridge','$log')";
$sql = mysqli_query($GLOBALS["___mysqli_ston"], $result);
#######################################Error 3###############################################################
if(!$sql)
{ $msg = $result."\n";
$msg .= "####Error 3####";
if($debug == '1') echo $msg;
trigger_error($msg, E_USER_ERROR);
/**
* calling Error message
*/
include ("../config/Errorreport.php"); }
#############################################################################################################
else {
echo "Changes accepted!"; }
}
}
}//if ($formSubmitSaveFridge)
}
?>
'0') { echo "| Box | ";
while ($row = mysqli_fetch_object($resultB))
{
echo "| ".$row->Aliquots_Box." | ";
}}
else { echo "No entry for 'box' found."; }
?>
'0') { echo "| Rack | ";
while ($row = mysqli_fetch_object($resultR))
{ echo "| ".$row->Aliquots_Rack." | ";
}}
else { echo "No entry for 'rack' found."; }
?>
|
'0') { echo "| Fridge | ";
while ($row = mysqli_fetch_object($resultF))
{ echo "| ".$row->Aliquots_Fridge." | ";
}}
else { echo "No entry for 'fridge' found."; }
?>
|
|
|
|
| After closing this window you have to reload your input form. |
|