Could you do something like...
tl.loadJSON("myfile.php?"+ (new Date().getTime()), function(json, url) {
eventSource.loadJSON(json, url);
...and myfile.php file simply performs the query and returns the array
of data...
myfile.php would be something like...
<?php
...
$qresult = mysql_query($query) or die(mysql_error());
...
if (mysql_num_rows($qresult) > 0) {
$qstring = ...
while($row = mysql_fetch_array($qresult)){
$qstring .= ...
}
echo $qstring;
?>
I don't think you need the new Date() extension to the file call here as
the php file will be executed each time and not stored in cache
- John
**************************************************
John Callahan
Geospatial Application Developer
Delaware Geological Survey, University of Delaware
227 Academy St, Newark DE 19716-7501
Tel: (302) 831-3584
Email: [email protected]
http://www.dgs.udel.edu
**************************************************
JadedAngel wrote:
> My apologies in advance if I'm posting this in the wrong place. If
> that's the case, please let me know where this question should be
> asked.
>
> I'm developing an application that will read Timeline data from a
> mySQL database using PHP. At the moment (just to get things working)
> we're reading the data and then writing it to a temporary file (called
> 'myfile.js' in this example), with the data in JSON format.
>
> The current way Timeline loads the data is through this function:
>
> tl.loadJSON("./data/myfile.js?"+ (new Date().getTime()), function
> (json, url) {
> eventSource.loadJSON(json, url);
>
> Rather than write to a file and then read it back in, we'd like to
> read from the database then and insert it directly into a javascript
> variable, something like:
>
> <?php
> // php code for reading data from the database goes here,
> // and the data gets returned as the PHP var "$timeline_data"
> ?>
> <script type='text/javascript'>
>
> // printed via PHP, the data is stuffed into the javascript var 'foo'
> var foo = <?php echo $timeline_data; ?>;
>
>
> The problem is that I have no idea what javascript variable the data
> in 'myfile.js' is supposed to end up in. What would I replace the
> current data file loading lines with to insert the returned data
> directly into a javascript var so that TimeLine can use it?
>
> In other words, what Javascript variable does the data loaded through
> these two lines end up in:
>
> tl.loadJSON("./data/myfile.js?"+ (new Date().getTime()), function
> (json, url) {
> eventSource.loadJSON(json, url);
>
>
> I thank you in advance for any help you may be able to offer.
>
> LDM
> [email protected]
> (Timeline n00b)
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SIMILE Widgets" 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/simile-widgets?hl=en
-~----------~----~----~----~------~----~------~--~---
