convert site: perl/file to php/mysql

[jbroder]

I am planning to convert my perl/ssi site with over 1000 html pages to a php/mysql site. So, I have to parse all these files and put the data into tables on the database.
What I need is write a script to parse files and then put them into the mysql database.

I have used perl for file access and regex parsing alot. I have used php for mysql access alot.

I can't decide which language to use. Should I use perl to get the most of its regex function and learn the perl database connectivity part? Or should I use php for its database function and learn its file access methods?

Thanks for any help.

Jon
------------------
guitartricks.com

[Hunkorama417]

PHP can handle Perl based regex using preg() [I think it's preg() or either preg_replace()]. I tend to lean more to PHP, but Perl can be very nice indeed. If I were you I'd use Perl and the DBI module to interact w/ mySQL.
------------------
Andrew
www.digi-FX.net

[Stephen]

this thread might help you decide whether to use perl:

http://www.aota.net/ubb/Forum15/HTML/000467-1.html

------------------
Stephen Carter, Random Mouse Software
Putting Customer Reviews On Your Site
U R L:  www.randommouse.com

[thalcor]

You can use both Perl and PHP to access your MySQL database.  Convert your data files to MySQL and then using then port your existing Perl code using the Perl DBI/DBD.  Same with the PHP code.  Should be easy to accomplish.

[sumengen]

Unless you have a very good reason, there is no need to convert your perl scripts to a limited and painful language like php.
DBI (perl's database connectivity) is nothing complex. Just couple of functions. The challenge is to master sql and mysql. It looks like you are already familiar with mysql, so you can just add 2-3 lines of more perl code to your program and that's it.

[jbroder]

Thanks for all the responses. It seems the consensus is that learning Perl DBI will be my best bet for the file to database conversion. Can anyone recommend a good web site or book that explains DBI?