본문 바로가기
HTML

insert

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

	include("67.php");
	$sql="INSERT INTO member(id, pw, name, EMAIL)
	VALUES('$id;', '$pw;', '$name;', '$EMAIL;')";
	$result = mysql_query($sql, $connect);

	$sql="SELECT * FROM member";
	$result = mysql_query($sql, $connect);
	while($row = mysql_fetch_row($result))
	{
		echo 'ID: '.$row[0].' ';
		echo 'PW: '.$row[1].' ';
		echo 'NAME: '.$row[2].' ';
		echo 'EMAIL: '.$row[3].' ';
		echo '<br>';
	}
?>
	<form action="89.php" method="post" name="89">
	I&nbsp;&nbsp;&nbsp;D:<input type="text" name="id" value" "><BR>
	P&nbsp;&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' 카테고리의 다른 글

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

댓글