connect to mysql server from device

[encolo]

I need to connect with mysql server from a device emulator.

I tried the Mysql library, but it not work on the device, only on the desktop

Regards
Enrico

 

[Erel]

You can create a simple web service (with PHP for example) that will run on the server and will handle the devices queries, which will be issued with the HTTP library.

 

[laura]

Erel!!!!!!

do you have an example with php?

 

[Erel]

Search (outside) for "php mysql tutorial".
The php code should read the "get" (or "post") parameters, issue the queries accordingly and print the response.

This code returns an array with the "get" parameters:
$_GET and $_POST are special arrays that holds the get and post parameters.

 

[laura]

:sign0013:
Erel!!!

I would like yto know how can I use XML
i saw Syntax: Table1.SaveXML (File Name) and Syntax: LoadXML (File Name)
and I was trying... but I really don't know.... I'm new:sign0148:
can you help me?
do you have an example?

 

[mjcoon]

I would like yto know how can I use XML
i saw Syntax: Table1.SaveXML (File Name) and Syntax: LoadXML (File Name)
and I was trying...

These are just for saving and restoring tables and people have had problems with them; see http://www.b4x.com/forum/questions-help-needed/3337-table-colwdith-doesnt-work-device.html#post18863.

If you have already tried perhaps you would like to attach your code to a message and someone will have a look at it. It's easier than you trying to explain what you wish to do or someone trying to expain all about XML...

Mike.