stanigator/form.php Secret

## form.php
<html>

<head>
<title>FORM</title>
</head>

<body>
<form method="post" action="insert.php">

Name: <input type="text" name="name" /><br />
Email: <input type="text" name="email" /><br />
Password: <input type="password" name="password" /><br />
Confirm Password: <input type="password" name="cpassword" /><br />

<input type="submit" name="submit" value="Register" />

<a href="output.php">See data</a>

</form>
</body>

</html>

## insert.php
<?php

$name = $_POST["name"];
$email = $_POST["email"];
$pw = $_POST["password"];
$cpw = $_POST["cpassword"];

if ($name && $email && $pw)
{
	mysql_connect("localhost", "root", "") or die("We couldn't connect!");
	mysql_select_db("testsite");

	mysql_query("INSERT INTO users(name, email, password) VALUES('$name', '$email', '$pw'") or die(mysql_error());

	$registered = mysql_affected_rows();

	echo "$registered was inserted";
}
else
{
	echo "At least one value is empty";
}

mysql_close();

?>

## output.php
<?php

mysql_connect("localhost", "root", "") or die("Problem with connection");

mysql_select_db("testsite");

$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_array($result))
{
	echo $row["name"]." ".$row["email"]." ".$row["password"]."<br />";
}

mysql_close();

?>
	<html>

	<head>
	<title>FORM</title>
	</head>

	<body>
	<form method="post" action="insert.php">

	Name: <input type="text" name="name" /><br />
	Email: <input type="text" name="email" /><br />
	Password: <input type="password" name="password" /><br />
	Confirm Password: <input type="password" name="cpassword" /><br />

	<input type="submit" name="submit" value="Register" />

	<a href="output.php">See data</a>

	</form>
	</body>

	</html>
	<?php

	mysql_connect("localhost", "root", "") or die("Problem with connection");

	mysql_select_db("testsite");

	$result = mysql_query("SELECT * FROM users");

	while($row = mysql_fetch_array($result))
	{
	echo $row["name"]." ".$row["email"]." ".$row["password"]."<br />";
	}

	mysql_close();

	?>