session_start(); /* 未登入會員的網友,不得進入到會員資料的頁面 */ include ("vaild.php"); include ("Backend/config/dbconf.php"); global $host,$user,$pass,$database; $sess_account = $_SESSION['agribizMember']; $entriesPerPage = 10; $now = date("Y-m-d H:i:s"); $today = date("Y-m-d"); $eYear = date("Y"); $eMonth = date("m"); $parent_type = "book"; $Msg = ""; $db = new mysqli($host,$user,$pass,$database); if (mysqli_connect_errno()) {echo "
Sorry,無法連線
"; } //查詢上次評量資料 $sql = "SELECT datetime,eYear,eMonth FROM agribiz_exam2014 WHERE account = ? ORDER BY eYear DESC,eMonth DESC"; if ($stmt = $db->prepare($sql)) { $stmt->bind_param("s", $sess_account); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($lastdate,$lastyear,$lastmonth); $stmt->fetch(); } $sql = "select count(*) from agribiz_exam2014 where account = ? and eYear = ? and eMonth = ?"; if ($stmt = $db->prepare($sql)) { $stmt->bind_param("sss", $sess_account,$eYear,$eMonth); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($CountThisMonth); $stmt->fetch(); if ($CountThisMonth > 0) $Msg = "您已經執行過這個月的自我評量了!再做一次會覆蓋掉先前的結果喔!"; else {} } $sql = "SET NAMES big5"; if ($stmt = $db->prepare($sql)) { $stmt->execute(); } $sql = "select org,contact,jobtitle from agribiz_member where account = ?"; if ($stmt = $db->prepare($sql)) { $stmt->bind_param("s", $sess_account); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($org,$contact,$jobtitle); $stmt->fetch(); } if ($_POST['confirm'] != "") { $sorg = $org; $s11 = $_POST['s11v']; $s12 = $_POST['s12v']; $s13 = $_POST['s13v']; $s14 = $_POST['s14v']; $s15 = $_POST['s15v']; $s1t = $s11+$s12+$s13+$s14+$s15; $s21 = $_POST['s21v']; $s22 = $_POST['s22v']; $s23 = $_POST['s23v']; $s24 = $_POST['s24v']; $s25 = $_POST['s25v']; $s2t = $s21+$s22+$s23+$s24+$s25; $s31 = $_POST['s31v']; $s32 = $_POST['s32v']; $s33 = $_POST['s33v']; $s34 = $_POST['s34v']; $s35 = $_POST['s35v']; $s3t = $s31+$s32+$s33+$s34+$s35; $s41 = $_POST['s41v']; $s42 = $_POST['s42v']; $s43 = $_POST['s43v']; $s44 = $_POST['s44v']; $s45 = $_POST['s45v']; $s4t = $s41+$s42+$s43+$s44+$s45; $s51 = $_POST['s51v']; $s52 = $_POST['s52v']; $s53 = $_POST['s53v']; $s54 = $_POST['s54v']; $s55 = $_POST['s55v']; $s5t = $s51+$s52+$s53+$s54+$s55; $s61 = $_POST['s61v']; $s62 = $_POST['s62v']; $s63 = $_POST['s63v']; $s64 = $_POST['s64v']; $s65 = $_POST['s65v']; $s6t = $s61+$s62+$s63+$s64+$s65; $tt = $_POST['tt']; $sql = "SET NAMES big5"; if ($stmt = $db->prepare($sql)) { $stmt->execute(); } $sql = "replace INTO agribiz_exam2014 (account,eYear,eMonth,org,s11,s12,s13,s14,s15,s1t,s21,s22,s23,s24,s25,s2t,s31,s32,s33,s34,s35,s3t,s41,s42,s43,s44,s45,s4t,s51,s52,s53,s54,s55,s5t,s61,s62,s63,s64,s65,s6t,tt) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; if ($stmt = $db->prepare($sql)) { $stmt->bind_param("ssssiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii", $sess_account,$eYear,$eMonth,$sorg,$s11,$s12,$s13,$s14,$s15,$s1t,$s21,$s22,$s23,$s24,$s25,$s2t,$s31,$s32,$s33,$s34,$s35,$s3t,$s41,$s42,$s43,$s44,$s45,$s4t,$s51,$s52,$s53,$s54,$s55,$s5t,$s61,$s62,$s63,$s64,$s65,$s6t,$tt); if ($stmt->execute()) { $Msg = "自我評量成功!"; $redir = "window.location = './exam2014_result.php?eYear=$eYear&eMonth=$eMonth'"; } else { echo $stmt->error; $Msg = "自我評量失敗!"; } } else { $Msg = "自我評量失敗!!"; } } ?>
include ("personal.php"); ?>
|
include ("right.php"); ?> |