4 Answers

• Sure thing. using the code below you would received the data using the xhr.onload function. Check out the kitchen sink docs for xhr examples.

  xhr.onload is going to return responseText(among other objects) which is whatever data your .php page returns - in this case a json encoded array.

  not sure what experience you have in web languages but xhr is just ajax so all your doing is making an ajax call to a php page(which queries your database and returns an array that you will json encode) and returning it's data.

  var xhr = Titanium.Network.createHTTPClient();
  xhr.open('GET','http://www.foo.com/phpFile.php?varName='+varValue); // vars optional
  
  xhr.onload = function()
  {
    data = JSON.parse(this.responseText);
    var dl = (data.length-1);
    for(i=0; i<=dl;i++)
    {
      //should print some data
      Ti.API.info(data[i].foo);
    } // end for loop
  }; // end xhr onload
  xhr.send();
  

• Hey, just create an XHR object and point to your php file. In that php file you'll do all your php just like normal - log in to db, query your db and return a json object.

  xhr.open('GET','http://www.foo.com/phpFile.php?varName='+varValue);
  xhr.send();
  

• Thanks for your answer Kelly :) I'm still a bit confused though, could you go into a bit more depth, not entirely sure I understand.

  thanks :)

• Hey again,
  Sorry for the late reply, been under the weather. Thanks for your reply however the problem I'm having is not returning the data to the page after accessing the database, it's accessing the database itself. The prob I'm having is how to access databases through PHP in Titanium, I know how to access a database through PHP but currently it appears that PHP in Titanium does not have SQLITE support and does not provide information about connecting to a MySQL DB (if any exists) or any other for that matter. I can't find any documentation on it either =/