I'm trying to insert data from registration form to database but when I click register I don't see anything in my database.
I really need to fix this so that I'll be able to insert into my database. I can't really figure out where the problem is from. Thanks a lot for your contribution.
This is my code help me out. Please help me out.
<?php
session_start();
$server = 'localhost';
$users = 'root';
$pass = '';
$dataBase = 'accounts';
$_SESSION['message'] = '';
$mysqli = new mysqli($server, $users, $pass, $dataBase) or die("Not connected");
if($mysqli){
echo 'Connected Successfully';
}
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
//The two passwords are equal to each other
if($_POST['Password'] == $_POST['ConfirmPassword']){
$username = $mysqli->real_escape_string($_POST["username"]);
$email = $mysqli->real_escape_string($_POST['email']);
$password = md5($_POST['Password']); //hash password security
$phone = $mysqli->real_escape_string($_POST['Number']);
$_SESSION['username'] = $username;
$sql = "INSERT INTO user (username, email, password, phone) VALUES ('$username','$email','$password','$phone')";
//if the query is correct, then redirect to a welcome.php page. done!
if($mysqli->query($sql) === true){
$_SESSION['message'] = "Registration successful! $username is now a member";
header("location: login.php");
echo 'Successfully Registered!';
}
else{
$_SESSION['message'] == "Sorry you are not registered, check your field";
}
}
else{
$_SESSION['message'] == "Passwords do not match!";
}
}
?>
<body class="bg agileinfo">
<h1 class="agile_head text-center" style="color:#000"> Welcome</h1>
<div class="w3layouts_main wrap">
<!--Horizontal Tab-->
<div id="parentHorizontalTab_agile">
<ul class="resp-tabs-list hor_1">
<!-- <li>LogIn</li> -->
<li>SignUp</li>
</ul>
<div class="agile_its_registration">
<form action="#" method="post" class="agile_form">
<div class="alert alert-error"><?=$_SESSION['message'] ?></div>
<p>Username</p>
<input type="text" name="username" required="required" />
<p>Email</p>
<input type="email" name="email" required="required" />
<p>Phone Number</p>
<input type="text" name="Number" required="required" />
<p>Password</p>
<input type="password" name="Password" required="required" id="Password">
<p>Confirm Password</p>
<input type="password" name="ConfirmPassword" required="required" id="ConfirmPassword">
<div class="check w3_agileits">
<label class="checkbox w3"><input type="checkbox" name="checkbox" required="required" ><i> </i>I accept the terms and conditions</label>
</div>
<input type="submit" value="Signup"/>
<input type="reset" value="Reset" />
</form>
</div>
</div>
</div>
</body>