jQuery Forum

No, PHP doesn't run on Phonegap. Maybe you should read the PhoneGap documentation?

Phonegap is just a native app that embeds a web browser in the app. Web browsers can run Javascript code. Not PHP. PHP is run only on servers.

It might be possible to create some native framework that DOES run PHP, but I don't know of any. I use Rhodes, which is a native framework that embeds both a a web browser and an internal server that runs Ruby scripts. Something similar might be done with PHP.

Well in the PhoneGap documentation is nothing ...
I dont know how "Rhodes" works and i dont know how to install PHP on the device.
Some ideas? How I can get my data from the external SQL database?

Right.

What I'm saying is that if you'd bothered to read the Phonegap documentation, you'd know that PhoneGap doesn't run PHP scripts.

Now you have, and you have the same answer. ;)

I don't know if any framework that runs PHP on the device. But I opted that there might be one that I don't know about, and so it might be fruitful for you to search for one.

Rhodes won't help you, as it runs Ruby, not PHP. I offered it just as an example of a framework that lets you run a popular server-side language on the device. Thus, maybe somebody has done something similar with PHP.

Do you want to get data online from your SQL database? Then write a web service (probably using PHP, since that is what you are familiar with).

Or, as you stated earlier, do you want to put the database on your phone?

You can do this in PhoneGap, you just can't write your code in PHP - you have to write it in Javascript.

Well the database is on a webserver.

Is there a way to get the database local on that phone? Like synchronize it from the web to my local database?
Could that update every "appstart" because the database will get updated ...

Thx so far,
 Chris

Yes, you can get the database local on the phone. But it won't be a MySQL database. It will be SQLite. PhoneGap provides this, see the PhoneGap documentation.

You will still need to write a web service to allow the data to be retrieved from your server database. You can either retrieve from the web service as needed, or synchronize at start-up.

Hello Christian

as i understood phonegaps docu, you could use php as on your project for classes and methods.
But for creating the app itself you are setting up html files like a pure and basic website.
Inside that website you can fetch your dynamic generated data from mysql through ajax / javascript and php.

So the way would be: html website with ajax request on a php class/method to fetch data. The method within the class gets the data from mysql and returns it.

Hope i was right... i was in same situation as you :)

Hoffe das hilft.

Hey Phoenixh,

do you have an example with the ajax and php/mysql query?

(Hast du ein Beispiel / Beispielcode wie du aus der Datenbank rausliest und dann in Kombination mit Ajax das auf einer JQueryMobile / Phonegap App Seite ausgibst? Bin noch nicht ganz so fit in der Geschichte.)

Thx,
 Chris

Hello there,

i didnt setup a project like that but what you need is:

• Database
• PHP Class News (with method get() - as an example)
• jQuery function to fetch the data from the method get() in Class News
  http://api.jquery.com/jQuery.get/

Hmm that does not work...

Could I sync the mysql database with a local database?
And then get my content from the local one? Well I created a local database but still dont know how to get the mysql data into that local database :D
There are some toturials but they are all with so different libarys / programms... is ther no Phonegap / Cordova solution? I dont want to install 5-10 external Libarys or something like that. Is there no simple easy toturial?
The thing is, i know what i need but dont know how to program that!
I need one Database online, one on my device only using Phonegap / Cordova. (For multi devices) And pipe that casts (Select Array from the mysql database) to the local sqlite database like phoenixh sayed.

Thx for your help, i need weekend,... now!
:-)

I created a local database but still dont know how to get the mysql data into that local database

You need to write a web service that will access the mySQL database and expose it using, for example, a REST interface, and so can be used to download the data from the database. You can write your web service in any language/framework you would like. i.e. PHP, Ruby/Rails, Ruby/Sinatra, Java, node.js, etc. etc. etc.

You can first test your web service using any browser and typing URLs in the address bar. (Since REST is so simple.)

You can then use jQuery $.ajax() to retrieve the data.

Your app can either access bits of data as needed from the web service, or else load all of the data at once when it starts the first time. If you provide some means of checking for updates, then you can also update your local database on the device periodically as well.

Hey,

thx for that REST hint. I created a REST script and now got some problems :-o

1. if (!isset($_SESSION['users'])) {
       $_SESSION['users'] = array(
           (object) array("id" => 1, "firstName" => "John", "lastName" => "Smith", "deleted" => false),
           (object) array("id" => 2, "firstName" => "Lisa", "lastName" => "Taylor", "deleted" => false)
       );
   }

Managed it with a simple XML File.

1. $.ajax({ 
                   url:'www.xyz.com/categorie.xml', 
                   dataType:'xml',
                   async:false, 
                   type:'POST', 
                   success:function(data) {
                        $(data).find("categorie").each(function () {
                            var xmlDaten = $(this);
                            u.executeSql('INSERT INTO Categorie (id, name) VALUES ("' + xmlDaten.attr("id") + '", "' + xmlDaten.find("name").text() + '")');
                        });
                    }, 
                   error:function(XMLHttpRequest,textStatus, errorThrown) {    
                     alert("Error status :"+textStatus); 
                     alert("Error type :"+errorThrown); 
                     alert("Error message :"+XMLHttpRequest.responseXML);
                   }
                   });