Advertisement
hmeco

get some stuff and print it pretty

Nov 29th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.87 KB | None | 0 0
  1. function readContentFromSql(){
  2.  
  3.         $servername = "host";
  4.         $username = "bruger";
  5.         $password = "kode";
  6.         $dbname = "dbnavn";
  7.  
  8.  
  9.         //try to connect
  10.         $conn = new mysqli($servername, $username, $password, $dbname);
  11.         // Check connection
  12.         if ($conn->connect_error) {
  13.             die("Connection failed: " . $conn->connect_error);
  14.             return "Connection Status FAIL!";
  15.         }
  16.         else {
  17.  
  18.           $sql = "SELECT * FROM logBreakTimes";
  19.           $result = $conn->query($sql);
  20.  
  21.           if ($result->num_rows > 0) {
  22.               // output data of each row
  23.               echo "<table style='width:100%' float:center;>
  24.                <tr>
  25.                  <th>ID</th>
  26.                  <th>Date</th>
  27.                  <th>Time Break Started</th>
  28.                  <th>Time Break Ended</th>
  29.                  <th>Time Elapsed</th>
  30.                  <th>Internal Code</th>
  31.                  <th>Validator</th>
  32.                  <th>Details</th>
  33.                </tr>";
  34.               while($row = $result->fetch_assoc()) {
  35.                 echo "<center><tr>";
  36.                   echo "<td>".$row["ID"]."</td>";
  37.                   echo "<td>".$row["dateNow"]."</td>";
  38.                   echo "<td>".$row["timeStart"]."</td>";
  39.                   echo "<td>".$row["timeEnd"]."</td>";
  40.                   echo "<td>".$row["timeDiff"]."</td>";
  41.                   echo "<td>".$this->codeTranslator($row["internalCode"])."</td>";
  42.                   echo "<td>".$this->validate($row["dateNow"],$row["timeStart"],$row["timeEnd"],$row["hash"])."</td>";
  43.                   echo "<td><a href='tools/details.php?id=".$row["hash"]."'> More </a></td>";
  44.                 echo "</center></tr>";
  45.  
  46.               }
  47.           } else {
  48.               echo "No Records found in database";
  49.           }
  50.           $conn->close();
  51.         }
  52.  
  53.       }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement