| Server IP : 27.254.66.5 / Your IP : 216.73.217.39 Web Server : Apache/2 System : Linux cs82.hostneverdie.com 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64 User : technic2 ( 1951) PHP Version : 7.4.30 Disable Function : apache_child_terminate, apache_setenv, define_syslog_variables, escapeshellarg, escapeshellcmd,exec, fp, fput, highlight_file, ini_alter, ini_restore, inject_code, passthru,phpAds_remoteInfo, phpAds_XmlRpc,phpAds_xmlrpcDecode, phpAds_xmlrpcEncode, popen, posix_getpwuid, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid,posix_setuid, posix_setuid, posix_uname,proc_open,proc_close, proc_get_status, proc_nice, proc_terminate, shell_exec, syslog, system, xmlrpc_entity_decode, show_source,sleep,pcntl_exec,virtual,suexec,dbmopen,dl,symlink,disk_free_space,diskfreespace,leak MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/technic2/domains/technicrayong.ac.th/public_html/old-website/jivec58east/ |
Upload File : |
<?php
session_start();
$_SESSION["osj_name"] = "no";
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>สิ่งประดิษฐ์ของคนรุ่นใหม่</title>
<style type="text/css">
.FontTahoma {font-family: Tahoma, Geneva, sans-serif;
}
</style>
<script language="javascript">
function fncSubmit()
{
if(document.form1.selectvec.value == "")
{
alert('กรุณาเลือกชื่อ อศจ.');
document.form1.selectvec.focus();
return false;
}
if(document.form1.passvec.value == "")
{
alert('กรุณาป้อนรหัสผ่าน');
document.form1.passvec.focus();
return false;
}
document.form1.submit();
}
</script>
</head>
<body bgcolor="#a0ff80">
<form name="form1" id="form1" method="post" action="checklogin.php" onSubmit="JavaScript:return fncSubmit();">
<table border="0" align="center" cellpadding="0" cellspacing="0" width="1000">
<tr class="FontTahoma">
<td><br><table border="0" align="center" cellpadding="0" cellspacing="0" width="1000">
<tr>
<td align="center" ><img src="vec_logo.png" width="170" height="169"></td>
<td><div align="center">
<br>
<h2>ระบบบันทึกข้อมูลสิ่งประดิษฐ์อาชีวศึกษา ระดับภาค<br>
ภาคตะวันออกและกรุงเทพมหานคร<br>
ปีการศึกษา 2558<br>
ประกวดระหว่างวันที่ 6-10 ธันวาคม 2558<br>
ณ โรงแรมสตาร์พลาซ่า จังหวัดระยอง
</h2><br>
</div></td>
<td align="center"><img src="inventor_logo.png" width="170" height="169"></td>
</tr>
<?php
require_once("config.php");
$sql = "select * from province";
$result = mysql_query($sql) or die ("คำสั่ง sql ผิด");
?>
<tr>
<td align="center" valign="top"><table width="95%" border="1">
<tr>
<td align="left"><p align="center"><strong>ประกาศ</strong></p>
<ul>
<li>เลื่อนวันจัดงาน เป็นวันที่ 6-10 ธ.ค. 58</li>
<li><a href="https://goo.gl/xsKPLU" target="_blank">กำหนดการจัดงาน</a></li>
<li><a href="https://goo.gl/KPLi4d" target="_blank">ข้อแนะนำในการตรวจสอบข้อมูล</a></li>
</ul>
<p> </p>
<p> </p>
<p> </p>
<p><br>
<br>
</p></td>
</tr>
</table></td>
<td><table width="80%" border="1" align="center">
<tr>
<td>
<p><strong>คำชี้แจง</strong></p>
1. เว็บไซต์นี้จะมีเฉพาะข้อมูลของสิ่งประดิษฐ์ ที่ผ่านเข้าสู่การแข่งขันระดับภาคเท่านั้น<br>
2. ให้อศจ. แต่ละจังหวัดตรวจสอบว่าจำนวนผลงานสิ่งประดิษฐ์ที่ผ่านเข้าสู่การแข่งขันระดับภาค ครบถ้วนและถูกต้องทุกประเภทหรือไม่<br>
3. อศจ. ใดที่ส่งประกวดประเภทองค์ความรู้ภาษาอังกฤษ (ประเภทที่ 12) จะต้องป้อนข้อมูลผลงานสิ่งประดิษฐ์ลงในเว็บไซต์นี้ด้วย<br>
4. ทุกผลงานสิ่งประดิษฐ์ที่จะประกวดระด้บภาค จะต้องพิมพ์ใบสมัครจากเว็บไซต์ ออกมาให้หัวหน้าสถานศึกษาลงนาม และนำใบสมัครดังกล่าว มายื่น ณ วันลงทะเบียน <br>
5. กรณีมีข้อสงสัยและต้องการติดต่อผู้ดูแลระบบ สามารถติดต่อได้ที่ อ.ปริญญา โทร : 0811660069 e-mail : prinya.c@gmail.com Line ID : Kit969<br>
<p align="right">24/พ.ย./2558</p></td>
</tr>
</table>
<br>
<table border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>กรุณาเลือกชื่อ อศจ. </td>
<td><select name="select_osj" id="select_osj">
<option value="">==================</option>
<?php
while ($row = mysql_fetch_array($result))
{
?>
<option value="<?php echo $row["province_id"]; ?>"><?php echo $row["osj_name"]; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>กรุณาป้อนรหัสผ่าน</td>
<td><input name="osj_password" type="password" id="osj_password" size="8" maxlength="8"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="button" id="button" value="Submit">
<input type="reset" name="button2" id="button2" value="Reset"></td>
</tr>
</table>
</td>
<td align="center" valign="top"><table width="95%" border="1">
<tr>
<td align="center"><p> </p>
<p style="color:#F00">เว็บไซต์จะปิดไม่ให้เพิ่ม/แก้ไข ข้อมูล<br>
ในวันจันทร์ที่ 30 พ.ย. 58<br>
เวลา 09.00 น.</p>
<p style="color:#F00">เพื่อนำข้อมูลจากเว็บไปใช้ในส่วนอื่น ๆ ที่เกี่ยวข้อง</p>
<p><br>
<br>
</p>
<p> </p>
<p><br>
<br>
</p></td>
</tr>
</table></td>
</tr>
</table>
<tr class="FontTahoma">
<td align="center"><p><strong>สรุปยอดการสมัครส่งผลงานเข้าประกวด</strong></p>
<table width="700" border="1" cellspacing="0" cellpadding="0">
<tr>
<th bgcolor="#FF9966">ประเภท</th>
<th bgcolor="#FF9966">ระดับ ปวช.</th>
<th bgcolor="#FF9966">ระดับ ปวส.</th>
<th bgcolor="#FF9966">รวม</th>
</tr>
<?php
require_once("config.php");
//$sql = "select invention_type, sum(invention_level like 'ปวช.' ) as L1, sum(invention_level like 'ปวส.' ) as L2, sum(invention_level like 'ปวช.' or invention_level like 'ปวส.' ) as L3 from jivec group by invention_type";
$sql = "select joe.invention_type, sum(invention_level like 'ปวช.' ) as L1, sum(invention_level like 'ปวส.' ) as L2, sum(invention_level like 'ปวช.' or invention_level like 'ปวส.' ) as L3 from (select invention.invention_type_id, jivec.* from invention join jivec on invention.invention_type_name = jivec.invention_type) as joe group by joe.invention_type order by joe.invention_type_id";
$result = mysql_query($sql) or die ("คำสั่ง sql ผิด");
?>
<?php
$TL1 = 0;
$TL2 = 0;
$TL3 = 0;
$x = 0;
while ($row = mysql_fetch_array($result))
{
$TL1 += $row["L1"];
$TL2 += $row["L2"];
$TL3 += $row["L3"];
$x++;
$class = ($x%2 == 0)? '#FFCC99': '#FFFF99';
?>
<tr bgcolor="<?php echo $class; ?>">
<td><?php echo $row["invention_type"]; ?></td>
<td align="center"><?php echo $row["L1"]; ?></td>
<td align="center"><?php echo $row["L2"]; ?></td>
<td align="center"><?php echo $row["L3"]; ?></td>
</tr>
<?php
}
?>
<tr>
<td align="center" bgcolor="#FF9966"><strong>รวม</strong></td>
<td align="center" bgcolor="#FF9966"><?php echo $TL1; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $TL2; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $TL3; ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<p><strong>สรุปภาพรวมราย อศจ.</strong></p>
<table width="900" border="1" cellspacing="0" cellpadding="0">
<tr>
<th bgcolor="#FF9966">ลำดับที่</th>
<th bgcolor="#FF9966">ชื่อ อศจ.</th>
<th bgcolor="#FF9966">ป 1</th>
<th bgcolor="#FF9966">ป 2</th>
<th bgcolor="#FF9966">ป 3</th>
<th bgcolor="#FF9966">ป 4</th>
<th bgcolor="#FF9966">ป 5</th>
<th bgcolor="#FF9966">ป 6</th>
<th bgcolor="#FF9966">ป 7</th>
<th bgcolor="#FF9966">ป 8</th>
<th bgcolor="#FF9966">ป 9</th>
<th bgcolor="#FF9966">ป 10</th>
<th bgcolor="#FF9966">ป 11</th>
<th bgcolor="#FF9966">ป 12</th>
<th bgcolor="#FF9966">รวม</th>
</tr>
<?php
//$con = mysql_connect("localhost", "root", "prakit992508*") or die ("เชื่อต่อฐานข้อมูลไม่ได้");
//mysql_select_db("jivec", $con) or die ("ติดต่อก้อนฐานข้อมูลไม่ได้");
//mysql_query("set names utf8");
require_once("config.php");
//$sql2 = "select jivec.vocational_name, sum(invention.invention_type_id = 1) as p1, sum(invention.invention_type_id = 2) as p2, sum(invention.invention_type_id = 3) as p3, sum(invention.invention_type_id = 4) as p4, sum(invention.invention_type_id = 5) as p5, sum(invention.invention_type_id = 6) as p6, sum(invention.invention_type_id = 7) as p7, sum(invention.invention_type_id = 8) as p8, sum(invention.invention_type_id = 9) as p9, sum(invention.invention_type_id = 10) as p10, sum(invention.invention_type_id = 11) as p11 from invention, jivec WHERE invention.invention_type_name = jivec.invention_type group by vocational_name";
$sql2 = "select sim.vocational_name, sum(invention.invention_type_id = 1) as p1, sum(invention.invention_type_id = 2) as p2, sum(invention.invention_type_id = 3) as p3, sum(invention.invention_type_id = 4) as p4, sum(invention.invention_type_id = 5) as p5, sum(invention.invention_type_id = 6) as p6, sum(invention.invention_type_id = 7) as p7, sum(invention.invention_type_id = 8) as p8, sum(invention.invention_type_id = 9) as p9, sum(invention.invention_type_id = 10) as p10, sum(invention.invention_type_id = 11) as p11, sum(invention.invention_type_id = 12) as p12 from invention,
(select province.province_id, jivec.* from province join jivec on province.osj_name = jivec.vocational_name) as sim WHERE invention.invention_type_name = sim.invention_type group by sim.vocational_name order by sim.province_id";
$resultv2 = mysql_query($sql2) or die ("คำสั่ง sql ผิด");
?>
<?php
$Tpv1 = 0;
$Tpv2 = 0;
$Tpv3 = 0;
$Tpv4 = 0;
$Tpv5 = 0;
$Tpv6 = 0;
$Tpv7 = 0;
$Tpv8 = 0;
$Tpv9 = 0;
$Tpv10 = 0;
$Tpv11 = 0;
$Tpv12 = 0;
$countv = 0;
$xv = 0;
while ($rowv2 = mysql_fetch_array($resultv2))
{
$Tpv1 += $rowv2["p1"];
$Tpv2 += $rowv2["p2"];
$Tpv3 += $rowv2["p3"];
$Tpv4 += $rowv2["p4"];
$Tpv5 += $rowv2["p5"];
$Tpv6 += $rowv2["p6"];
$Tpv7 += $rowv2["p7"];
$Tpv8 += $rowv2["p8"];
$Tpv9 += $rowv2["p9"];
$Tpv10 += $rowv2["p10"];
$Tpv11 += $rowv2["p11"];
$Tpv12 += $rowv2["p12"];
$countv += 1;
$xv++;
$class = ($xv%2 == 0)? '#FFCC99': '#FFFF99';
?>
<tr bgcolor="<?php echo $class; ?>">
<td align="center"><?php echo $countv; ?></td>
<td><?php echo $rowv2["vocational_name"]; ?></td>
<td align="center"><?php echo $rowv2["p1"]; ?></td>
<td align="center"><?php echo $rowv2["p2"]; ?></td>
<td align="center"><?php echo $rowv2["p3"]; ?></td>
<td align="center"><?php echo $rowv2["p4"]; ?></td>
<td align="center"><?php echo $rowv2["p5"]; ?></td>
<td align="center"><?php echo $rowv2["p6"]; ?></td>
<td align="center"><?php echo $rowv2["p7"]; ?></td>
<td align="center"><?php echo $rowv2["p8"]; ?></td>
<td align="center"><?php echo $rowv2["p9"]; ?></td>
<td align="center"><?php echo $rowv2["p10"]; ?></td>
<td align="center"><?php echo $rowv2["p11"]; ?></td>
<td align="center"><?php echo $rowv2["p12"]; ?></td>
<td align="center"><?php echo ($rowv2["p1"] + $rowv2["p2"] + $rowv2["p3"] + $rowv2["p4"] + $rowv2["p5"] + $rowv2["p6"] + $rowv2["p7"] + $rowv2["p8"] + $rowv2["p9"] + $rowv2["p10"] + $rowv2["p11"] + $rowv2["p12"]); ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="2" align="center" bgcolor="#FF9966"><strong>รวม</strong></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv1; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv2; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv3; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv4; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv5; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv6; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv7; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv8; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv9; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv10; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv11; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tpv12; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo ($Tpv1 + $Tpv2 + $Tpv3 + $Tpv4 + $Tpv5 + $Tpv6 + $Tpv7 + $Tpv8 + $Tpv9 + $Tpv10 + $Tpv11 + $Tpv12); ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<p><strong>สรุปภาพรวมรายวิทยาลัย</strong></p>
<table width="900" border="1" cellspacing="0" cellpadding="0">
<tr>
<th bgcolor="#FF9966">ลำดับที่</th>
<th bgcolor="#FF9966">ชื่อวิทยาลัย</th>
<th bgcolor="#FF9966">ป 1</th>
<th bgcolor="#FF9966">ป 2</th>
<th bgcolor="#FF9966">ป 3</th>
<th bgcolor="#FF9966">ป 4</th>
<th bgcolor="#FF9966">ป 5</th>
<th bgcolor="#FF9966">ป 6</th>
<th bgcolor="#FF9966">ป 7</th>
<th bgcolor="#FF9966">ป 8</th>
<th bgcolor="#FF9966">ป 9</th>
<th bgcolor="#FF9966">ป 10</th>
<th bgcolor="#FF9966">ป 11</th>
<th bgcolor="#FF9966">ป 12</th>
<th bgcolor="#FF9966">รวม</th>
</tr>
<?php
//$con = mysql_connect("localhost", "root", "prakit992508*") or die ("เชื่อต่อฐานข้อมูลไม่ได้");
//mysql_select_db("jivec", $con) or die ("ติดต่อก้อนฐานข้อมูลไม่ได้");
//mysql_query("set names utf8");
require_once("config.php");
$sql2 = "select invention.invention_type_id, jivec.college_name, sum(invention.invention_type_id = 1) as p1, sum(invention.invention_type_id = 2) as p2, sum(invention.invention_type_id = 3) as p3, sum(invention.invention_type_id = 4) as p4, sum(invention.invention_type_id = 5) as p5, sum(invention.invention_type_id = 6) as p6, sum(invention.invention_type_id = 7) as p7, sum(invention.invention_type_id = 8) as p8, sum(invention.invention_type_id = 9) as p9, sum(invention.invention_type_id = 10) as p10, sum(invention.invention_type_id = 11) as p11, sum(invention.invention_type_id = 12) as p12 from invention, jivec WHERE invention.invention_type_name = jivec.invention_type group by college_name";
$result2 = mysql_query($sql2) or die ("คำสั่ง sql ผิด");
?>
<?php
$Tp1 = 0;
$Tp2 = 0;
$Tp3 = 0;
$Tp4 = 0;
$Tp5 = 0;
$Tp6 = 0;
$Tp7 = 0;
$Tp8 = 0;
$Tp9 = 0;
$Tp10 = 0;
$Tp11 = 0;
$Tp12 = 0;
$count = 0;
$x = 0;
while ($row2 = mysql_fetch_array($result2))
{
$Tp1 += $row2["p1"];
$Tp2 += $row2["p2"];
$Tp3 += $row2["p3"];
$Tp4 += $row2["p4"];
$Tp5 += $row2["p5"];
$Tp6 += $row2["p6"];
$Tp7 += $row2["p7"];
$Tp8 += $row2["p8"];
$Tp9 += $row2["p9"];
$Tp10 += $row2["p10"];
$Tp11 += $row2["p11"];
$Tp12 += $row2["p12"];
$count += 1;
$x++;
$class = ($x%2 == 0)? '#FFCC99': '#FFFF99';
?>
<tr bgcolor="<?php echo $class; ?>">
<td align="center"><?php echo $count; ?></td>
<td><?php echo $row2["college_name"]; ?></td>
<td align="center"><?php echo $row2["p1"]; ?></td>
<td align="center"><?php echo $row2["p2"]; ?></td>
<td align="center"><?php echo $row2["p3"]; ?></td>
<td align="center"><?php echo $row2["p4"]; ?></td>
<td align="center"><?php echo $row2["p5"]; ?></td>
<td align="center"><?php echo $row2["p6"]; ?></td>
<td align="center"><?php echo $row2["p7"]; ?></td>
<td align="center"><?php echo $row2["p8"]; ?></td>
<td align="center"><?php echo $row2["p9"]; ?></td>
<td align="center"><?php echo $row2["p10"]; ?></td>
<td align="center"><?php echo $row2["p11"]; ?></td>
<td align="center"><?php echo $row2["p12"]; ?></td>
<td align="center"><?php echo ($row2["p1"] + $row2["p2"] + $row2["p3"] + $row2["p4"] + $row2["p5"] + $row2["p6"] + $row2["p7"] + $row2["p8"] + $row2["p9"] + $row2["p10"] + $row2["p11"]+ $row2["p12"]); ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="2" align="center" bgcolor="#FF9966"><strong>รวม</strong></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp1; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp2; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp3; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp4; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp5; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp6; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp7; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp8; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp9; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp10; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp11; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tp12; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo ($Tp1 + $Tp2 + $Tp3 + $Tp4 + $Tp5 + $Tp6 + $Tp7 + $Tp8 + $Tp9 + $Tp10 + $Tp11+ $Tp12); ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<p><strong>สรุปจำนวนผู้เข้าร่วมงาน ราย อศจ.</strong></p>
<table width="900" border="1" cellspacing="0" cellpadding="0">
<tr>
<th bgcolor="#FF9966">ลำดับที่</th>
<th bgcolor="#FF9966">ชื่อ อศจ.</th>
<th bgcolor="#FF9966">นักศึกษาชาย</th>
<th bgcolor="#FF9966">นักศึกษาหญิง</th>
<th bgcolor="#FF9966">ครูที่ปรึกษาชาย</th>
<th bgcolor="#FF9966">ครูที่ปรึกษาหญิง</th>
<th bgcolor="#FF9966">รวม</th>
</tr>
<?php
//$con = mysql_connect("localhost", "root", "prakit992508*") or die ("เชื่อต่อฐานข้อมูลไม่ได้");
//mysql_select_db("jivec", $con) or die ("ติดต่อก้อนฐานข้อมูลไม่ได้");
//mysql_query("set names utf8");
require_once("config.php");
//$sql4 = "select vocational_name, sum(male_student_amount) as n1, sum(female_student_amount) as n2, sum(male_advisor_amount) as n3, sum(female_advisor_amount) as n4 from jivec group by vocational_name";
$sql4 = "select kit.vocational_name, sum(male_student_amount) as n1, sum(female_student_amount) as n2, sum(male_advisor_amount) as n3, sum(female_advisor_amount) as n4 from (select province.province_id, jivec.* from province join jivec on province.osj_name = jivec.vocational_name) as kit group by kit.vocational_name order by kit.province_id";
$result4 = mysql_query($sql4) or die ("คำสั่ง sql ผิด");
?>
<?php
$Tn1 = 0;
$Tn2 = 0;
$Tn3 = 0;
$Tn4 = 0;
$count = 0;
$x = 0;
while ($row4 = mysql_fetch_array($result4))
{
$Tn1 += $row4["n1"];
$Tn2 += $row4["n2"];
$Tn3 += $row4["n3"];
$Tn4 += $row4["n4"];
$count += 1;
$x++;
$class = ($x%2 == 0)? '#FFCC99': '#FFFF99';
?>
<tr bgcolor="<?php echo $class; ?>">
<td align="center"><?php echo $count; ?></td>
<td><?php echo $row4["vocational_name"]; ?></td>
<td align="center"><?php echo $row4["n1"]; ?></td>
<td align="center"><?php echo $row4["n2"]; ?></td>
<td align="center"><?php echo $row4["n3"]; ?></td>
<td align="center"><?php echo $row4["n4"]; ?></td>
<td align="center"><?php echo ($row4["n1"] + $row4["n2"] + $row4["n3"] + $row4["n4"]); ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="2" align="center" bgcolor="#FF9966"><strong>รวม</strong></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tn1; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tn2; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tn3; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo $Tn4; ?></td>
<td align="center" bgcolor="#FF9966"><?php echo ($Tn1 + $Tn2 + $Tn3 + $Tn4); ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<p><strong>สรุปรายละเอียดเพิ่มเติม</strong></p>
<table width="900" border="1" cellspacing="0" cellpadding="0">
<?php
require_once("config.php");
$sql5 = "select sum(power220v != '') as u1, sum(power380v != '') as u2, sum(use_water != '') as u3, sum(use_gas != '') as u4, sum(use_fuel_engine != '') as u5, sum(pollution like 'มีมลพิษ') as u6, sum(have_noise != '') as u7, sum(have_exhaust != '') as u8, sum(have_smoke != '') as u9 from jivec";
$result5 = mysql_query($sql5) or die ("คำสั่ง sql ผิด");
?>
<?php
while ($row5 = mysql_fetch_array($result5))
{
?>
<tr>
<td bgcolor="#FF9966">ใช้ไฟฟ้า 220V</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u1"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">ใช้ไฟฟ้า 380V</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u2"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">ใช้น้ำประปา</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u3"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">ใช้แก๊สหุงต้ม</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u4"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">ใช้เชื้อเพลิง</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u5"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">มีมลพิษ</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u6"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">มีเสียงดัง</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u7"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">มีไอเสีย</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u8"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<tr>
<td bgcolor="#FF9966">มีควันไฟ</td>
<td bgcolor="#FFCC99" align="center"><?php echo $row5["u9"]; ?></td>
<td bgcolor="#FFFF99" align="center">ชิ้น</td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>