| Server IP : 172.67.187.206 / Your IP : 172.71.28.156 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : E:/Inetpub/www/myschool/triamudom/check/knowledge/ |
Upload File : |
<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php');
include ($path.'include/class_display.php');
include ($path.'include/function.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>ระบบเช็คชื่อออนไลน์ โรงเรียนแกลง"วิทยสถาวร" จังหวัดระยอง</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<!-- FAVICON-->
<!-- Css styles -->
<link href="css/main.css" rel="stylesheet">
<script src="js/jquery-1.7.2.min.js"></script>
<script src="js/jquery.scrollTo-1.4.2-min.js"></script>
<script src="js/jquery.localscroll-1.2.7-min.js"></script>
<script src="js/jquery.mobilemenu.js"></script>
<script src="js/custom.js"></script>
<!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<style type="text/css">
body,td,th {
font-family: TH SarabunPSK;
font-size: 16px;
}
a:link {
color: #666666;
text-decoration: none;
}
body {
background-color: #FFF;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style1 {
font-size: 18px;
font-weight: bold;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head>
<body>
<br>
<form name="form2" method="post" action="<?php print $_SERVER['PHP_SELF'];?>" onSubmit="return chknull(this);">
<input name="tb_student_codecard" type="text" class="orange_textcheck" id="tb_student_codecard" size="1" style="border:none">
</form>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" valign="top">
<?php
//set the number of columns
$columns =6;
// $sql_limit_q = "limit 4";
$sql_dis_pro="select * FROM
tb_knowledges
INNER JOIN tb_registers_knowledge ON tb_knowledges.tb_knowledge_id = tb_registers_knowledge.tb_knowledge_id
GROUP BY
tb_registers_knowledge.tb_knowledge_id";
$query_dis_pro = $db->query($sql_dis_pro);
//we add this line because we need to know the number of rows
$num_dis_pro = $db->num_rows($query_dis_pro);
?>
<table width="0%" border="0" align="center" cellpadding="0" cellspacing="0">
<?
//changed this to a for loop so we can use the number of rows
for($i = 0; $i < $num_dis_pro; $i++) {
$fetch_dis_pro = $db->fetch_array($query_dis_pro);
if($i % $columns == 0) {
//if there is no remainder, we want to start a new row
echo "<TR>\n";
}
?>
<td><table width="0%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td width="23%" align="center" valign="top" nowrap><div class="span3">
<div class="team-wrap">
<p><a href="picture.php?tb_register_knowledge_id=<?php print $fetch_dis_pro['tb_register_knowledge_id'];?>" target="_blank"><img src="../webadmin/images/174738_179221222119663_7480233_n.jpg" width="100" border="1"></a><br>
<span class="style1"><?php print $fetch_dis_pro['tb_knowledge_name'];?></span><br>
</p>
</div>
</div></td>
</tr>
</table></td>
<? if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_dis_pro) {
//if there is a remainder of 1, end the row
//or if there is nothing left in our result set, end the row
echo "</TR>\n";
}
}
?>
</table></td>
</tr>
</table>
</body>
</html>