PHP Signup Script
0 98958
PHP Signup Script: Here, let us learn the code for creating PHP signup script for new user signup, connecting form with a database, how validation is implemented on all mandatory fields including email and phone no field and how to check the user existence after submitting the form with the valid code.
dbconnect.php
<?php $session_start(); global $db; $GLOBALS['db'] = mysqli_connect('localhost','root', '', 'students'); ?>
sign-up.php
<?php
include('dbconnect.php');
if(isset($_POST['submit']))
{
$msg= user_signup($_POST);
}
?>
<html>
<head> </head>
<body>
<section class="bg-grey">
<div class="main">
<div class="container">
<div class="col-md-12">
<div class="form-content-box">
<div class="login-header">
<h3 class="text-center"> Sign Up </h3>
</div>
<div class="Details">
<form action="" method="post">
<div class="form-group">
<input type="text" class="form-control" name="name" placeholder="Full Name" required>
</div>
<div class="form-group">
<input type="email" name="email" class="form-control" placeholder="Email Address" required>
</div>
<div class="form-group">
<input type="text" class="form-control" name="phone" placeholder="Mobile" pattern="(\+?\d[- .]*){10,10}" oninput="this.value = this.value.replace(/[^0-9.]/g, ''); this.value = this.value.replace(/(\..*)\./g, '$1');" title="Please Enter Your 10 digit vaild number!" required>
</div>
<div class="form-group">
<input type="password" name="password" class="form-control" placeholder="Password" required>
</div>
<div class="form-group text-center">
<button type="submit" name="submit" class="btn btn-submit">Signup</button>
</div>
</form>
</div>
<div class="login-footer">
</div>
</div>
</div>
</div>
</div>
<section>
<div class="clearfix"></div>
</body>
</html>
<?php
function user_signup($data){
$name = mysqli_real_escape_string($GLOBALS['db'],$data['name']);
$email = mysqli_real_escape_string($GLOBALS['db'],$data['email']);
$phone = mysqli_real_escape_string($GLOBALS['db'],$data['phone']);
$pass = mysqli_real_escape_string($GLOBALS['db'],md5($data['password']));
$qry=mysqli_query($GLOBALS['db'],"select * from users where (email='$email' || phone='$phone') ");
if($qry->num_rows >0)
{
echo "<script>alert('Email Id or Phone Number already exists.')</script>";
}
else
{
$sql="INSERT INTO users(name,email,phone,password) VALUES('$name','$email','$phone','$pass')";
$query=mysqli_query($GLOBALS['db'],$sql) or die("Error 2".mysqli_error($GLOBALS['db']));
if($query)
{
$sms_msg = "Thank You for registering with us.<br>Regards,<br>onTime Infotech,<br>https://www.ontimeinfotech.com/";
echo "<script>alert('Congratulations!! Registration has been done successfully.')</script>";
echo '<script>window.location.href="login.php";</script>';
}
}
}
?>
Below are the screenshot for signup form:
If user email id/phone number already exists:
If user does not exists already:
Share:
Comments
Waiting for your comments