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>"; } } } } } ?> |
Direct link: https://paste.plurk.com/show/146709