คือส่งค่า ID ผ่าน URL ไปโชวข้อมูลได้เเล้วคะ เเต่พอถึงหน้า update มันไม่อัพข้อมูลใหม่ลง DB ค่ะ
upme.php
<?php
if ($_POST['vid'] == 0)
{
?>
<form method="POST" action="upme.php">
แก้ไขข้อมูล รหัสพนักงาน: <input type="text" name="vid" >
<br> <input type="submit" name="send" value="Submit">
</form>
<?php
}else
{
$link = mysql_connect("localhost","wayorath_regis2","regis2");
$sql = mysql_select_db("wayorath_regis") or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_query("Set Names tis620");
if(isset($_POST['vid']))
{
$myid = $_POST['vid'];
$sql = "select * from admin where ID_I = '$myid'";
$result = mysql_query($sql);
mysql_query("Set Names tis620");
echo " <form action=update.php?ID=$myid method=POST>";
$db = mysql_fetch_array($result);
echo "รหัสพนักงาน:" .$myid."<br>";
echo "ชื่อพนักงาน:" ;
echo "<input type=text name=myname value=$db[name]><br>";
echo "ชื่อเข้าระบบ:" ;
echo "<input type=text name=myuser value= $db[username]><br>";
echo "รหัสผ่าน:" ;
echo "<input type=text name=mypass value=$db[pass]><br>";
echo "<input type=submit name=subit id=button value=Submit><br>";
echo "</form>";
}
}
?>
-------------------
update.php
<?php
$link = mysql_connect("localhost","wayorath_regis2","regis2");
$sql = mysql_select_db("wayorath_regis") or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_query("Set Names tis620");
$sql = "UPDATE admin SET name='".$_POST['$myname']."',username='".$_POST['$myuser']."',pass='".$_POST['$mypass']."' where ID_I='".$_POST['$ID']."'";
$result = mysql_query($sql);
//echo $result;
if($result)
{echo "update ok";}
else
{ echo "not up";};
?>
ช่วยแก้ code PHP หน่อยค่ะ
upme.php
<?php
if ($_POST['vid'] == 0)
{
?>
<form method="POST" action="upme.php">
แก้ไขข้อมูล รหัสพนักงาน: <input type="text" name="vid" >
<br> <input type="submit" name="send" value="Submit">
</form>
<?php
}else
{
$link = mysql_connect("localhost","wayorath_regis2","regis2");
$sql = mysql_select_db("wayorath_regis") or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_query("Set Names tis620");
if(isset($_POST['vid']))
{
$myid = $_POST['vid'];
$sql = "select * from admin where ID_I = '$myid'";
$result = mysql_query($sql);
mysql_query("Set Names tis620");
echo " <form action=update.php?ID=$myid method=POST>";
$db = mysql_fetch_array($result);
echo "รหัสพนักงาน:" .$myid."<br>";
echo "ชื่อพนักงาน:" ;
echo "<input type=text name=myname value=$db[name]><br>";
echo "ชื่อเข้าระบบ:" ;
echo "<input type=text name=myuser value= $db[username]><br>";
echo "รหัสผ่าน:" ;
echo "<input type=text name=mypass value=$db[pass]><br>";
echo "<input type=submit name=subit id=button value=Submit><br>";
echo "</form>";
}
}
?>
-------------------
update.php
<?php
$link = mysql_connect("localhost","wayorath_regis2","regis2");
$sql = mysql_select_db("wayorath_regis") or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_query("Set Names tis620");
$sql = "UPDATE admin SET name='".$_POST['$myname']."',username='".$_POST['$myuser']."',pass='".$_POST['$mypass']."' where ID_I='".$_POST['$ID']."'";
$result = mysql_query($sql);
//echo $result;
if($result)
{echo "update ok";}
else
{ echo "not up";};
?>