mySQL & QB64

[AtomicSlaughter]

OK, so i have been experimenting with mySQL and QB64 under Linux (Ubuntu 20.04) and here is what i have discovered.

Using Pipecom by SpriggsySpriggs, I have been able to impliment a rudimentary mySQL interface

Here is the code for creating and adding to the database

Code: QB64: [Select]

1. Shell "echo 'CREATE DATABASE epos' | mysql -uroot"
2. Shell "echo 'CREATE TABLE plu (item CHAR(20), price CHAR(20), grp CHAR(20), tax CHAR(20), kit CHAR(20))' | mysql -uroot epos"
3.  
4. Do
5.     Input "item>   ", item$
6.     Input "price>  ", price$
7.     Input "group>  ", grp$
8.     Input "tax>    ", tax$
9.     Input "kitchen ", kit$
10.     Print ""
11.     Shell "echo " + Chr$(34) + "INSERT INTO plu (item, price, grp, tax, kit) VALUES ('" + item$ + "', " + price$ + ", " + grp$ + ", " + tax$ + ", " + kit$ + ")" + Chr$(34) + " | mysql -uroot epos"
12.  
13. Loop
14.  
15. '$INCLUDE:'pipecom.bas'

And here is the code for reading the data back

Code: QB64: [Select]

1. Do
2.     price_search
3. Loop
4.  
5. Sub price_search
6.     Cls
7.     Print "price search"
8.     Input "Enter item Name >", q$
9.     query$ = pipecom_lite("echo " + Chr$(34) + "SELECT price FROM plu WHERE item = '" + q$ + "'" + Chr$(34) + " | mysql -uroot epos -s")
10.     Print "the price of " + q$ + " is " + query$
11.     q$ = ""
12.     query$ = ""
13.     _Delay 2
14. End Sub
15.  
16. '$INCLUDE:'pipecom.bas'

Not sure if this is useful to anyone but here it is anyway

[zaadstra]

Interesting!  I'll save this for a future use or idea, thanks!