$ex = explode('-', $begin); $y = $ex[2] - 543; $m = $ex[1]; $d = $ex[0]; return $y . '-' . $m . '-' . $d; } else { return ''; } } public function check_query($str) { return mysql_query($str) or die("Can 't connect MYSQL SERVER!!"); } } //http://127.0.0.1/report_pdf/appendix_report/query_case3.php?begin=03-11-2542&end=07-11-2557 $esn = new query3(); $begin = trim($_GET['begin']); $end = trim($_GET['end']); $b_conv = $esn->date_eng_format($begin); $e_conv = $esn->date_eng_format($end); $b = $esn->date_eng_format($begin); $e = $esn->date_eng_format($end); ##------------------ giveinformation --------------- $tb1_ = " `06_giveinformation`"; $i = 1; $arr_give = array('- What \'s your disease?', '- What \'s treatment?', '- How to manage the side effect?', '- Bring medication to each visit?', '- How to correct be havior?', '- Ohter'); $givearr = array(); $result_give_yes = array(); $result_give_no = array(); while ($i <= 5) { $g = '`GiveInformation' . $i . '`';
{ return mysql_query($str) or die("Can 't connect MYSQL SERVER!!"); } public function query_tb($hn, $fname, $wr) { /* SELECT HN, count( `GiveInformation1` ) FROM `06_giveinformation` WHERE `HN` = 'AA0096' GROUP BY `GiveInformation1` HAVING `GiveInformation1` = 'Y' */ return $this->str_ = " SELECT {$fname}\n FROM `06_giveinformation`\n WHERE `HN` = '{$hn}' \n AND `{$fname}` = 'Y' " . $wr; } } $esn = new query3(); $begin = trim($_REQUEST['begin']); $end = trim($_REQUEST['end']); $b_conv = $esn->date_eng_format($begin); $e_conv = $esn->date_eng_format($end); #$hn=trim($_REQUEST["hn"]); //ของเดิม $hn = trim($_REQUEST["HN"]); //echo "<br>"; $fname = "GiveInformation1"; $result_give_yes[] = array(); if (strlen($hn) == 6) { $z = 1; while ($z <= 5) { $fname = "GiveInformation" . $z; //AND `MonitoringDate` BETWEEN ' $b_conv' AND '$e_conv' "; $wr = " AND `MonitoringDate` BETWEEN ' {$b_conv}' AND '{$e_conv}' ";
SELECT DISTINCT ( HN ) FROM `06_giveinformation` LIMIT 0 , 30 */ /* return $this->str_ = " SELECT $fname FROM `06_giveinformation` WHERE `HN` = '$hn' AND `$fname` = 'Y' ; "; */ return $this->str_ = " SELECT \n DISTINCT ( HN )\n FROM " . $fname; } } $esn = new query3(); $result_give_yes[] = array(); $begin = trim($_REQUEST['begin']); $end = trim($_REQUEST['end']); $b_conv = $esn->date_eng_format($begin); $e_conv = $esn->date_eng_format($end); $tb = "`06_giveinformation`"; $field_name = "GiveInformation1"; $fname = $tb . " WHERE `MonitoringDate` BETWEEN ' {$b_conv}' AND '{$e_conv}' AND "; # WHERE `MonitoringDate` BETWEEN ' $b_conv' AND '$e_conv' // echo $esn->query_tb($fname); $z = 1; while ($z <= 5) { $fname_ = " GiveInformation" . $z . " ='Y' ;"; #echo $strQue_= $esn->query_tb($hn,$fname); $strQue_ = $esn->query_tb($fname . $fname_);