Looking for advice for my PHP project
Posted: Tue May 29, 2007 8:48 pm
Hi all,
I've recently gotten back into PHP development for some personal projects. I am a bit rusty and I wanted to get some advice on the best way to proceed in building a PHP application with a MySQL database backend. The web app will run on Apache with Debian as the OS.
The basic premise of my application is this:
- Will take XML log files and parse them and enter the data into MySQL
- Users can then edit that data via the PHP web interface, using forms, etc.
- Users then output the data into HTML format using their choice of available HTML templates
My questions are this:
1. I've been away from PHP development for awhile. Are there any new open source classes or technologies I can use to easily parse the XML and get it into my MySQL database?
2. I don't have experience with XSL/XSLT, and I'm more familiar with "HTML templates" where basically anyone that knows HTML can make template and use variable substitution for data that will come from the database. Again, is there good open source code available for this?
I would rather not store the data as XML in the database, I'd much prefer to parse it and then store it in plain text format. I wan the option of not only turning it into HTML via templates, but possibly writing something to export it to other formats such as PDF.
Thanks in advance,
Mizzmazz
I've recently gotten back into PHP development for some personal projects. I am a bit rusty and I wanted to get some advice on the best way to proceed in building a PHP application with a MySQL database backend. The web app will run on Apache with Debian as the OS.
The basic premise of my application is this:
- Will take XML log files and parse them and enter the data into MySQL
- Users can then edit that data via the PHP web interface, using forms, etc.
- Users then output the data into HTML format using their choice of available HTML templates
My questions are this:
1. I've been away from PHP development for awhile. Are there any new open source classes or technologies I can use to easily parse the XML and get it into my MySQL database?
2. I don't have experience with XSL/XSLT, and I'm more familiar with "HTML templates" where basically anyone that knows HTML can make template and use variable substitution for data that will come from the database. Again, is there good open source code available for this?
I would rather not store the data as XML in the database, I'd much prefer to parse it and then store it in plain text format. I wan the option of not only turning it into HTML via templates, but possibly writing something to export it to other formats such as PDF.
Thanks in advance,
Mizzmazz