ช่วยแนะนำหน่อยคับ ต้องการให้มันออกมาสวยคับ ไม่รุ้จะต้องทำไงดี
ขอโทษทีคับ นี้โค๊ดคับ
Date :
2010-08-08 20:04:42By :
เด็กไม่เก่ง
ขอร้่องงงงงงงงงงละคับ ผมต้องการจริๆงคับ
Date :
2010-08-08 20:46:04By :
เด็กไม่เก่ง
พี่ๆคับช่วยสน่อยคับ
Date :
2010-08-09 10:09:47By :
เด็กมัยเก่ง
Date :
2010-08-09 14:08:25By :
เด็กไม่เก่ง
ทไงดัคับ ให้มันแสดงออกมาเป็นดังที่ถามไว้คับ ช่วยด้วยคับบบบบบบบบบบบบบบบ
Date :
2010-08-09 15:11:45By :
เด็กไม่เก่ง
พี่ๆคับ ช่วยยยยยยยยยยยยยยด้วยยยยยยยยยยยยยยยยยยย
Date :
2010-08-09 22:55:09By :
เด็กไม่เก่ง
แก้ไข script เดิมให้นะครับเด๋วไม่เข้าใจเอา
Date :
2010-08-10 00:13:38By :
modboyit
มัน error คับพี่ ต้องการให้มันแสดงตามกระทู้คับ ตอนนี้มันแสดงออกมาแบบนี้คับ
Date :
2010-08-10 00:41:47By :
เด็กไม่เก่ง
ใส่ table เข้าไปครับ นี่ตัวอย่าง
Date :
2010-08-10 05:57:27By :
PlaKriM
ถ้าใส่tableนี้เข้าไป นตัวแปรของage จะเป็นสีดำ ไม่สามารถทำได้คับ
Date :
2010-08-10 11:10:43By :
เด็กฝึกหัด
เอาละซิ งามหน้าไหมเนี้ย ไม่ยอมให้เค้าหมด
ประวัติการแก้ไข
Date :
2010-08-10 12:21:08By :
PlaKriM
55555 งานเข้าแล้วครับพี่ปลากริม
Date :
2010-08-10 12:23:29By :
Dragons_first
พี่มันerrorแบบนี้คะ
Date :
2010-08-10 13:07:46By :
เด็กไม่เก่ง
ขอบคุณ ผมได้เป้นแนวทางในการ join ข้อมูลเลย
Date :
2010-08-10 13:26:00By :
computer_psu031
ให้ช่วยนะคะ ไม่ได้ให้ก็อป
Date :
2010-08-10 14:48:26By :
เด็กไม่เก่ง
ที่แรกCode (PHP) <?php
}
##################################################################
if($select=="age"){
Code (PHP) </table>
<?php
}
?>
</div></td>
Date :
2010-08-10 15:23:40By :
PlaKriM
พี่ ereor
Date :
2010-08-10 16:51:39By :
เด็กไม่เก่ง
ผิดตรงไหนคะ ช่วยหน่อยคะ
Date :
2010-08-10 23:20:39By :
เด็กฝึกหัด
Code (PHP) <?php
<FONT size=10>}
</FONT>
?> <<<,///เพิ่มเข้าไปครับ บรรทัดที่ 157
ประวัติการแก้ไข
Date :
2010-08-11 10:14:19By :
pob_suwan
ใส่แล้ว ยังเหมือนเดิม
Date :
2010-08-11 10:19:33By :
เด็กฝึกหัด
ผิดตรงไหนคะ ช่วยด้วยยยยยยยยยยยยยยยยยยยยยย
Date :
2010-08-11 11:31:39By :
เด็กฝึกหัด
<FONT size=10>}</FONT>
Date :
2010-08-11 11:47:41By :
PlaKriM
เป็นแบบนี้อีกแล้ว
Date :
2010-08-11 13:13:53By :
เด็กฝึกหัด
ผิดตรงไหนอีกแล้วคะ ช่วยด้วยยยยยยยยยยยยย
Date :
2010-08-11 13:48:29By :
เด็กฝึกหัด
เอาโค๊ดมาดูครับ แล้วอย่าลืมครอบด้วย code php ด้วย
Date :
2010-08-11 13:49:03By :
PlaKriM
นี้โค๊ดคะ
Date :
2010-08-11 14:07:20By :
เด็กไม่เก่ง
กรรม บอกให้ครอบด้วย code php หน่อย แล้วผมจะรู้ไหมเนี้ย 275 มันอยู่บรรทัดไหน
Date :
2010-08-11 14:18:14By :
PlaKriM
Code (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>แสดงรายงานสรุปสถิติ</title>
<style type="text/css">
<!--
body {
background-image: url(image/background.gif);
}
-->
</style></head>
<body>
<center>
<form name="form1" method="post" action="">
<p> </p>
<p> </p>
<table width="448" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><strong>ต้องการแสดงสรุปรายงานสถิติ : </strong></td>
<td><select name="select">
<option value="0" selected="selected">โปรดเลือก</option>
<option value="sex">รายงานสถิติตามเพศ</option>
<option value="age">รายงานสถิติตามอายุ</option>
</select>
<input type="submit" name="button" id="button" value="ตกลง" /></td>
</tr>
</table>
</form>
</center>
<table width="607" height="119" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td><p align="center">
<?
$select=$_POST[select];
?>
</p>
<div align="left">
<?
$host="localhost";
$user="root";
$pass="123";
$dbname = "cal";
$connect=mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$sql = "SELECT*FROM(
SELECT
(select count(*) from bmi_db where sex = 'male') as count_male_all,
(select count(*) from bmi_db where sex = 'male' and BMI <20 ) as count_male_20,
(select count(*) from bmi_db where sex = 'male' and BMI >=20 and BMI <25 ) as count_male_25,
(select count(*) from bmi_db where sex = 'male' and BMI >=25 and BMI <29 ) as count_male_29,
(select count(*) from bmi_db where sex = 'male' and BMI >=29 ) as count_male_mex,
(select count(*) from bmi_db where sex = 'female') as count_female_all,
(select count(*) from bmi_db where sex = 'female' and BMI <20 ) as count_female_20,
(select count(*) from bmi_db where sex = 'female' and BMI >=20 and BMI <25 ) as count_female_25,
(select count(*) from bmi_db where sex = 'female' and BMI >=25 and BMI <29 ) as count_female_29,
(select count(*) from bmi_db where sex = 'female' and BMI >=29 ) as count_female_mex,
(select count(*) from bmi_db where age>=1 and age<=12) as count_1to12_all,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI < 20) as count_1to12_20,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=20 and BMI <25) as count_1to12_25,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=25 and BMI <29) as count_1to12_29,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=29) as count_1to12_mex,
(select count(*) from bmi_db where age>=13 and age<=19) as count_13to19_all,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI < 20) as count_13to19_20,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=20 and BMI <25) as count_13to19_25,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=25 and BMI <29) as count_13to19_29,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=29) as count_13to19_mex,
(select count(*) from bmi_db where age>=20 and age<=54) as count_20to54_all,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI < 20) as count_20to54_20,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=20 and BMI <25) as count_20to54_25,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=25 and BMI <29) as count_20to54_29,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=29) as count_20to54_mex,
(select count(*) from bmi_db where age>=55 and age<=100) as count_55to100_all,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI < 20) as count_55to100_20,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=20 and BMI <25) as count_55to100_25,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=25 and BMI <29) as count_55to100_29,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=29) as count_55to100_mex
FROM
bmi_db LIMIT 0,1
)a";
echo" <br>";
$query = mysql_query($sql);
if($select=="sex"){
//echo"เลือก รายงานสถิติตามเพศ <br>";//
?>
<table width="308" align="center">
<tr>
<td><div align="center"><strong>เพศ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>ชาย</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_male_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_male_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_male_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_male_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_male_mex; ?></td>
</tr>
<tr>
<td><strong>หญิง</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_female_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_female_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_female_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_female_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_female_mex; ?></td>
</tr>
</table>
<?php
}
##################################################################
if($select=="age"){
//echo"เลือก รายงานสถิติตามอายุ <br>";/
//1-12
?>
<table width="374" align="center">
<tr>
<td><div align="center"><strong>อายุ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>1 - 12 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_1to12_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_1to12_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_1to12_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_1to12_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_1to12_mex; ?></td>
</tr>
<tr>
<td><strong>13 - 19 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_13to19_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_13to19_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_13to19_25;?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_13to19_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_13to19_mex; ?></td>
</tr>
<tr>
<td><strong>20 - 54 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_20to54_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_20to54_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_20to54_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_20to54_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_20to54_mex; ?></td>
</tr>
<tr>
<td><strong>55 - 100</strong> </td>
<td>ทั้งหมด</td>
<td><?php echo $count_55to100_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_55to100_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_55to100_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_55to100_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_55to100_mex; ?></td>
</tr>
</table>
<?php
}
</td>
</tr>
</table>
<p> </p>
<p align="center"><a href="adin.php"><strong>กลับ</strong></a></p>
</body>
</html>
Date :
2010-08-11 14:24:50By :
pob_suwan
Code (PHP) <?php
}
?>
?> ไม่ได้ใส่ ครับCode (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>แสดงรายงานสรุปสถิติ</title>
<style type="text/css">
<!--
body {
background-image: url(image/background.gif);
}
-->
</style></head>
<body>
<center>
<form name="form1" method="post" action="">
<p> </p>
<p> </p>
<table width="448" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><strong>ต้องการแสดงสรุปรายงานสถิติ : </strong></td>
<td><select name="select">
<option value="0" selected="selected">โปรดเลือก</option>
<option value="sex">รายงานสถิติตามเพศ</option>
<option value="age">รายงานสถิติตามอายุ</option>
</select>
<input type="submit" name="button" id="button" value="ตกลง" /></td>
</tr>
</table>
</form>
</center>
<table width="607" height="119" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td><p align="center">
<?
$select=$_POST[select];
?>
</p>
<div align="left">
<?
$host="localhost";
$user="root";
$pass="123";
$dbname = "cal";
$connect=mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$sql = "SELECT*FROM(
SELECT
(select count(*) from bmi_db where sex = 'male') as count_male_all,
(select count(*) from bmi_db where sex = 'male' and BMI <20 ) as count_male_20,
(select count(*) from bmi_db where sex = 'male' and BMI >=20 and BMI <25 ) as count_male_25,
(select count(*) from bmi_db where sex = 'male' and BMI >=25 and BMI <29 ) as count_male_29,
(select count(*) from bmi_db where sex = 'male' and BMI >=29 ) as count_male_mex,
(select count(*) from bmi_db where sex = 'female') as count_female_all,
(select count(*) from bmi_db where sex = 'female' and BMI <20 ) as count_female_20,
(select count(*) from bmi_db where sex = 'female' and BMI >=20 and BMI <25 ) as count_female_25,
(select count(*) from bmi_db where sex = 'female' and BMI >=25 and BMI <29 ) as count_female_29,
(select count(*) from bmi_db where sex = 'female' and BMI >=29 ) as count_female_mex,
(select count(*) from bmi_db where age>=1 and age<=12) as count_1to12_all,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI < 20) as count_1to12_20,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=20 and BMI <25) as count_1to12_25,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=25 and BMI <29) as count_1to12_29,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=29) as count_1to12_mex,
(select count(*) from bmi_db where age>=13 and age<=19) as count_13to19_all,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI < 20) as count_13to19_20,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=20 and BMI <25) as count_13to19_25,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=25 and BMI <29) as count_13to19_29,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=29) as count_13to19_mex,
(select count(*) from bmi_db where age>=20 and age<=54) as count_20to54_all,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI < 20) as count_20to54_20,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=20 and BMI <25) as count_20to54_25,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=25 and BMI <29) as count_20to54_29,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=29) as count_20to54_mex,
(select count(*) from bmi_db where age>=55 and age<=100) as count_55to100_all,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI < 20) as count_55to100_20,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=20 and BMI <25) as count_55to100_25,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=25 and BMI <29) as count_55to100_29,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=29) as count_55to100_mex
FROM
bmi_db LIMIT 0,1
)a";
echo" <br>";
$query = mysql_query($sql);
if($select=="sex"){
//echo"เลือก รายงานสถิติตามเพศ <br>";//
?>
<table width="308" align="center">
<tr>
<td><div align="center"><strong>เพศ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>ชาย</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_male_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_male_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_male_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_male_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_male_mex; ?></td>
</tr>
<tr>
<td><strong>หญิง</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_female_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_female_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_female_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_female_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_female_mex; ?></td>
</tr>
</table>
<?php
}
##################################################################
if($select=="age"){
//echo"เลือก รายงานสถิติตามอายุ <br>";/
//1-12
?>
<table width="374" align="center">
<tr>
<td><div align="center"><strong>อายุ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>1 - 12 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_1to12_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_1to12_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_1to12_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_1to12_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_1to12_mex; ?></td>
</tr>
<tr>
<td><strong>13 - 19 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_13to19_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_13to19_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_13to19_25;?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_13to19_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_13to19_mex; ?></td>
</tr>
<tr>
<td><strong>20 - 54 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_20to54_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_20to54_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_20to54_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_20to54_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_20to54_mex; ?></td>
</tr>
<tr>
<td><strong>55 - 100</strong> </td>
<td>ทั้งหมด</td>
<td><?php echo $count_55to100_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_55to100_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_55to100_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_55to100_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_55to100_mex; ?></td>
</tr>
</table>
<?php
}
?>
</td>
</tr>
</table>
<p> </p>
<p align="center"><a href="adin.php"><strong>กลับ</strong></a></p>
</body>
</html>
ประวัติการแก้ไข
Date :
2010-08-11 14:30:03By :
pob_suwan
พี่คะ มันไม่แสดงค่าที่คนออกมาคะ เป็นเพราะอะไรหรือคะ
Date :
2010-08-11 15:19:55By :
เด็กฝึกหัด
Code (PHP) <tr>
104.<td><strong>ชาย</strong></td>
105.<td>ทั้งหมด</td>
106.<td><?php echo $count_male_all; ?></td> <<<<<<แกส่วนนี้ดูครับ เป็น <?php echo "$count_male_all"; ?>
107.</tr>
Date :
2010-08-11 15:38:03By :
pob_suwan
ไม่ออกคะ ยังไม่ออกมาคะพี่ๆ
Date :
2010-08-11 16:10:20By :
เด็กฝึกหัด
Code (PHP) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>แสดงรายงานสรุปสถิติ</title>
<style type="text/css">
<!--
body {
background-image: url(image/background.gif);
}
-->
</style></head>
<body>
<center>
<form name="form1" method="post" action="">
<p> </p>
<p> </p>
<table width="448" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><strong>ต้องการแสดงสรุปรายงานสถิติ : </strong></td>
<td><select name="select">
<option value="0" selected="selected">โปรดเลือก</option>
<option value="sex">รายงานสถิติตามเพศ</option>
<option value="age">รายงานสถิติตามอายุ</option>
</select>
<input type="submit" name="button" id="button" value="ตกลง" /></td>
</tr>
</table>
</form>
</center>
<table width="607" height="119" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td><p align="center">
<?
$select=$_POST[select];
?>
</p>
<div align="left">
<?
$host="localhost";
$user="root";
$pass="123";
$dbname = "cal";
$connect=mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$sql = "SELECT*FROM(
SELECT
(select count(*) from bmi_db where sex = 'male') as count_male_all,
(select count(*) from bmi_db where sex = 'male' and BMI <20 ) as count_male_20,
(select count(*) from bmi_db where sex = 'male' and BMI >=20 and BMI <25 ) as count_male_25,
(select count(*) from bmi_db where sex = 'male' and BMI >=25 and BMI <29 ) as count_male_29,
(select count(*) from bmi_db where sex = 'male' and BMI >=29 ) as count_male_mex,
(select count(*) from bmi_db where sex = 'female') as count_female_all,
(select count(*) from bmi_db where sex = 'female' and BMI <20 ) as count_female_20,
(select count(*) from bmi_db where sex = 'female' and BMI >=20 and BMI <25 ) as count_female_25,
(select count(*) from bmi_db where sex = 'female' and BMI >=25 and BMI <29 ) as count_female_29,
(select count(*) from bmi_db where sex = 'female' and BMI >=29 ) as count_female_mex,
(select count(*) from bmi_db where age>=1 and age<=12) as count_1to12_all,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI < 20) as count_1to12_20,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=20 and BMI <25) as count_1to12_25,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=25 and BMI <29) as count_1to12_29,
(select count(*) from bmi_db where age>=1 and age<=12 and BMI >=29) as count_1to12_mex,
(select count(*) from bmi_db where age>=13 and age<=19) as count_13to19_all,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI < 20) as count_13to19_20,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=20 and BMI <25) as count_13to19_25,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=25 and BMI <29) as count_13to19_29,
(select count(*) from bmi_db where age>=13 and age<=19 and BMI >=29) as count_13to19_mex,
(select count(*) from bmi_db where age>=20 and age<=54) as count_20to54_all,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI < 20) as count_20to54_20,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=20 and BMI <25) as count_20to54_25,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=25 and BMI <29) as count_20to54_29,
(select count(*) from bmi_db where age>=20 and age<=54 and BMI >=29) as count_20to54_mex,
(select count(*) from bmi_db where age>=55 and age<=100) as count_55to100_all,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI < 20) as count_55to100_20,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=20 and BMI <25) as count_55to100_25,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=25 and BMI <29) as count_55to100_29,
(select count(*) from bmi_db where age>=55 and age<=100 and BMI >=29) as count_55to100_mex
FROM
bmi_db LIMIT 0,1
)a";
echo" <br>";
$query = mysql_query($sql);
if($select=="sex"){
//echo"เลือก รายงานสถิติตามเพศ <br>";//
$count_male_all = mysql_result($query,0,'count_male_all'); // ผู้ชายทั้งหมด
$count_male_20 = mysql_result($query,0,'count_male_20'); // ผู้ชายผอม
$count_male_25 = mysql_result($query,0,'count_male_25'); // ผู้ชายปกติ
$count_male_29 = mysql_result($query,0,'count_male_29'); // ผู้ชายอ้วน
$count_male_mex = mysql_result($query,0,'count_male_mex'); // ผู้ชายอ้วนมากๆ
$count_female_all = mysql_result($query,0,'count_female_all'); // ผู้หญิงทั้งหมด
$count_female_20 = mysql_result($query,0,'count_female_20'); // ผู้หญิงผอม
$count_female_25 = mysql_result($query,0,'count_female_25'); // ผู้หญิงปกติ
$count_female_29 = mysql_result($query,0,'count_female_29'); // ผู้หญิงอ้วน
$count_female_mex = mysql_result($query,0,'count_female_mex'); // ผู้หญิงอ้วนมากๆ
?>
<table width="308" align="center">
<tr>
<td><div align="center"><strong>เพศ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>ชาย</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_male_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_male_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_male_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_male_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_male_mex; ?></td>
</tr>
<tr>
<td><strong>หญิง</strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_female_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_female_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_female_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_female_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_female_mex; ?></td>
</tr>
</table>
<?php
}
##################################################################
if($select=="age"){
//echo"เลือก รายงานสถิติตามอายุ <br>";/
//1-12
$count_1to12_all = mysql_result($query,0,'count_1to12_all'); // อายุ 0-12 ทั้งหมด
$count_1to12_20 = mysql_result($query,0,'count_1to12_20'); // อายุ 0-12 ผอม
$count_1to12_25 = mysql_result($query,0,'count_1to12_25'); // อายุ 0-12 ปกติ
$count_1to12_29 = mysql_result($query,0,'count_1to12_29'); // อายุ 0-12 อ้วน
$count_1to12_mex = mysql_result($query,0,'count_1to12_mex'); // อายุ 0-12 อ้วนมากๆ
//13 - 19
$count_13to19_all = mysql_result($query,0,'count_13to19_all'); // อายุ 15-18 ทั้งหมด
$count_13to19_20 = mysql_result($query,0,'count_13to19_20'); // อายุ 15-18 ผอม
$count_13to19_25 = mysql_result($query,0,'count_13to19_25'); // อายุ 15-18 ปกติ
$count_13to19_29 = mysql_result($query,0,'count_13to19_29'); // อายุ 15-18 อ้วน
$count_13to19_mex = mysql_result($query,0,'count_13to19_mex'); // อายุ 15-18 อ้วนมากๆ
//20 - 54
$count_20to54_all = mysql_result($query,0,'count_20to54_all'); // อายุ 15-18 ทั้งหมด
$count_20to54_20 = mysql_result($query,0,'count_20to54_20'); // อายุ 15-18 ผอม
$count_20to54_25 = mysql_result($query,0,'count_20to54_25'); // อายุ 15-18 ปกติ
$count_20to54_29 = mysql_result($query,0,'count_20to54_29'); // อายุ 15-18 อ้วน
$count_20to54_mex = mysql_result($query,0,'count_20to54_mex'); // อายุ 15-18 อ้วนมากๆ
//55 - 100
$count_55to100_all = mysql_result($query,0,'count_55to100_all'); // อายุ 15-18 ทั้งหมด
$count_55to100_20 = mysql_result($query,0,'count_55to100_20'); // อายุ 15-18 ผอม
$count_55to100_25 = mysql_result($query,0,'count_55to100_25'); // อายุ 15-18 ปกติ
$count_55to100_29 = mysql_result($query,0,'count_55to100_29'); // อายุ 15-18 อ้วน
$count_55to100_mex = mysql_result($query,0,'count_55to100_mex'); // อายุ 15-18 อ้วนมากๆ
?>
<table width="374" align="center">
<tr>
<td><div align="center"><strong>อายุ</strong></div></td>
<td><div align="center"><strong>เกณฑ์</strong></div></td>
<td><div align="center"><strong>คน</strong></div></td>
</tr>
<tr>
<td><strong>1 - 12 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_1to12_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_1to12_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_1to12_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_1to12_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_1to12_mex; ?></td>
</tr>
<tr>
<td><strong>13 - 19 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_13to19_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_13to19_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_13to19_25;?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_13to19_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_13to19_mex; ?></td>
</tr>
<tr>
<td><strong>20 - 54 </strong></td>
<td>ทั้งหมด</td>
<td><?php echo $count_20to54_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_20to54_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_20to54_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_20to54_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_20to54_mex; ?></td>
</tr>
<tr>
<td><strong>55 - 100</strong> </td>
<td>ทั้งหมด</td>
<td><?php echo $count_55to100_all; ?></td>
</tr>
<tr>
<td> </td>
<td>ผอม</td>
<td><?php echo $count_55to100_20; ?></td>
</tr>
<tr>
<td> </td>
<td>ปกติ</td>
<td><?php echo $count_55to100_25; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วน</td>
<td><?php echo $count_55to100_29; ?></td>
</tr>
<tr>
<td> </td>
<td>อ้วนมาก</td>
<td><?php echo $count_55to100_mex; ?></td>
</tr>
</table>
<?php
}
?>
</td>
</tr>
</table>
<p> </p>
<p align="center"><a href="adin.php"><strong>กลับ</strong></a></p>
</body>
</html>
Date :
2010-08-11 16:24:10By :
pob_suwan
ได้แล้วคะ ขอบคุณมากๆคะๆๆๆๆๆๆๆๆๆๆๆๆๆๆๆๆๆๆๆ ขอบคุณจริงๆๆๆๆๆ
Date :
2010-08-11 16:29:59By :
เด็กฝึกหัด
ดีใจด้วยครับ
Date :
2010-08-11 16:39:04By :
pob_suwan
Server 04
Load balance : Server 04
Quote:
