MySQL PHP to Posgres Converter 0.94

MySQL PHP to PostgreSQL is an application that takes a php page that uses mysql calls and changes them into PostgreSQL calls.
This allows any website (if it converts properly) that was written in PHP for MySQL to run as a website written to run on PostgreSQL.
- Step 1: Download and uncompress
To uncompress simply type: tar xvzf mysqlphp2postgres.tar.gz
If youre on a non-GNU system you might have to type: gzip -dc mysqlphp2postgres.tar.gz | tar xvf -
- Step 2: Compile
To compile simply type: make
If youre on a non-GNU system youll have to edit the make file to change the compiler to cc instead of gcc
- Step 3: Install
Type: make install
This will simply copy the binary file to /usr/local/bin/
- Step 4: Convert
Type: mysqlphp2postgres inputfile.php outputfile.php
The input file is the php page that uses mysql. The outfile is the page you want to create. You will probably need to tell mysqlphp2postgres the name of the postgreSQL database since mysql_select_db doesnt translate. You can do this by using a -d switch. So if, for example, the database youre connecting to is called blah, you could type: mysqlphp2postgres -d blah inputfile.php outputfile.php
Problems:
I have had the following problems from using this program:
MySQL has a lot more functions in PHP than PostgreSQL that do more things. I havent had a problem with any unsupported functions in my programs, but someone probably will. If you want to help write code for this to support those functions (if thats even possible) feel free to help.
Enhancements:
- Fixed some stuff.
- Cleaned up some code.
- This program now produces code optomized for PHP 4.1.0 and above.