본문 바로가기
HTML

delete

by chaechaekim 2019. 8. 2.
<?php
$id=$_POST['id'];
$pw=$_POST['pw'];
$name=$_POST['name'];
$E_mail=$_POST['EMAIL'];
echo $id;
Echo "<br>";
echo $pw;
Echo "<br>";
echo $name;
Echo "<br>";
echo $EMAIL;
Echo "<br>";

include ("67.php");
$sql="DELETE FROM member WHERE id='$id'";
$result = mysql_query ($sql,$connect);
$sql="SELECT * FROM member";
$result = mysql_query ($sql,$connect);
echo "<table border=1>";
while ($row= mysql_fetch_row($result))
{
 echo "<tr>";
 echo "<td>"; echo 'ID: ';echo "</td>";
 echo "<td>"; echo $row[0];echo "</td>";
 echo "<td>"; echo 'PW: ';echo "</td>";
 echo "<td>"; echo $row[1];echo "</td>";
 echo "<td>"; echo 'NAME: ';echo "</td>";
 echo "<td>"; echo $row[2];echo "</td>";
 echo "<td>"; echo 'EMAIL: ';echo "</td>";
 echo "<td>"; echo $row[3];echo "</td>";
 echo "</tr>";
}
echo "</table>"
?> 
<form action= "27.php" method="post" name ="insert">
&nbsp;I&nbsp;&nbsp;&nbsp;D: <input type="text" name="id" value=""><br>
&nbsp;P;&nbsp;&nbsp;W: <input type="text" name="pw" value=""><br>
NAME: <input type="text" name="name" value=""><br>
EMAIL: <input type="text" name="EMAIL" value=""><br>
<input type= "submit" name="run" value="실행">

'HTML' 카테고리의 다른 글

insert  (0) 2019.08.02
전송  (0) 2019.08.01
배열  (0) 2019.07.31
제어문  (0) 2019.07.31
  (0) 2019.07.31

댓글