CS3083/table.php at main · baraql/CS3083 · 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
<?php
include 'connect.php';
?>


<!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>How to Style HTML Tables with CSS</title>
    <link rel="stylesheet" href="styleTable.css">
</head>
<body>
    <table class="content-table">
        <thead>
          <tr>
            <th>ID</th>
            <th>First Name</th>
            <th>Last Name</th>
            <th>Street</th>
            <th>City</th>
            <th>State</th>
            <th>Zip</th>
            <th>Phone</th>

          </tr>
        </thead>
        <tbody>


        <?php
        $sql = "SELECT * FROM `criminals`";
        $result = mysqli_query($con, $sql);

        if ($result) {
            while ($row = mysqli_fetch_assoc($result)) {
                $id = $row['criminal_ID'];
                $fname = $row['criminal_name_first'];
                $lname = $row['criminal_name_last'];
                $street = $row['criminal_street'];
                $city  = $row['criminal_city'];
                $state  = $row['criminal_state'];
                $zip  = $row['criminal_zip'];
                $phone  = $row['criminal_phone'];

                echo '<tr>
                    <th scope="row">'.$id.'</th>
                    <td>'.$fname.'</td>
                    <td>'.$lname.'</td>
                    <td>'.$street.'</td>
                    <td>'.$city.'</td>
                    <td>'.$state.'</td>
                    <td>'.$zip.'</td>
                    <td>'.$phone.'</td>
                </tr>';
            }
        }
    ?>


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