The cookie table does exist (cookie extention to firebug) . If I run
phpsqlajax_genxml.php directly I see the xml output. I did try :
GDownloadUrl("phpsqlajax_genxmllast.php?table="+ tablename, function(data) {
with a java function to get the tablename (which I tested with
document.write ) the tablename displayed okay but the markers did not
show.
If I hard code the table name into the sql statement in
phpsqlajax_genxmllast.php it displays fine.
I cannot trace which bit is going wrong.
2009/3/14 Andrew Leach <[email protected]>:
>
> On Mar 14, 1:43 pm, park2 <[email protected]> wrote:
>> I have used the sample phpsqlajax_map.html in the samples. I an trying
>> to pass a variable (tablename) to phpsqlajax_genxml.php.
>>
>> In phpsqlajax_genxml.php I have added $table = $_COOKIE["table"]; and
>> changed the sql to:
>>
>> $query = 'SELECT * FROM '.$table; if I run phpsqlajax_genxml.php in a
>> browser I get the xml output as expected.
>
> If the cookie isn't working, how are you getting the right output?
>
>> I have change phpsqlajax_map.html to phpsqlajax_map.php and added
>> <?php $table=$_GET['table']; $expire=time()+60*60*24*30; setcookie
>> ("table", $table,$expire);?>
>
> Is this line before any output from the php? Cookies have to be sent
> as a header, so you can't do this after some text has been sent
> (including a blank line perhaps) although I would have thought that it
> would generate a "Headers already sent" or similar error.
>
>> I call phpsqlajax_map.php?table=tablename from my main app.
>>
>> So I get tablename set it as a cookie, then I would expect
>> phpsqlajax_genxml.php to generate populate the map but I do not get
>> any markers showing. Any ideas on why this is not working or another
>> approach I can use.
>
> Have you checked using Firebug or something similar that the cookie is
> being sent correctly?
>
> An alternative: You could pass a tablename (or a value which is
> interpreted to create the tablename) as a parameter in the genxml.php
> URL: genxml.php?q=towns. Your genxml.php would receive q and construct
> the table name from its value.
>
> I would suggest not passing a literal table name between the client
> and server anyway, whether you do it with a cookie or not. Cookies can
> be inspected and the less you give away about your database the
> better. Passing some sort of alias is preferred if you need to do it
> at all.
>
> [This isn't really a Maps API question; it's more of a PHP question]
>
> Andrew
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
