ตัวอย่างโค้ด update.php
<?
$update_id = $_POST['id'];
if ($update_id"")
{
$host = "localhost";
$user = "ชื่อ
user";
$pass = "รหัสผ่านของ
user";
$link = mysql_connect($host,$user,$pass);
mysql_select_db("ชื่อ
database",$link);
$OLD_ID = $_POST['id'];
$OLD_NAME =$_POST['name'];
$OLD_LNA =$_POST['lname'];
$SQL_ex = "update ชื่อ
table set
name='$OLD_NAME',lname='$OLD_LNA' where id='$OLD_ID'";
$result = mysql_query($SQL_ex);
mysql_close($link);
}
$id_key = $_POST['id_key'];
if ($id_key=="")
{
echo '<form action = "update.php" method = "post">';
echo ' Search ID <br>';
echo ' <input type = "text" name = "id_key"
size="20"><br>';
echo ' <input type = "submit" value =
"Search"><p> </p>';
}
else
{
$host = "localhost";
$user = "ชื่อ
user";
$pass = "รหัสผ่านของ
user";
$link = mysql_connect($host,$user,$pass);
mysql_select_db("ชื่อของ
database",$link);
$result = mysql_query($SQL_ex);
$resultt=mysql_query("select * from ชื่อ table where
id='$id_key'");
$id=mysql_result($resultt,0,'id');
$name=mysql_result($resultt,0,'name');
$lname=mysql_result($resultt,0,'lname');
echo '<form action = "update.php" method =
"POST">';
echo '<hr><br>';
echo '<center>UPDATE PAGE</center>';
echo '<br><hr>';
echo 'ID :';
echo "<input type = hidden name = id size=20
value=$id>";
echo "$id <br>";
echo 'Name :';
echo "<input type =text name = name size=20
value=$name><br>";
echo 'Lastname :';
echo "<input type = text name = lname size=20
value=$lname><br><hr>";
echo '<input type = "submit" value = "Add">';
echo '</form>';
mysql_close($link);
}
?>
ไม่มีความเห็น