Register Register Member Login Member Login Member Login Forgot Password ??
PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone
 

Registered : 109,027

HOME > PHP > PHP Forum > โค๊ดการดึงข้อมมูลมาแสดงในแบบสถิติ เช่นวันเดือนปี ประมาณนี้



 

โค๊ดการดึงข้อมมูลมาแสดงในแบบสถิติ เช่นวันเดือนปี ประมาณนี้

 



Topic : 046526

Guest




โค๊ดการดึงข้อมูลขึ้นมาแสดงแบบสถิติเช่นมีลำดับ วันเดือนปี ต้องทำแบบใดบ้าง ท่านใดมีแนวบ้าง



Tag : PHP







Move To Hilight (Stock) 
Send To Friend.Bookmark.
Date : 2010-08-04 20:59:02 By : ทั่วไป View : 875 Reply : 4
 

 

No. 1



โพสกระทู้ ( 74,058 )
บทความ ( 838 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์
Twitter Facebook

คุณเก็บแบบไหนบ้างครับ สามารถ Query ได้ถ้ามีการเก็บแบบล่ะเอียดครับ






แสดงความคิดเห็นโดยอ้างถึง ความคิดเห็นนี้
Date : 2010-08-04 21:27:11 By : webmaster
 


 

No. 2



โพสกระทู้ ( 17 )
บทความ ( 0 )



สถานะออฟไลน์


ก็พอจะมีนะ
แต่เป็นการเก็บสถิติของการสอบ
แสดงความคิดเห็นโดยอ้างถึง ความคิดเห็นนี้
Date : 2010-08-05 13:40:32 By : rin032
 

 

No. 3



โพสกระทู้ ( 17 )
บทความ ( 0 )



สถานะออฟไลน์


//เลือกแบบทดสอบ// select_test.php

<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<HTML>
<HEAD>
<TITLE></TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=tis-620">
<link href="style.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY >

<CENTER><table width="1000" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >
<TR>

<TD COLSPAN=2>
<?include "head.php";?></TD>
</TR>
<TR>
<TD width=20% valign=top><?include"menu1.php";?>
</TD><BR>
<TD width=80% align=center valign=top>

<?
include("connectdb.php");
mysql_connect("$host", "$user", "$passwd") or die("ÁÕ¤ÇÒÁ¼Ô´¾ÅҴ㹡ÒÃàª×èÍÁµè͡ѺÃкº°Ò¹¢éÍÁÙÅ");
mysql_select_db("$dbName") or die("ÁÕ¤ÇÒÁ¼Ô´¾ÅҴ㹡ÒõԴµèÍ°Ò¹¢éÍÁÙÅ");

$sql="select * from lesson";
$dbquery = mysql_db_query("$dbName", $sql);
$count = mysql_num_rows($dbquery);
?>

<br> <table border="1" cellspacing="0" cellpadding="0" align="top">
<td width="200" valign="top" height="21" bordercolor="#CC3300"> <img src="image/test.gif" width="200" height="50">
<table width="80%" border="0" cellspacing="0" cellpadding="0"></table>
<table width="204" height="21" border="0" align="center" cellpadding="2" cellspacing="2" style="border-collapse: collapse">
<?
if ($count!=0){
$loop=0;
$num=0;
while ($loop<$count)
{
$result = mysql_fetch_array($dbquery);
$num+=1;
?>
<tr>
<td width="206" height="2" bgcolor="" ><font color=#FF3300>
<a href=result_test.php?lesson_id=<?=$result[lesson_id]?>>
<?=$num.". ".$result[lesson_name]?>
</a></font> </td>
</tr>
<?$loop++;}}?>
</table>
</td></table>
</form>
</form>
</TD>
</TR>
<TR>
<TD colspan=2><?include "foot.html";?></TD>
</TR>
</TABLE>


</TD>
</TR>
</TABLE>
</CENTER>
</BODY>
</HTML>

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//แบบทดสอบ// result_test.php
<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<title>Ẻ·´Êͺ</title>
<style>
A {
COLOR: blue; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC0000; TEXT-DECORATION: underline
}

</style>
<BODY><CENTER><table width="1000" height="885" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >

<tr>
<td colspan="3"bgcolor=""><? include "head.php" ;?></td>
</tr>

<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>

<td width="75%" valign="top" align="left">
<form method="post" action="random_check.php">
<p align=center><font color=#0033CC>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color=#FF0000><CENTER><B>¤ÓªÕéᨧ : ¢éÍÊͺÁÕ·Ñé§ËÁ´ 4 µÑÇàÅ×Í¡ ¨§àÅ×Í¡¤ÓµÍº·ÕèÊØ´à¾Õ§¢éÍà´ÕÂÇ</B></CENTER><BR></font>

<?
$number=1;
include("connectdb.php");

$sql="select * from exam where lesson_id='$lesson_id' ORDER BY RAND() LIMIT 3";
$result=mysql_db_query("$dbName",$sql);

while ($r=mysql_fetch_array($result)){
$ex_id=$r[ex_id];
$question=$r[question];
$choice1=$r[choice1];
$choice2=$r[choice2];
$choice3=$r[choice3];
$choice4=$r[choice4];

echo "<font color=#FF0000>¢éÍ $number. $question</font> <BR>
<input type='radio' name='select_$ex_id' value='1'>
$choice1<BR>
<input type='radio' name='select_$ex_id' value='2'>
$choice2<BR>
<input type='radio' name='select_$ex_id' value='3'>
$choice3<BR>
<input type='radio' name='select_$ex_id' value='4'>
$choice4<BR>
<input type='hidden' name='total_question[]' value='$ex_id'>
<HR> ";
$number++;
}
?>

<BR><CENTER><input align="center" type="submit" value="ºÑ¹·Ö¡"><input align="center" type="reset" value="¡àÅÔ¡"></CENTER>

<BR><CENTER><FONT SIZE=2 COLOR=#009933 face="MS Sans Serif">
[&nbsp;<A HREF="index_user.php"><FONT SIZE=2 COLOR=#009933 face="MS Sans Serif">¡ÅѺ</font></A>&nbsp;]</CENTER>
<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>

</TD></TR></TABLE></CENTER></BODY>

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//เช็คคะแนน// random_chack.php

<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<title>µÃǨ¹Ñº¤ÐṹẺ·´Êͺ</title>
<style>
A {
COLOR: blue; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC0000; TEXT-DECORATION: underline
}

</style>
<CENTER><table width="1000" height="885" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >

<tr>
<td colspan="3"bgcolor=""><? include "head.php" ;?></td>
</tr>

<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>
<td width="75%" valign="top" align="center">
<BR>

<?
$date_exam = format_date_th (date("Y-m-d H:i:s"),"7");
function format_date_th ($value,$type) {
if (strlen ($value) > 10) {
list ($s_date,$s_time) = split (" ", $value);
list ($s_year, $s_month, $s_day) = split ("-", $s_date);
list ($s_hour, $s_minute, $s_second) = split (":", $s_time);
}
else{
list ($s_year, $s_month, $s_day) = split ("-", $value);
}
$s_month +=0;
$s_day += 0;
if ($s_day == "0") return "";
$s_year += 543;
$month_full_th = array ('','Á¡ÃÒ¤Á', '¡ØÁÀҾѹ¸ì', 'ÁÕ¹Ò¤Á', 'àÁÉÒ¹', '¾ÄÉÀÒ¤Á', 'ÁԶعÒ¹', '¡Ã¡®Ò¤Á', 'ÊÔ§ËÒ¤Á',' ¡Ñ¹ÂÒ¹', 'µØÅÒ¤Á', '¾ÄȨԡÒ¹','¸Ñ¹ÇÒ¤Á');
$month_brief_th = array ('','Á.¤.','¡.¾.','ÁÕ.¤.','àÁ.Â.','¾.¤.','ÁÔ.Â.','¡.¤.','Ê.¤.','¡.Â.','µ.¤.','¾.Â.','¸.¤.');
$day_of_week = array("ÍÒ·ÔµÂì","¨Ñ¹·Ãì","Íѧ¤ÒÃ","¾Ø¸","¾ÄËÑʺ´Õ","ÈØ¡Ãì","àÊÒÃì");
switch ($type) {
case "1" : // Çѹ·Õè 1 Á¡ÃÒ¤Á 2552 àÇÅÒ 14.01 ¹.
$msg = "Çѹ·Õè ". $s_day . " " . $month_full_th[$s_month] . " " . $s_year . " àÇÅÒ " . $s_hour . "." . $s_minute . " ¹." ;
break;
case "2" : // 1 Á.¤. 2548 14.11 ¹.
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . $s_year . " " . $s_hour . "." . $s_minute . " ¹." ;
break;
case "3" : // Çѹ·Õè 1 Á¡ÃÒ¤Á 2552
$msg = "Çѹ·Õè ". $s_day . " " . $month_full_th[$s_month] . " " . $s_year ;
break;
case "4" : // 1 Á¡ÃÒ¤Á 2552
$msg = $s_day . " " . $month_full_th[$s_month] . " " . $s_year ;
break;
case "5" : // 1 Á.¤. 2552
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . $s_year ;
break;
case "6" : // 1 Á.¤. 52
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . substr($s_year,-2) ;
break;
case "7" : // 1 Á¡ÃÒ¤Á 2552 àÇÅÒ 14.01 ¹.
$msg = $s_day . " " . $month_full_th[$s_month] . " " . $s_year . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; àÇÅÒ " . $s_hour . "." . $s_minute . " ¹." ;
break;
}
return ($msg);

}
$lesson= //ตรงนี้ยังไม่ได้ เป็นการเพิ่มข้อมูลบทเรียน//
$correct=0;
$total=count($total_question);
print "<font color=#CC3300 size=3 face=\"MS Sans Serif\"><h2><p align=center><b>¼Å¡Ò÷ÓẺ·´Êͺ¢Í§ ¤Ø³</b></font><font color=#FF0033 size=5 face=\"MS Sans Serif\"> $name_show </font></p></h2> ";
include "connectdb.php";
$sql="select ex_id,select_choice from exam order by ex_id";
$result=mysql_db_query("$dbName","$sql");
while ($r=mysql_fetch_array($result)) {
$ex_id=$r[ex_id];
$select_choice=$r[select_choice];

if (in_array ($ex_id, $total_question)) {
$select="select_".$ex_id;
if (${$select}==$select_choice){
$correct++;
}
}
}
echo "<font face= 'Angsana New' size='5' color = '#0000FF'><p align=center><b>Ẻ·´Êͺ·Ñé§ËÁ´</font><font face= 'Angsana New' size='5' color = '#FF0000'><b> $total </font> <font color=#0000FF size=3 face=\"MS Sans Serif\"><b>¢éÍ</font></b></p> <font face= 'Angsana New' size='5' color = '#0000FF'><p align=center><b>¤Ø³·Óä´é</font><font color=#FF0033 size=3 face=\"MS Sans Serif\"> $correct </font> <font color=#0000FF size=3 face=\"MS Sans Serif\">¢éÍ </font>";

include "connectdb.php";
$result=mysql_db_query("$dbName","$sql");
$sql="insert into statistic (user_login,sequence_id,lesson,all_test,point_test,date_exam)
values ('$name_show','$sequence_id','$lesson','$total','$correct','$date_exam')";
$result=mysql_db_query("$dbName","$sql");
?>

<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>
</table></center>

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//เก็บรายละเอียดสถิติการสอบ// statistic.php

<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<STYLE type=text/css>A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #0033CC; TEXT-DECORATION: none
}
A:hover {
COLOR: #0099FF; TEXT-DECORATION: none
}
A.d {
COLOR: #ffffff; FONT-FAMILY: verdana; FONT-SIZE: 12px; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
A.d:visited {
COLOR: #000000; FONT-FAMILY: verdana; FONT-SIZE: 12px; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
</STYLE>

<STYLE type=text/css>SMALL {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 14pt
}
INPUT {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE:11pt
}
TEXTAREA {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 11pt
}
B {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 10pt
}

TD {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 11pt
}
BODY {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 14pt
}
BODY {
MARGIN: 0px; PADDING-BOTTOM: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-BOTTON: 0px
}
</STYLE>
</head>
<SCRIPT LANGUAGE="JavaScript">
function checkform(theform)
{

if (theform.title.value=="")
{
alert("¡ÃÍ¡¢éÍÁÙÅ㹪èͧËÑÇ¢éͤӶÒÁ´éǤèÐ");
theform.title.focus();
return (false);
}
if (theform.body.value=="")
{
alert("ãÊèÃÒÂÅÐàÍÕ´´éǤèÐ");
theform.body.focus();
return (false);
}
}
</SCRIPT>
<SCRIPT language=JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</SCRIPT>

<td>
<center>
<table width=800 border=0 cellspacing=1 cellpadding=1>
<!-----------------------------àÃÔèÁÊèǹËÑÇ---------------------------------->
</head>

<body background="#FFFFFF"><CENTER><table width="1000" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="#FFFFFF">
<tr>
<td colspan="2"bgcolor=""><? include "head.php" ;?></td>
</tr>
<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>

<td width="81%" valign="top" align="left">
<div align="center"><font color="#000066"><table width=810 cellspacing=1>

</table>
<?
include("connectdb.php");
$dbquery = mysql_db_query("$dbName", "select * from statistic where user_login='$name_show' order by sequence_id desc ");

$count = mysql_num_rows($dbquery);

if ($numpage=="")
{
$numpage=1;
$old_page = 0;
$next_rec = 20;
}
else
{
$old_page =($numpage-1)*13;
$next_rec = $numpage*13;
}

?>
<? if ($count!=0)
{
$j=$j+$old_page;
echo "<font color=#3300CC><h4><center><br>ʶԵԡÒÃÊͺ»ÃÐÁÇżŤÇÒÁÃÙé¢Í§ ".$name_show." <br></font></h4></center>";
echo "<table width=550 border=1 bordercolor=#CC3300 cellpadding=0 cellspacing=0 style=\"border-collapse: collapse\">";
echo "<tr bgcolor=\"#FFCC99\"><td width=50 align=center><strong>¤ÃÑ駷Õè</strong></td><td width=150 align=center><strong>ª×èͺ·àÃÕ¹</strong></td><td width=150 align=center><strong>¨Ó¹Ç¹¢éÍÊͺ</strong></td><td width=150 align=center><strong>¤Ðá¹¹·Õèä´é</strong></td><td width=300 align=center><strong>ÇѹÊͺ</strong></td></tr>";
while ($i < $count )
{
$result = mysql_fetch_array($dbquery);
if ($i>=$old_page && $i<=$next_rec)
{
$j=$j+1;
echo "<tr bgcolor=#FFFFFF align=center><td width=50 ><FONT COLOR=#3300CC>$result[sequence_id]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[lesson]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[all_test]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[point_test]</FONT></td><td width=300 align=left><FONT COLOR=#3300CC>&nbsp;&nbsp;&nbsp;$result[date_exam]</FONT></td></tr>";
}
$i++;
}
echo "</table>";
}
else
?>
<BR><BR><BR>

<BR>
<br><br><BR><BR><BR>
<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>
</body>
</html>
///////////////////////////////////////////////////////////////////////////////////////////////////////
ไม่รู้ว่าจะเข้าใจไหมนะ
ถ้าไม่เข้าใจขอโทษด้วยละกัน
แสดงความคิดเห็นโดยอ้างถึง ความคิดเห็นนี้
Date : 2010-08-05 13:50:48 By : rin032
 


 

No. 4



โพสกระทู้ ( 648 )
บทความ ( 0 )



สถานะออฟไลน์


ตาลายครับ

//เลือกแบบทดสอบ// select_test.php

Code (PHP)
<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<HTML>
<HEAD>
<TITLE></TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=tis-620">
<link href="style.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY >

<CENTER><table width="1000" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >
<TR>

<TD COLSPAN=2>
<?include "head.php";?></TD>
</TR>
<TR>
<TD width=20% valign=top><?include"menu1.php";?>
</TD><BR>
<TD width=80% align=center valign=top>

<?
include("connectdb.php");
mysql_connect("$host", "$user", "$passwd") or die("ÁÕ¤ÇÒÁ¼Ô´¾ÅҴ㹡ÒÃàª×èÍÁµè͡ѺÃкº°Ò¹¢éÍÁÙÅ");
mysql_select_db("$dbName") or die("ÁÕ¤ÇÒÁ¼Ô´¾ÅҴ㹡ÒõԴµèÍ°Ò¹¢éÍÁÙÅ");

$sql="select * from lesson";
$dbquery = mysql_db_query("$dbName", $sql);
$count = mysql_num_rows($dbquery);
?>

<br> <table border="1" cellspacing="0" cellpadding="0" align="top">
<td width="200" valign="top" height="21" bordercolor="#CC3300"> <img src="image/test.gif" width="200" height="50">
<table width="80%" border="0" cellspacing="0" cellpadding="0"></table>
<table width="204" height="21" border="0" align="center" cellpadding="2" cellspacing="2" style="border-collapse: collapse">
<?
if ($count!=0){
$loop=0;
$num=0;
while ($loop<$count)
{
$result = mysql_fetch_array($dbquery);
$num+=1;
?>
<tr>
<td width="206" height="2" bgcolor="" ><font color=#FF3300>
<a href=result_test.php?lesson_id=<?=$result[lesson_id]?>>
<?=$num.". ".$result[lesson_name]?>
</a></font> </td>
</tr>
<?$loop++;}}?>
</table>
</td></table>
</form>
</form>
</TD>
</TR>
<TR>
<TD colspan=2><?include "foot.html";?></TD>
</TR>
</TABLE>


</TD>
</TR>
</TABLE>
</CENTER>
</BODY>
</HTML>


///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//แบบทดสอบ// result_test.php
Code (PHP)
<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<title>Ẻ·´Êͺ</title>
<style>
A {
COLOR: blue; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC0000; TEXT-DECORATION: underline
}

</style>
<BODY><CENTER><table width="1000" height="885" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >

<tr>
<td colspan="3"bgcolor=""><? include "head.php" ;?></td>
</tr>

<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>

<td width="75%" valign="top" align="left">
<form method="post" action="random_check.php">
<p align=center><font color=#0033CC>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color=#FF0000><CENTER><B>¤ÓªÕéᨧ : ¢éÍÊͺÁÕ·Ñé§ËÁ´ 4 µÑÇàÅ×Í¡ ¨§àÅ×Í¡¤ÓµÍº·ÕèÊØ´à¾Õ§¢éÍà´ÕÂÇ</B></CENTER><BR></font>

<?
$number=1;
include("connectdb.php");

$sql="select * from exam where lesson_id='$lesson_id' ORDER BY RAND() LIMIT 3";
$result=mysql_db_query("$dbName",$sql);

while ($r=mysql_fetch_array($result)){
$ex_id=$r[ex_id];
$question=$r[question];
$choice1=$r[choice1];
$choice2=$r[choice2];
$choice3=$r[choice3];
$choice4=$r[choice4];

echo "<font color=#FF0000>¢éÍ $number. $question</font> <BR>
<input type='radio' name='select_$ex_id' value='1'>
$choice1<BR>
<input type='radio' name='select_$ex_id' value='2'>
$choice2<BR>
<input type='radio' name='select_$ex_id' value='3'>
$choice3<BR>
<input type='radio' name='select_$ex_id' value='4'>
$choice4<BR>
<input type='hidden' name='total_question[]' value='$ex_id'>
<HR> ";
$number++;
}
?>

<BR><CENTER><input align="center" type="submit" value="ºÑ¹·Ö¡"><input align="center" type="reset" value="¡àÅÔ¡"></CENTER>

<BR><CENTER><FONT SIZE=2 COLOR=#009933 face="MS Sans Serif">
[&nbsp;<A HREF="index_user.php"><FONT SIZE=2 COLOR=#009933 face="MS Sans Serif">¡ÅѺ</font></A>&nbsp;]</CENTER>
<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>

</TD></TR></TABLE></CENTER></BODY>


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//เช็คคะแนน// random_chack.php

Code (PHP)
<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<title>µÃǨ¹Ñº¤ÐṹẺ·´Êͺ</title>
<style>
A {
COLOR: blue; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC0000; TEXT-DECORATION: underline
}

</style>
<CENTER><table width="1000" height="885" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="" >

<tr>
<td colspan="3"bgcolor=""><? include "head.php" ;?></td>
</tr>

<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>
<td width="75%" valign="top" align="center">
<BR>

<?
$date_exam = format_date_th (date("Y-m-d H:i:s"),"7");
function format_date_th ($value,$type) {
if (strlen ($value) > 10) {
list ($s_date,$s_time) = split (" ", $value);
list ($s_year, $s_month, $s_day) = split ("-", $s_date);
list ($s_hour, $s_minute, $s_second) = split (":", $s_time);
}
else{
list ($s_year, $s_month, $s_day) = split ("-", $value);
}
$s_month +=0;
$s_day += 0;
if ($s_day == "0") return "";
$s_year += 543;
$month_full_th = array ('','Á¡ÃÒ¤Á', '¡ØÁÀҾѹ¸ì', 'ÁÕ¹Ò¤Á', 'àÁÉÒ¹', '¾ÄÉÀÒ¤Á', 'ÁԶعÒ¹', '¡Ã¡®Ò¤Á', 'ÊÔ§ËÒ¤Á',' ¡Ñ¹ÂÒ¹', 'µØÅÒ¤Á', '¾ÄȨԡÒ¹','¸Ñ¹ÇÒ¤Á');
$month_brief_th = array ('','Á.¤.','¡.¾.','ÁÕ.¤.','àÁ.Â.','¾.¤.','ÁÔ.Â.','¡.¤.','Ê.¤.','¡.Â.','µ.¤.','¾.Â.','¸.¤.');
$day_of_week = array("ÍÒ·ÔµÂì","¨Ñ¹·Ãì","Íѧ¤ÒÃ","¾Ø¸","¾ÄËÑʺ´Õ","ÈØ¡Ãì","àÊÒÃì");
switch ($type) {
case "1" : // Çѹ·Õè 1 Á¡ÃÒ¤Á 2552 àÇÅÒ 14.01 ¹.
$msg = "Çѹ·Õè ". $s_day . " " . $month_full_th[$s_month] . " " . $s_year . " àÇÅÒ " . $s_hour . "." . $s_minute . " ¹." ;
break;
case "2" : // 1 Á.¤. 2548 14.11 ¹.
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . $s_year . " " . $s_hour . "." . $s_minute . " ¹." ;
break;
case "3" : // Çѹ·Õè 1 Á¡ÃÒ¤Á 2552
$msg = "Çѹ·Õè ". $s_day . " " . $month_full_th[$s_month] . " " . $s_year ;
break;
case "4" : // 1 Á¡ÃÒ¤Á 2552
$msg = $s_day . " " . $month_full_th[$s_month] . " " . $s_year ;
break;
case "5" : // 1 Á.¤. 2552
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . $s_year ;
break;
case "6" : // 1 Á.¤. 52
$msg = $s_day . " " . $month_brief_th[$s_month] . " " . substr($s_year,-2) ;
break;
case "7" : // 1 Á¡ÃÒ¤Á 2552 àÇÅÒ 14.01 ¹.
$msg = $s_day . " " . $month_full_th[$s_month] . " " . $s_year . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; àÇÅÒ " . $s_hour . "." . $s_minute . " ¹." ;
break;
}
return ($msg);

}
$lesson= //ตรงนี้ยังไม่ได้ เป็นการเพิ่มข้อมูลบทเรียน//
$correct=0;
$total=count($total_question);
print "<font color=#CC3300 size=3 face=\"MS Sans Serif\"><h2><p align=center><b>¼Å¡Ò÷ÓẺ·´Êͺ¢Í§ ¤Ø³</b></font><font color=#FF0033 size=5 face=\"MS Sans Serif\"> $name_show </font></p></h2> ";
include "connectdb.php";
$sql="select ex_id,select_choice from exam order by ex_id";
$result=mysql_db_query("$dbName","$sql");
while ($r=mysql_fetch_array($result)) {
$ex_id=$r[ex_id];
$select_choice=$r[select_choice];

if (in_array ($ex_id, $total_question)) {
$select="select_".$ex_id;
if (${$select}==$select_choice){
$correct++;
}
}
}
echo "<font face= 'Angsana New' size='5' color = '#0000FF'><p align=center><b>Ẻ·´Êͺ·Ñé§ËÁ´</font><font face= 'Angsana New' size='5' color = '#FF0000'><b> $total </font> <font color=#0000FF size=3 face=\"MS Sans Serif\"><b>¢éÍ</font></b></p> <font face= 'Angsana New' size='5' color = '#0000FF'><p align=center><b>¤Ø³·Óä´é</font><font color=#FF0033 size=3 face=\"MS Sans Serif\"> $correct </font> <font color=#0000FF size=3 face=\"MS Sans Serif\">¢éÍ </font>";

include "connectdb.php";
$result=mysql_db_query("$dbName","$sql");
$sql="insert into statistic (user_login,sequence_id,lesson,all_test,point_test,date_exam)
values ('$name_show','$sequence_id','$lesson','$total','$correct','$date_exam')";
$result=mysql_db_query("$dbName","$sql");
?>

<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>
</table></center>


//////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//เก็บรายละเอียดสถิติการสอบ// statistic.php

Code (PHP)
<?php

#### ʤÃÔ껹Õéãªé㹡ÒÃàªç¤ ÇèÒÅçÍ¡ÍÔ¹ËÃ×ÍÂѧ ãËé¹ÓʤÃÔ껹Õéä»äÇé·Õè˹éÒ·Õè¤Ø³µéͧ¡ÒÃãËéàªç¤ ####
session_start() ;
if(!session_is_registered("cardid_check")) {
// url=index.php ¤ÓÊÑ觹Õé¨ÐãËéä»Ë¹éÒ·Õè¨Ðµéͧ¡ÃÍ¡ user,pwd ¶éÒÍÂÙèâ¿Åìà´ÍÃìÍ×è¹ãËéàÃÕ¡ãËé¶Ù¡¹Ð¤ÃѺ
echo "<script>alert('¡ÃسÒÅçÍ¡ÍÔ¹¡è͹');window.location.href ='index.php'; </script>";

exit() ;
}?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<STYLE type=text/css>A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #0033CC; TEXT-DECORATION: none
}
A:hover {
COLOR: #0099FF; TEXT-DECORATION: none
}
A.d {
COLOR: #ffffff; FONT-FAMILY: verdana; FONT-SIZE: 12px; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
A.d:visited {
COLOR: #000000; FONT-FAMILY: verdana; FONT-SIZE: 12px; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
</STYLE>

<STYLE type=text/css>SMALL {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 14pt
}
INPUT {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE:11pt
}
TEXTAREA {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 11pt
}
B {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 10pt
}

TD {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 11pt
}
BODY {
FONT-FAMILY: MS Sans Serif, Microsoft Sans Serif; FONT-SIZE: 14pt
}
BODY {
MARGIN: 0px; PADDING-BOTTOM: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-BOTTON: 0px
}
</STYLE>
</head>
<SCRIPT LANGUAGE="JavaScript">
function checkform(theform)
{

if (theform.title.value=="")
{
alert("¡ÃÍ¡¢éÍÁÙÅ㹪èͧËÑÇ¢éͤӶÒÁ´éǤèÐ");
theform.title.focus();
return (false);
}
if (theform.body.value=="")
{
alert("ãÊèÃÒÂÅÐàÍÕ´´éǤèÐ");
theform.body.focus();
return (false);
}
}
</SCRIPT>
<SCRIPT language=JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</SCRIPT>

<td>
<center>
<table width=800 border=0 cellspacing=1 cellpadding=1>
<!-----------------------------àÃÔèÁÊèǹËÑÇ---------------------------------->
</head>

<body background="#FFFFFF"><CENTER><table width="1000" border="2" background="image/Copy of 9.gif" bordercolor="#CC3300" bgcolor="#FFFFFF">
<tr>
<td colspan="2"bgcolor=""><? include "head.php" ;?></td>
</tr>
<tr>
<td width="1000" rowspan="2" valign =top><? include "menu1.php" ;?></td>

<td width="81%" valign="top" align="left">
<div align="center"><font color="#000066"><table width=810 cellspacing=1>

</table>
<?
include("connectdb.php");
$dbquery = mysql_db_query("$dbName", "select * from statistic where user_login='$name_show' order by sequence_id desc ");

$count = mysql_num_rows($dbquery);

if ($numpage=="")
{
$numpage=1;
$old_page = 0;
$next_rec = 20;
}
else
{
$old_page =($numpage-1)*13;
$next_rec = $numpage*13;
}

?>
<? if ($count!=0)
{
$j=$j+$old_page;
echo "<font color=#3300CC><h4><center><br>ʶԵԡÒÃÊͺ»ÃÐÁÇżŤÇÒÁÃÙé¢Í§ ".$name_show." <br></font></h4></center>";
echo "<table width=550 border=1 bordercolor=#CC3300 cellpadding=0 cellspacing=0 style=\"border-collapse: collapse\">";
echo "<tr bgcolor=\"#FFCC99\"><td width=50 align=center><strong>¤ÃÑ駷Õè</strong></td><td width=150 align=center><strong>ª×èͺ·àÃÕ¹</strong></td><td width=150 align=center><strong>¨Ó¹Ç¹¢éÍÊͺ</strong></td><td width=150 align=center><strong>¤Ðá¹¹·Õèä´é</strong></td><td width=300 align=center><strong>ÇѹÊͺ</strong></td></tr>";
while ($i < $count )
{
$result = mysql_fetch_array($dbquery);
if ($i>=$old_page && $i<=$next_rec)
{
$j=$j+1;
echo "<tr bgcolor=#FFFFFF align=center><td width=50 ><FONT COLOR=#3300CC>$result[sequence_id]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[lesson]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[all_test]</FONT></td><td width=150 ><FONT COLOR=#3300CC>$result[point_test]</FONT></td><td width=300 align=left><FONT COLOR=#3300CC>&nbsp;&nbsp;&nbsp;$result[date_exam]</FONT></td></tr>";
}
$i++;
}
echo "</table>";
}
else
?>
<BR><BR><BR>

<BR>
<br><br><BR><BR><BR>
<tr>
<td colspan="3"bgcolor=""><? include "foot.html";?></td>
</tr>
</body>
</html>

///////////////////////////////////////////////////////////////////////////////////////////////////////
ไม่รู้ว่าจะเข้าใจไหมนะ
ถ้าไม่เข้าใจขอโทษด้วยละกัน
แสดงความคิดเห็นโดยอ้างถึง ความคิดเห็นนี้
Date : 2010-08-05 14:48:40 By : 50121680
 

   

ค้นหาข้อมูล


   
 

แสดงความคิดเห็น
Re : โค๊ดการดึงข้อมมูลมาแสดงในแบบสถิติ เช่นวันเดือนปี ประมาณนี้
 
 
รายละเอียด
 
ตัวหนา ตัวเอียง ตัวขีดเส้นใต้ ตัวมีขีดกลาง| ตัวเรืองแสง ตัวมีเงา ตัวอักษรวิ่ง| จัดย่อหน้าอิสระ จัดย่อหน้าชิดซ้าย จัดย่อหน้ากึ่งกลาง จัดย่อหน้าชิดขวา| เส้นขวาง| ขนาดตัวอักษร แบบตัวอักษร
ใส่แฟลช ใส่รูป ใส่ไฮเปอร์ลิ้งค์ ใส่อีเมล์ ใส่ลิ้งค์ FTP| ใส่แถวของตาราง ใส่คอลัมน์ตาราง| ตัวยก ตัวห้อย ตัวพิมพ์ดีด| ใส่โค้ด ใส่การอ้างถึงคำพูด| ใส่ลีสต์
smiley for :lol: smiley for :ken: smiley for :D smiley for :) smiley for ;) smiley for :eek: smiley for :geek: smiley for :roll: smiley for :erm: smiley for :cool: smiley for :blank: smiley for :idea: smiley for :ehh: smiley for :aargh: smiley for :evil:
Insert PHP Code
Insert ASP Code
Insert VB.NET Code Insert C#.NET Code Insert JavaScript Code Insert C#.NET Code
Insert Java Code
Insert Android Code
Insert Objective-C Code
Insert XML Code
Insert SQL Code
Insert Code
เพื่อความเรียบร้อยของข้อความ ควรจัดรูปแบบให้พอดีกับขนาดของหน้าจอ เพื่อง่ายต่อการอ่านและสบายตา และตรวจสอบภาษาไทยให้ถูกต้อง

อัพโหลดแทรกรูปภาพ

Notice

เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ
อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง

   
  เพื่อความปลอดภัยและการตรวจสอบ กระทู้ที่แทรกไฟล์อัพโหลดไฟล์จากที่อื่น อาจจะถูกลบทิ้ง
 
โดย
อีเมล์
บวกค่าให้ถูก
<= ตัวเลขฮินดูอารบิก เช่น 123 (หรือล็อกอินเข้าระบบสมาชิกเพื่อไม่ต้องกรอก)







Exchange: นำเข้าสินค้าจากจีน, Taobao, เฟอร์นิเจอร์, ของพรีเมี่ยม, ร่ม, ปากกา, power bank, แฟลชไดร์ฟ, กระบอกน้ำ

Load balance : Server 02
ThaiCreate.Com Logo
© www.ThaiCreate.Com. 2003-2024 All Rights Reserved.
ไทยครีเอทบริการ จัดทำดูแลแก้ไข Web Application ทุกรูปแบบ (PHP, .Net Application, VB.Net, C#)
[Conditions Privacy Statement] ติดต่อโฆษณา 081-987-6107 อัตราราคา คลิกที่นี่