Page 3 of 3
Re: open a database
Posted: Fri Jan 31, 2025 3:29 pm
by plouf
Im the manual there is examples
Check bottom of the manual has two examples
https://www.spiderbasic.com/documentati ... index.html
Re: open a database
Posted: Fri Jan 31, 2025 4:12 pm
by Caronte3D
nad wrote: Fri Jan 31, 2025 3:07 pm
Is there an example of opening a SQLite db and acessing it? This is my first try at using SpiderBasic. To accomplish access to the DB, I wrote a program in PHP to access the SQLite DB. In SpiderBasic I send a request request = HTTPRequest(#PB_HTTP_Get, "
http://localhost/person_api.php?personNum=" + Str(personNum)). I hope this is the wrong way to do? Is there an example somewhere where it uses spiderBasic instead of this work around?
This is the *only* way to open a remote SQL DB with SpiderBasic.
Also... it's not a workaround, it's how the client/server works, but if you only need to use a local DB, better use PureBasic and you can do everything.
Re: open a database
Posted: Wed Feb 05, 2025 3:02 pm
by bmld76
Hello,
It is what I do to access to Mysql database.I use it for a client and it works fine. I write an exemple with pure basic and spider in this post :
https://www.purebasic.fr/french/viewtop ... 43#p218443