修改資料update
張貼日期:Mar 10, 2010 1:16:18 PM
<?php
// 新增資料
if ($_POST["Submit"]) {
$c_name = trim($_POST["c_name"]) ;
$c_link = trim($_POST["c_link"]) ;
$c_sort = trim($_POST["c_sort"]) ;
$c_id = trim($_POST["c_id"]) ;
$sql = " UPDATE `tb_link` SET `c_name` = '".$c_name."', `c_link` = '".$c_link."' , `c_sort` = ".$c_sort." WHERE c_id = ".$c_id ;
mysql_query($sql);
if (mysql_errno()>0 ) {
Alert_Box("修改失敗!!");
WinBack();
exit;
} else {
Alert_Box("修改成功!!");
WinLoadPage("list_link.php");
}
}
$sql = "SELECT * FROM `tb_link` WHERE `c_id` = ".$_GET["c_id"] ;
$result = mysql_query($sql) ;
$editrow = mysql_fetch_array($result) ;
?>
<form action="<? echo $_SERVER['PHP_SELF'];?>" method="post" name="form1" onSubmit="return form_check();">
<table width="500" border="1" align="center" cellpadding="4" cellspacing="0" bordercolor="#DFCCB9" style="border-collapse: collapse">
<tr>
<td colspan="2" align="center" bgcolor="#DFCCB9"><strong>修改連結</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td nowrap><font size="2">網站名稱:</font></td>
<td><input name="c_name" type="text" id="c_name" size="30" maxlength="50" value="<? echo $editrow["c_name"] ;?>"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>*網址<font size="2">:</font></td>
<td><input name="c_link" type="text" id="c_link" value="<? echo $editrow["c_link"] ;?>" size="30">
<br>
例:http://www.yahoo.com.tw</td>
</tr>
<tr bgcolor="#FFFFFF">
<td><font size="2">排序:</font></td>
<td>
<select name="c_sort" id="c_sort">
<?
$sql = "SELECT * FROM `tb_link`" ;
$result = mysql_query($sql) ;
for ($i=0;$i<mysql_num_rows($result);$i++){
echo "<option value=".($i+1) ;
echo ($editrow["c_sort"]==($i+1))? " selected ":"" ;
echo " >".($i+1)."</option>" ;
}
?>
</select> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="center"> <input name="c_id" type="hidden" id="c_id" value="<? echo $_GET["c_id"] ; ?>">
<input type="submit" name="Submit" value="確定修改">
<input name="back" type="button" id="back" onClick="history.go(-1)" value="回上一頁"></td>
</tr>
</table>
</form>