<?php require_once('Connections/myconect.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_myconect, $myconect);
$query_cnblue = "SELECT * FROM mama";
$cnblue = mysql_query($query_cnblue, $myconect) or die(mysql_error());
$row_cnblue = mysql_fetch_assoc($cnblue);
$totalRows_cnblue = mysql_num_rows($cnblue);
$maxRows_report = 10;
$pageNum_report = 0;
if (isset($_GET['pageNum_report'])) {
$pageNum_report = $_GET['pageNum_report'];
}
$startRow_report = $pageNum_report * $maxRows_report;
mysql_select_db($database_myconect, $myconect);
$query_report = "SELECT * FROM mama";
$query_limit_report = sprintf("%s LIMIT %d, %d", $query_report, $startRow_report, $maxRows_report);
$report = mysql_query($query_limit_report, $myconect) or die(mysql_error());
$row_report = mysql_fetch_assoc($report);
if (isset($_GET['totalRows_report'])) {
$totalRows_report = $_GET['totalRows_report'];
} else {
$all_report = mysql_query($query_report);
$totalRows_report = mysql_num_rows($all_report);
}
$totalPages_report = ceil($totalRows_report/$maxRows_report)-1;
?>
<!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=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<form id="form1" name="form1" method="POST">
<p>มหาวิทยาลัยเกริก (ม.กร) </p>
<p>รหัสนักศึกษา
<label for="textfield46"></label>
<input name="stu_id" type="text" id="textfield46" value="<?php echo $row_report['stu_id']; ?>" />
</p>
<p>GPA
<label for="year"></label>
<input name="GPA" type="text" id="textfield2" value="<?php echo $row_report['GPA']; ?>" />
</p>
<p>ภาค
<label for="sector"></label>
<label for="sector"></label>
<select name="sector" id="sector">
<option value="ต้น" selected="selected">ต้น</option>
<option value="ปลาย">ปลาย</option>
<option value="ฤดูร้อน">ฤดูร้อน</option>
</select>
</p>
<p>ปีการศึกษา
<label for="name"></label>
<input name="year" type="text" id="textfield3" value="<?php echo $row_report['year']; ?>" />
</p>
<p>ชื่อ
<label for="yearstu"></label>
<input name="name" type="text" id="textfield4" value="<?php echo $row_report['name']; ?>" />
</p>
<p>นักศึกษาชั้นปี
<label for="faculty"></label>
<input name="yearstu" type="text" id="textfield5" value="<?php echo $row_report['yearstu']; ?>" />
</p>
<p>ภาค
<label for="sectorr"></label>
<select name="sectorr" id="sectorr">
<option value="ปกติ" selected="selected">ปกติ</option>
<option value="ภาคค่ำ">ภาคค่ำ</option>
</select>
</p>
<p>รูปแบบ
<label for="style"></label>
<select name="style" id="style">
<option value="4 ปี">4 ปี</option>
<option value="ต่อเนื่อง">ต่อเนื่อง</option>
<option value="เทียบโอน">เทียบโอน</option>
</select>
</p>
<p>คณะ
<label for="education"></label>
<input name="faculty" type="text" id="textfield6" value="<?php echo $row_report['faculty']; ?>" />
</p>
<p>สาขา
<label for="adviser"></label>
<input name="education" type="text" id="textfield7" value="<?php echo $row_report['education']; ?>" />
</p>
<p id="GPA">อาจารย์ที่ปรึกษา
<label for="textfield8"></label>
<input name="adviser" type="text" id="textfield8" value="<?php echo $row_report['adviser']; ?>" />
</p>
<table width="1380" height="301" border="1">
<tr>
<td width="137"><blockquote>
<p>รหัสวิชา</p>
</blockquote></td>
<td width="382"><blockquote>
<blockquote>
<blockquote>
<blockquote>
<p>ชื่อวิชา</p>
</blockquote>
</blockquote>
</blockquote>
</blockquote></td>
<td width="66">หน่วยกิต</td>
<td width="60">กลุ่ม </td>
<td width="60">เกรด</td>
<td width="60">แต้ม</td>
<td width="569">เอกสารฉบับบนี้ให้แทนใบเสร็จรับเงิน</td>
</tr>
<tr>
<td><label for="department_id"></label>
<input name="department_id" type="text" id="department_id" value="<?php echo $row_report['department_id']; ?>" size="15" /></td>
<td><label for="department_name"></label>
<input name="department_name" type="text" id="department_name" value="<?php echo $row_report['department_name']; ?>" size="10" /></td>
<td><label for="credit"></label>
<input name="credit" type="text" id="credit" value="<?php echo $row_report['group']; ?>" size="10" /></td>
<td><label for="group"></label>
<input name="group" type="text" id="group" value="<?php echo $row_report['group']; ?>" size="10" /></td>
<td><label for="gread"></label>
<input name="gread" type="text" id="gread" value="<?php echo $row_report['gread']; ?>" size="10" /></td>
<td><label for="textfield39"></label>
<input name="textfield39" type="text" id="textfield39" size="10" /></td>
<td rowspan="7" valign="top"><p> เดิมลงทะเบียน
<label for="education"></label>
<label for="education"></label>
<input name="textfield6" type="text" id="textfield6" size="5" />
หน่วยกิต</p>
<p>ขอเพิ่ม
<label for="adviser"></label>
<input name="textfield7" type="text" id="textfield7" size="5" />
หน่วยกิต</p>
<p>รวมเป็น
<label for="textfield8"></label>
<input name="textfield8" type="text" id="textfield8" size="5" />
หน่วยกิต</p>
<p>ชำระเงินเพิ่ม (ถ้ามี)
<label for="textfield9"></label>
<input name="textfield9" type="text" id="textfield9" size="5" />
บาท</p>
<p>ลงนาม</p>
<p> </p>
<p>จนท.การเงิน</p>
<p>......./....../......</p></td>
</tr>
<tr>
<td><label for="deportment_id"></label>
<input name="deportment_id" type="text" id="deportment_id" value="<?php echo $row_report['department_id']; ?>" size="15" /></td>
<td><label for="dep"></label>
<input name="dep" type="text" id="dep" size="10" /></td>
<td><label for="textfield22"></label>
<input name="textfield22" type="text" id="textfield22" size="10" /></td>
<td><label for="textfield28"></label>
<input name="textfield28" type="text" id="textfield28" size="10" /></td>
<td><label for="textfield34"></label>
<input name="textfield34" type="text" id="textfield34" size="10" /></td>
<td><label for="textfield40"></label>
<input name="textfield40" type="text" id="textfield40" size="10" /></td>
</tr>
<tr>
<td><label for="textfield12"></label>
<input name="textfield12" type="text" id="textfield12" size="15" /></td>
<td><label for="textfield18"></label>
<input name="textfield18" type="text" id="textfield18" size="10" /></td>
<td><label for="textfield23"></label>
<input name="textfield23" type="text" id="textfield23" size="10" /></td>
<td><label for="textfield29"></label>
<input name="textfield29" type="text" id="textfield29" size="10" /></td>
<td><label for="textfield35"></label>
<input name="textfield35" type="text" id="textfield35" size="10" /></td>
<td><label for="textfield41"></label>
<input name="textfield41" type="text" id="textfield41" size="10" /></td>
</tr>
<tr>
<td><label for="textfield13"></label>
<input name="textfield13" type="text" id="textfield13" size="15" /></td>
<td><label for="textfield19"></label>
<input name="textfield19" type="text" id="textfield19" size="10" /></td>
<td><label for="textfield24"></label>
<input name="textfield24" type="text" id="textfield24" size="10" /></td>
<td><label for="textfield30"></label>
<input name="textfield30" type="text" id="textfield30" size="10" /></td>
<td><label for="textfield36"></label>
<input name="textfield36" type="text" id="textfield36" size="10" /></td>
<td><label for="textfield42"></label>
<input name="textfield42" type="text" id="textfield42" size="10" /></td>
</tr>
<tr>
<td><label for="textfield14"></label>
<input name="textfield14" type="text" id="textfield14" size="15" /></td>
<td><label for="textfield20"></label>
<input name="textfield20" type="text" id="textfield20" size="10" /></td>
<td><label for="textfield25"></label>
<input name="textfield25" type="text" id="textfield25" size="10" /></td>
<td><label for="textfield31"></label>
<input name="textfield31" type="text" id="textfield31" size="10" /></td>
<td><label for="textfield37"></label>
<input name="textfield37" type="text" id="textfield37" size="10" /></td>
<td><label for="textfield43"></label>
<input name="textfield43" type="text" id="textfield43" size="10" /></td>
</tr>
<tr>
<td><label for="textfield15"></label>
<input name="textfield15" type="text" id="textfield15" size="15" /></td>
<td>รวม
<label for="textfield45"></label></td>
<td><label for="textfield26"></label>
<input name="textfield26" type="text" id="textfield26" size="10" /></td>
<td><label for="textfield32"></label>
<input name="textfield32" type="text" id="textfield32" size="10" /></td>
<td><label for="textfield38"></label>
<input name="textfield38" type="text" id="textfield38" size="10" /></td>
<td><label for="textfield44"></label>
<input name="textfield44" type="text" id="textfield44" size="10" /></td>
</tr>
<tr>
<td height="102"><input name="textfield45" type="text" id="textfield45" size="10" /></td>
<td align="right"><blockquote>
<blockquote>
<blockquote>
<blockquote>
<p> </p>
</blockquote>
</blockquote>
</blockquote>
</blockquote></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<label for="GPA"></label>
<td> </td>
<td> </td>
<td> </td>
<td><p> </p>
<p>
<input type="submit" name="button" id="button" value="บันทึก" />
</p></td>
</form>
<?php } while ($row_report = mysql_fetch_assoc($report)); ?>
</body>
</html>
<?php
mysql_free_result($cnblue);
mysql_free_result($report);
?>
