= 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 '
';
}
}
?>
}}}
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 '
';
?>
}}}
[[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 '