open a database

Just starting out? Need help? Post your questions and find answers here.
plouf
Posts: 295
Joined: Tue Feb 25, 2014 6:01 pm
Location: Athens,Greece

Re: open a database

Post by plouf »

Im the manual there is examples

Check bottom of the manual has two examples
https://www.spiderbasic.com/documentati ... index.html
Christos
User avatar
Caronte3D
Posts: 187
Joined: Sat Nov 23, 2019 5:21 pm
Location: Some Universe

Re: open a database

Post 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.
bmld76
Posts: 27
Joined: Wed May 24, 2023 5:10 pm

Re: open a database

Post 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
Post Reply