phpDbmsProject/feedbacksql.php at master · djagathsingh/phpDbmsProject · GitHub

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
<?php
	session_start();
    if(isset($_POST['feedbacksubmit']))
	{	if(!empty($_POST['comments']))
		{
			$conn = new mysqli("localhost","root", "" , "project");
			if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
			}
			$sessData=$_SESSION['sessData'];
			$sql="select fid from farmer where email='{$sessData['email']}'";
			$result=$conn->query($sql);
			if($result->num_rows == 1 )
			{	$row=$result->fetch_assoc();
				$fid=$row['fid'];
			}
			else
			{	header("Location:feedback.php");
				$sessData['status']['type'] = 'error';
				$sessData['status']['msg'] = 'Some problem occurred, please try again.';
			}
			$sql="insert into feedback values('{$fid}','{$_POST['comments']}')";
			if($conn->query($sql) == TRUE )
			{	header("Location:feedback.php");
				$sessData['status']['type'] = 'success';
				$sessData['status']['msg'] = 'We appreciate your time!!';
			}
			else
			{	header("Location:feedback.php");
				$sessData['status']['type'] = 'error';
				$sessData['status']['msg'] = 'Some problem occurred, please try again.';
			}

		}
		else
		{
			header("Location:feedback.php");
			$sessData['status']['type'] = 'error';
			$sessData['status']['msg'] = 'Some problem occurred, please try again.';
		}
		$_SESSION['sessData']=$sessData;
    }

?>