สอบถามเกี่ยวกับการนับจำนวนประเภท ที่แสดงจากฐานข้อมูล
ผมค้นหาข้อมูลจากวันที่ แล้วแสดงเป็นตารางCode (PHP) <html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<style type="text/css">
body {
background-image: url(file:///D|/AppServ/www/Old-Paper-Background-520x346.jpg);
}
</style>
</head>
<body>
<title></title>
<link type="text/css" href="flora.calendars.picker.css" rel="stylesheet"/>
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript" src="jquery.calendars.min.js"></script>
<script type="text/javascript" src="jquery.calendars.plus.min.js"></script>
<script type="text/javascript" src="jquery.calendars.picker.min.js"></script>
<script type="text/javascript" src="jquery.calendars.thai.min.js"></script>
<script type="text/javascript" src="jquery.calendars.thai-th.js"></script>
<script type="text/javascript" src="jquery.calendars.picker-th.js"></script>
<script type="text/javascript">
$(function() {
$('#mydate').calendarsPicker({calendar: $.calendars.instance('thai','th')});
////$("#mydate").datepicker({ dateFormat: 'yy-mm-dd',minDate:0 ,maxDate: 7});
});
</script>
<script type="text/javascript">
$(function() {
$('#mydate1').calendarsPicker({calendar: $.calendars.instance('thai','th')});
});
</script>
<script type="text/javascript">
$(function() {
$('#mydate2').calendarsPicker({calendar: $.calendars.instance('thai','th')});
});
</script>
<script type="text/javascript">
$(function() {
$('#mydate3').calendarsPicker({calendar: $.calendars.instance('thai','th')});
});
</script>
<form name="frmSearch" method="get" action="<?=$_SERVER['file:///D|/AppServ/www/SCRIPT_NAME'];?>">
<table width="865" border="1" align="center">
<tr> </tr>
</table>
<table width="599" border="1" align=center>
<tr>
<th>กรอกตำแหน่ง
<input name="txtKeyword" type="text" id="mydate1" onkeyup="beginchk(this,event)" value="<?=$_GET["txtKeyword"];?>">
<input name="txtKeyword2" type="text" id="mydate2" onkeyup="beginchk(this,event)" value="<?=$_GET["txtKeyword2"];?>">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<?
$from=$_GET["txtKeyword"];
$strYear = substr($from,6,4)-543;
$strMonth = substr($from,3,2);
$strDay = substr($from,0,2);
$birth = $strYear."-".$strMonth."-".$strDay;
$from2=$_GET["txtKeyword2"];
$strYear2 = substr($from2,6,4)-543;
$strMonth2 = substr($from2,3,2);
$strDay2 = substr($from2,0,2);
$birth2 = $strYear2."-".$strMonth2."-".$strDay2;
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("dataidp3");
mysql_query("SET NAMES UTF8");
///$strSQL = "SELECT * FROM idp3 WHERE (day LIKE '%".$_GET["txtKeyword"]."%' or day LIKE '%".$_GET["txtKeyword"]."%' )";
$strSQL = "SELECT idp3.ID , idp3.name,idp3.day ,team.teamname,idp3.teamid
,count(idp3.teamid = 1) as aaa ,count(idp3.teamid = 2) as bbb ,count(idp3.teamid = 3) as ccc
FROM idp3
left join team on idp3.teamid = team.teamid WHERE idp3.day BETWEEN '$birth' and '$birth2'
group by idp3.ID
";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$day=$objResult["day"];
mysql_query("SET NAMES UTF8");
?>
<?
?>
<center><table width="627" border="1">
<tr>
<td width="617"><table width="621" border="1" align=center>
<tr>
<th width="124" bgcolor="#EEEEEE">ลำดับ</th>
<th width="286" bgcolor="#EEEEEE"> <div align="center">เรื่อง</div></th>
<th width="189" bgcolor="#EEEEEE"> <div align="center">ประเภท</div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td height="22" bgcolor="#EEEEEE"><?=$objResult["ID"];?></td>
<td bgcolor="#EEEEEE"><?=$objResult["name"];?></td>
<td bgcolor="#EEEEEE"> <?=$objResult["teamname"];?></td>
<?
}
?>
</table></td>
</tr>
<?
?>
</table>
<p>
<?
mysql_close($objConnect);
}
?>
</p>
<p>ประเภท 1 จำนวน
<label for="textfield"></label>
<input type="text" name="textfield2" id="textfield2">
</p>
<p>ประเภท 2 จำนวน
<input type="text" name="textfield" id="textfield">
</p>
<p>ประเภท 3 จำนวน
<input type="text" name="textfield3" id="textfield3">
</p>
<p> </p>
</body>
</html>
Tag PHP, MySQL
Date :
2016-07-25 11:42:13By :
puldoolView :
1050Reply :
4
ลองแบบนี้ดูนะครับCode (PHP) $strSQL = "SELECT
idp3.ID ,
idp3.name,
idp3.day ,
team.teamname,idp3.teamid,
count(idp3.teamid) as team
FROM idp3
left join team on idp3.teamid = team.teamid
WHERE idp3.day BETWEEN '$birth' and '$birth2'
group by idp3.ID,idp3.teamid";
Date :
2016-07-25 13:15:06By :
thesin18598
ถ้าต้องการแบ่งประเภท และจำนวนนับ ลงตาม textxbox จะต้องทำประมาณไหนครับ
Date :
2016-07-25 13:32:34By :
puldool
แบบนี้ก็น่าจะได้นะCode (PHP) $strSQL = "SELECT
idp3.ID ,
idp3.name,
idp3.day ,
team.teamname,idp3.teamid,
team.team_name,****
count(idp3.teamid) as team
FROM idp3
left join team on idp3.teamid = team.teamid
WHERE idp3.day BETWEEN '$birth' and '$birth2'
group by idp3.ID,idp3.teamid";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery)){
echo "ประเภท".$objResult["team_name"]."จำนวน".$objResult["team"];
}
Date :
2016-07-25 14:38:01By :
thesin18598
ขอโทษนะครับถ้าไม่ตรงจุด
Date :
2016-07-26 15:56:13By :
puldool
Server 04
Load balance : Server 04
