forked from shashankkaran/goldenEagles_GrievancePanel
-
Notifications
You must be signed in to change notification settings - Fork 0
/
usermakecomp.php
50 lines (37 loc) · 1.05 KB
/
usermakecomp.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
<?php
// $fname=$_FILES["f2"]["name"];
// $uploaddir = './uploads/'.$fname;
// $target_file = $uploaddir . basename($_FILES["f2"]["name"]);
// $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
// move_uploaded_file($_FILES['f2']['tmp_name'],$uploaddir);
$cat=$_POST['category'];
$subcat=$_POST['subcategory'];
$nature=$_POST['nature'];
$comp=$_POST['comp'];
$date= date("F j, Y, g:i a");
$servername='localhost';
$username='root';
$password='';
$dbname='project';
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($conn)
{
$query1="SELECT * FROM `userlogininfo`";
$result=mysqli_query($conn,$query1);
if($result)
{
while($row=mysqli_fetch_assoc($result))
{
$user=$row['user'];
}
}
$pend='1';
$query2="INSERT INTO `complaints`(`user`, `category`, `subcategory`, `nature`, `comp`, `pending`, `date`) VALUES
('$user','$cat','$subcat','$nature','$comp','$pend','$date')";
$result=mysqli_query($conn,$query2);
if($result)
{
echo "<script>window.location.assign('afterlogin.php');</script>";
}
}
?>