fork download
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta content="text/html; charset=UTF-8" http-equiv="content-type">
  5. <title>此專案內容總覽</title>
  6. <script src="jquery-2.1.4.min.js" type="text/javascript"></script>
  7. <script type="text/javascript">
  8. function show(s,i,obj){
  9. $("."+s).css("display",obj.checked?"block":"none");
  10. $("."+i).css("display",obj.checked?"block":"none");
  11. }
  12. </script>
  13. </head>
  14. <body>
  15. <?php
  16. @header('Content-Type: text/html; charset=utf-8');
  17. include("mysql.inc.php");
  18. $fieldArray = array('序號','發包日期','專案別','發案者','委外類別','委外工作內容','外包人員','外包金額','分期','比例','分期金額','扣款','扣款事由','實付金額','交件日期','請款日期','付款日期','請款憑據','備註');
  19. for($i=1;$i<=18;$i++){//列印18組左右的checkbox
  20. //echo "<input type='checkbox' checked onclick=\"show('s".($i+2)."','i".($i+2)."',this);\">{$fieldArray[$i]}";
  21. echo "<input type='checkbox' id='$i' class='css-checkbox sme' checked='checked' onclick=\"show('s".($i+2)."','i".($i+2)."',this);\"/>
  22. <label for='$i' name='checkbox66_lbl' class='css-label sme depressed'>{$fieldArray[$i]}</label>";
  23. }
  24.  
  25. $sql="SELECT * FROM bag";
  26. $result=mysql_query($sql);
  27. echo "<table border='1'>";
  28. $fieldArray = array('序號','發包日期','專案別','發案者','委外類別','委外工作內容','外包人員','外包金額','分期','比例','分期金額','扣款','扣款事由','實付金額','交件日期','請款日期','付款日期','請款憑據','備註');
  29. for($i=1;$i<=18;$i++){//把欄位名稱存進陣列迴圈列印出來
  30. echo "<td class='s".($i+2)."' style='display:'>{$fieldArray[$i]}</td>";
  31. }
  32. while ($row = mysql_fetch_array($result)){//將內容用迴圈列印出來
  33. echo "<tr>";
  34. for($i=3;$i<=20;$i++){
  35. echo "<td class='i".$i."' style='display:'>".$row[$i]."</td>";
  36. }
  37. echo "</tr>";
  38. }
  39. echo "</table>";
  40.  
  41. ?>
  42. </body>
  43. </html>
Runtime error #stdin #stdout #stderr 0.03s 52480KB
stdin
Standard input is empty
stdout
<!DOCTYPE html>
<html>
<head>
	<meta content="text/html; charset=UTF-8" http-equiv="content-type">
	<title>此專案內容總覽</title>
	<script src="jquery-2.1.4.min.js" type="text/javascript"></script>
	<script type="text/javascript">
		function show(s,i,obj){
			$("."+s).css("display",obj.checked?"block":"none");
			$("."+i).css("display",obj.checked?"block":"none");
		}
	</script>
</head>
<body>
<input type='checkbox' id='1' class='css-checkbox sme' checked='checked' onclick="show('s3','i3',this);"/>
		<label for='1' name='checkbox66_lbl' class='css-label sme depressed'>發包日期</label><input type='checkbox' id='2' class='css-checkbox sme' checked='checked' onclick="show('s4','i4',this);"/>
		<label for='2' name='checkbox66_lbl' class='css-label sme depressed'>專案別</label><input type='checkbox' id='3' class='css-checkbox sme' checked='checked' onclick="show('s5','i5',this);"/>
		<label for='3' name='checkbox66_lbl' class='css-label sme depressed'>發案者</label><input type='checkbox' id='4' class='css-checkbox sme' checked='checked' onclick="show('s6','i6',this);"/>
		<label for='4' name='checkbox66_lbl' class='css-label sme depressed'>委外類別</label><input type='checkbox' id='5' class='css-checkbox sme' checked='checked' onclick="show('s7','i7',this);"/>
		<label for='5' name='checkbox66_lbl' class='css-label sme depressed'>委外工作內容</label><input type='checkbox' id='6' class='css-checkbox sme' checked='checked' onclick="show('s8','i8',this);"/>
		<label for='6' name='checkbox66_lbl' class='css-label sme depressed'>外包人員</label><input type='checkbox' id='7' class='css-checkbox sme' checked='checked' onclick="show('s9','i9',this);"/>
		<label for='7' name='checkbox66_lbl' class='css-label sme depressed'>外包金額</label><input type='checkbox' id='8' class='css-checkbox sme' checked='checked' onclick="show('s10','i10',this);"/>
		<label for='8' name='checkbox66_lbl' class='css-label sme depressed'>分期</label><input type='checkbox' id='9' class='css-checkbox sme' checked='checked' onclick="show('s11','i11',this);"/>
		<label for='9' name='checkbox66_lbl' class='css-label sme depressed'>比例</label><input type='checkbox' id='10' class='css-checkbox sme' checked='checked' onclick="show('s12','i12',this);"/>
		<label for='10' name='checkbox66_lbl' class='css-label sme depressed'>分期金額</label><input type='checkbox' id='11' class='css-checkbox sme' checked='checked' onclick="show('s13','i13',this);"/>
		<label for='11' name='checkbox66_lbl' class='css-label sme depressed'>扣款</label><input type='checkbox' id='12' class='css-checkbox sme' checked='checked' onclick="show('s14','i14',this);"/>
		<label for='12' name='checkbox66_lbl' class='css-label sme depressed'>扣款事由</label><input type='checkbox' id='13' class='css-checkbox sme' checked='checked' onclick="show('s15','i15',this);"/>
		<label for='13' name='checkbox66_lbl' class='css-label sme depressed'>實付金額</label><input type='checkbox' id='14' class='css-checkbox sme' checked='checked' onclick="show('s16','i16',this);"/>
		<label for='14' name='checkbox66_lbl' class='css-label sme depressed'>交件日期</label><input type='checkbox' id='15' class='css-checkbox sme' checked='checked' onclick="show('s17','i17',this);"/>
		<label for='15' name='checkbox66_lbl' class='css-label sme depressed'>請款日期</label><input type='checkbox' id='16' class='css-checkbox sme' checked='checked' onclick="show('s18','i18',this);"/>
		<label for='16' name='checkbox66_lbl' class='css-label sme depressed'>付款日期</label><input type='checkbox' id='17' class='css-checkbox sme' checked='checked' onclick="show('s19','i19',this);"/>
		<label for='17' name='checkbox66_lbl' class='css-label sme depressed'>請款憑據</label><input type='checkbox' id='18' class='css-checkbox sme' checked='checked' onclick="show('s20','i20',this);"/>
		<label for='18' name='checkbox66_lbl' class='css-label sme depressed'>備註</label>
stderr
PHP Warning:  include(mysql.inc.php): failed to open stream: No such file or directory in /home/ULKFKM/prog.php on line 17
PHP Warning:  include(): Failed opening 'mysql.inc.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /home/ULKFKM/prog.php on line 17
PHP Fatal error:  Call to undefined function mysql_query() in /home/ULKFKM/prog.php on line 26