Using Post tData?

[Andrew Kluthe]

Hmmm.

echo "<td><. $row['urladdress'] . </td>";

That line there doesn't quite look right.

I'm not sure if you pasted this out directly or not.

What's your reasoning for the table in the script? If I were going to use
this as an http interface I would likely just use <br> tags to put them all
in a nice list that livecode could process easily.

The syntactcaly correct version of that echo would be.

echo "<td>" . $row['urladdress']  . "</td>";

Also I believe you have an extra orphan </td> in the last line of the
script you posted.

You are getting something back from the url so livecode's url commands are
fetching the right stuff, and you say this query works fine when peeked at
from a browser window.

I'd look at your loop a little closer.

Andrew


On Mon, Sep 23, 2013 at 12:20 AM, Earthednet-wp <prothero at earthednet.org>wrote:

> John,
> I use post and php for remote MySQL database interaction. To use the LC
> MySQL commands directly, you have to open permissions to the database to
> the world (assuming your app accesses it). This makes an extremely insecure
> system. You can open an ssh tunnel using shell commands, but I find the php
> solution more to my liking.
> Good luck,
> Bill
>
> William Prothero
> http://es.earthednet.org
>
> On Sep 22, 2013, at 8:42 PM, JOHN PATTEN <johnpatten at me.com> wrote:
>
> > Hi All…
> >
> > I would like to be able to pull data into a livecode project from an
> on-rev mysql database. It currently works in a  browser as a simple web app
> and is built all on in php.
> >
> > I thought I may be able to just use the post command, however when I try
> to post some data to a php url that executes a query on the database and
> then echoes back the results all I get in an "answer it" is the first
> header line, "Assigned Resources," and no array results. Here is the
> abbreviated php code:
> >
> > mysql_connect;
> > $result = mysql_query("SELECT urladdress, urltitle FROM urllist WHERE
> docid = '$doccode'");
> >
> > echo "<table border='1'>
> > <tr>
> > <th>Assigned Resources</th>
> > </tr>";
> >
> > while($row = mysql_fetch_array($result))
> >  {
> >  echo "<tr>";
> >
> >  echo "<td><. $row['urladdress'] . </td>";
> >  echo "</tr>";
> >  }
> > echo "</td></table>";
> >
> > This works fine in the browser, but I was hoping to use all these php
> database connections in the web app within a stack and an iOS app. Any
> recommendations, or should I abandon ship, and go in a different direction
> to access the mysql data from within a lc stack?
> >
> > Thanks in advance!
> >
> > John Patten
> > SUSD
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
Regards,

Andrew Kluthe
andrew at ctech.me