<html>
<head>
<title>Adding User</title>
</head>
<body>
<h2>Adding users to mysql database.</h2>
<form action="insertformhandler.php" method="post">
Select gender:
<select name="gender">
<option value="male">man</option>
<option value="female">woman</option>
</select><br />
Fill user name:
<input name="username" type="text" size="20"/> <br />
Fill user age:
<input name="age" type="text" size="3"/> <br />
Fill user info:
<input name="info" type="text" size="60"/> <br />
<input name="submit" type="submit" value="Add"/>
</form>
</body>
</html>
<html>
<head>
<title>User adding</title>
</head>
<body>
<h2>adding new user.</h2>
<?php
$username = $_POST['username'];
$gender = $_POST['gender'];
$age = $_POST['age'];
$info = $_POST['info'];
if(!$username and !$gender and !$age and !$info){
echo "Error: There is no data passed.";
exit;
}
if(!$username or !$gender or !$age or !$info){
echo "Error: Some data did not be passed.";
exit;
}
if(!get_magic_quotes_gpc()){
$username = addslashes($username);
$gender = addslashes($gender);
$age = addslashes($age);
$info = addslashes($info);
}
@ $db = mysqli_connect('localhost','root','12345678');
mysqli_select_db($db,'testphp');
if(mysqli_connect_errno()){
echo "Error: Could not connect to mysql database.";
exit;
}
$q = "INSERT INTO user( id,name, age, gender, info) VALUES (2,'$username',$age,'$gender', '$info')";
if( !mysqli_query($db,$q)){
echo "no new user has been added to database.";
}else{
echo "New user has been added to database.";
};
mysqli_close($db);
?>
</body>
</html>