mySQL DB Database to HTML files (automatically create multiple static html files from a database)
This is a discussion on mySQL DB Database to HTML files (automatically create multiple static html files from a database) within the MySQL forums, part of the Database Server Software category; --> i need automatically create html files from a mysql db can be locally on in the server. any idea? ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:17 AM
| |||
| |||
 Re: mySQL DB Database to HTML files (automatically create multiplestatic html files from a database) fhelik wrote: > i need automatically create html files from a mysql db can be locally > on in the server. any idea? "mysql --xml" outputs in XML format. You can then filter using an XSLT template to produce your HTML files. See http://www.zvon.org/xxl/XSLTutorial/...ok1/index.html for a tutorial on XSLT. Regards, Bill K.      |
|
02-28-2008, 08:17 AM
| |||
| |||
| Re: mySQL DB Database to HTML files (automatically create multiple static html files from a database) Bill Karwin wrote: > fhelik wrote: > > i need automatically create html files from a mysql db can be locally > > on in the server. any idea? > > "mysql --xml" outputs in XML format. > > You can then filter using an XSLT template to produce your HTML files. > See http://www.zvon.org/xxl/XSLTutorial/...ok1/index.html for a > tutorial on XSLT. > > Regards, > Bill K. i might work but is not automatic, i need a php file to put in the server to i can run a cron job and makes the files in the server but thanks it might help someone else |
|
02-28-2008, 08:17 AM
| ||||
| ||||
| Re: mySQL DB Database to HTML files (automatically create multiple static html files from a database) fhelik wrote: > Bill Karwin wrote: > > fhelik wrote: > > > i need automatically create html files from a mysql db can be locally > > > on in the server. any idea? > > > > "mysql --xml" outputs in XML format. > > > > You can then filter using an XSLT template to produce your HTML files. > > See http://www.zvon.org/xxl/XSLTutorial/...ok1/index.html for a > > tutorial on XSLT. Great suggestion! > > > > Regards, > > Bill K. > > i might work but is not automatic, i need a php file to put in the > server to i can run a cron job and makes the files in the server The 'mysql' command suggested can be automated by cron. > > but thanks it might help someone else |
Linear Mode
