-
Notifications
You must be signed in to change notification settings - Fork 0
/
registration.php
114 lines (91 loc) · 2.66 KB
/
registration.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
session_start();
$host = "localhost";
$user = "root";
$password = "";
$db = "farm";
$con = new mysqli('localhost', 'root', '', 'farm');
if (!$con) {
die(mysqli_error($con));
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Set form variables
$email = $_POST["email"];
$tel_number = $_POST["tel_number"];
$user = $_POST["user"];
if ($user == "farmer") {
$sql = "insert into registration ( Telephone_Number, Email, User_Type) values (
'$tel_number','$email', '$user')";
} else {
$sql = "insert into companies (Email,Telephone_Number,User_Type) values ('$email','$tel_number','$user') ";
}
$result = mysqli_query($con, $sql);
if ($result) {
$user_id = mysqli_insert_id($con);
$_SESSION['user_id'] = $user_id;
echo "Data inserted successfully";
if ($user == "farmer") {
header('location:farmereg.php');
} else {
header('location:companyreg.php');
}
} else {
die(mysqli_error($con));
}
}
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="navigation-bar">
<nav>
<ul id='MenuItems'>
<li><a href='website.html'>Home</a></li>
<li><a href='Agronomy Tips.php'>Agronomy Tips</a></li>
<li><a href='authentication.php'>Verify Seed</a></li>
<li><a href='Aboutus.html'>About Us</a></li>
<li><a href='contactus.html'>Contact Us</a></li>
</ul>
</nav>
</div>
<div class="main-content">
<div>
<center>
<span>
<div class="regcontainer">
<div class="header">
<h1> REGISTRATION DETAILS</h1>
</div>
<form class="reg_f" action="#" method="POST">
<label>Telephone number</label>
<input type="text" name="tel_number" required>
<br><br>
<label>Email</label>
<input type="text" name="email" required>
<br><br>
<label>Type of user </label>
<select name="user" id="user" required>
<option value="">Select User Type</option>
<option value="farmer">farmer</option>
<option value="company">company</option>
</select>
<br><br>
<button type="submit" value="submit" class="submitButton">Proceed</button>
<button type="reset">Clear</button>
<br>
</div>
</div>
</div>
</form>
</span>
</center>
<div class="main-footer">
<span>
Powered by Ndegwa 2022
</span>
</div>
</body>
</html>