[FX.php List] Anyone using XSLT anymore?

[Bob Patin]

Dan,

I think you've made the perfect suggestion!

I'll populate the database with their HTML, then (as you suggested)  
write a script to output the HTML into files that the database then  
references, just like I would do if I were displaying photos. I would  
think Troi File would probably output the text files; if anyone knows  
of a better choice for this, please let me know...

So the database would have to actually write the files and then send  
them over to a different machine, unless I put all of this (FMSA, OS  
X Server) on the same machine. I've never run FMSA alongside OS X  
Server before; would this be a crazy way to do it?

Thanks for your help (and all you guys)! I think I see daylight!

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060


On Sep 20, 2006, at 10:42 AM, DC wrote:

> Bob,
>
> My earlier suggestion *was* to just set up some kind of caching  
> system.
>
> But since you say you have to maintain the user interface in FMP  
> you *really should look into* my suggestion to store HTML in FMP  
> (for searching) and a copy of every HTML file in the filesystem  
> (for serving with a php include(). Search using FX.php then serve  
> the file using a path stored with the HTML data. The trick here is  
> to keep the HTML in the database records and the HTML files in  
> sync. i believe there is a plugin that can write files for you from  
> field data. a simple script every quarter would keep the HTML in sync.
>
> But, if you already have an HTML caching system in place... you can  
> try the following. note, i recommend using the above solution  
> rather than trying to build an HTML output cache and scripting a  
> query sending spider using curl! Scripting a query spider to build  
> a cache is not a quick weekend project. It might be fun and  
> interesting, but the above architectural solution is better.
>
> forging ahead... i originally suggested using wget (a GUI variant  
> of it exists) but, it doesn't smoothly handle form requests.
> If you know all of the possible permutations of queries ahead of  
> time you can just write a PHP script that uses foreach() and loops  
> through and calls curl with every permutation.
>
> I usually use system_exec() to call curl - see the php manual and  
> terminal 'man curl' for details on every aspect of it. curl can  
> send form elements via POST using the -d switch.
>
> To send form input via POST I've demonstrated the correct syntax by  
> using your login page for squirrel mail:
>
> curl "http://webmail.longtermsolutions.com:16080/webmail/src/ 
> redirect.php" -d login_username=danFromFXlist -d  
> secretkey=supersecretpassword -d js_autodetect_results=0 -d  
> just_logged_in=1
>
> in php it would look something like this:
> $returned_page = system_exec('curl "http:// 
> webmail.longtermsolutions.com:16080/webmail/src/redirect.php" -d  
> login_username=danFromFXlist -d secretkey=supersecretpassword -d  
> js_autodetect_results=0 -d just_logged_in=1');
>
>
> if you change these to the correct squirrel mail login and password  
> you should get a confirmation login page from your site.
>
> HTH,
> dan
>
> On Sep 20, 2006, at 11:03 AM, Bob Patin wrote:
>
>> No, I never did, and was going to look for the email where you  
>> mentioned a caching "spider" that would cache during off-peak  
>> hours. Does it have the capacity to run queries on its own?  
>> Specifically, is it smart enough to go to an input page, select  
>> from a pulldown, and run a query?
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060920/06f771b6/attachment.html