Untitled


<html>
<body>

<form action="" method="POST">
<p><b>Register</b></p><br>
Username: <input type="text" name="Username" /><br />
Password: <input type="PASSWORD" name="Password" /><br />
Actief:  <input type="text" name="Actief" /><br />
<input type="submit"  value="Register"/>

</form>

</body>
</html>
<?php
$host="localhost"; // Host name
$Username="root"; // Mysql username
$Password=""; // Mysql password
$db_name="dries"; // Database name
$tbl_name="beheer"; // Table name

// Connect to server and select databse.
$link = mysql_connect("$host", "$Username", "$Password") or die("cannot connect");
mysql_select_db("$db_name",$link) or die("cannot select DB");

// username and password sent from form
if (isset($_POST["Username"])) {
$myusername = $_POST["Username"];
}
if (isset($_POST["Password"])) {
$mypassword = $_POST["Password"];
}
if (isset($_POST["Actief"])) {
$myactief = $_POST["Actief"];
}
if (isset($_POST["Username"]) && isset($_POST["Password"]) && isset($_POST["Actief"]) ) {
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myactief = stripslashes($myactief);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$myactief = mysql_real_escape_string($myactief);
$sql="INSERT INTO $tbl_name (username,password,actief) values ('$myusername','$mypassword','$myactief')";
$result=mysql_query($sql,$link);
}

$result = mysql_query("SELECT * FROM $tbl_name", $link);
$num_rows = mysql_num_rows($result);

echo "<TABLE id= 'table'>";
echo "<TR>";
echo "<TH>ID<TH>";
echo "<TH>Username</TH>";
echo "<TH>Password</TH>";
echo "<TH>Actief</TH>"   ;
echo "</TR>";
$result = "SELECT * FROM $tbl_name";
$result1 = run_query($result);
while ($result3 = get_record($result1)) {
echo "<TR>";
echo "<TD>".$result3['id']."</TD>";
echo "<TD>".$result3['username']."</TD>" ;
echo "<TD>".$result3['password']."</TD>";
echo "<TD>".$result3['actief']."</TD>";
echo "</TR>";
}
echo "</TABLE>";

?>