John, the data comes back from that php script as a list so you can manipulate it in LC however you want.
Gerry -- http://gerryorkin.com On 10/07/2011, at 12:34 AM, John Patten <johnpat...@me.com> wrote: > Thanks Gerry! > > That's just what I was after. When query result data is returned to the > LiveCode iOS app, is it returned in the same format as if the query was done > in LiveCode? For example: > > Id1 songblue 3:00 > Id2 songred 2:45 > Id3 song green 2:53 > > ... > > Essentially will I be able to put the query result in a variable and then > manipulate it by line like normal in LiveCode (iOS)? > > Thank You! > > Sent from my iPad > > On Jul 8, 2011, at 11:24 PM, Gerry Orkin <gerry.or...@gmail.com> wrote: > >> John >> >> MySQL is supported in LC on iOS. However tapping in to MySQL databases from >> mobile devices introduces a bunch of access and security issues, so rather >> than using the MySQL commands I use .php files on my MySQL server to do my >> SELECTs and INSERTs. I run them from my iOS app using url http calls. >> >> For example, from my app I call: >> >> function sqlGetSongsOnServer >> return url ("http://somedomain.com/somedirectory/songs.php";) >> end sqlGetSongsOnServer >> >> On the server side, the songs.php looks like this: >> >> <? >> // script to return number of songs >> >> // connection information >> $hostName = "localhost"; >> $userName = "whatever"; >> $password = "blahblahblah"; >> $dbName = "mediadb"; >> >> // make connection to database >> mysql_connect($hostName, $userName, $password) or die("Unable to connect to >> host $hostName"); >> >> mysql_select_db($dbName) or die( "Unable to select database $dbName"); >> >> // return all the songs sorted by songnumber field >> $query = " SELECT * FROM `songs` ORDER BY `songs`.`songnumber`"; >> $result = mysql_query($query); >> >> // Determine the number of songs >> $number = mysql_numrows($result); >> >> // Print the songs for return to LC >> for ($i=0; $i<$number; $i++) { >> $songtitle = mysql_result($result,$i,"songtitle"); >> $filesize = mysql_result($result,$i, "filesize"); >> $desc = mysql_result($result,$i, "desc"); >> print "$songtitle\t$filesize\t$desc\n"; >> } >> >> // Close the database connection >> mysql_close(); >> ?> >> >> >> >> Cheers >> >> Gerry >> >> >> >> >> On 09/07/2011, at 2:39 PM, JOHN PATTEN wrote: >> >>> Hi All! >>> >>> I have a little stack I'm testing some ideas out on. It makes some simple >>> SELECT and INSERT mySQL queries using the LiveCode calls. It is my >>> understanding that those LiveCode mySQL calls do not work in iOS. >>> >>> Is it possible to to still access a mySQL database from with in iOS (in >>> LiveCode)? If the answer is yes, how would I go about doing that in the >>> best way? >>> >>> Thank you! >>> >>> John Patten >>> SUSD >>> _______________________________________________ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
