Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
9
Erster Beitrag:
vor 3 Jahren, 8 Monaten
Letzter Beitrag:
vor 3 Jahren, 8 Monaten
Beteiligte Autoren:
Yogi Yang, Ola, DerekT, Fabrice Harari, Gianni Spano, kingdr, Arie

WM 17 - How to Read and Write data to/from MySQL

Startbeitrag von Yogi Yang am 09.09.2014 05:30

I am asking this as I am still confused as to which way should I go for this particular situation.

I have never developed any serious Mobile Apps. I have to develop a mobile app that will have to read and write data to/from MySQL. Actually we have developed a web site in which user can enter data through web interface.

I have a need where in I have to show user performance Line Graph in Android based devices from the data that is entered through the web inteface.

How would this be possible in WM 17?

Are there any features that will allow us to access MySQL server from an Android app?

Or have we to go through a different route.

My dead line is 13 Sept 2014 so all help/ideas and practical suggestions are higly appreciated.

TIA

Yogi Yang

Antworten:

Hi

Looks like there's none except sqlLite (hNativeAccessSQLite) native driver/
(not sure,might be HFCS) in Android Apps.
I guess, WB/webApp is the only solutions so far.

Cheers

King

von kingdr - am 09.09.2014 06:46
Like the King said: there is no native access available in WM.
There is this 3-party stuff around for years called PHP4WM. But I never had the feeling it is very professional (excuses to the developer if I am wrong...)
Just Google PHP4WM
I found this one for instance http://helouardi.blogspot.nl/p/blog-page.html

You need an extra layer like a webpage or webservice or a simple socket-application. Your app connect to this middle-tier and this service itself handles the mysql-actions.
PC soft has a ready-to-use solution http://doc.windev.com/en-US/?1000021063
Never used it, so I cant tell you about pros/cons and if WM17 is supported.
Otherwise you must developt one yourself. Will cost you some significant time of course, but it's reuable in forthcoming project if you do it smart :xcool:

von Arie - am 09.09.2014 07:00
Hello Yogi

Take a look to this page. I have used it in the past creating a small c# application to connect to a mysql db using a wireless connection.

http://www.devart.com/dotconnect/mysql/

Hope in this help.

Gianni

von Gianni Spano - am 09.09.2014 08:49
Thanks everyone for helpful hints and tips.

I am experimenting with PHP4WD to see how it goes.

PC Soft's ready to use solution seems to be available for WX 19 and higher.

Regards,

Yogi Yang

von Yogi Yang - am 11.09.2014 13:45
Arie,

Thanks for pointingh me to PHP4WD. It worked after a bit of head banging.

BTW is there an English version of the modules and Class. It feel a bit awkward typing the MoveFirst (Premier), MoveNext (Suivant), etc. Or better still if there is any facility in WD to convert the code from its French version to English.

TIA

Yogi Yang

von Yogi Yang - am 25.09.2014 06:44
Hi

You are looking for the CODE/Language/Convert To function

Best regards

von Fabrice Harari - am 25.09.2014 10:16
Hi Yogi,

"Or better still if there is any facility in WD to convert the code from its French version to English."

Yes, there is. See the (old) main (text based) menu -> Code -> Code language -> Translate to English.

Maybe its also in the new graphical menu, but its such a mess that I don't find anything in it...:)

best regards
Ola

von Ola - am 25.09.2014 10:33
Ola

Open any code editor window.

Translate options are in the Language section under the Code tab.

von DerekT - am 25.09.2014 14:21
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.