-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_requestag.php
executable file
·56 lines (56 loc) · 2.87 KB
/
add_requestag.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
<?php
include_once 'db.php';
include 'adminheader.php';
$uid3=$_GET['uid2'];
$res=mysqli_query($conn,"select uid,name,email,phone,address,av_food from food_details where uid=".$uid3);
$userRow=mysqli_fetch_array($conn,$res);
if(isset($_POST['send_request']))
{
$uid=$_POST['uid'];
$agid=$_POST['agent_name'];
$uname = mysqli_real_escape_string($conn,$_POST['username']);
$email = mysqli_real_escape_string($conn,$_POST['email']);
$email = mysqli_real_escape_string($conn,$_POST['email']);
$phone=mysqli_real_escape_string($conn,$_POST['phone']);
$address=mysqli_real_escape_string($conn,$_POST['address']);
$food=mysqli_real_escape_string($conn,$_POST['food']);
$message=mysqli_real_escape_string($conn,$_POST['message']);
$sta="pending";
if(mysqli_query($conn,"INSERT INTO admin_request(uid,agid,name,email,phone,address,food,message,status) VALUES('$uid','$agid','$uname','$email','$phone','$address','$food','$message','$sta')"))
{
?>
<script>alert('successfully registered ');</script>
<?php
header("location:adminhome.php");
}
else
{
?>
<script>alert('error occur...');</script>
<?php
}
}
?>
<html>
<head>
<link href="style.css" rel="stylesheet">
<script type="text/javascript" src="js/jquery.js"></script>
</head>
<body>
<div id="divagsend">Send Request To Agent</div>
<div id="agform">
<form method="POST">
<?php $rs_new = mysqli_query($conn,"SELECT agid from add_agent");while($row1=mysqli_fetch_array($conn,$rs_new)) { ?>
<input type="hidden" name="agent_name" value="<?php echo $row1['agid'];?>"><?php } ?><br>
<input type="hidden" name="uid" value="<?php echo $userRow['uid'];?>"><br>
<label>Username </label><input type="text" name="username" value="<?php echo $userRow['name'];?>"><br><br>
<label>Email </label><input type="email" name="email" value="<?php echo $userRow['email'];?>"><br><br>
<label>Phone </label><input type="text" name="phone" value="<?php echo $userRow['phone'];?>"><br><br>
<label>Address </label><input type="text" name="address" value="<?php echo $userRow['address'];?>"><br><br>
<label>Food Quantity </label><input type="text" name="food" value="<?php echo $userRow['av_food'];?>"><br><br>
<label>Message </label><input type="text" name="message"><br><br>
<input type="hidden" name="status"></div>
<div id="agdiv"><input type="submit" name="send_request" Value="Send Request"></div>
</form>
</body>
</html>