郭進電腦使用筆記: 10月 2019

2019年10月30日星期三

CH4 認識Python基本語法

--------------------------
--------------------------

--------------------------

--------------------------
--------------------------

--------------------------

--------------------------4.3 語法規則

--------------------------4.2.8 函數

內定函數：
>>> pow(3,2)
9

自訂函數：

外部函數：在系統外，先導入 import 套件或模組才能執行
>>> import math
>>> math.sqrt(100)
10.0

--------------------------

運算的種類
數值運算：+ - * / % // **
字串運算：+ * [ ]
邏輯運算：AND ＯＲ NOT
比較運算：< > == != <> >= <=
位元運算：& | ~

資料型別
數字 digit
文字 character
字串 string
容器 container --> 陣列

列表 list [ ]
元組 tuple ( )
字典 dictionary { }
集合 set { }

--------------------------

>>> print("%4.3f" %12.3) #浮點數
12.300
>>> print("%e" %12.3) #浮點數(科學記數法)
1.230000e+01

>>> print("%d" %10)
10
>>> print("%4d" %10) #10進制
10
>>> print("%04d" %10)
0010

>>> print("%4o" %10) #8進制
12

>>> print("%4x" %10) #16進制
a
>>> print("%+4x" %10)
+a

>>> print("I'm %s. I'm %d year old" %('Tom',30))
I'm Tom. I'm 30 year old

--------------------------

>>> ord('!') #ASCII Code
33

>>> print("%c" %33)
!
>>> chr(33) #10進制
'!'
>>> print("\41") #8進制
!
>>> print("\x21") #16進制
!

--------------------------

>>> a=123.45
>>> print('%6.2f%%' %a)
123.45%

--------------------------

print("\\x41 is \x41.\n")
\x41 is A. #16進制

print("\\101 is \101.\n")
\101 is A. #8進制

-------------------------數字，文字互轉

ord("A")
65

chr(65)
'A'

print("%c" %65)
A

print("\101")
A

print("\x41")
A

-----------------數字，進制互轉

bin(65)
'0b1000001'

print("%0b" %65)
Traceback (most recent call last):
File "<pyshell#97>", line 1, in <module>
print("%0b" %65)
ValueError: unsupported format character 'b' (0x62) at index 2

oct(65)
'0o101'

print("%0o" %65)
101

hex(65)
'0x41'

print("%0x" %65)
41

-------------------------

a=65
b=92
print('阿珠的成績：'+str(a)+', 阿花的成績：'+str(b))
print('阿珠的成績：%2d, 阿花的成績：%2d' %(a,b))
print('阿珠的成績：{}, 阿花的成績：{}'.format(str(a),str(b)))

阿珠的成績：65, 阿花的成績：92
阿珠的成績：65, 阿花的成績：92
阿珠的成績：65, 阿花的成績：92

CH3 python 語法熟悉度練習

n=[]
for i in range(0,10):
i=(int(input('輸入第'+str(i+1)+'數字:')))
n.append(i)
print(n)
print(end='\n')

a=int(input('開始位置：'))
b=int(input('結束位置：'))
print('從 ',a,' 到 ',b,' 的總和=',sum(n[a-1:b]))

輸入第1數字:10
輸入第2數字:9
輸入第3數字:8
輸入第4數字:7
輸入第5數字:6
輸入第6數字:5
輸入第7數字:4
輸入第8數字:3
輸入第9數字:2
輸入第10數字:1
[10, 9, 8, 7, 6, 5, 4, 3, 2, 1]

開始位置：2
結束位置：4
從 2 到 4 的總和= 24

索引: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
[10, 9, 8, 7, 6, 5, 4, 3, 2, 1]
位置: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

sum(n[1:4]) --> sum(n[a-1:b])
=9+8+7
-----------------------------------------------------------

n=[]
for i in range(0,5):
i=(int(input('輸入第'+str(i+1)+'數字:')))
n.append(i)
print(n)
print(end='\n')

for i in range(0,5):
print('n[',i,']=',n[i])

輸入第1數字:5
輸入第2數字:4
輸入第3數字:3
輸入第4數字:2
輸入第5數字:1
[5, 4, 3, 2, 1]

n[ 0 ]= 5
n[ 1 ]= 4
n[ 2 ]= 3
n[ 3 ]= 2
n[ 4 ]= 1

-----------------------------------------------------------

a=[29,11,42,75,64,35]
for i in range(0,6):
print('%2d' %i,end=' ')

print()

for i in range(0,6):
print(a[i],end=' ')

0 1 2 3 4 5
29 11 42 75 64 35

-----------------------------------------------------------

n=[]
for i in range(0,5):
n.append(int(input('輸入第'+str(i+1)+'數字:')))

print(n)

輸入第1數字:6
輸入第2數字:7
輸入第3數字:8
輸入第4數字:9
輸入第5數字:10
[6, 7, 8, 9, 10]

-----------------------------------------------------------

rainbow=['紅','澄','黃','綠','藍','靛','紫']
print(rainbow[0:3])
print(rainbow[2:4])
print(rainbow[1])

print(rainbow[:4])
print(rainbow[3:])

['紅', '澄', '黃']
['黃', '綠']
澄
['紅', '澄', '黃', '綠']
['綠', '藍', '靛', '紫']

-----------------------------------------------------------

scores=[20,40,60,80,100]
print('學科分數：',end='')
for grade in scores:
print(grade,end=' ')
print(end='\n') #同 print()

avg=sum(scores)/len(scores)
print('平均=',avg)

print('調整後的分數：',end='')
for i in range(0,len(scores)):
scores[i]=(scores[i]**0.5)*10
print('%.2f' %scores[i],end=' ')
print(end='\n')

new_avg=sum(scores)/len(scores)
print('新平均：',new_avg)
print('新平均：%.3f' %new_avg)

學科分數：20 40 60 80 100
平均= 60.0
調整後的分數：44.72 63.25 77.46 89.44 100.00
新平均： 74.97385975550067
新平均：74.974

----------------------------------------------------------- list

fruits=['蘋果','香蕉','西瓜','芒果']

fruits.append('番石榴')
print(fruits)

fruits.insert(2,'鳳梨')
print(fruits)

fruits.pop()
print(fruits)

fruits.remove('西瓜')
print(fruits)

fruits.clear()
print(fruits)

['蘋果', '香蕉', '西瓜', '芒果', '番石榴']
['蘋果', '香蕉', '鳳梨', '西瓜', '芒果', '番石榴']
['蘋果', '香蕉', '鳳梨', '西瓜', '芒果']
['蘋果', '香蕉', '鳳梨', '芒果']
[]

-----------------------------------------------------------

op=input('輸入運算符號 +-*/:')
a=int(input('整數1：'))
b=int(input('整數2：'))

if op==('+'):
print(a+b)
elif op==('-'):
print(a-b)
elif op==('*'):
print(a*b)
elif op==('/'):
print(a/b)
else:
print('輸入錯誤！')

-----------------------------------------------------------

age=int(input('輸入年齡：'))
if (age>70):
print('老年')
elif(age<30):
print('青年')
else:
print('壯年')

-----------------------------------------------------------

a=5
b=2
print('a+b=',a+b)
print('a-b=',a-b)
print('a*b=',a*b)
print('a/b=',a/b)
print('a%b=',a%b)
print('a//b=',a//b)
print('a**b=',a**b)

a+b= 7
a-b= 3
a*b= 10
a/b= 2.5
a%b= 1
a//b= 2
a**b= 25

-----------------------------------------------------------

a=input()
print('a=',a)

na=input('輸入你的名字：')
print('你的名字：',na)

-----------------------------------------------------------

a=[2,4,6,8,10]
for i in range(0,len(a)):
print(a[i]*a[i])
a[i]=a[i]*a[i]
print(a)

-----------------------------------------------------------

list=['Jerome',0.38,1234,True]
for i in range(0,len(list)):
print(list[i],type(list[i]))

print('變數是string的有：')
for i in range(0,len(list)):
if isinstance(list[i],str):
print(list[i],type(list[i]))

Jerome <class 'str'>
0.38 <class 'float'>
1234 <class 'int'>
True <class 'bool'>
變數是string的有：
Jerome <class 'str'>

----------------------------------------------------------- 猜數字
ans=35
for guessChance in range(0,3):
guess=int(input("Please input a number(1~100):"))
if ans==guess:
print('答對了')
break
else:
print('猜錯了')
print('game over')

----------------------------------------------------------- 串列

list=['Jerome',0.38,1234,True]
for i in list:
print (i)

a=['Jerome',0.38,1234,True]
for i in range(0,len(a)):
print(a[i])

----------------------------------------------------------- 9*9

for i in range(1,10):
for j in range(1,10):
print(i*j,end=' ') #end='' 接續印
print() #換行

--------------------------------------------------------------------

for i in range(1,10):
for j in range(1,10):
if(i*j<10):print(' ',end='') #個位數，前加上一個空格
print(i*j,end=' ')
print()

--------------------------------------------------------------------

for i in range(1,10):
for j in range(1,10):
print("%3d" %(i*j),end='')
print()

--------------------------------------------------------------------
for i in range(1,10):
    for j in range(1,10):
        print("{0}*{1}={2:2d}\t".format(i,j,i*j),end="")
    print()


1*1= 1    1*2= 2    1*3= 3    1*4= 4    1*5= 5    1*6= 6    1*7= 7    1*8= 8    1*9= 9
2*1= 2    2*2= 4    2*3= 6    2*4= 8    2*5=10    2*6=12    2*7=14    2*8=16    2*9=18
3*1= 3    3*2= 6    3*3= 9    3*4=12    3*5=15    3*6=18    3*7=21    3*8=24    3*9=27
4*1= 4    4*2= 8    4*3=12    4*4=16    4*5=20    4*6=24    4*7=28    4*8=32    4*9=36
5*1= 5    5*2=10    5*3=15    5*4=20    5*5=25    5*6=30    5*7=35    5*8=40    5*9=45
6*1= 6    6*2=12    6*3=18    6*4=24    6*5=30    6*6=36    6*7=42    6*8=48    6*9=54
7*1= 7    7*2=14    7*3=21    7*4=28    7*5=35    7*6=42    7*7=49    7*8=56    7*9=63
8*1= 8    8*2=16    8*3=24    8*4=32    8*5=40    8*6=48    8*7=56    8*8=64    8*9=72
9*1= 9    9*2=18    9*3=27    9*4=36    9*5=45    9*6=54    9*7=63    9*8=72    9*9=81

// \t Tab ,end='' 以空格結束，不寫預設為換行

2019年10月2日星期三

系統：Apache+php+Mariadb

MYSQLi 相關函數連結資料庫流程

先連結主機與資料庫 mysqli_connect
使用 mysqli_query() 函數設定編碼
使用 mysqli_query() 函數執行 SQL 語法，SQL語法可分為兩種

SQL語法若是 insert into， delete， update 三個語法則會變更資料表內容
SQL語法若是 select 語法，執行 mysqli_query() 後的結果傳遞給變數儲存，接著就可以利用 mysqli_num_rows() 取得查詢後筆數，或者利用 mysqli_fetch_array() 取出每一筆記錄

使用 mysqli_free_result() 會將 mysqli_query() 執行結果清除
使用 mysqli_close() 函數關閉 MYSQL 伺服器連結

-----------------------------------------------------------------------------------------

# yum -y install httpd
# rpm -qa | grep httpd
httpd-tools-2.4.6-90.el7.centos.x86_64
httpd-2.4.6-90.el7.centos.x86_64

# systemctl start httpd.service
# systemctl enable httpd.service
# systemctl status httpd.service

# firewall-cmd --add-service=http --permanent
# firewall-cmd --reload
# firewall-cmd --list-all

http://192.168.1.4/

-----------------------------------------------------------------------------------------

# yum -y install php php-mysql php-devel php-mbstring
# rpm -qa | grep php
php-cli-5.4.16-46.el7.x86_64
php-devel-5.4.16-46.el7.x86_64
php-5.4.16-46.el7.x86_64
php-common-5.4.16-46.el7.x86_64
php-pdo-5.4.16-46.el7.x86_64
php-mysql-5.4.16-46.el7.x86_64
php-mbstring-5.4.16-46.el7.x86_64

# vi /etc/php.ini
...
display_errors = On
...
# systemctl restart httpd.service

-----------------------------------------------------------------------------------------

yum -y install mariadb-server
# rpm -qa | grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
mariadb-5.5.64-1.el7.x86_64
mariadb-server-5.5.64-1.el7.x86_64

# systemctl start mariadb.service
# systemctl enable mariadb.service
# systemctl status mariadb.service

# mysqladmin -u root password db123456
# mysql -u root -p
Enter password:

MariaDB [(none)]> create database kkdb character set='utf8' collate='utf8_unicode_ci';
MariaDB [(none)]> use kkdb;

MariaDB [kkdb]> create table tblstu (sid int primary key auto_increment, gra varchar(1), cla varchar(2), sno varchar(2), na varchar(10), pwd varchar(10));

MariaDB [kkdb]> show create table tblstu \G;
*************************** 1. row ***************************
Table: tblstu
Create Table: CREATE TABLE `tblstu` (
`sid` int(11) NOT NULL AUTO_INCREMENT,
`gra` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`cla` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`sno` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`na` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`pwd` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

------------------------------------------------------------ 匯出資料

MariaDB [kkdb]> SELECT @n:=@n+1 AS 題號, ans AS 答案, qus AS 題目, concat('(A)',opt1) AS 選項1, concat('(B)',opt2) AS 選項2, concat('(C)',opt3) AS 選項3, concat('(D)',opt4) AS 選項4 INTO OUTFILE 'qus2.txt' FROM tblexam,(SELECT @n:=0) AS tmp;

MariaDB [kkdb]> SELECT @n:=@n+1 AS 題號, ans AS 答案, qus AS 題目, concat('(A)',opt1) AS 選項1, concat('(B)',opt2) AS 選項2, concat('(C)',opt3) AS 選項3, concat('(D)',opt4) AS 選項4 INTO OUTFILE 'qus2.csv' FROM tblexam,(SELECT @n:=0) AS tmp;

# ls /var/lib/mysql/kkdb
db.opt qus2.csv qus2.txt tblch.frm tblexam.frm tblsr.frm tblstu.frm

# cp /var/lib/mysql/kkdb/qus2.csv /home/s301/40/

//csv會亂碼，所以用txt再以word開啟，再修改版面

------------------------------------------------------ addqus.php

<?php
if (isset($_POST['qus']))
{
require_once("connMysql.php");

$sql="INSERT INTO tblexam (chid, qus, opt1, opt2, opt3, opt4, ans) VALUES ('".$_POST['chpr']."','".$_POST['qus']."','".$_POST['opt1']."','".$_POST['opt2']."','".$_POST['opt3']."','".$_POST['opt4']."','".$_POST['ans']."')";

$rslt=mysqli_query($conn,$sql);
header("Location:addqus.php");

}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>

<?php
require_once("connMysql.php");

$sql="SELECT chid,chpr FROM tblch ORDER BY chpr";
$rslt=mysqli_query($conn,$sql);
?>

<div id='container'>
<header>
<h1>新增測驗題目</h1>
<nav>
<ul>
<li><a href='lspwd.php'>各班級密碼</a></li>
<li><a href='lssr.php'>各班級測驗記錄</a></li>
<li><a href='addqus.php'>新增測驗題目</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<form action="addqus.php" method="post">
<table>
<tr>
<td>章節名</td>
<td>
<select name="chpr" required>
<option value="">請選擇</option>

<?php
while ($row=mysqli_fetch_assoc($rslt) )
echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");
?>

</select>
</td>
</tr>
<tr>
<td>題目</td>
<td>
<input name="qus" type="text" maxlength="100" size="100" required>
</td>
</tr>
<tr>
<td>選項1</td>
<td>
<input name="opt1" type="text" maxlength="50" size="50" required>
</td>
</tr>
<tr>
<td>選項2</td>
<td>
<input name="opt2" type="text" maxlength="50" size="50" required>
</td>
</tr>
<tr>
<td>選項3</td>
<td>
<input name="opt3" type="text" maxlength="50" size="50" required>
</td>
</tr>
<tr>
<td>選項4</td>
<td>
<input name="opt4" type="text" maxlength="50" size="50" required>
</td>
</tr>
<tr>
<td>答案</td>
<td>
<select name="ans" required>
<option value="">請選擇</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>
</td>
</tr>
<tr>
<td>
<input type="submit" value="新增題目" name="ok">
</td>
</tr>
</table>
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
<p>

<h1>以下列出所有已收錄題目：</h1>

<?php
$sql="SELECT * FROM tblexam ORDER BY chid, qid";
$rslt=mysqli_query($conn,$sql);

while ($row=mysqli_fetch_assoc($rslt))
{
echo $row['qid'],"-->", $row['chid'];
echo "</br>";
echo $row['qus'], $row['opt1'], $row['opt2'], $row['opt3'], $row['opt4'];
echo "</br>";
echo $row['ans'];
echo "</br>";
echo "<p>";
};
?>

</body>
</html>

<?php
}
?>

------------------------------------------------------------ lspwd.php

<?php
if (isset($_POST['cla']))
{
require_once("connMysql.php");
$sql="SELECT sno,na,pwd FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."'";

$rslt=mysqli_query($conn,$sql);
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>各班級密碼</h1>
<nav>
<ul>
<li><a href='lspwd.php'>各班級密碼</a></li>
<li><a href='lssr.php'>各班級測驗記錄</a></li>
<li><a href='addqus.php'>新增測驗題目</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<table>
<tr>
<th>座號</th>
<th>名字</th>
<th>密碼</th>
</tr>

<?php
while ($row=mysqli_fetch_assoc($rslt))
{
?>

<tr>
<td><?php echo $row['sno'] ?></td>
<td><?php echo $row['na'] ?></td>
<td><?php echo $row['pwd'] ?></td>
</tr>

<?php
}
?>

</table>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>各班級密碼</h1>
<nav>
<ul>
<li><a href='lspwd.php'>各班級密碼</a></li>
<li><a href='lssr.php'>各班級測驗記錄</a></li>
<li><a href='addqus.php'>新增測驗題目</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<form action="lspwd.php" method="post">
年級：
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
班級：
<select name="cla" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=19;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
<p>
<input type="submit" value="查詢資料" name="ok">
</p>

</form>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
?>

---------------------------------------------------------------- lssr.php

<?php
if (isset($_POST['cla']))
{
require_once("connMysql.php");
$sql="SELECT tblstu.sno,tblch.chpr,tblsr.scr,tblsr.dte FROM tblsr LEFT JOIN tblstu ON tblsr.sid=tblstu.sid LEFT JOIN tblch ON tblsr.chid=tblch.chid WHERE tblstu.gra='".$_POST['gra']."' AND tblstu.cla='".$_POST['cla']."'";

$rslt=mysqli_query($conn,$sql);
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>各班級測驗記錄</h1>
<nav>
<ul>
<li><a href='lspwd.php'>各班級密碼</a></li>
<li><a href='lssr.php'>各班級測驗記錄</a></li>
<li><a href='addqus.php'>新增測驗題目</a></li>

<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<table>
<tr>
<th>座號</th>
<th>章節</th>
<th>分數</th>
<th>日期</th>
</tr>

<?php
while ($row=mysqli_fetch_assoc($rslt))
{
?>

<tr>
<td><?php echo $row['sno'] ?></td>
<td><?php echo $row['chpr'] ?></td>
<td><?php echo $row['scr'] ?></td>
<td><?php echo $row['dte'] ?></td>
</tr>

<?php
}
?>

</table>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>各班級測驗記錄</h1>
<nav>
<ul>
<li><a href='lspwd.php'>各班級密碼</a></li>
<li><a href='lssr.php'>各班級測驗記錄</a></li>
<li><a href='addqus.php'>新增測驗題目</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<form action="lssr.php" method="post">
年級：
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>

班級：
<select name="cla" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=19;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
<P>
<input type="submit" value="查詢資料" name="ok">
</P>

</form>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}

--------------------------------------------------------------------- score.php

<?php
session_start();
require_once("connMysql.php");

$sql="SELECT tblsr.scr, tblch.chpr FROM tblsr INNER JOIN tblch ON tblsr.chid=tblch.chid WHERE tblsr.sid=".$_SESSION['sid'];

$rslt=mysqli_query($conn,$sql);
$cnt=mysqli_num_rows($rslt);

if ($cnt>0)
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>測驗記錄</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<table>
<tr>
<th>章節</th>
<th>分數</th>
</tr>

<?php
while ($row=mysqli_fetch_assoc($rslt))
{
?>

<tr>
<td><?php echo $row['chpr'] ?></td>
<td><?php echo $row['scr'] ?></td>
</tr>

<?php
}
?>

</table>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
else
{
?>

<script language="javascript">;
alert("目前尚無測驗資料...");
window.location.href="menu.html"
</script>;

<?php
}
?>

--------------------------------------------------------------------- add.php

<?php
if (isset($_POST['pwd']))
{

require_once("connMysql.php");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND na='".$_POST['na']."'";
$rslt=mysqli_query($conn,$sql);
$cnt=mysqli_num_rows($rslt);

if ($cnt>0)
{
?>
<script language="javascript">;
alert("註冊資料已經重複!");
history.go(-1)
</script>;
<?php
}
else
{
$sql="INSERT INTO tblstu (gra, cla, sno, na, pwd) VALUES ('".$_POST['gra']."','".$_POST['cla']."','".$_POST['sno']."','".$_POST['na']."','".$_POST['pwd']."')";
$rslt=mysqli_query($conn,$sql);
?>
<script language="javascript">;
alert("新增註冊資料完成!請登入系統...");
window.location.href="index.php"
</script>;
<?php
}

}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>註冊資料</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
<form action="add.php" method="post">
<table>
<tr>
<td>年級</td>
<td>
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td>
<td>班級</td>
<td>
<select name="cla" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=19;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
</td>
<td>座號</td>
<td>
<select name="sno" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=29;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
</td>
</tr>
<tr>
<td>姓名</td>
<td>
<input name="na" type="text" required>
</td>
<td>密碼</td>
<td>
<input name="pwd" type="password" maxlength="10" placeholder="最長10字元" required>
</td>
</tr>
<tr>
<td>
<input type="submit" value="註冊資料" name="ok">
</td>
</tr>
</table>
</form>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
?>

--------------------------------------------------------------------- menu.html

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>功能選單</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

--------------------------------------------------------------------- index.php V3.0

<?php
if (isset($_POST['pwd']))

if ($_POST['pwd']=="!QAZ@WSX")
{
header("Location:menu0.html");
}
else
{
session_start();
require_once("connMysql.php");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND pwd='".$_POST['pwd']."'";

$rslt=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($rslt);

if (is_null($row['sid']))
{
?>
<script language="javascript">;
alert("沒有註冊資料!請先註冊...");
window.location.href="add.php"
</script>;
<?php
}
else
{
$_SESSION['sid']=$row['sid'];
$_SESSION['gra']=$row['gra'];
$_SESSION['cla']=$row['cla'];
$_SESSION['na']=$row['na'];
header("Location:menu.html");
}

}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>同學登入</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<section>
</section>
<form action="index.php" method="post">
<table>
<tr>
<td>年級</td>
<td>
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td>
<td>
</td>
<td>
</td>

<td>班級</td>
<td>
<select name="cla" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=19;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
</td>
<td></td>
<td></td>
<td>座號</td>
<td>
<select name="sno" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=29;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
<td>密碼</td>
<td colspan="9">
<input name="pwd" type="password" maxlength="10" required>
</td>
</tr>
<tr>
</tr>
<tr>
<td colspan="10">
<input type="submit" value="登入網站" name="ok">
</td>
</tr>

<tr>
</tr>

<tr>
<td colspan="10">
<a href="add.php">新同學註冊資料</a>
</td>
</tr>

</table>
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
?>

~

--------------------------------------------------------------------- exam.php V3.0

<?php
session_start();
if (isset($_POST['chpr']))
{
$_SESSION['chid']=$_POST['chpr'];
require_once("connMysql.php");
$sql="SELECT * FROM tblexam where chid='".$_POST['chpr']."' ORDER BY RAND() LIMIT 10";
$rslt=mysqli_query($conn,$sql);
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>線上測驗</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<form action="check.php" method="post">

<?php
$i=1;
while ($row=mysqli_fetch_assoc($rslt))
{
?>

<select name="sel<?php echo $i ?>" required>
<option >請選擇</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>

<font size="4" color="Brown"><?php echo $i ?>.</font>
<font size="4" color="DarkBlue"><?php echo $row['qus'] ?></font></br>
      (A)<?php echo $row['opt1'] ?>
 (B)<?php echo $row['opt2'] ?>
 (C)<?php echo $row['opt3'] ?>
 (D)<?php echo $row['opt4'] ?>

<input type="hidden" name=q<?php echo $i ?> value="<?php echo ord($row['ans'])+2019 ?>">

<p>

<?php
$i++;
}
?>

<input type="submit" value="我答完了" name="ok">
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>

<?php
require_once("connMysql.php");
$sql="SELECT chid,chpr FROM tblch WHERE gra='".$_SESSION['gra']."' ORDER BY chpr";
$rslt=mysqli_query($conn,$sql);
?>

<header>
<h1>選擇測驗範圍</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='score.php'>測驗記錄</a></li>
<li><a href='chat.php'>吾聊天地</a></li>
<li><a href='message.php'>留言板頁</a></li>
</ul>
</nav>
</header>
<form action="exam.php" method="post">
<table>
<tr>
<td>章節名</td>
<td>
<select name="chpr" required>
<option value="">請選擇</option>

<?php
while ($row=mysqli_fetch_assoc($rslt) )
echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");
?>

</select>
</td>
</tr>
<tr>
<td>
<input type="submit" value="確定範圍" name="ok">
</td>
</tr>
</table>
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php
}
?>

--------------------------------------------------------------------- check.php V3.0

<?php
session_start();
$scr=0;
for ($i=1;$i<=10;$i++)
{
if ($_POST["sel$i"]==chr($_POST["q$i"]-2019))
{
$scr++;
}
}
require_once("connMysql.php");

date_default_timezone_set('Asia/Taipei');
$dte=date("Y/m/d H:i:s");
$sql="INSERT INTO tblsr (sid, chid, scr, dte) VALUES (".$_SESSION['sid'].",".$_SESSION['chid'].",".$scr.",'".$dte."')";

$rslt=mysqli_query($conn,$sql);
?>

<script language="javascript">;
alert("本次測驗共答對<?php echo $scr ?>題！！");
window.location.href="menu.html"
</script>;

--------------------------------------------------------------------- add.php V2

<?php
if (isset($_POST['pwd']))
{

require_once("connMysql.php");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND na='".$_POST['na']."'";
$rslt=mysqli_query($conn,$sql);
$cnt=mysqli_num_rows($rslt);

if ($cnt>0)
{
?>
<script language="javascript">;
alert("註冊資料已經重複!");
history.go(-1)
</script>;
<?php
}
else
{
$sql="INSERT INTO tblstu (gra, cla, sno, na, pwd) VALUES ('".$_POST['gra']."','".$_POST['cla']."','".$_POST['sno']."','".$_POST['na']."','".$_POST['pwd']."')";
$rslt=mysqli_query($conn,$sql);
?>
<script language="javascript">;
alert("新增註冊資料完成!請登入系統...");
window.location.href="index.php"
</script>;
<?php
}

}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>註冊資料</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='#'>修改密碼</a></li>
<li><a href='#'>吾聊天地</a></li>
</ul>
</nav>
</header>
<section>
<form action="add.php" method="post">
<table>
<tr>
<td>年級</td>
<td>
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td>
<td>班級</td>
<td>
<select name="cla" required>
<option value="">請選擇</option>

<?php
for ($i=1;$i<=19;$i++)
{
?>
<option value="<?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?>"><?php echo str_pad($i,2,'0',STR_PAD_LEFT) ?></option>
<?php
}
?>

</select>
</td>
<td>座號</td>
<td>
<select name="sno" required>

<?php

for ($i=1;$i<=29;$i++)

{

<?php

}

</select>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</section>

<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>

</body>

</html>

<?php

}

--------------------------------------------------------------------- menu.html

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>功能選單</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='#'>修改密碼</a></li>
<li><a href='#'>吾聊天地</a></li>
</ul>
</nav>
</header>
<section>
</section>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

--------------------------------------------------------------------- menu0.html

--------------------------------------------------------------------- exam.php

<?php
session_start();
if (isset($_POST['chpr']))
{
$_SESSION['chid']=$_POST['chpr'];
require_once("connMysql.php");
$sql="SELECT * FROM tblexam where chid='".$_POST['chpr']."' ORDER BY RAND() LIMIT 10";
$rslt=mysqli_query($conn,$sql);
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>線上測驗</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='#'>修改密碼</a></li>
<li><a href='#'>吾聊天地</a></li>
</ul>
</nav>
</header>
<form action="check.php" method="post">

<?php
$i=1;
while ($row=mysqli_fetch_assoc($rslt))
{
?>

<input type="hidden" name=q<?php echo $i ?> value="<?php echo $row['ans'] ?>">
<font size="4" color="Brown"><?php echo $i ?>.</font>
<font size="4" color="DarkBlue"><?php echo $row['qus'] ?></font></br>
<input type="radio" name="rdo<?php echo $i ?>" value="A"><?php echo $row['opt1'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="B"><?php echo $row['opt2'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="C"><?php echo $row['opt3'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="D"><?php echo $row['opt4'] ?>
<p>

<?php
$i++;
}
?>

<input type="submit" value="我答完了" name="ok">
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>
</body>
</html>

<?php

}

else

{

<!DOCTYPE html>

<html>

<head>

<title>郭老師資訊學園</title>

</head>

<?php

require_once("connMysql.php");

$sql="SELECT chid,chpr FROM tblch WHERE gra='".$_SESSION['gra']."' ORDER BY chpr";

$rslt=mysqli_query($conn,$sql);

<h1>選擇測驗範圍</h1>

<nav>

<ul>

</ul>

</nav>

</header>

<table>

<tr>

<td>

<?php

while ($row=mysqli_fetch_assoc($rslt) )

echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");

</select>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</div>

</body>

</html>

<?php

}

--------------------------------------------------------------------- check.php

<?php
session_start();
$scr=0;
for ($i=1;$i<=10;$i++)
{
if ($_POST["rdo$i"]==$_POST["q$i"])
{
$scr++;
}
}
require_once("connMysql.php");

$sql="INSERT INTO tblsr (sid, chid, scr) VALUES (".$_SESSION['sid'].",".$_SESSION['chid'].",".$scr.")";
$rslt=mysqli_query($conn,$sql);
?>
<script language="javascript">;
alert("本次測驗共答對<?php echo $scr ?>題！！");
window.location.href="menu.html"
</script>;

---------------------------------------------------------------------- index.php V2

<?php
if (isset($_POST['pwd']))

if ($_POST['pwd']=="!QAZ@WSX")
{
header("Location:menu0.html");
}
else
{
session_start();
require_once("connMysql.php");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND pwd='".$_POST['pwd']."'";

$rslt=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($rslt);

if (is_null($row['sid']))
{
?>
<script language="javascript">;
alert("沒有註冊資料!請先註冊...");
window.location.href="add.php"
</script>;
<?php
}
else
{
$_SESSION['sid']=$row['sid'];
$_SESSION['gra']=$row['gra'];
header("Location:menu.html");
}

}
else
{
?>

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='container'>
<header>
<h1>同學登入</h1>
<nav>
<ul>
<li><a href='exam.php'>線上測驗</a></li>
<li><a href='#'>修改密碼</a></li>
<li><a href='#'>吾聊天地</a></li>
</ul>

</nav>

</header>

</section>

<table>

<tr>

<td>

</select>

</td>

<td>

<?php

for ($i=1;$i<=19;$i++)

{

<?php

}

</select>

</td>

<td>

<?php

for ($i=1;$i<=29;$i++)

{

<?php

}

</select>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</div>

</body>

</html>

<?php

}

---------------------------------------------------------------------- add.html
# vi /var/www/html/add.html

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
<h1>註冊會員資料</h1>
<nav>修改密碼線上測驗療聊園地
</nav>
</header>
<section>
</section>
<article>
<form action="add.php" method="post">
<table>
<tr>
<td>年級</td>
<td>
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td>
<td>班級</td>
<td>
<select name="cla" required>
<option value="">請選擇</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
</select>
</td>
<td>座號</td>
<td>
<select name="sno" required>
<option value="">請選擇</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
</select>
</td>
</tr>
<tr>
<td>姓名</td>
<td>
<input name="na" type="text" required>
</td>
<td>密碼</td>
<td>
<input name="pwd" type="password" maxlength="10" placeholder="最長10字元" required>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<input type="submit" value="註冊資料" name="ok">
</td>
</tr>
</table>
</form>
</article>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</body>
</html>

------------------------------------------------------------------------------- add.php

# vi /var/www/html/add.php

<?php
if (isset($_POST['pwd'])){
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");

mysqli_set_charset($conn,"utf8");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND na='".$_POST['na']."'";
$rslt=mysqli_query($conn,$sql);
$cnt=mysqli_num_rows($rslt);

if ($cnt>0){
?>
<script language="javascript">;
alert("註冊資料已經重複!");
history.go(-1)
</script>;
<?php
}
else{
$sql="INSERT INTO tblstu (gra, cla, sno, na, pwd) VALUES ('".$_POST['gra']."','".$_POST['cla']."','".$_POST['sno']."','".$_POST['na']."','".$_POST['pwd']."')";
$rslt=mysqli_query($conn,$sql);
?>
<script language="javascript">;
alert("新增註冊資料完成!請登入系統...");
window.location.href="index.html"
</script>;
<?php
}
}
?>

----------------------------------------------------------------------------------------- index.html

# vi /var/www/html/index.html

<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
<h1>同學登入</h1>
<nav>修改密碼線上測驗療聊園地
</nav>
</header>
<section>
</section>
<article>
<form action="login.php" method="post">
<table>
<tr>
<td>年級</td>
<td>
<select name="gra" required>
<option value="">請選擇</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td>
<td>班級</td>
<td>
<select name="cla" required>
<option value="">請選擇</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
</select>
</td>
<td>座號</td>
<td>
<select name="sno" required>
<option value="">請選擇</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
</select>
</tr>
<tr>
<td>密碼</td>
<td>
<input name="pwd" type="password" maxlength="10" required>
</td>
</tr>
<tr>
<td>
<input type="submit" value="登入網站" name="ok">
</td>
</tr>
</table>
</form>
</article>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</body>
</html>

-------------------------------------------------------------------------- login.php --v2 加上session

<?php
session_start();
//$_SESSION['sid']="";

if (isset($_POST['pwd']))
{
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");

mysqli_set_charset($conn,"utf8");
$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND pwd='".$_POST['pwd']."'";
$rslt=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($rslt);

//echo gettype($row['sid']);
if (is_null($row['sid']))
{
?>
<script language="javascript">;
alert("沒有註冊資料!請先註冊...");
window.location.href="add.html"
</script>;
<?php
}
else
{
$_SESSION['sid']=$row['sid'];
header("Location:menu.html");
}
}
?>

----------------------------------------------------------------------------------------- login.php

# vi /var/www/html/login.php

<?php
if (isset($_POST['pwd'])){
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");

mysqli_set_charset($conn,"utf8");

$sql="SELECT * FROM tblstu WHERE gra='".$_POST['gra']."' AND cla='".$_POST['cla']."' AND sno='".$_POST['sno']."' AND pwd='".$_POST['pwd']."'";

$rslt=mysqli_query($conn,$sql);
$cnt=mysqli_num_rows($rslt);
if ($cnt>0){
header("Location:menu.html");
}
else{
?>
<script language="javascript">;
alert("沒有註冊資料!請先註冊...");
window.location.href="add.html"
</script>;
<?php
}
}
?>

-----------------------------------------------------------------------------------------

MariaDB [kkdb]> create table tblsr (sid int, chid int, scr tinyint);
MariaDB [kkdb]> show create table tblsr \G;
*************************** 1. row ***************************
Table: tblsr
Create Table: CREATE TABLE `tblsr` (
`sid` int(11) DEFAULT NULL,
`chid` int(11) DEFAULT NULL,
`scr` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

MariaDB [kkdb]> create table tblch (chid int primary key auto_increment, gra varchar(1), chpr varchar(30));

MariaDB [kkdb]> INSERT INTO tblch (gra, chpr) VALUES ('1', '第一章資訊科技導論');

MariaDB [kkdb]> create table tblexam (qid int primary key auto_increment, chid int, qus varchar(100), opt1 varchar(25), opt2 varchar(25), opt3 varchar(25), opt4 varchar(25), ans varchar(1));

MariaDB [kkdb]> INSERT INTO tblexam (gra, chpr, qus, opt1, opt2, opt3, opt4, ans) VALUES ('1', '第一章資訊科技導論', '訓練飛行員可以運用何種電腦科技來避免人員與飛機的實際損失？', '電腦輔助設計(CAD)', '電腦輔助製造(CAM)', '無線射頻辨識(RFID)', '虛擬實境(VR)', 'D');

MariaDB [kkdb]> select * from tblexam;

----------------------------------------------------------- addqus.php V2

<?php
if (isset($_POST['qus']))
{
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");
mysqli_set_charset($conn,"utf8");

$sql="INSERT INTO tblexam (chid, qus, opt1, opt2, opt3, opt4, ans) VALUES ('".$_POST['chpr']."','".$_POST['qus']."','".$_POST['opt1']."','".$_POST['opt2']."','".$_POST['opt3']."','".$_POST['opt4']."','".$_POST['ans']."')";
$rslt=mysqli_query($conn,$sql);
header("Location:addqus.php");
}
else
{
?>
<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");
mysqli_set_charset($conn,"utf8");

$sql="SELECT chid,chpr FROM tblch ORDER BY chpr";
$rslt=mysqli_query($conn,$sql);
?>
<header>
<nav>修改密碼線上測驗療聊園地</nav>
<h1>新增題目</h1>
</header>
<form action="addqus.php" method="post">
<table>
<tr>
<td>章節名</td>
<td>
<select name="chpr" required>
<option value="">請選擇</option>
<?php
while ($row=mysqli_fetch_assoc($rslt) )
echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");
?>
</select>
</td>
</tr>
<tr>
<td>題目</td>
<td>
<input name="qus" type="text" maxlength="100" size="60" required>
</td>
</tr>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

</select>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

<p>

<h1>以下列出所有已收錄題目：</h1>

<?php

$sql="SELECT * FROM tblexam ORDER BY chid, qid";

$rslt=mysqli_query($conn,$sql);

while ($row=mysqli_fetch_assoc($rslt))

{

echo $row['qid'],"-->", $row['chid'];

echo "</br>";

echo $row['qus'], $row['opt1'], $row['opt2'], $row['opt3'], $row['opt4'];

echo "</br>";

echo $row['ans'];

echo "</br>";

echo "<p>";

};

</body>

</html>

<?php

}

----------------------------------------------------------- addqus.php

<?php

if (isset($_POST['qus']))

{

$conn=mysqli_connect("localhost","root","db123456","kkdb");

if (mysqli_connect_errno($conn))

die("無法連線!");

mysqli_set_charset($conn,"utf8");

$sql="INSERT INTO tblexam (chid, qus, opt1, opt2, opt3, opt4, ans) VALUES ('".$_POST['chpr']."','".$_POST['qus']."','".$_POST['opt1']."','".$_POST['opt2']."','".$_POST['opt3']."','".$_POST['opt4']."','".$_POST['ans']."')";

$rslt=mysqli_query($conn,$sql);

header("Location:addqus.php");

}

else

{

<!DOCTYPE html>

<html>

<head>

<title>郭老師資訊學園</title>

</head>

<body>

<?php

$conn=mysqli_connect("localhost","root","db123456","kkdb");

if (mysqli_connect_errno($conn))

die("無法連線!");

mysqli_set_charset($conn,"utf8");

$sql="SELECT chid,chpr FROM tblch ORDER BY chpr";

$rslt=mysqli_query($conn,$sql);

<nav>修改密碼線上測驗療聊園地</nav>

</header>

<table>

<tr>

<td>

<?php

while ($row=mysqli_fetch_assoc($rslt) )

echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");

</select>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

</tr>

<td>

</select>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</body>

</html>

<?php

}

------------------------------------------------------------------- exam.php

<?php
if (isset($_POST['chpr']))
{
$conn=mysqli_connect("localhost","root","db123456","kkdb");
if (mysqli_connect_errno($conn))
die("無法連線!");
mysqli_set_charset($conn,"utf8");

$sql="SELECT * FROM tblexam where chid='1' ORDER BY RAND() LIMIT 10";
$rslt=mysqli_query($conn,$sql);
?>
<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">
<link href="WebStyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
<nav>修改密碼線上測驗療聊園地</nav>
<h1>線上測驗</h1>
<h2></h2>
</header>
<form action="check.php" method="post">
<?php
$i=1;
while ($row=mysqli_fetch_assoc($rslt))
{
?>
<input type="hidden" name=q<?php echo $i ?> value="<?php echo $row['ans'] ?>">
<font size="4" color="Brown"><?php echo $i ?>.</font>
<font size="4" color="DarkBlue"><?php echo $row['qus'] ?></font></br>
<input type="radio" name="rdo<?php echo $i ?>" value="A"><?php echo $row['opt1'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="B"><?php echo $row['opt2'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="C"><?php echo $row['opt3'] ?>
<input type="radio" name="rdo<?php echo $i ?>" value="D"><?php echo $row['opt4'] ?>
<p>
<?php
$i++;
}
?>
<input type="submit" value="我答完了" name="ok">
</form>
<footer><p>Copyright © 2019 GuoChin All Rights Reserved</p></footer>
</body>
</html>
<?php
}
else
{
?>
<!DOCTYPE html>
<html>
<head>
<title>郭老師資訊學園</title>
<meta charset="utf-8">

</head>

<body>

<?php

$conn=mysqli_connect("localhost","root","db123456","kkdb");

if (mysqli_connect_errno($conn))

die("無法連線!");

mysqli_set_charset($conn,"utf8");

$_SESSION['gra']='7';

$sql="SELECT chid,chpr FROM tblch WHERE gra='".$_SESSION['gra']."' ORDER BY chpr";

$rslt=mysqli_query($conn,$sql);

<nav>修改密碼線上測驗療聊園地</nav>

<h1>選擇測驗範圍</h1>

</header>

<table>

<tr>

<td>

<?php

while ($row=mysqli_fetch_assoc($rslt) )

echo("<OPTION VALUE=".$row['chid'].">".$row['chpr']."</OPTION>");

</select>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</body>

</html>

<?php

}

-----------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------

訂閱：文章 (Atom)

內容選單標籤

2019年10月30日 星期三

CH4 認識Python基本語法

CH3 python 語法熟悉度練習

2019年10月2日 星期三

系統：Apache+php+Mariadb

2019年10月30日星期三

2019年10月2日星期三