1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?
include("password.php");
if ( isset($_POST['year'])and ($_POST['semester'])){
$sbl = "SELECT * FROM studentlist ";
if($rb = mysqli_query($link,$sbl)){
$sql = "SELECT * FROM ps WHERE year LIKE '{$_POST['year']}' AND updown LIKE '{$_POST['semester']}'";
if($rq = mysqli_query($link,$sql)){
$spl = "SELECT * FROM money WHERE year LIKE '{$_POST['year']}' AND updown LIKE '{$_POST['semester']}'";
if($rp = mysqli_query($link,$spl)){


while($kb = mysqli_fetch_assoc($rb) and $kp = mysqli_fetch_assoc($rp) and $kq = mysqli_fetch_assoc($rq)){
  echo "<center>"."<table   width=760px border=1>";
  echo "<td>"."繳款學生"."</TD>"."<td>"."收費項目"."</TD>"."<td>"."金額"."</TD>"."<td>"."※繳費注意事項"."</TD>"."<TR>";
  echo "<TD rowspan=3>".substr($kb["curr_class_num"],-5,1)."年".substr($kb["curr_class_num"],-4,2)."班".substr($kb["curr_class_num"],-2,2)."號".$kb["stud_name"]."<BR>"."學號：".$kb["student_id"]."</TD>";
  echo "<td>"."班級費"."</td>"."<td>".$kp["class"]."元"."</td>";
  echo "<td rowspan=4 >".$kq["note"]."</TD>";
  echo "<tr>"."<td>"."家長會費"."</td>"."<td>".$kp["parent"]."元"."</td>"."<tr>";
  echo "<td>"."學生團體保險費"."</td>"."<td>".$kp["stud_team"]."元"."</td>"."<tr>";
  echo "<td rowspan=1 >"."帳戶"."</td>"."<td>"."學生活動費"."</td>"."<td>".$kp["stud_move"]."元"."</td>"."<tr>";
  echo "<td rowspan=6 >".$kq["acc"]."</td>"."<td>"."電腦設備維護管理費"."</td>"."<td>".$kp["computer"]."元"."</td>";
  echo "<td rowspan=8  >"."元大銀行收款蓋章         2"."</TD>"."<tr>"."<td>"."教科書成本費"."</td>"."<td>".$kp["book"]."元"."</td>"."<tr>";
  echo "<td>"."校外教學代辦費"."</td>"."<td>".$kp["fieldtrip"]."元"."</td>"."<tr>";
  echo "<td>"."午餐基本費及燃料費"."</td>"."<td>".$kp["lunch"]."元"."</td>"."<tr>";
  echo "<td>".$kp["dii"]."月份午餐費"."</td>"."<td>".$kp["nowlunch"]."元"."</td>"."<tr>";
  echo "<td>"."合作社代辦費"."</td>"."<td>".$kp["shop"]."元"."</td>"."<tr>";
  echo "<td rowspan=1 >"."繳費期限"."</td>"."<td>"."英文CD"."</td>"."<td>".$kp["engcd"]."元"."</td>"."<tr>";
  echo "<td rowspan=2 >".substr($kq["time"],-6,2)."年".substr($kq["time"],-4,2)."月".substr($kq["time"],-2,2)."日"."~"."<BR>".substr($kq["endtime"],-6,2)."年".substr($kq["endtime"],-4,2)."月".substr($kq["endtime"],-2,2)."日"."</td>";
  echo "<td>"."合計應繳金額"."</td>"."<td>".$kp["toto"]."元"."</td>"."<tr>";
  echo "<td colspan=3 >".$kp["toto"]." (金額塗改無效)"."</td>";





}



}

}

}
}
?>