Android and POST commands (revisited)…?

JOHN PATTEN johnpatten at me.com
Thu Sep 26 18:45:02 EDT 2013


Hi All..

I've been testing a project in an Android device and can't seem to get the POST command to work on Android. It works fine on the desktop (Mac). I have checked the list and bug reports and have seen past issue Header adjustments, etc. and it appears that any real bugs had been resolved. This leads me to believe the problem is my code. Here's what I'm trying to do. The project uses a number in a fld to query a mysql database on my on-rev account and pulls out a couple of fields.
...
   put cd fld "assignmentNumber" into tPostData
   get libURLFormData("doccode",tPostData)
   set the httpHeaders to "Content-Type: application/x-www-form-urlencoded" --added this from a previous solution but had no effect.
   post it to url "http://jpatten.on-rev.com/safetube_student/lc_lookup_title_exec.php"

…
and the PHP code from the lc_lookup_title_exec.php...

$doccode = clean($_POST['doccode']); 
$result = mysql_query("SELECT title, summary FROM urldoc WHERE docid = $doccode");
if($result === FALSE) {
die(mysql_error());
}
while($row = mysql_fetch_array($result))
  {
echo $row['title'] . PHP_EOL . $row['summary'];
  }

Any suggestions on how this can be changed to work on a Android device?

Thank you!

John Patten
SUSD


More information about the use-livecode mailing list