File: C:/xampp/htdocs/cieclock/rollDB.php
<?php
$week=$_GET['week'];
$stid=$_POST['stid'];
$weeknum="w".$week;
$servername = "127.0.0.1";
$username = "root";
$password = "fredsql";
$DBNAME = "ntua";
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//echo "Connected successfully";
if( !mysqli_select_db($conn, $DBNAME)) {
die ("無法選擇資料庫");
}
mysqli_query( $conn, "SET NAMES 'utf8'");
$querys = "select stid from student where stid= '$stid' and $weeknum is NULL order by id DESC limit 1 ";
//echo "qry:".$querys;
//$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$results = mysqli_query($conn, $querys);
$num = mysqli_num_rows( $results);
if ($num > 0)
{
$query = "update student set $weeknum = NOW() where stid='$stid'";
//echo $query;
$result = mysqli_query($conn, $query);
echo "第".$week."週完成點名!";
}
else {
echo "學號不符或重複登錄!";
}
?>
<html>
<head>
<body style="background-color:<?php echo $ch1C3;?>">
<table width="400" border="0" align="center" bgcolor="<?php echo $ch1C4;?>" >
<tr>
<tr>
</table>
</body>
</html>