โดย ManGal49 » 30/11/2010 12:42 am
<?
$employee_id=$_POST["employee_id"].$employee_id=$_GET["employee_id"];
include("mysql.inc.php");
$sql="select * from t_employee where employee_id='$employee_id' ";
$result=mysql_query($sql);
if ($row=mysql_fetch_object($result))
{
?>
<form id="form1" name="form1" method="post" action="employee_update.php">
<table width="500" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="162"><div align="right" class="style6">รหัสพนักงาน</div></td>
<td width="10"> </td>
<td width="316"><input name="employee_id_new" type="text" id="employee_id_new" value="<? echo $row->employee_id;?>" size="10" maxlength="10" /></td>
</tr>
<tr>
<td><div align="right" class="style6">ชื่อ</div></td>
<td> </td>
<td><input name="employee_name_new" type="text" id="employee_name_new" value="<? echo $row->employee_name;?>" size="20" maxlength="50" /></td>
</tr>
<tr>
<td><div align="right" class="style6">นามสกุล</div></td>
<td> </td>
<td><input name="employee_sname_new" type="text" id="employee_sname_new" value="<? echo $row->employee_sname;?>" size="20" maxlength="50" /></td>
</tr>
<tr>
<td><div align="right" class="style6">เพศ</div></td>
<td> </td>
<td><input name="employee_sex_new" type="text" id="employee_sex_new" value="<? echo $row->employee_sex;?>" size="5" maxlength="4" /></td>
</tr>
<tr>
<td><div align="right" class="style6">ที่อยู่</div></td>
<td> </td>
<td><input name="employee_address_new" type="text" id="employee_address_new" value="<? echo $row->employee_address;?>" size="50" maxlength="100" /></td>
</tr>
<tr>
<td><div align="right" class="style6">วันเกิด</div></td>
<td> </td>
<td><input name="employee_birthday_new" type="text" id="employee_birthday_new" value="<? echo $row->employee_birthday;?>" size="20" maxlength="10" /></td>
</tr>
<tr>
<td><div align="right" class="style6">เงินเดือน</div></td>
<td> </td>
<td><input name="employee_salary_new" type="text" id="employee_salary_new" value="<? echo $row->employee_salary;?>" size="20" maxlength="10" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="submit" id="submit" value="Submit" /></td>
</tr>
</table>
</form>
<?
}
mysql_free_result($result);
mysql_close($link);
?>
นี่ครับ โค้ด employee_edit ของผม
<?
$employee_id=$_POST["employee_id"].$employee_id=$_GET["employee_id"];
include("mysql.inc.php");
$sql="select * from t_employee where employee_id='$employee_id' ";
$result=mysql_query($sql);
if ($row=mysql_fetch_object($result))
{
?>
<form id="form1" name="form1" method="post" action="employee_update.php">
<table width="500" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="162"><div align="right" class="style6">รหัสพนักงาน</div></td>
<td width="10"> </td>
<td width="316"><input name="employee_id_new" type="text" id="employee_id_new" value="<? echo $row->employee_id;?>" size="10" maxlength="10" /></td>
</tr>
<tr>
<td><div align="right" class="style6">ชื่อ</div></td>
<td> </td>
<td><input name="employee_name_new" type="text" id="employee_name_new" value="<? echo $row->employee_name;?>" size="20" maxlength="50" /></td>
</tr>
<tr>
<td><div align="right" class="style6">นามสกุล</div></td>
<td> </td>
<td><input name="employee_sname_new" type="text" id="employee_sname_new" value="<? echo $row->employee_sname;?>" size="20" maxlength="50" /></td>
</tr>
<tr>
<td><div align="right" class="style6">เพศ</div></td>
<td> </td>
<td><input name="employee_sex_new" type="text" id="employee_sex_new" value="<? echo $row->employee_sex;?>" size="5" maxlength="4" /></td>
</tr>
<tr>
<td><div align="right" class="style6">ที่อยู่</div></td>
<td> </td>
<td><input name="employee_address_new" type="text" id="employee_address_new" value="<? echo $row->employee_address;?>" size="50" maxlength="100" /></td>
</tr>
<tr>
<td><div align="right" class="style6">วันเกิด</div></td>
<td> </td>
<td><input name="employee_birthday_new" type="text" id="employee_birthday_new" value="<? echo $row->employee_birthday;?>" size="20" maxlength="10" /></td>
</tr>
<tr>
<td><div align="right" class="style6">เงินเดือน</div></td>
<td> </td>
<td><input name="employee_salary_new" type="text" id="employee_salary_new" value="<? echo $row->employee_salary;?>" size="20" maxlength="10" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="submit" id="submit" value="Submit" /></td>
</tr>
</table>
</form>
<?
}
mysql_free_result($result);
mysql_close($link);
?>
นี่ครับ โค้ด employee_edit ของผม