本文整理汇总了PHP中perform_post_insert_actions函数的典型用法代码示例。如果您正苦于以下问题:PHP perform_post_insert_actions函数的具体用法?PHP perform_post_insert_actions怎么用?PHP perform_post_insert_actions使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了perform_post_insert_actions函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: mysql_error
else
{
$sql .= "NULL, ";
}
$sql .= "`NewClinic`=";
if ($_GET['Lost2FollowUp'] == 3)
{
$sql .= "'".$_GET['NewClinic']."', ";
}
else
{
$sql .= "NULL, ";
}
$sql .= "`Notes`='".$_GET['Notes_lost']."', ";
$sql .= "DeathDate=NULL, Immediate=NULL, Contributing1=NULL, Contributing2=NULL, Contributing3=NULL, Contributing4=NULL, Underlying=NULL ";
$sql .= " WHERE `PatientCode`='".$_GET['PatientCode']."'";
// echo $sql;
execute_query($sql);
echo mysql_error();
}
*/
?>
<?php
echo mysql_error();
mysql_close($dbconnection);
perform_post_insert_actions("last_state", "last_state.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例2: cohortdb_connect
<?php
$dbconnection = cohortdb_connect($cohort_db_server, $cohort_db_username, $cohort_db_password);
$db_selected = mysql_select_db($cohort_db_name, $dbconnection);
if (!$db_selected) {
die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error());
}
//if ($_GET['code'] == "" || !is_numeric($_GET['code']))
//{ die('Πρέπει να δωσετε ένα σωστό Κωδικό Ασθενή!'); }
check_patient($_GET['code']);
$sql = "UPDATE hbv_antiiikes_treatments_dosages SET EndDate='" . join_date($_GET, 'EndDate1') . "'";
$sql .= " WHERE PatientCode='" . $_GET['code'] . "' AND StartDate='" . $_GET['start1'] . "'";
$sql .= " AND Medicine='" . $_GET['Medicine'] . "' AND link_id='" . $_GET['link_id'] . "'";
execute_query($sql);
//echo "<pre>$sql";
//echo mysql_error();
$sql = "INSERT INTO hbv_antiiikes_treatments_dosages VALUES('" . $_GET['code'] . "', '" . $_GET['Medicine'] . "', ";
if ($_GET['dosage1'] != "") {
$sql .= "'" . replacecomma($_GET['dosage1']) . "', '" . $_GET['dosage1type'] . "', '" . $_GET['dosage2type'] . "', '";
} else {
$sql .= "NULL, NULL, NULL, '";
}
$sql .= join_date($_GET, 'StartDate2') . "', '" . $_GET['end2'] . "', '" . $_GET['link_id'] . "')";
execute_query($sql);
//echo "<pre>$sql";
//echo mysql_error();
mysql_close($dbconnection);
perform_post_insert_actions("", "hbv_show_antiiikes_data.php?code=" . $_GET['code'], "");
?>
</BODY></HTML>
示例3: execute_query
execute_query($sql);
$j = 0;
if ($_GET[$exams[$i]['Code'] . '_Unit'] == $exams[$i]['Unit1']) {
$j = 1;
}
if ($_GET[$exams[$i]['Code'] . '_Unit'] == $exams[$i]['Unit2']) {
$j = 2;
}
if ($_GET[$exams[$i]['Code'] . '_Unit'] == $exams[$i]['Unit3']) {
$j = 3;
}
if ($_GET[$exams[$i]['Code'] . '_Unit'] == $exams[$i]['Unit4']) {
$j = 4;
}
if ($_GET[$exams[$i]['Code'] . '_Unit'] == $exams[$i]['Unit5']) {
$j = 5;
}
if (replacecomma($_GET[$exams[$i]['Code'] . '_Lower']) != $exams[$i]['Lower' . $j] || replacecomma($_GET[$exams[$i]['Code'] . '_Upper']) != $exams[$i]['Upper' . $j]) {
// echo "<BR>".$_GET[$exams[$i]['Code'].'_Lower']." != ".$exams[$i]['Lower']."<BR>".$_GET[$exams[$i]['Code'].'_Upper']." != ".$exams[$i]['Upper']."<BR>";
$sql = "UPDATE `other_exams_list` SET Lower" . $j . "='" . replacecomma($_GET[$exams[$i]['Code'] . '_Lower']) . "', Upper" . $j . "='" . replacecomma($_GET[$exams[$i]['Code'] . '_Upper']) . "' WHERE Code='" . $exams[$i]['Code'] . "'";
// echo "<BR>$sql<BR>";
execute_query($sql);
// echo mysql_error();
}
}
}
mysql_close($dbconnection);
perform_post_insert_actions("exams_other", "other_exams.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例4: execute_query
$sql .= " WHERE PatientCode=" . $_GET['code'] . " AND NososSyndrom=" . $_GET['del_syndr_id_' . $i];
$sql .= " AND NososSyndromDate='" . $_GET['del_syndr_date_' . $i] . "';";
echo "<BR>" . $sql . "<BR><BR>";
$what_happened = execute_query($sql);
/* if ($what_happened == 1)
{
echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
}
else
{
echo "<P>".mysql_error()."$what_happened</P>";
}
*/
}
}
}
mysql_close($dbconnection);
perform_post_insert_actions("aids_clinical_status", "clinical_status.php?code=" . $_GET['code'], "");
?>
<!--
<p><a href='clinical_status.php?code=<?php
echo $_GET['code'];
?>
'>Κάντε click εδώ για επιστροφή</a></p>
<p><a href='atomic.php?code=<?php
echo $_GET['code'];
?>
'>Κάντε click εδώ για να καταχωρήσετε το ατομικό αναμνηστικό</a></p>
</BODY></HTML> -->
示例5: die
if (!$db_selected) {
die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error());
}
check_patient($_GET['PatientCode']);
//print_r($_GET);
//print_r($data_array2);
if ($_GET['EndDate_year'] == "") {
$enddate = "0000-00-00";
} else {
$enddate = join_date($_GET, 'EndDate');
}
$sql = "";
$sql = "INSERT INTO `iris` ( `PatientCode` , `StartDate` , `EndDate` , `What` , `Type` , `Antimetopisi`)";
$sql .= " VALUES ('" . $_GET['PatientCode'] . "', '" . join_date($_GET, 'StartDate');
$sql .= "', '" . $enddate . "', '" . $_GET['What'] . "', '" . $_GET['Type'] . "', '" . $_GET['Antimetopisi'];
$sql .= "');";
echo $sql;
$what_happened = execute_query($sql);
if ($what_happened == 1) {
echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
} else {
echo "<P>{$what_happened}</P>";
}
echo mysql_error();
//form_data2table($_GET);
mysql_close($dbconnection);
perform_post_insert_actions("iris", "iris.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例6: VALUES
} else {
$data_array2['Operator'] = $_GET['Operator2'];
}
$sql = "";
$sql = "INSERT INTO `hcv_iologikes` ( `PatientCode` , `ExamDate` , `Result` , `Value` , `Units`, `Operator`, `Method`)";
$sql .= " VALUES ( '" . $_GET['PatientCode'] . "', '" . join_date($data_array2, 'ExamDate') . "', '" . $data_array2['Result'] . "', ";
//if (is_numeric($data_array2['Value']))
//{
$sql .= "'" . $data_array2['Value'] . "', '" . $data_array2['Units'] . "', '" . $data_array2['Operator'] . "', ";
//}
//else
//{
// $sql .= "NULL, NULL, NULL, ";
//}
$sql .= " '" . $data_array2['Method'] . "')";
$sql = replace2null($sql);
//echo $sql;
$what_happened = execute_query($sql);
if ($what_happened == 1) {
// echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
} else {
// echo "<P>$what_happened</P>".mysql_error();
}
//form_data2table($_GET);
mysql_close($dbconnection);
perform_post_insert_actions("hcv_iologikes", "hcv_iolog_observe.php?code=" . $_GET['PatientCode'], "");
//echo "<p><a href='iologikes.php?code=".$_GET['PatientCode']."'>Καντε click εδώ για να καταχωρήσετε κι άλλη εξέταση</a></p>";
?>
</BODY></HTML>
示例7: execute_query
} else {
$sql .= " Heroin='-1', Hash='-1', Cocaine='-1', ";
$sql .= " OtherDrugName='', OtherDrugValue='-1', ";
}
if ($lipoatrofia != 0 && join_date($_GET, 'DateOfVisit') > $lipoatrofia) {
$sql .= " Lipoatrofia='" . $_GET['Lipoatrofia'] . "', ";
} else {
$sql .= " Lipoatrofia=NULL, ";
}
if ($enapothesi != 0 && join_date($_GET, 'DateOfVisit') > $enapothesi) {
$sql .= " Enapothesi='" . $_GET['Enapothesi'] . "', ";
} else {
$sql .= " Enapothesi=NULL, ";
}
$sql .= " PressureSystolic='" . $_GET['sad'] . "', PressureDiastolic='" . $_GET['dap'] . "' ";
$sql .= " WHERE PatientCode='" . $_GET['PatientCode'] . "' AND Clinic='" . $_GET['clinicid'] . "' AND DateofVisit='" . $_GET['visitdate'] . "';";
// echo $sql;
//echo "<BR><BR>";
$what_happened = execute_query($sql);
if ($what_happened == 1) {
// echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
// echo "<P><a href='clinical_status.php?code=".$data_array2['PatientCode']."'>Κάντε click εδώ για να εισάγετε την κλινική κατάσταση του ασθενή</a></P>";
} else {
echo mysql_error();
}
mysql_close($dbconnection);
perform_post_insert_actions("clinic_visits", "main.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例8: substr
$meds = substr($meds, 0, strlen($meds) - 3);
$sql = "";
$sql = "INSERT INTO `prophylactic_therapies` ";
$sql .= " VALUES ('" . $_GET['code'] . "', '" . $new_therapies[$i]['therapy'] . "', '" . $new_therapies[$i]['type'] . "', '" . $new_therapies[$i]['start'];
$sql .= "', '" . $new_therapies[$i]['end'] . "', '" . $new_therapies[$i]['reason'] . "', '" . $meds . "', '" . $new_therapies[$i]['note'] . "');";
echo $sql;
execute_query($sql);
}
}
/*
$sql = "";
$sql = "INSERT INTO `prophylactic_therapies` ( `PatientCode` , `Therapy` , `Type` , `StartDate` , `EndDate` , `Reason`)";
$sql .= " VALUES ('".$data_array2['PatientCode']."', '".$data_array2['Therapy'.$k]."', '".$data_array2['Type'.$k]."', '".$data_array2['StartDate'.$k];
$sql .="', '".$data_array2['EndDate'.$k]."', '".$data_array2['Reason'.$k]."');";
echo $sql;
$what_happened = execute_query($sql);
if ($what_happened == 1)
{
echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
}
else
{
echo "<P>$what_happened</P>";
}
*/
mysql_close($dbconnection);
perform_post_insert_actions("prophylactic_therapies", "prophylactic.php?code=" . $_GET['code'], "");
?>
</BODY></HTML>
示例9: execute_query
if ($_GET['GP120_' . $i . '_1'] != "") {
execute_query($sql);
}
}
// INSERT Medicine Resistance
for ($i = 0; $i < count($atccodes); $i++) {
if ($_GET['Score_' . $atccodes[$i]] != "-") {
$score = $_GET['Score_' . $atccodes[$i]];
if (isset($_GET['Boosting_' . $atccodes[$i]]) && $_GET['Boosting_' . $atccodes[$i]] == "on") {
$boosting = '1';
} else {
$boosting = '0';
}
$sql = "INSERT INTO `hiv_resistance_meds` VALUES('" . $_GET['PatientCode'] . "', '" . $_GET['SampleID'] . "', ";
$sql .= "'" . join_date($_GET, 'SeqDate') . "', '" . $atccodes[$i] . "', '" . $boosting . "', '" . $_GET['Score_' . $atccodes[$i]] . "')";
execute_query($sql);
}
}
// INSERT Extra Data
$sql = "INSERT INTO `hiv_resistance` VALUES('" . $_GET['PatientCode'] . "', '" . $_GET['SampleID'] . "', ";
$sql .= "'" . join_date($_GET, 'SampleDate') . "', '" . join_date($_GET, 'SeqDate') . "', '" . $_GET['Lab'] . "', '" . $_GET['Algorithm'] . "', ";
$sql .= "'" . $_GET['TestType'] . "')";
//echo $sql;
$what_happened = execute_query($sql);
echo mysql_error();
mysql_close($dbconnection);
perform_post_insert_actions("hiv_subtype", "hiv_resistance.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例10: execute_query
$sql .= "'" . $_POST['Note' . $i] . "');";
// echo $sql."<BR>";
$what_happened = execute_query($sql);
if ($what_happened == 1) {
// echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
} else {
// echo "<P>$what_happened</P>";
}
}
}
session_start();
session_unregister("antiretro_startdate");
$sql = "SELECT StartDate FROM antiretro_treatments WHERE PatientCode=" . $_GET['code'] . " GROUP BY StartDate";
$result = execute_query($sql);
if (mysql_num_rows($result) == 0) {
$_SESSION['antiretro_startdate'] = "3000-01-01";
} else {
$row = mysql_fetch_assoc($result);
$_SESSION['antiretro_startdate'] = $row['StartDate'];
}
mysql_free_result($result);
mysql_close($dbconnection);
perform_post_insert_actions("", "fix_antiretro.php?code=" . $_POST['code'], "");
//perform_post_insert_actions("", "antiretro.php?code=".$_POST['code'], "");
?>
<p><a href="javascript:location.href = 'antiretro.php?code=<?php
echo $_POST['code'];
?>
';">Καντε click εδώ για να εισάγετε και άλλα δεδομένα αντιρετροϊκών θεραπειών </a></p>
</BODY></HTML>
示例11: execute_query
$exams_sql = "SELECT * FROM orologikes_list";
$result = execute_query($exams_sql);
$exams = array();
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$row = mysql_fetch_assoc($result);
$exams[$i] = $row['Code'];
}
mysql_free_result($result);
$jump2conifection = 0;
for ($i = 0; $i < count($exams); $i++) {
if ($_GET[$exams[$i]] != "0") {
$sql = "";
$sql .= "INSERT INTO exams_orologikes VALUES (";
$sql .= "'" . $_GET['PatientCode'] . "', '" . join_date($_GET, $exams[$i] . 'Date') . "', '" . $exams[$i] . "', ";
$sql .= "'" . $_GET[$exams[$i]] . "');";
// echo $sql."<BR>";
execute_query($sql);
if (($exams[$i] == 'HBsAg' || $exams[$i] == 'Anti-HCV') && $_GET[$exams[$i]] == 1) {
$jump2conifection = 1;
}
}
}
mysql_close($dbconnection);
if ($jump2conifection) {
perform_post_insert_actions("exams_orologikes", "coinfection.php?code=" . $_GET['PatientCode'], "");
} else {
perform_post_insert_actions("exams_orologikes", "orologikes.php?code=" . $_GET['PatientCode'], "");
}
?>
</BODY></HTML>
示例12: VALUES
$_GET['Diagnosis'] = $_GET['DiagnosisICD'];
}
$sql = "";
$sql = "INSERT INTO `hospitalization` ( `PatientCode` , `EntryDate` , `ExitDate` , `Diagnosis` , `Ekbasi`)";
$sql .= " VALUES ('" . $data_array2['PatientCode'] . "', '" . join_date($data_array2, 'EntryDate') . "', '" . join_date($data_array2, 'ExitDate') . "'";
$sql .= ", '" . $data_array2['Diagnosis'] . "', '" . $data_array2['Ekbasi'] . "');";
//echo $sql;
$what_happened = execute_query($sql);
if ($what_happened == 1) {
// echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
} else {
// echo "<P>$what_happened</P>";
}
//form_data2table($_GET);
/*
$what_happened = execute_query($sql);
if ($what_happened == 1)
{
echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
}
else
{
echo "<P>$what_happened</P>";
}
*/
mysql_close($dbconnection);
perform_post_insert_actions("", "hospitalization.php?code=" . $_GET['PatientCode'], "");
?>
</BODY></HTML>
示例13: check_patient
check_patient($_GET['code']);
if (isset($_GET['count'])) {
for ($i = 0; $i < $_GET['count']; $i++) {
if (isset($_GET['del_therapy_sw_' . $i])) {
$sql = "";
$sql .= " DELETE FROM `other_treatments` ";
$sql .= " WHERE PatientCode=" . $_GET['code'];
$sql .= " AND Therapy='" . $_GET['del_therapy_id_' . $i] . "'";
$sql .= " AND StartDate='" . $_GET['del_therapy_startdate_' . $i] . "'";
$sql .= " AND EndDate='" . $_GET['del_therapy_enddate_' . $i] . "'";
// echo "<BR>".$sql."<BR><BR>";
$what_happened = execute_query($sql);
if ($what_happened == 1) {
// echo "<P>Τα δεδομένα διαγράφτηκαν με επιτυχία!</P>";
} else {
// echo "<P>$what_happened</P>";
}
}
}
}
perform_post_insert_actions("delete_therapies_other", getenv('HTTP_REFERER'), "");
mysql_close($dbconnection);
?>
<p><a href="javascript:location.href = '<?php
echo getenv('HTTP_REFERER');
?>
';">Κάντε click εδώ για επιστροφή</a></p>
</BODY></HTML>
示例14: execute_query
$sql .= " WHERE PatientCode='" . $_GET['code'] . "' AND ClinicalStatusID='" . $_GET['del_state_id_' . $i] . "'";
$sql .= " AND ClinicalStatusDate='" . $_GET['del_state_date_' . $i] . "'";
// echo "<BR>".$sql."<BR><BR>";
$what_happened = execute_query($sql);
/* if ($what_happened == 1)
{
echo "<P>Τα δεδομένα διαγράφτηκαν με επιτυχία!</P>";
}
else
{
echo "<P>$what_happened</P>";
} */
}
}
}
mysql_close($dbconnection);
perform_post_insert_actions("atomiko_anamnistiko", "atomic.php?code=" . $_GET['code'], "");
?>
<!--
<p><a href='atomic.php?code=<?php
echo $_GET['code'];
?>
'>Κάντε click εδώ για επιστροφή</a></p>
<p><a href='anosologikes.php?code=<?php
echo $_GET['code'];
?>
'>Κάντε click εδώ για να καταχωρήσετε ανοσολογικές εξετάσεις</a></p>
</BODY></HTML>
-->
示例15: cohortdb_connect
<?php
require_once './include/basic_defines.inc.php';
require_once './include/basic_functions.inc.php';
require_once './include/form_functions.inc.php';
$dbconnection = cohortdb_connect($cohort_db_server, $cohort_db_username, $cohort_db_password);
$db_selected = mysql_select_db($cohort_db_name, $dbconnection);
if (!$db_selected) {
die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error());
}
$code = $_GET['code'];
check_patient($code);
$query3 = "SELECT clinic_visits.PatientCode, Name, Surname, BirthDate, MAX(DateOfVisit) ";
$query3 .= "FROM clinic_visits, patients,last_state ";
$query3 .= "WHERE patients.PatientCode=clinic_visits.PatientCode AND patients.PatientCode=last_state.PatientCode AND ";
$query3 .= "last_state.LastState=1 AND clinic_visits.PatientCode='" . $code . "' ";
$query3 .= "GROUP BY PatientCode ";
$query3 .= "HAVING DATEDIFF(NOW(), MAX(DateOfVisit)) > 364";
$result = execute_query($query3);
//echo mysql_error();
$num = mysql_num_rows($result);
if ($num > 0) {
perform_post_insert_actions("", "jail.php?code=" . $code, "");
} else {
perform_post_insert_actions("", "main.php?code=" . $code, "");
}
mysql_close($dbconnection);