Quiz/select.php at master · RishabhSinha02/Quiz · 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
<?php
error_reporting(E_ERROR | E_PARSE);
if ($_POST['email']) {
    $email = $_POST['email'];
//    View Modal content


echo '
<div class="row">

            <table class="table table-hover table-primary table-striped" id="mytable">
      <thead>
        <tr class="table-secondary">
          <th width= "40%" scope="col">
            <center>Email.</center>
          </th>
          <th scope="col">'.$email.'</th>
        </tr>
      </thead>
      </table>

    <table class="table table-hover table-primary table-striped" id="mytable">
      <thead>
        <tr class="table-success">
          <th width= "15%">
            <center>Sr. No</center>
          </th>
          <th width= "25%" scope="col">Title</th>
          <th scope="col">Description</th>
        </tr>
      </thead>
      <tbody>
        ';

        include "Partial/dpconnect.php";
        $sql = "SELECT * FROM `notes` WHERE `notes`.`email` = '$email'";
        $result = mysqli_query($conn, $sql);
        $sno = 0;
        while($row = mysqli_fetch_assoc($result)){
            $sno+=1;
            echo "<tr>
            <th scope='row'><center>$sno</center></th>
            <td>" . $row['title'] . "</td>
            <td>" . $row['description'] . "</td>
              </tr>";
            }

        echo '
      </tbody>
    </table>


';
}
?>