}
if ($_GET['Info1'] == 1) {
    $sql .= "Info2=NULL, ";
} else {
    $sql .= "Info2='" . $_GET['Info2'] . "', ";
}
$sql .= " Notes='" . $_GET['Notes'] . "', StartDate='" . join_date($_GET, 'StartDate') . "'";
//if ((isset($_GET['EndDate_year'])) && ($_GET['EndDate_year'] != ''))
//{
$sql .= ", EndDate='{$enddate}' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'";
//}
//else
//{
//	$sql .= " WHERE PatientCode='".$_GET['code']."' AND StartDate='".$_GET['start']."' AND EndDate='".$_GET['end']."'";
//}
$sql = replace2null($sql);
// form_data2table($_GET);
// echo "<pre>";
// echo $sql;
execute_query($sql);
// echo mysql_error();
// die;
execute_query("UPDATE hbv_antiiikes_treatments SET EndDate='{$enddate}', StartDate='" . join_date($_GET, 'StartDate') . "' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'");
// UPDATE StartDate Change in Dosages
execute_query("UPDATE hbv_antiiikes_treatments_dosages SET StartDate='" . join_date($_GET, 'StartDate') . "' WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start'] . "'");
// UPDATE EndDate Change in Dosages
execute_query("UPDATE hbv_antiiikes_treatments_dosages SET EndDate='{$enddate}' WHERE PatientCode='" . $_GET['code'] . "' AND EndDate='" . $_GET['end'] . "'");
perform_post_insert_actions("", "hbv_show_antiiikes_data.php?code=" . $_GET['code'], "");
mysql_close($dbconnection);
?>
</BODY></HTML>
示例#2
0
$result = execute_query($query3);
?>
 <div id=data style="display: none" class="img-shadow"> 
<?php 
query2table($result);
mysql_close($dbconnection);
?>
</div>
<div class="img-shadow">
<p style="display: block; border: 1px solid #a9a9a9">
This is a test sentence with shadow
</p>
</div>
<p>
<?php 
echo replace2null("Hello, ''");
?>
</p>
<script>
function show()
{
	if (document.all.data.style.display == "none")
	{
		document.all.data.style.display = "";
	}
	else
	{
		document.all.data.style.display = "none";
	}
}
</script>