mysql & mssql command

[whtlghtn]

I am doing development for a web based environment which connects to a Microsoft SQL Server. Because of my lack of funds I am doing my development in a web environment that connect mysql server. I have been able to transfer my code to the production server and do a text replace from my to ms and all of my sql command work fine. Is there are way to set a variable (ex $db_type = "ms") and use that variable in my sql command. I tried the following, but it did not work.

$db = $db_type.sql_connect($hostname,$db_username,$db_password)

Any ideas or direction would be greatly appreciated.

Thanks,
WhtLghtn

[Anon]

Although php supports variable function names ,I'm sorry to say that ,databases dont respect us as much as Zeev does 🙂

If you have looked up both mssql and mysql you should see that they have differences at the way we have to build our queries..

But your problem has a solution.. If you have a look at phpbuilder articles you'll find a diary about the cross platform php scripts and the answer they found for your question.

Read it.. You'll like it 😉

have fun with PHP..

[Anon]

I found it for you..

http://www.phpbuilder.com/columns/banahan20010720.php3

[[deleted]]

This is ofcourse doomed to fail if even one function takes the paremeters in a different order.

The solution to your problem is in a 'database abstraction layer'.

That is a set of functions that do the actual database work. You can then build a set of those functions to run queries on a mysql database, and another set of functions (with 100% the same names and parameters) that works on a ms-sql database.

That way your code itself doesn't rely on mysql or ms-sql and it will work for both.