On 1/14/05 19:34, "Donna-n-Doug Finner" <[EMAIL PROTECTED]> wrote:
> Noob alert.... > I've been through most of the available documentation at a fairly high > level - if I've missed the obvious, just point me in the right > direction. > > What I'd like to build: > Windows XP system (actually, I'd prever a *nix but must use Win). > Backend data stored in MySQL db > Front end user interface built using PHP/HTML running on Apache. > > User builds a select via the web front end. > User selects a canned analysis or graph for the data set. > System grabs the data, passes the data to R, magic happens, graphs displayed. > User isn't exposed to the R-GUI. > > Is this kind of design possible? > Without going into detail, how would this kind of system be > structured? What keywords can I look up that fill in the blanks? Are > there any samples of this type of system I can see and/or use? > Is there another way I should be thinking about this kind of design? > > Additional wrinkle - we may need to substitute Excel as the raw data > source. I've been playing with converting XL files to tab sep var > files and had some level of luck. I haven't given the ODBC method a > try yet since that was a 'not' recommended method. > > I'm sure I'll have more to follow. This tool looks pretty neat. > Thanks in advance for any tips or pointers. > > Doug > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > It sounds like you are early in the design process? Have you looked at PostgreSQL and Pl/R? You can simply pipe the data to R in batch mode, write the graphs generated by R to temporary files, and then use those in your generated HTML. There are numerous posts about running R in batch mode. As for using R with PHP, someone else will have to comment about specifics. Sean ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
