CRM-System/complaint_solved.php at main · Tanu-Shree22/CRM-System · 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
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
<!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.0">
    <title>Answered Complaints</title>
    <link href="css/ans_comp.css" type="text/css" rel="stylesheet">
</head>
<body>
    <h1><u>Answered Complaints</u></h1>

    <header>
    <nav class="navbar">
        <ul>
        <li><a href="logout.php"> <button class="logbtn">Log out</button></a></li>
            <!-- <li><a href="#">About</a></li> -->
            <li><a href="FAQs Page(customers).php">FAQs</a></li>
            <li><a href="profiles.php">Customer Profiles</a></li>
            <li><a href="reports.php">Reports</a></li>
            <li><a href="complaints.php"class="active"> Complaints</a></li>
            <li><a href="data.php"> Customer Data</a></li>
            <li><a href="target_data.php"> Target customers</a></li>
            <li><a href="emp_offer.php">Offers</a></li>
            <li><a href="employee page.php" >Home </a></li>
            <img src="img/crm-icon-png.png" alt="logo">
        </ul>
    </nav>
   </header>
    <input id="searchbar" onkeyup="search_animal()" type="text"
        name="search" placeholder="Search.....">
    <br>
    <table class="container">

   <tr>
       <th>Customer Id</th>
       <th>Date</th>
       <th>E-mail</th>
       <th>Full Name</th>
       <th>Phone No.</th>
       <th>Concern</th>
       <th>Action</th>
   </tr>
   <?php
	require_once "config.php";
    error_reporting(0);
	$sql = "SELECT * FROM complaints where status = 1";
		$result = mysqli_query($conn, $sql);
		if (mysqli_num_rows($result) > 0) {
			while ($row = mysqli_fetch_assoc($result)) {
                // $id = $id + 1;

        echo"<tr class='element'><td>" .  $row['id'] . "</td>
       <td>" . $row['date'] . "</td>
       <td>" . $row['email_id'] . "</td>
       <td>" .  $row['full_name'] . "</td> <td>" . $row['phone'] . "</td><td>" .   $row['concern'] . "</td>


     <td>
     <a onClick=\"javascript: return confirm('Are you sure to delete this record?');\"href='complaint_delete.php?id=" .$row['id']. "'> <button class='delete'>Delete </button></a>
       </td>
    </tr>";


    }}
 else{
	// echo "something went wrong.";
}


?>

<script>

        </script>
 <script src="js/search.js"></script>

 </table>
</body>
</html>