USE Ubuntu
sqlite3 -header -csv /Library/WebServer/Documents/forsale.db "select * from forsale;" > /Library/WebServer/Documents/forsale.csv
exec("/Library/WebServer/Documents/querry.sql");
$db->close();
?>
One Database For all goods
Search via Category for Plants, Electronics...
create search.php for each category
forsale.db
feed list from db into querry
Sqlite to text
PHP dump to CSV is in forsale.csv
and works with insert.php script. which is driven by insert.html
file:///Library/WebServer/Documents/php_csv_sqlite.html
sqlite3 siir_05.db "SELECT AField FROM siir;" > ATextFile.txt\
use sql scriipt
Use DB Browser to Import
PHP Sqlite ADMIN has Graph Function
Script to Ouput data from Databases
Inventory System
Filemaker
Sqlite
https://www.freecodecamp.org/news/making-an-awesome-inventory-management-application-in-php-and-mysql-from-start-to-finish-90bc5996680a/
CRUD System Add Update Function From Here
Displaying Data in Html Tables
IOS
Android
Graphs Python
Python Charts II
To export from
Filemaker Convert to WIN format in Textwrangler.
Set Value of Input field
Image In database example
<img src="https://i.giphy.com/media/FgJ6FbfJGwztK/200w_s.gif" width="237" height="251"> a
- Seeds Germination
- 3d Printing Settings
- Zip Code Lookup
- Shipping Calc
- Venues Database
- Musicians Database
- Medical Databases
- Plants Database
- For Sale Database with Pictures