|
|
|
ช่วยดูให้หน่อยค่ะว่าทำไมถึง โชว์ค่าในtext Area ไม่ได้ |
|
|
|
|
|
|
|
เราทำ Insert ข้อความลงไปใน DB ได้แล้ว แต่ทำไมมันไม่ยอมโชว์ค่า(ข้อความ)ใน text Areaขึ้นมาเลยอะคะ
config.php
Code (PHP)
<?php session_start();?>
<?php require_once('../connection/connect.php'); ?>
<?php require_once('../connection/function.php'); ?>
<script type="text/javascript" src="../scripts/calendarDateInput.js">
</script>
<html><!-- InstanceBegin template="/Templates/index.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Examination Online System</title>
<style type="text/css">
body
{
margin:auto auto auto auto;
}
#left
{
position:fixed;
right:-2px;
width:202px;
}
#right
{
position:fixed;
float:right;
width:770px;
}
.cbg table tr td table tr td #right table tr td h3 {
text-align: center;
}
.cbg table tr td table tr td #right table tr td {
color: #00F;
font-weight: bold;
font-size: 16px;
font-family: Arial, Helvetica, sans-serif;
}
</style>
<!-- InstanceEndEditable -->
<meta name="description" content="Education website">
<meta name="keywords" content="education, learning, teaching">
<link href="../css/style.css" rel="stylesheet" type="text/css">
<!-- InstanceBeginEditable name="head" -->
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css">
<link href="../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css">
<!-- InstanceEndEditable -->
</head>
<body>
<table width="765" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="1"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/t1.gif" width="335" height="237"></td>
<td><table width="105%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/t2.gif" width="354" height="37"></td>
</tr>
<tr>
<td><img src="../images/t2-5.gif" width="354" height="200"></td>
</tr>
</table></td>
<td><img src="../images/t3.gif" width="330" height="237"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1"><img src="../images/ml.gif" width="7" height="35"></td>
<td background="../images/mbg.gif" class="bgx"><table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="menu"><a href="#">About Us</a></td>
<td width="1"><img src="../images/msep.gif" width="5" height="35"></td>
<td class="menu"><a href="#">Student Life</a></td>
<td width="1"><img src="../images/msep.gif" width="5" height="35"></td>
<td class="menu"><a href="#">Contact Details</a></td>
</tr>
</table></td>
<td width="1"><img src="../images/mr.gif" width="8" height="35"></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" height="27" background="../images/cbgl.gif" class="bgy"><img src="../images/cbgl.gif" width="7" height="1"></td>
<td width="1149" class="cbg"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" height="100%" valign="top"> </td>
<td width="991" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><!-- InstanceBeginEditable name="EditRegion3" -->
<!-- right form -->
<div id="right">
<table width="100%" border="1" align="center">
<tr>
<td width="266"><h3>จัดการข้อสอบ</h3></td>
</tr>
</table>
<form name="form1" method="post" action="save_config.php">
<table width="100%" border="1">
<tr>
<td width="13%">รหัสวิชา</td>
<td width="54%"><select name="chapterId" id="chapterId">
<?php
$sql = "select courseId,CONCAT(courseId,' ',courseName) as courseIN from courses order by courseId ";
$query = mysql_query($sql)or die(mysql_error());
$num = mysql_num_rows($query);
for($i=1;$i<=$num;$i++)
{
$row = mysql_fetch_array($query);
?>
<option value="<?php echo $row ['courseId']?>"><?php echo $row ['courseIN']?></option>
<?php
}
?>
</select></td>
<td width="33%"> </td>
<td width="33%"> </td>
</tr>
<tr>
<td>วันที่สอบ</td>
<td> <script> DateInput('orderdate', true, 'DD-MON-YYYY')</script>
</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>เวลาเริ่มสอบ</td>
<td> </td>
<td>เวลาสิ้นสุด</td>
<td> </td>
</tr>
<tr>
<td>ใช้เวลาในการสอบ</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>รายละเอียด</td>
<td>
<?php
$sql = "select configId,config_desc from config_exams where configId='$configId'";
$query = $query = mysql_query($sql)or die ("error=$sql");
$row = mysql_fetch_array($query);
?>
<textarea name="config_desc" id="config_desc" cols="45" rows="5" value ="<?=$row ['config_desc']?>"></textarea></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>จำนวนข้อสอบ </td>
<td><input type="text" name="textfield" id="textfield"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>คะแนน</td>
<td><input type="text" name="textfield2" id="textfield2"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="button" id="button" value="ยืนยัน">
<input type="button" name="button3" id="button3" value="แก้ไข"onclick="location='update_config.php?configId<?php echo $row ['config_desc']?> '">
<input type="reset" name="button2" id="button2" value="ยกเลิก"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<p> </p>
</div>
<!-- left form -->
<div id=left>
<table width="200" border="1">
<tr>
<th bgcolor="#0033CC" scope="col"><font color="#F9F" size="5" class="tr"><a href="page_teacher.php">เมนูหลัก</a></font></th>
</tr>
<tr>
<td><ul id="MenuBar1" class="MenuBarVertical">
<li><a class="MenuBarItemSubmenu" href="#"><font size="3" color="#006699"><strong> ตั้งค่าการสอบ</strong></font></a>
<ul>
<li><a href="manage_student.php"><font size="3">กำหนดสิทธิ์สอบ</font></a></li>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu"><font size="3" color="#006699"><strong>จัดกาข้อสอบ</strong></font></a>
<ul>
<li><a href="create_course.php"><font size="3">เพิ่ม</font></a></li>
<li><a href="manage_course.php"><font size="3">ลบ-แก้ไข</font></a></li>
</ul>
</li>
<li><a class="MenuBarItemSubmenu" href="#"><font size="3" color="#006699"><strong>จัดการนักศึกษา</strong></font></a>
<ul>
<li><a href="create_chapter.php"><font size="3">เพิ่มบทเรียน</font></a></li>
</ul>
<li><a class="MenuBarItemSubmenu" href="#"><font size="3" color="#006699"><strong>จัดการข้อสอบ</strong></font></a>
<ul>
<li><a href="search_course_addquiz.php"><font size="3">เพิ่มข้อสอบ</font></a></li>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu"><font size="3" color="#006699"><strong>จัดการคะแนนสอบ</strong></font></a>
<ul>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu"><font size="3" color="#006699"><strong>จัดการข้อมูลส่วนตัว</strong></font></a>
<ul>
<li><a href="change_password.php">เปลี่ยนแปลงรหัส</a></li>
</ul>
</li>
</ul></td>
</tr>
<tr> </tr>
</table>
</div>
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
<!-- InstanceEndEditable --></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="8" background="../images/cbgr.gif" class="bgy"><img src="../images/cbgr.gif" width="8" height="1"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/bml.gif" width="7" height="24"></td>
<td width="100%" bgcolor="#0C5282" class="bottom-menu">Copyright © 2010 School of Information Technology, King Mongkut's University of Technology Thonburi.</td>
<td><img src="../images/bmr.gif" width="8" height="24"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#1A658C" class="bottom_addr"> </td>
</tr>
</table>
<p> </p>
<div style="position:absolute;left:-30000px;top:-30000px"><a href="http://anvisionwebtemplates.com">Website templates</a><a href="http://cityants.co.uk">Business directory UK</a><a href="http://cityants.net">Yellow pages US</a><a href="http://anvisionwebdesign.com">Website design company</a><a href="http://webdesignfinders.net">Web design directory</a><a href="http://australia.webdesignfinders.net">Web design directory Australia</a><a href="http://canada.webdesignfinders.net">Web design directory Canada</a><a href="http://anvisionwebtemplates.com/free-education-web-templates-layouts.html">Free education web templates</a></div>
</body>
<!-- InstanceEnd --></html>
code save_config.php
Code (PHP)
[php]<?php require_once('../connection/connect.php'); ?>
<?php require_once('../connection/function.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=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
$configId = $_POST['configId'];
$date_exam = $_POST['date_exam'];
$start_time = $_POST['start_time'];
$end_time = $_POST['end_time'];
$config_desc = $_POST['config_desc'];
$course_id = $_POST['course_id '];
$chapter_id = $_POST['chapter_id'];
if(empty($config_desc))
{
exit("<script>alert('กรุณาใส่รายละเอียดค่ะ');history.bank();</script>");
}
$sql = "insert into config_exams
(configId,config_desc)values('$configId','$config_desc')";
$query = mysql_query($sql)or die (mysql_error());
$row = mysql_fetch_array($query);
?>
<script type="text/javascript">
window.location='config.php?configId=<?=configId;?>&config_desc=<?=$config_desc;?>';
</script>
</body>
</html>
[/php]
ส่วนของ DB
การแสดงผล
Tag : PHP
|
|
|
|
|
|
Date :
2010-08-20 02:27:41 |
By :
pandakuku |
View :
1596 |
Reply :
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code (PHP)
<textarea name="config_desc" id="config_desc" cols="45" rows="5"><?=$row ['config_desc']?></textarea>
textarea ไม่ได้ใช้ properties value น่ะครับ
|
|
|
|
|
Date :
2010-08-20 06:22:23 |
By :
webmaster |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ลองแบบนี้ดู
Code (PHP)
<textarea name="config_desc" id="config_desc" cols="45" rows="5" ><?=$row ["config_desc"];?></textarea>
|
|
|
|
|
Date :
2010-08-20 10:14:18 |
By :
Mr.Poo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
มันไม่ขึ้นอะค่ะลองแล้ว
|
|
|
|
|
Date :
2010-08-20 12:09:20 |
By :
pandakuku |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<?=$row["config_desc"];?> ชิด ๆ กันหน่อย
|
|
|
|
|
Date :
2010-08-20 12:30:56 |
By :
Gg |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
window.location='config.php?configId=<?=$configId?>&config_desc=<?=$config_desc?>';
|
|
|
|
|
Date :
2010-08-20 13:19:20 |
By :
heng |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|