![Smile :)](./images/smilies/icon_e_smile.gif)
Is there a sample to send queries to a MySQL database maintained in a web server? Please help.
Moderator: Rathinagiri
My own code is not good to teach about this since, it handles tables with lots of fields and other complications, but, you can found useful simple code here:rathinagiri wrote:Yes. This we have already discussed.
Is there a sample to send queries to a MySQL database maintained in a web server? Please help.
And, if you don't have access to a 'real' server, you can install EasyPHP (preconfigured apache php and mysql) and test locally.Roberto Lopez wrote: more specifically:
http://www.freewebmasterhelp.com/tutorials/phpmysql/4
Regards,
The basic php samples that I've linked to in the previous message, send back to the browser a new html page that will be loaded automatically.rathinagiri wrote:Thanks for throwing some light on the subject Roberto.
I can now create a html file by sending a query. Now, how to get the data in a grid/array (xBase) format? Should we convert from that html file?
I've been working on this for the last two days and I already have a working mode, but, without an xbase interface yet.apais wrote:Hola Roberto...
I'm wondering if you are considering the js->json->php->json->js chain for communications exchange.
Another one: will you use arrays as recordsets or build a specific object for that ?
Also: Sqlite would be a non-need-to-setup database for preliminar tests and proof of concept don't you think ?
Just trying to shed some light into the project
Regards
Angel