Context Navigation

Changes between Version 4 and Version 5 of Docs/825gen2/Dev/Networking/PHP

-              v4
+              v5
 It may also be helpful to use browser "Developer tools" selection to view the generated html code.
+[[Image(825webdevtools.png)]]
+PHP can also be used to read SQLite databases.
+{{{
+root@imx8mq-var-dart:/usr/share/apache2/default-site/htdocs# cat testsqlite.php
+<!DOCTYPE html>
+<html lang="en">
+<head>
+  <title>825 SQLite Test</title>
+</head>
+<body>
+<?php
+$db = new SQLite3('/mnt/nand/apps/ids/ids.db3');
+$results = $db->query('SELECT truck_name,tare FROM trucks');
+echo '<table><tr><th>Truck ID</th><th>Tare</th></tr>';
+while ($row = $results->fetchArray()) {
+   $truckid = $row['truck_name'];
+   $tare = $row['tare'];
+   echo '<tr><td>' . $truckid . '</td><td>' . $tare . '</td></tr>';
+}
+echo '</table>';
+?>
+</body>
+</html>
+}}}