Changes between Version 14 and Version 15 of Docs/825gen2/Dev/Networking/PHP

Timestamp:

02/29/24 11:36:52 (9 months ago)

Author:

Don Wilson

Comment:

--

Docs/825gen2/Dev/Networking/PHP

@@ -107 +107 @@
     padding: 0 15px;
   }
+  table td:nth-child(3) { text-align: left; }
 </style>
 </head>
@@ -118 +119 @@
   $result = $conn->query($sql);
   if($result->num_rows > 0) {
-    echo '<table><tr><th>Tran Num</th><th>date/time</th><th>Vehicle</th><th>Gross Wt</th><th>Tare Wt</th><th>Net Wt</th><th>Image</th><th>First pass</th></tr>';
+    echo '<table><tr><th>Tran Num</th><th>date/time</th><th>Vehicle<br/>Product<br/>Customer</th><th>Gross Wt</th><th>Tare Wt</th><th>Net Wt</th><th>Image</th><th>First pass</th></tr>';
     while($row = $result->fetch_assoc()) {
       $tkt_num = $row['tkt_num'];
       $datetime = $row['date'] . ' ' . $row['time'];
           $veh = $row['truck'];
+          $prod = $row['prod'];
+          $cust = $row['cust'];
+          $job = $row['job'];
       $gross = $row['gross'];
       $tare = $row['tare'];
       $net = $row['net'];
-      echo '<tr><td>' . $tkt_num . '</td><td>' . $datetime . '</td><td>' . $veh . '</td><td>' . $gross . '</td><td>' . $tare . '</td><td>'. $net  . '</td>';
+      echo '<tr><td>' . $tkt_num . '</td><td>' . $datetime . '</td><td>' . $veh . '<br/>' . $prod . '<br/>' . $cust . '</td><td>' . $gross . '</td><td>' . $tare . '</td><td>'. $net  . '</td>';
       $imgfile = sprintf("v%06d_1.jpg", $tkt_num);
       $img = 'images/' . $imgfile;