Well.....I tried this (with a simple test file) and I don't think the php file is being parsed as a php file when loaded through the tl.loadJSON function. Dang. That would have been too easy, lol.
So, I'm still looking to find out how to load the data into some var, essentially bypassing the tl.loadJSON function. On Apr 1, 3:18 pm, John Callahan <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
