Quote:<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body bgcolor="#cc9520"> <?php include("config.php"); ?> </br></br><center><h2>Member Manager</h2></center> <form name="add_member" method="post" action="add_member.php"> <center><input type="submit" name="add_member" value="Add Member"></form> </br></br><table align="center" border='1' bordercolor="black" width="1000"> <tr bgcolor='#0066ff'> <td><center><b>UserID</td> <td><center><b>Username</td> <td><center><b>Name</td> <td><center><b>Email</td> <td><center><b>Tel</td> <td><center><b>Address</td> <td><center><b>Status</td> <td><center><b>Edit</td> <td><center><b>Delete</td> </tr> <?php mysql_query("SET NAMES UTF8"); $sql="select * from member"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)){ $UserID=$row['UserID']; $Username=$row['Username']; $Name=$row['Name']; $Email=$row['Email']; $Tel=$row['Tel']; $Address=$row['Address']; $Status=$row['Status']; echo "<tr>"; echo "<td><center>$UserID</td>"; echo "<td>$Username</td>"; echo "<td>$Name</td>"; echo "<td>$Email</td>"; echo "<td>$Tel</td>"; echo "<td>$Address</td>"; echo "<td><center>$Status</td>"; echo "<td><center><a href='edit_member02.php?UserID=$UserID'>Edit</a></center></td>"; echo "<td><center><a href='delete_member01.php?UserID=$UserID'>Delete</a></center></td>"; echo "</tr>"; } ?> </table> </br><center><form name="return" method="post" action="admin_page.php"> <input type="submit" name="return" value="Return to Mainmenu"> </form></center> <br><br> </body> </html>
Quote:<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body bgcolor="#cc9520"> <?php include("config.php"); ?> </br><center><h2>Member Manager</h2></center> <?php $UserID=$_REQUEST["UserID"]; mysql_query("SET NAMES UTF8"); $sql="select * from member where UserID='$UserID' "; $result=mysql_query($sql); $row=mysql_fetch_array($result); $UserID=$row["UserID"]; $Username=$row["Username"]; $Name=$row["Name"]; $Email=$row["Email"]; $Tel=$row["Tel"]; $Address=$row["Address"]; $Status=$row["Status"]; ?> <form method="post" action="edit_member03.php"> <table align="center" border="1" bordercolor="black" width=""> <tr> <td><b>UserID</td> <td><?=$UserID?></td> </tr> <tr> <td><b>Username</td> <td><input type="text" name="Username" value="<?=$Username?>"></td> </tr> <tr> <td><b>Name</td> <td><input type="text" name="Name" value="<?=$Name?>"></td> </tr> <tr> <td><b>Email</td> <td><input type="text" name="Email" value="<?=$Email?>"></td> </tr> <tr> <td><b>Tel</td> <td><input type="text" name="Tel" value="<?=$Tel?>"></td> </tr> <tr> <td><b>Address</td> <td><input type="text" name="Address" value="<?=$Address?>"></td> </tr> <tr> <td><b>Status</td> <td><select name="statuslist"> <option value="1">Admin <option value="2">User</td> </tr> </table></br> <center><input type="submit" name="save" value="Save"></center> </form> <br><br> </body>
Quote:<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body bgcolor="#cc9520"> <?php include("config.php"); ?> </br></br><center><h2>Member Manager</h2></center> <?php $UserID=$row["UserID"]; $Username=$row["Username"]; $Password=$row["Password"]; $Name=$row["Name"]; $Email=$row["Email"]; $Tel=$row["Tel"]; $Address=$row["Address"]; $Status=$row["Status"]; mysql_query("SET NAMES UTF8"); $sql = "UPDATE member SET Username = '".trim($_POST['Username'])."' ,Name = '".trim($_POST['Name'])."' ,Email = '".trim($_POST['Email'])."' ,Tel = '".trim($_POST['Tel'])."' ,Address = '".trim($_POST['Address'])."' WHERE UserID = $UserID'"; $result=mysql_query($sql); if($result){ echo "<center><b>Save Complete !</b></center>"; }else{ echo "<center><b>Save Failed !</b></center>"; } ?> <br> <center><b>Return to<a href='edit_member01.php'> Member Manager Page</a></b></center> <br><br> </body> </html>
1.
<input type=
"hidden"
name=
"UserID"
value=
"<? echo $row['UserID']; ?>"
>
Quote:<?php $UserID=$row["UserID"]; $Username=$row["Username"]; $Password=$row["Password"]; $Name=$row["Name"]; $Email=$row["Email"]; $Tel=$row["Tel"]; $Address=$row["Address"]; $Status=$row["Status"]
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง