PHP and MS-SQL: Looking for advise ... 1

[casabella]

I was just handed a project to write an UI in PHP to query
MS-SQL database.

I am just starting to get comfortable with MySQL. Is there too much difference or is it just a matter of which functions one uses? Which extensions do I need (php_msql or php_mssql)?

Regards,


Jose

 

[vacunita]

Actually its pretty much the same thing. You pass the queries to the DB using the db functions such as mssql_query,.

And you retrieve the data, using other functions. The construction of queries should be exactly the same, its just how you send them to the DB.

Obviously if you are using MSSQL you need to use the MSSQL libraries, not the MYSQL, as those are for MYSQL, a different DB all together.

Start Here:

http://www.php.net/manual/en/function.mssql-connect.php

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[casabella]

Thanks vacunita!

I'll do some reading and see where it takes me. I am sure I'll come back this way with more questions.


Jose

 

[jpadie]

for portability consider using an abstraction layer like PDO or, if you need query rewriting capability, ADODB or MDB2.

 

[casabella]

Thanks jpadie, I will keep these in mind. PDO is something you used on that "chat" code you gave me some weeks back. I have been meaning to read-up on it, perhaps the time has come to actually start reading.

Regards,


Jose