FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


PHP and SQL Server





sevensealscomputing
Since php.net seems to be down as of right now, I was wondering if the calls for SQL server are any different than those of mysql (in other words, can I just sub in "mssql_" for "mysql_" and have everything work out fine)?
hexkid
sevensealscomputing wrote:
Since php.net seems to be down as of right now, I was wondering if the calls for SQL server are any different than those of mysql (in other words, can I just sub in "mssql_" for "mysql_" and have everything work out fine)?

There are a few differences, but mostly, yes. Just substitute mysql_* for mssql_* and it'll work.

The most different function is
mysql_error() <===> mssql_get_last_message()
titiankaba
here some Microsoft SQL Server functions that you can use...

mssql_close Close MS SQL Server connection
mssql_connect Open MS SQL server connection
mssql_data_seek Move internal row pointer
mssql_fetch_array Fetch row as array
mssql_fetch_field Get field information
mssql_fetch_object Fetch row as object
mssql_fetch_row Get row as enumerated array
mssql_field_length Get the length of a field
mssql_field_name Get the name of a field
mssql_field_seek Set field offset
mssql_field_type Get the type of a field
mssql_free_result Free result memory
mssql_get_last_message Returns the last message from server (over min_message_severity?)
mssql_min_error_severity Sets the lower error severity
mssql_min_message_severity Sets the lower message severity
mssql_num_fields Get number of fields in result
mssql_num_rows Get number of rows in result
mssql_pconnect Open persistent MS SQL connection
mssql_query Send MS SQL query
mssql_result Get result data
mssql_select_db Select MS SQL database
Related topics
php without server
how to set up a server
SQL Server 2000 and MYSQL, pls help me.
Visual Studio 2005 and SQL Server 2005 Express, Free?
VB.NET and SQL Server
xp and microsoft sql server 2005 enterprise edition
programeren
Using pgSQL and MS SQL with php 4/5
Converting Access database to SQL server 2005
(solicitud) video de manejo de sql
Problem with my SQL Server (not Frihost)
How to install SQL Server 2000 on Vista?
SQL SERVER
Move database to different SQL server
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.