 |
|
|
 |
 |
|
ลองศึกษาดูน่ะคราบ
[code]<html>
<head>
<title>:: Script การติดต่อฐานข้อมูล เพื่อ เพิ่ม/ลบ/แก้ไข/ค้นคืน ข้อมูล ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<style>
BODY {
FONT-FAMILY: Arial, Helvetica, sans-serif
}
.style1 {color: #FF0000}
</style>
<script type="text/javascript" language="javascript">
function addNumber(){
var in1 = parseInt(document.form1.thai.value);
if(in1 >= 50){document.form1.thaigrade.value = "1";}
if (in1 >= 60){document.form1.thaigrade.value = "2";}
if (in1 >= 70){document.form1.thaigrade.value = "3";}
if (in1 >= 80){document.form1.thaigrade.value = "4";}
if (in1 > 100){document.form1.thaigrade.value = "error";}
if (in1 < 50){document.form1.thaigrade.value = "0";}
var in2 = parseInt(document.form1.math.value);
if(in2 >= 50){document.form1.mathgrade.value = "1";}
if (in2 >= 60){document.form1.mathgrade.value = "2";}
if (in2 >= 70){document.form1.mathgrade.value = "3";}
if (in2 >= 80){document.form1.mathgrade.value = "4";}
if (in2 > 100){document.form1.thaigrade.value = "error";}
if (in2 < 50){document.form1.mathgrade.value = "0";}
var in3 = parseInt(document.form1.science.value);
if(in3 >= 50){document.form1.sciencegrade.value = "1";}
if (in3 >= 60){document.form1.sciencegrade.value = "2";}
if (in3 >= 70){document.form1.sciencegrade.value = "3";}
if (in3 >= 80){document.form1.sciencegrade.value = "4";}
if (in3 > 100){document.form1.thaigrade.value = "error";}
if (in3 < 50){document.form1.sciencegrade.value = "0";}
var in4 = parseInt(document.form1.social.value);
if(in4 >= 50){document.form1.socialgrade.value = "1";}
if (in4 >= 60){document.form1.socialgrade.value = "2";}
if (in4 >= 70){document.form1.socialgrade.value = "3";}
if (in4 >= 80){document.form1.socialgrade.value = "4";}
if (in4 > 100){document.form1.thaigrade.value = "error";}
if (in4 < 50){document.form1.socialgrade.value = "0";}
var in5 = parseInt(document.form1.art.value);
if(in5 >= 50){document.form1.artgrade.value = "1";}
if (in5 >= 60){document.form1.artgrade.value = "2";}
if (in5 >= 70){document.form1.artgrade.value = "3";}
if (in5 >= 80){document.form1.artgrade.value = "4";}
if (in5 > 100){document.form1.thaigrade.value = "error";}
if (in5 < 50){document.form1.artgrade.value = "0";}
var in6 = parseInt(document.form1.health.value);
if(in6 >= 50){document.form1.healthgrade.value = "1";}
if (in6 >= 60){document.form1.healthgrade.value = "2";}
if (in6 >= 70){document.form1.healthgrade.value = "3";}
if (in6 >= 80){document.form1.healthgrade.value = "4";}
if (in6 > 100){document.form1.thaigrade.value = "error";}
if (in6 < 50){document.form1.healthgrade.value = "0";}
var in7 = parseInt(document.form1.work.value);
if(in7 >= 50){document.form1.workgrade.value = "1";}
if (in7 >= 60){document.form1.workgrade.value = "2";}
if (in7>= 70){document.form1.workgrade.value = "3";}
if (in7 >= 80){document.form1.workgrade.value = "4";}
if (in7 > 100){document.form1.thaigrade.value = "error";}
if (in7 < 50){document.form1.workgrade.value = "0";}
var in8 = parseInt(document.form1.eng.value);
if(in8 >= 50){document.form1.enggrade.value = "1";}
if (in8 >= 60){document.form1.enggrade.value = "2";}
if (in8>= 70){document.form1.enggrade.value = "3";}
if (in8 >= 80){document.form1.enggrade.value = "4";}
if (in8 > 100){document.form1.thaigrade.value = "error";}
if (in8 < 50){document.form1.enggrade.value = "0";}
var sum = ((in1+in2+in3+in4+in5+in6+in7+in8)/8)/25;
document.form1.total.value = sum;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>
</head>
<body onLoad="MM_preloadImages('pic/button/home2.png')">
<!-- ส่วนหัวของฟอร์มที่เป็นการบอกว่าจะให้ไปหน้าไหน หลังกดปุ่ม Submit -->
<form name="form1"form action="editdata_in.php" method="post">
<p>
<!-- ทำ Hidden Field เก็บค่า ID ไว้ส่งไปที่หน้า editdata_in.php ด้วย -->
|
 |
 |
 |
 |
| Date :
2009-12-14 01:13:42 |
By :
parita |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
เพิ่มเติม
<?php
include "config.inc.php";
$id = $_GET['id'];
$query = "select * from member where id='$id'";
$result = mysql_query($query);
$dbarr = mysql_fetch_array($result) ;
?>
</p>
<table width="498" height="674" border="0" align="center" background="pic/blackboard.jpg">
<tr>
<td width="241" height="59"><img src="pic/button/edit_st2.png" alt="" width="235" height="60"></td>
<td width="241"><img src="pic/button/home1.png" width="235" height="60" border="0" usemap="#Map" id="Image1"></td>
</tr>
<tr>
<td height="607" colspan="2" align="center" valign="top"><p>
<input type="hidden" name="id" value="<?php echo "$id"; ?>">
</p>
<table border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#0066CC">
<tr>
<td width="125" bgcolor="#FFFFFF"><p><font size="2"> ID</font></p></td>
<td colspan="2" bgcolor="#FFFFFF"><font size="2" color="red"> <? echo $id; ?></font> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><p><font size="2"> ชื่อ - นามสกุล</font></p></td>
<td colspan="2" bgcolor="#FFFFFF"><input name="namesurname" type="text" value ="<?php echo "$dbarr[namesurname]"; ?>" size="30" style="width: 227px" maxlength="50"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> ชั้น</font></td>
<td colspan="2" bgcolor="#FFFFFF"><input name="class" type="text" size="5" value ="<?php echo "$dbarr[class]"; ?>" maxlength="5"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> วัน/เดือน/ปีเกิด</font></td>
<td colspan="2" bgcolor="#FFFFFF"><font size="2">
<input name="dmy" type="text" size="10" value ="<?php echo "$dbarr[dmy]"; ?>" maxlength="10">
<span class="style1">ex.1/9/2530</span></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> เพศ</font></td>
<td colspan="2" bgcolor="#FFFFFF"><font size="2">
<input name="sex" type="radio" value="ชาย" checked>
ชาย
<input name="sex" type="radio" value="หญิง">
หญิง </font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> ที่อยู่</font></td>
<td colspan="2" bgcolor="#FFFFFF"><font size="2">
<textarea name="address" cols="30" rows="3" wrap="virtual"><?php echo "$dbarr[address]"; ?></textarea>
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> ภาษาไทย</font></td>
<td width="79" bgcolor="#FFFFFF"><input name="thai1" type="text" size="5" value ="<?php echo "$dbarr[thaigrade]"; ?>" maxlength="5"> </td>
<td width="174" bgcolor="#FFFFFF"><input name="thai" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="thaigrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> คณิตศาสตร์</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[mathgrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="math" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="mathgrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> วิทยาศาสตร์</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[sciencegrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="science" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="sciencegrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> สังคมศึกษา</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[socialgrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="social" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="socialgrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> ศิลปะศึกษา</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[artgrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="art" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="artgrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> สุขศึกษา</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[healthgrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="health" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="healthgrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> การงานพื้นฐานอาชีพฯ</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[workgrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="work" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="workgrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="2"> ภาษาอังกฤษหลัก</font></td>
<td bgcolor="#FFFFFF"><input name="input" type="text" size="5" value ="<?php echo "$dbarr[enggrade]"; ?>" maxlength="5"> </td>
<td bgcolor="#FFFFFF"><input name="eng" type="text" size="5" value ="" maxlength="5"onKeyUp="addNumber()">
<input name="enggrade" type="text" size="5" value ="" maxlength="5"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"></font>เกรดเฉลี่ย
<div align="center"></div></td>
<td colspan="2" bgcolor="#FFFFFF"><input type"text" name="total" value="0" /> </td>
</tr>
<tr bgcolor="#0066CC">
<td colspan="3"><div align="center">
<input type="submit" name="Submit" value="แก้ไขข้อมูล">
<input type="reset" name="Reset" value="ลบข้อมูล">
</div></td>
</tr>
</table></td>
</tr>
</table>
</form>
<map name="Map"><area shape="rect" coords="1,1,234,58" href="add.php" onMouseOver="MM_swapImage('Image1','','pic/button/home2.png',1)" onMouseOut="MM_swapImgRestore()">
</map></body>
</html>[/code]
|
| |
|
|
| |
| Date :
2009-12-14 01:15:01 |
By :
parita |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
