= PHP = The 825 Gen2 includes PHP https://en.wikipedia.org/wiki/PHP which combined with the Apache Web Server allows for powerful web features. From a terminal **php -v** will show the PHP version. {{{ card825gen2:~$ php -v PHP 8.1.10 (cli) (built: Aug 30 2022 16:09:36) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.10, Copyright (c) Zend Technologies }}} Accessing MySQL database from php: Make sure MySQL is configured first. Refer to the [wiki:Docs/825gen2/Dev/Database/MySQL MySQL] page MySQL (MariaDB) Create a simple test php file to read from the database {{{ cd /usr/share/apache2/default-site/htdocs nano readmysql.php }}} {{{#!php 825 MySQL Test query($sql); if($result->num_rows > 0) { echo ''; while($row = $result->fetch_assoc()) { $title = $row['title']; $description = $row['description']; echo ''; } echo '
TitleDescription
' . $title . '' . $description . '
'; } } ?> }}} Test with PC on same network as 825. [[Image(825webpagephp.png)]] 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. {{{ card825gen2:/usr/share/apache2/default-site/htdocs$ cat testsqlite.php }}} {{{#!php 825 SQLite Test query('SELECT truck_name,tare FROM trucks'); echo ''; while ($row = $results->fetchArray()) { $truckid = $row['truck_name']; $tare = $row['tare']; echo ''; } echo '
Truck IDTare
' . $truckid . '' . $tare . '
'; ?> }}} [[Image(825webphpsqlite.png)]] Following is a more advanced demo. This reads from an ID storage MySQL transaction table and also displays vehicle images associated with transactions. ids.php {{{#!php 825 ID Storage query($sql); if($result->num_rows > 0) { echo ''; 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 ''; $imgfile = sprintf("v%06d_1.jpg", $tkt_num); $img = 'images/' . $imgfile; if(file_exists($img)) { echo ''; } else { echo ''; } $imgfile = sprintf("v%06da_1.jpg", $tkt_num); $img = 'images/' . $imgfile; if(file_exists($img)) { echo ''; } else { echo ''; } echo ''; } echo '
Tran Numdate/timeVehicle
Product
Customer		Gross WtTare WtNet WtImageFirst pass
' . $tkt_num . '' . $datetime . '' . $veh . '
' . $prod . '
' . $cust . '		' . $gross . '' . $tare . ''. $net . '
'; } } ?> }}} [[Image(825webpage_ids_captured_images.png)]] This example report has date range selections and produces a material summary or detail: {{{#!php Product Detail'; } else { echo 'Product Summary'; } ?> 'today', 'name' => 'Today'], ['id' => 'tweek', 'name' => 'This week'], ['id' => 'tmonth', 'name' => 'This month'], ['id' => 'tyear', 'name' => 'This year'], ['id' => 'lweek', 'name' => 'Last week'], ['id' => 'lmonth', 'name' => 'Last month'], ['id' => 'lyear', 'name' => 'Last year'], ['id' => 'custom', 'name' => 'Custom'], ]; $types = [ ['id' => 'sum', 'name' => 'Summary'], ['id' => 'det', 'name' => 'Detail'], ]; $jsonFile = '/mnt/nand/apps/ids/db.json'; $jsonContent = file_get_contents($jsonFile); $data = json_decode($jsonContent, true); if (!$data) { echo "ID Storage database not configured"; } else { if ($data['dbtype'] != 'mysql') { echo "ID Storage database type must by MySQL for reporting"; } else { $range = $_GET['range']; if(!$range) { $range = "today"; } echo '
'; echo ''; echo ''; $dateFrom = $_GET['from']; $dateTo = $_GET['to']; if($range != "custom") { echo '