I am sorry to disturb you all. I am newbie and trying to learn php on my own. Maybe I can use my app at my class for assignment submission.
The problem is:
My registration page works well and doesn't return any error. However, it doesn't save to database.
Here is my code:
<html>
<head>
<title>Welcome to My Writing Center</title>
</head>
<body>
<h2>Here you can register to submit your essays</h2>
<a href="index.php">Click here to go back to home page</a><br/><br/>
<form action="sregister.php" method="POST">
Username: <input type="text" name="username" required="required" /> <br/>
Password: <input type="password" name="password" required="required" /> <br/>
First Name: <input type="text" name="firstName" required="required" /> <br/>
Last Name: <input type="text" name="lastName" required="required" /> <br/>
E-mail address: <input type="email" name="email" required="required" /> <br/>
Address: <input type="text" name="address" /> <br/>
<input type="submit" value="Register"/>
</form>
</body>
</html>
<?php
$db_name="writingcenter"; // Database name
$table_users="users"; // Table name
$dbc = mysqli_connect("localhost", "root", "", $db_name);
if($_SERVER["REQUEST_METHOD"]== "POST"){
$username = mysqli_real_escape_string($dbc,$_POST["username"]);
$password = mysqli_real_escape_string($dbc,$_POST["password"]);
$firstName = mysqli_real_escape_string($dbc,$_POST["firstName"]);
$lastName = mysqli_real_escape_string($dbc,$_POST["lastName"]);
$email = mysqli_real_escape_string($dbc,$_POST["email"]);
$address = mysqli_real_escape_string($dbc,$_POST["address"]);
$bool = true;
mysqli_connect("localhost", "root") or die(mysql_error()); //Connect to Server
mysqli_select_db($dbc,$db_name) or die("Cannot connect to DB"); //connect to db
$query = mysqli_query($dbc,"SELECT * FROM users");
while($row = mysqli_fetch_array($query))
{
$table_users = $row["username"];
if($username == $table_users)
{
$bool = false;
Print "<script>alert('User name has already been takens!');</script>";
Print "<script>window.location.assign('sregister.php');</script>";
}
$table_users = $row["email"];
if($email == $table_users)
{
$bool = false;
Print "<script>alert('This email address has already been registered. Please log in using your email address!');</script>";
Print "<script>window.location.assign('sregister.php');</script>";
}
}
if($bool)
{
mysqli_query($dbc,"INSERT INTO `users`(`username`, `password`, `firstName`, `lastName`, `email`, `address`) VALUES ($username, $password, $firstName, $lastName, $email, $address)");
Print "<script>alert('User successfully registered.');</script>";
Print "<script>window.location.assign('login.php');</script>";
}
}
?>
Could you please help me to find out where I am doing wrong?
Thanks for your help!
Best,
