phpwriting/orders.php at master · brianmugweru/phpwriting · 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
<?php
  $pagetitle = "All orders";
  $page = "orders";
  $menu = "orders";
  include("portal.php");
  function dashboard(){
    global $db;
    $sql = mysqli_query($db, "SELECT * FROM jobs");
    if(!$sql){
      echo "could not pick up any data from the database";
    }
?>
<table>
<tr>
<th>topic</th>
<th>type</th>
<th>subject</th>
<th>pages</th>
<th>deadline</th>
<th>language</th>
<th>upload date</th>
<th>deadline</th>
<th>client</th>
</tr>
<?php
  if(mysqli_num_rows($sql) > 0){
    while($row = mysqli_fetch_assoc($sql)){
?>
<tr>
      <td><?php echo $row["topic"];?></td>
      <td><?php echo $row["type"];?></td>
      <td><?php echo $row["subject"];?></td>
      <td><?php echo $row["pages"];?></td>
      <td><?php echo $row["ownership"];?></td>
      <td><?php echo $row["language"];?></td>
      <td><?php echo $row["upload_date"];?></td>
      <td><?php echo $row["deadline"]; ?></td>
      <td><?php echo $row["ownership"]; ?></td>
</tr>
<?php
    }
  }
  }
?>
</table>