function method_deneme()
{
if (isset($_REQUEST['next']) || isset($_REQUEST['summary']) || isset($_REQUEST['viewsummary'])) {
//next question
$answerStatus = 'unanswered';
if (time() < strtotime($_SESSION['endtime'])) {
if (strcmp($answerStatus, "unanswered") != 0) {
if (strcmp($answerStatus, "answered") == 0) {
$query = "update studentquestion set answered='answered',stdanswer='" . htmlspecialchars($_REQUEST['answer'], ENT_QUOTES) . "' where stdid=" . $_SESSION['stdid'] . " and testid=" . $_SESSION['testid'] . " and qnid=" . $_SESSION['qn'] . ";";
} else {
$query = "update studentquestion set answered='review',stdanswer='" . htmlspecialchars($_REQUEST['answer'], ENT_QUOTES) . "' where stdid=" . $_SESSION['stdid'] . " and testid=" . $_SESSION['testid'] . " and qnid=" . $_SESSION['qn'] . ";";
}
if (!executeQuery($query)) {
// to do
$_GLOBALS['message'] = "Your previous answer is not updated.Please answer once again";
}
closedb();
}
}
if ((int) $_SESSION['qn'] < (int) $_SESSION['tqn']) {
$_SESSION['qn'] = $_SESSION['qn'] + 1;
}
if ((int) $_SESSION['qn'] == (int) $_SESSION['tqn']) {
$endOfTest = true;
}
} else {
if (isset($_REQUEST['previous'])) {
// Perform the changes for current question
$answerStatus = 'unanswered';
if (time() < strtotime($_SESSION['endtime'])) {
$questionStatus = $this->getQuestionStatus();
if (strcmp($answerStatus, "unanswered") != 0) {
if (strcmp($answerStatus, "answered") == 0) {
$query = "update studentquestion set answered='answered',stdanswer='" . htmlspecialchars($_REQUEST['answer'], ENT_QUOTES) . "' where stdid=" . $_SESSION['stdid'] . " and testid=" . $_SESSION['testid'] . " and qnid=" . $_SESSION['qn'] . ";";
} else {
$query = "update studentquestion set answered='review',stdanswer='" . htmlspecialchars($_REQUEST['answer'], ENT_QUOTES) . "' where stdid=" . $_SESSION['stdid'] . " and testid=" . $_SESSION['testid'] . " and qnid=" . $_SESSION['qn'] . ";";
}
if (!executeQuery($query)) {
// to do
$_GLOBALS['message'] = "Your previous answer is not updated.Please answer once again";
}
closedb();
}
}
//previous question
if ((int) $_SESSION['qn'] > 1) {
$_SESSION['qn'] = $_SESSION['qn'] - 1;
}
} else {
if (isset($_REQUEST['fs'])) {
//Final Submission
header('Location: testack.php');
}
}
}
}
function delSujetAtelier($id)
{
$sql = "DELETE FROM `tab_atelier_sujet` WHERE `id_sujet`='" . $id . "'\n\t";
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if (FALSE == $result) {
return FALSE;
} else {
return TRUE;
}
}
function conn_db($hostname, $username, $password, $database)
{
$link = mysql_connect($hostname, $username, $password);
if (!$link) {
//echo "Mysql Connect Error".mysql_error();
return false;
}
$ret = mysql_select_db($database);
if (!$ret) {
closedb($link);
return false;
}
set_encode($link);
return $link;
}
function createXls()
{
$page = getQUERY("page");
$from = getQUERY("from");
$page1 = $page;
$req = getQUERY("req");
$req1 = str_replace("**", "&", $req);
$url = "";
$temp = explode("&", $req1);
$cid = getQUERY("c");
$uid = getQUERY("u");
$sd = substr($temp[1], 3);
$ed = substr($temp[2], 3);
$lang = substr($temp[0], 2);
opendb();
/* format na datum */
$datetimeformat = dlookup("select datetimeformat from users where id=" . $uid);
//'Y-m-d h:i:s a'; //
$datfor = explode(" ", $datetimeformat);
$dateformat = $datfor[0];
$timeformat = $datfor[1];
if ($timeformat == "H:i:s") {
$e_ = " 23:59";
$e1_ = "_23:59";
$s_ = " 00:00";
$s1_ = "_00:00";
$tf = " H:i";
} else {
$e_ = " 11:59 PM";
$e1_ = "_11:59_PM";
$s_ = " 12:00 AM";
$s1_ = "_12:00_AM";
$tf = " h:i a";
}
$sdG = DateTimeFormat($sd, 'd-m-Y H:i:s');
$edG = DateTimeFormat($ed, 'd-m-Y H:i:s');
/* format na datum */
$nameXls = $page1 . '_' . $cid . '_' . DateTimeFormat($sdG, $dateformat) . $s1_ . '_' . DateTimeFormat($edG, $dateformat) . $e1_ . '.xls';
$url = $page . "1.php?l=" . $lang . "&u=" . $uid . "&c=" . $cid . "&sd=" . DateTimeFormat($sd, "d-m-Y") . "%2000:00:00&ed=" . DateTimeFormat($ed, "d-m-Y") . "%2023:59:00&from=s";
closedb();
if ($from == "s") {
$handle = fopen('../savePDF/' . $nameXls, 'w+') or die('Cannot open file: ' . $nameXls);
$data = file_get_contents("http://panorama.gps.mk/settings/" . $url);
fwrite($handle, $data);
fclose($handle);
echo $nameXls;
}
}
?>
<span class="text2" style="font-style:italic; color:#153B75; font-size:12px"><?php
echo dic_("Reports.NoDataDay");
?>
</span></strong></td>
</tr>
<?php
}
?>
</table>
<?php
$_datumCnt = addToDate($_datumCnt, 1, "days");
}
closedb();
?>
<br /><br />
</div><br>
<div id="footer-rights-new" class="textFooter" style="padding:10px 10px 10px 10px">
<?php
echo $CopyrightString;
?>
| <?php
echo session("company");
?>
| <?php
echo session("user_fullname");
?>
| <?php
echo $CreationDate;
</tr>
<?php
while ($row = mysql_fetch_array($ret)) {
$i = $i + 1;
if ($row['type'] == 1) {
$type = "judgement";
} elseif ($row['type'] == 2) {
$type = "fill";
} else {
$type = "choice";
}
$query1 = "SELECT * FROM " . $type . "_" . $row['chapter'] . " WHERE " . $type . "_no=" . $row['no'];
$ret1 = mysql_query($query1, $link);
if (!$ret1) {
echo "query ERROR";
closedb($link);
exit;
}
$row1 = mysql_fetch_row($ret1);
?>
<tr>
<td align="center">
<?php
echo $row1[1];
?>
</td>
<td align="center" width="600px">
<?php
echo $row1[2];
#!/usr/bin/php -q
<?php
////////////////////////////////////////////////////////////////////////////
// $Id$
//
// Description: statistics cleanup
//
////////////////////////////////////////////////////////////////////////////
include "cleanup-functions.php";
include "cleanup-config.php";
// ************* PRELIMINARY TASKS, DATA INIT *************
set_time_limit(0);
// get for which revision we generate stats
if ($argv[1] == "") {
$rev = "HEAD";
} else {
$rev = $argv[1];
}
// open database connection
$dbh = initdb($sql_host, $sql_user, $sql_pass, $sql_db);
debug(10, "cleanup statistics");
$res = @mysql_query("DELETE FROM essential WHERE rev='{$rev}' AND " . "sdate < DATE_SUB(NOW(),INTERVAL '60' DAY)", $dbh);
if (!$res) {
send_err("SQL error: delete by sdate for {$rev} branch.");
die;
}
$deleted = @mysql_affected_rows($dbh);
debug(10, "deleted {$deleted} records for {$rev} branch");
closedb($dbh);
// send_ok("Deleted $deleted records for $rev branch.");
public static function redirect($url, $cnd = true)
{
if ($cnd) {
closedb();
header("Location: " . $url);
exit(0);
}
}
if(radios[i].checked === true) {
return radios[i].value;
}
}
}
$(document).ready(function(){
$('.del-btn').button({ icons: { primary: "ui-icon-trash"} });
$('.edit-btn').button({ icons: { primary: "ui-icon-pencil"} });
$('#add5').button({ icons: { primary: "ui-icon-plusthick"} });
$('#play').button({ icons: { primary: "ui-icon-play"} });
$('#pause').button({ icons: { primary: "ui-icon-pause"} });
$('#poglasno').button({ icons: { primary: "ui-icon-plus"} });
$('#potivko').button({ icons: { primary: "ui-icon-minus"} });
$('#gfAvail').buttonset();
$('#main_table tr td:nth-child(3) div').hide();
setDates();
top.HideWait();
});
</script>
</html>
<?php closedb(); ?>
function enterConnexionstatus($iduser, $date, $type, $macadress, $navig, $exploitation)
{
$sql = "INSERT INTO `tab_connexion`(`id_connexion`, `id_user`, `date_cx`, `type_cx`, `macasdress_cx`, `navigateur_cx`, `system_cx`) \n\tVALUES ('','" . $iduser . "','" . $date . "','" . $type . "','" . $macadress . "','" . $navig . "','" . $exploitation . "')";
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if ($result == TRUE) {
return TRUE;
} else {
return FALSE;
}
}
function eachResult($iID)
{
//显示基本信息信息
echo '<font style="color:red;font-weight:bold;">一：基本信息：</font><br/><br/>';
$query = "select formid from Basic" . $iID . " where formid=1;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question1 = array('姓名', '年龄（周岁）', '性别', '受教育程度', '年级', '民族', '宿舍号', '电话', '身高（cm）', '体重（kg）', 'Email', '身份证号', '个人编号', '出生地', '大学前长居住地', '睡眠时间是否规律', '每日平均睡眠时间（小时）', '每日平均睡眠时间（分钟）', '是否有午休习惯', '一周几次', '一次多长时间', '过去一年是否从事倒班工作', '几次', '过去三个月是否进行跨越1个时区以上的旅行', '如有，请注明时间地点', '有无睡眠相关疾病', '如有，请说疾病名称和患病时间', '平均每周饮酒', '平均每周饮咖啡', '您的月经周期是否规律', '您的月经周期', '平均每次月经持续时间', '初潮年龄');
for ($i = 1; $i <= 33; $i++) {
$query = "select * from Basic" . $iID . " where formid=1 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question1[$i - 1] . '</font>：' . $r[3] . '<br/>';
}
}
//BMI指数计算
echo '<font style="color:#0000FF;font-weight:bold;">BMI指数：</font>';
$query = "call BMI('Basic" . $iID . "',@output);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
$r = mysql_fetch_row($result);
echo $r[0];
mysql_free_result($result);
}
closedb();
//显示表二的信息
echo '<br/><br/><font style="color:red;font-weight:bold;">二：睡眠研究问卷调查：</font>';
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表二：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=2;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question2 = array('1.', '2.', '3.', '4.', '5(1).', '5(2).', '5(3).', '5(4).', '5(5).', '5(6).', '5(7).', '5(8).', '5(9).', '5(10).', '5(10)', '6.', '7', '8', '9', '10', '10(1).', '10(2).', '10(3).', '10(4).', '10(5).', '10(5)');
for ($i = 1; $i <= 26; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=2 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question2[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示表二计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score2('PartTwo" . $iID . "',@A,@B,@c,@D,@E,@F,@G,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">睡眠质量(A):</font>' . $r[0] . '     <font style="color:#0000FF">入睡时间(B):</font>' . $r[1] . '     <font style="color:#0000FF">睡眠时间(C):</font>' . $r[2] . '     <font style="color:#0000FF">睡眠效率(D):</font>' . $r[3] . '     <font style="color:#0000FF">睡眠障碍(E):</font>' . $r[4] . '     <font style="color:#0000FF">催眠药物(F):</font>' . $r[5] . '     <font style="color:#0000FF">日间功能障碍(G):</font>' . $r[6] . '     <font style="color:#0000FF">PSQI总分:</font>' . $r[7] . '<br/><br/>';
}
mysql_free_result($result);
}
closedb();
//显示表三的信息
echo '<font style="color:#E99324;font-weight:bold;">表三：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=3;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question3 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8');
for ($i = 1; $i <= 8; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=3 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question3[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示表三计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',3,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] > 6 && $r[0] < 12) {
echo '瞌睡';
} elseif ($r[0] > 11 && $r[0] < 17) {
echo '过度瞌睡';
} elseif ($r[0] > 16) {
echo '有危险性的瞌睡';
}
}
mysql_free_result($result);
}
closedb();
//显示表四的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表四：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=4;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question4 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19');
for ($i = 1; $i <= 19; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=4 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question4[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',4,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] > 15 && $r[0] < 43) {
echo '绝对夜晚型';
} elseif ($r[0] > 42 && $r[0] < 50) {
echo '中度夜晚型';
} elseif ($r[0] > 49 && $r[0] < 63) {
echo '中间型';
} elseif ($r[0] > 62 && $r[0] < 70) {
echo '中度清晨型';
} elseif ($r[0] > 69 && $r[0] < 87) {
echo '绝对清晨型';
}
}
mysql_free_result($result);
}
closedb();
//显示表五的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表五：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=5;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question5 = array('1(1).', '1(2).', '2.', '3.', '4(1).', '4(2).', '5.', '6(1).', '6(2).', '7(1).', '7(2).', '8(1).', '8(2).', '1.', '2(1).', '2(2).', '3.', '4.', '5.', '6(1).', '6(2).', '7.', '8(1).', '8(2).', '9(1).', '9(2).', '10(1)', '10(2)', '1.', '2.', '3.', '4.', '5(1).', '5(2).', '5(3).', '5(4).');
for ($i = 1; $i <= 36; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=5 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question5[$i - 1] . '</font> ' . $r[3] . '  ';
if ($i == 4) {
$n = $r[3];
}
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score5('PartTwo" . $iID . "',@A,@B,@C,@D,@E,@F,@G,@H,@I,@J,@k,@l,@m);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">工作日睡觉时间:</font>' . $r[0] . '     <font style="color:#0000FF">工作日睡醒时间:</font>' . $r[1] . '     <font style="color:#0000FF">工作日完全清醒时间:</font>' . $r[2] . '     <font style="color:#0000FF">工作日中间时间:</font>' . $r[3] . '     <font style="color:#0000FF">工作日持续时间:</font>' . $r[4] . '     <font style="color:#0000FF">休息日睡觉时间:</font>' . $r[5] . '     <font style="color:#0000FF">休息日睡醒时间:</font>' . $r[6] . '     <font style="color:#0000FF">休息日完全清醒时间:</font>' . $r[7] . '     <br/><font style="color:#0000FF"> 休息日中间时间:</font>' . $r[8] . '     <font style="color:#0000FF">休息日持续时间:</font>' . $r[9] . '    <font style="color:#0000FF">户外时间:</font>' . $r[12] . '       ';
echo '<font style="color:#0000FF">类型：</font>';
if ($n == "A") {
if ($r[10] < 121) {
echo 'extreme early';
} elseif ($r[10] > 120 && $r[10] < 181) {
echo 'moderate early';
} elseif ($r[10] > 180 && $r[10] < 241) {
echo 'slight early';
} elseif ($r[10] > 240 && $r[10] < 301) {
echo 'normal';
} elseif ($r[10] > 300 && $r[10] < 361) {
echo 'slight late';
} elseif ($r[10] > 360 && $r[10] < 421) {
echo 'moderate late';
} elseif ($r[10] > 420) {
echo 'extreme late';
}
} elseif ($n == "B") {
if ($r[10] < 121) {
echo 'extreme early';
} elseif ($r[10] > 120 && $r[10] < 181) {
echo 'moderate early';
} elseif ($r[10] > 180 && $r[10] < 241) {
echo 'slight early';
} elseif ($r[10] > 240 && $r[10] < 301) {
echo 'normal';
} elseif ($r[10] > 300 && $r[10] < 361) {
echo 'slight late';
} elseif ($r[10] > 360 && $r[10] < 421) {
echo 'moderate late';
} elseif ($r[10] > 420) {
echo 'extreme late';
}
echo "（休息日）";
if ($r[11] < 121) {
echo 'extreme early';
} elseif ($r[11] > 120 && $r[11] < 181) {
echo 'moderate early';
} elseif ($r[11] > 180 && $r[11] < 241) {
echo 'slight early';
} elseif ($r[11] > 240 && $r[11] < 301) {
echo 'normal';
} elseif ($r[11] > 300 && $r[11] < 361) {
echo 'slight late';
} elseif ($r[11] > 360 && $r[11] < 421) {
echo 'moderate late';
} elseif ($r[11] > 420) {
echo 'extreme late';
}
echo "（工作日）";
}
}
mysql_free_result($result);
}
closedb();
//显示表六的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表六：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=6;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question6 = array('1(1).', '1(2).', '1(3).', '2.', '3.', '4.', '5.');
for ($i = 1; $i <= 7; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=6 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question6[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',6,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] < 8) {
echo '没有临床上显著的失眠症';
} elseif ($r[0] > 7 && $r[0] < 15) {
echo '阈下失眠症';
} elseif ($r[0] > 14 && $r[0] < 22) {
echo '临床失眠症（中重度）';
} elseif ($r[0] > 62 && $r[0] < 70) {
echo '中度清晨型';
} elseif ($r[0] > 21 && $r[0] < 29) {
echo '临床失眠症（重度）';
}
}
mysql_free_result($result);
}
closedb();
//显示表七的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表七：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=7;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question7 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8.', '9.', '10.', '11.', '12.', '13.', '14.', '15.', '16.', '17.', '18.', '19.', '20.', '21.');
for ($i = 1; $i <= 21; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=7 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question7[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',7,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] < 5) {
echo '无抑郁';
} elseif ($r[0] > 4 && $r[0] < 8) {
echo '轻度抑郁';
} elseif ($r[0] > 7 && $r[0] < 16) {
echo '中度抑郁';
} elseif ($r[0] > 15) {
echo '重度抑郁';
}
}
mysql_free_result($result);
}
closedb();
//显示表八的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表八：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=8;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question8 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8.', '9.', '10.', '11.', '12.', '13.', '14.', '15.', '16.', '17.', '18.', '19.', '20.', '21.');
for ($i = 1; $i <= 21; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=8 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question8[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',8,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . round(1.19 * $r[0]) . '   ';
if ($r[0] > 44) {
echo '焦虑阳性';
}
}
mysql_free_result($result);
}
closedb();
//显示表九的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表九：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=9;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question9 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8.', '9.', '10.', '11.', '12.', '13.', '14.', '15.', '16.', '17.', '18.', '19.', '20.');
for ($i = 1; $i <= 20; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=9 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question9[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $iID . "',9,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] < 8) {
echo '没有临床上显著的失眠症';
} elseif ($r[0] > 7 && $r[0] < 15) {
echo '阈下失眠症';
} elseif ($r[0] > 14 && $r[0] < 22) {
echo '临床失眠症（中重度）';
} elseif ($r[0] > 62 && $r[0] < 70) {
echo '中度清晨型';
} elseif ($r[0] > 21 && $r[0] < 29) {
echo '临床失眠症（重度）';
}
}
mysql_free_result($result);
}
closedb();
//显示表十的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表十：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=10;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question10 = array('1.', '2.', '3(1).', '3(2).', '3(3).', '3(4).', '3(5).', '3(6).', '3(7).', '3(8).', '3(9).', '3(10).', '4(1).', '4(2).', '4(3).', '4(4).', '5(1).', '5(2).', '5(3).', '6.', '7.', '8.', '9(1).', '9(2).', '9(3).', '9(4).', '9(5).', '9(6).', '9(7).', '9(8).', '9(9).', '9(10).', '10(1).', '10(2).', '10(3).', '10(4).');
for ($i = 1; $i <= 36; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=10 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question10[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score10PF('PartTwo" . $iID . "',@PF);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">PF:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10RP('PartTwo" . $iID . "',@RP);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">RP:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10BP('PartTwo" . $iID . "',@BP);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">BP:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10GH('PartTwo" . $iID . "',@GH);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">GH:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10VT('PartTwo" . $iID . "',@VT);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">VT:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10SF('PartTwo" . $iID . "',@SF);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SF:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10RE('PartTwo" . $iID . "',@RE);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">RE:</font>' . $r[0] . '     ';
}
closedb();
$query = "call score10MH('PartTwo" . $iID . "',@MH);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">MH:</font>' . $r[0] . '     ';
}
mysql_free_result($result);
}
closedb();
//显示表十一的信息
echo '<br/><br/><font style="color:#E99324;font-weight:bold;">表十一：</font><br/>---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>';
$query = "select formid from PartTwo" . $iID . " where formid=11;";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
if (mysql_fetch_row($result)) {
//显示信息
$question11 = array('1.', '2.', '3.', '4.', '5.', '6.', '7.', '8.', '9.', '10.', '11.', '12.', '13.');
for ($i = 1; $i <= 13; $i++) {
$query = "select * from PartTwo" . $iID . " where formid=11 and questionid=" . $i . ";";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
if ($r[3] == '') {
$r[3] = '此处没有填写';
}
echo '<font style="color:#0000FF">' . $question11[$i - 1] . '</font> ' . $r[3] . '  ';
}
}
//显示计算结果
echo '<br/><br/><font style="color:#0000FF;font-weight:bold;">结论：</font><br/><br/>';
$query = "call score('PartTwo" . $_REQUEST[ID] . "',11,@score);";
$result = executeQuery($query);
if (!$result) {
die(mysql_error());
}
while ($r = mysql_fetch_row($result)) {
echo '<font style="color:#0000FF">SCORE:</font>' . $r[0] . '   ';
if ($r[0] < 23) {
echo '“夜晚”型';
} elseif ($r[0] > 7 && $r[0] < 15) {
echo '阈下失眠症';
} elseif ($r[0] > 23 && $r[0] < 43) {
echo '中间型';
} elseif ($r[0] > 43) {
echo '“清晨”型';
}
}
mysql_free_result($result);
}
closedb();
}
function getResaBy2dates($id, $date1, $date2)
{
$sql = "SELECT `id_resa`,`dateresa_resa`,`debut_resa`,`duree_resa`,nom_computer FROM tab_resa \n INNER JOIN tab_computer ON id_computer=id_computer_resa\n WHERE `id_user_resa`=" . $id . " \n\t\tAND `dateresa_resa` BETWEEN '" . $date1 . "' AND '" . $date2 . "'\n\t\tORDER BY `dateresa_resa` DESC , `debut_resa` DESC";
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if (FALSE == mysqli_num_rows($result)) {
return FALSE;
} else {
return $result;
}
}
function insertCapt()
{
$sql = "INSERT INTO `tab_captcha`(`id_captcha`, `capt_activation`, `capt_code`) VALUES (1,'N','') ;";
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if (FALSE == $result) {
$row = "echec";
} else {
$row = "OK";
}
return $row;
}
$sql = "INSERT INTO " . $table;
$fields = array();
$values = array();
foreach ($_GET as $key => $val) {
$column = $key;
echo "<br>{$key} = {$val}<br>";
$fields[] = "`{$key}`";
$values[] = "'" . $val . "'";
$mysqli = connectdb($dbhost, $dbuser, $dbpassword, $db);
// connect to database
createdbcol($mysqli, $column, $table);
// create columns
}
senddbdata($sql, $mysqli, $fields, $values);
// send data
closedb($mysqli);
// close database
// connect to database
function connectdb($dbhost, $dbuser, $dbpassword, $db)
{
$mysqli = new mysqli("{$dbhost}", "{$dbuser}", "{$dbpassword}", "{$db}");
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit;
}
return $mysqli;
}
// create column
function createdbcol($mysqli, $column, $table)
{
function getCyberSpec($epn)
{
$sql = "SELECT * FROM `tab_espace` WHERE `id_espace`='" . $epn . "' ";
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if (FALSE == $result) {
return FALSE;
} else {
return mysqli_fetch_array($result);
}
}
