File name: join.php
Table name:
1.tree
2.user
This is my code:
<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');
$userid = $_SESSION['userid'];
?>
<?php
//User cliced on join
if(isset($_GET['join_user'])){
$side='';
$pin = mysqli_real_escape_string($con,$_GET['pin']);
$email = mysqli_real_escape_string($con,$_GET['email']);
$mobile = mysqli_real_escape_string($con,$_GET['mobile']);
$address = mysqli_real_escape_string($con,$_GET['address']);
$account = mysqli_real_escape_string($con,$_GET['account']);
$under_userid = mysqli_real_escape_string($con,$_GET['under_userid']);
$side = mysqli_real_escape_string($con,$_GET['side']);
$password = "123456";
$flag = 0;
if($pin!='' && $email!='' && $mobile!='' && $address!='' && $account!='' && $under_userid!='' && $side!=''){
//User filled all the fields.
if(pin_check($pin)){
//Pin is ok
if(email_check($email)){
//Email is ok
if(!email_check($under_userid)){
//Under userid is ok
if(side_check($under_userid,$side)){
//Side check
$flag=1;
}
else{
echo '<script>alert("The side you selected is not availble.");</script>';
}
}
else{
//check under userid
echo '<script>alert("Invalid Under userid.");</script>';
}
}
else{
//check email
echo '<script>alert("This user id already availble.");</script>';
}
}
else{
//check pin
echo '<script>alert("Invalid pin");</script>';
}
}
else{
//check all fields are fill
echo '<script>alert("Please fill all the fields");</script>';
}
//Now we are heree
//It means all the information is correct
//Now we will save all the information
if($flag==1){
$query = mysqli_query($con,"insert into user('email','password','mobile','address','account') values('$email','$password','$mobile','$address','$account')");
echo '<script>alert("Testing Success.");</script>';
}
}
?><!--/join user-->
<?php
//functions
function pin_check($pin){
global $con,$userid;
$query =mysqli_query($con,"select * from pin_list where pin='$pin' and userid='$userid'");
if(mysqli_num_rows($query)>0){
return true;
}
else{
return false;
}
}
function email_check($email){
global $con;
$query =mysqli_query($con,"select * from user where email='$email'");
if(mysqli_num_rows($query)>0){
return false;
}
else{
return true;
}
}
function side_check($email,$side){
global $con;
$query =mysqli_query($con,"select * from tree where userid='$email'");
$result = mysqli_fetch_array($query);
$side_value = $result[$side];
if($side_value==''){
return true;
}
else{
return false;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Mlml Website - Join</title>
<!-- Bootstrap Core CSS -->
<link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<!-- MetisMenu CSS -->
<link href="vendor/metisMenu/metisMenu.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="dist/css/sb-admin-2.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="wrapper">
<!-- Navigation -->
<?php include('php-includes/menu.php'); ?>
<!-- Page Content -->
<div id="page-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Join</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-4">
<form method="get">
<div class="form-group">
<label>Pin</label>
<input type="text" name="pin" class="form-control" required>
</div>
<div class="form-group">
<label>Email</label>
<input type="email" name="email" class="form-control" required>
</div>
<div class="form-group">
<label>Mobile</label>
<input type="text" name="mobile" class="form-control" required>
</div>
<div class="form-group">
<label>Address</label>
<input type="text" name="address" class="form-control" required>
</div>
<div class="form-group">
<label>Account</label>
<input type="text" name="account" class="form-control" required>
</div>
<div class="form-group">
<label>Under Userid</label>
<input type="text" name="under_userid" class="form-control" required>
</div>
<div class="form-group">
<label>Side</label><br>
<input type="radio" name="side" value="left"> Left
<input type="radio" name="side" value="right"> Right
</div>
<div class="form-group">
<input type="submit" name="join_user" class="btn btn-primary" value="Join">
</div>
</form>
</div>
</div><!--/.row-->
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
<script src="vendor/jquery/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="vendor/bootstrap/js/bootstrap.min.js"></script>
<!-- Metis Menu Plugin JavaScript -->
<script src="vendor/metisMenu/metisMenu.min.js"></script>
<!-- Custom Theme JavaScript -->
<script src="dist/js/sb-admin-2.js"></script>
</body>
</html>