PHP MySQL Equivalent MsSQL Functions

Question

I am currently working on a project that requires a connection to a MsSQL database. Although I have never used MsSQL, I am a little familiar with how it works and differs from MySQL. However, I am unfamiliar with the integration of PHP and MsSQL. I have written a class for MySQL and am hoping to convert this class to MsSQL. So far all is good, but I have run into 2 functions that are not present in the predefined PHP library. These being:

mysql_real_escape_string
mysql_field_flags

Does anybody know of somewhere that shows how to recreate these equivalent functions for MsSQL?

Vishwanath Dalvi · Accepted Answer · 2012-03-13 10:17:47Z

1

The best option would be to use parameterised queries and prepared statements with PDO library.

answered Mar 13, 2012 at 10:17

Vishwanath Dalvi

36.9k41 gold badges128 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ben Carey Over a year ago

Thank you for your answer, I have now had a chance to research into PDO a little more and it is definitely the way to go. Thank you!

Ben Carey · Accepted Answer · 2012-03-15 09:57:48Z

0

I have reviewed this further and concluded that I will need to rewrite these functions myself. When I have done, I will post them up here for reference purposes.

UPDATE

More research has shown that the answer supplied by Viswanathan Iyer, is in fact correct. For connecting to a MsSQL database, the most effective and efficient way is to use the PDO library supplied by PHP

edited Mar 15, 2012 at 9:57

answered Mar 14, 2012 at 10:56

Ben Carey

17k20 gold badges95 silver badges181 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Equivalent MsSQL Functions

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related