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
