grim1208 Posted April 4, 2006 Share Posted April 4, 2006 What are the possiblities of programming with PHP and calling and adding to a MSSQL server? I have a site all programmed in asp, I want to add a subdomain, but program it in php using the existing MSSQL server databases.Where would I start to create my config.php to connect to the databse with the user and password, and what are some example codings to access table queries with PHP?Any links that direct me to tutorials would be great.Meanwhile I am googling, nothing too useful yet ... Quote Link to comment https://forums.phpfreaks.com/topic/6590-php-with-mssql-is-this-possible/ Share on other sites More sharing options...
jvrothjr Posted April 4, 2006 Share Posted April 4, 2006 [a href=\"http://us3.php.net/manual/en/ref.mssql.php\" target=\"_blank\"]http://us3.php.net/manual/en/ref.mssql.php[/a]Table of Contentsmssql_bind -- Adds a parameter to a stored procedure or a remote stored procedure mssql_close -- Close MS SQL Server connectionmssql_connect -- Open MS SQL server connectionmssql_data_seek -- Moves internal row pointermssql_execute -- Executes a stored procedure on a MS SQL server database mssql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both mssql_fetch_assoc -- Returns an associative array of the current row in the result set specified by result_id mssql_fetch_batch -- Returns the next batch of records mssql_fetch_field -- Get field informationmssql_fetch_object -- Fetch row as objectmssql_fetch_row -- Get row as enumerated arraymssql_field_length -- Get the length of a fieldmssql_field_name -- Get the name of a fieldmssql_field_seek -- Seeks to the specified field offsetmssql_field_type -- Gets the type of a fieldmssql_free_result -- Free result memorymssql_free_statement -- Free statement memorymssql_get_last_message -- Returns the last message from the server mssql_guid_string -- Converts a 16 byte binary GUID to a string mssql_init -- Initializes a stored procedure or a remote stored procedure mssql_min_error_severity -- Sets the lower error severitymssql_min_message_severity -- Sets the lower message severitymssql_next_result -- Move the internal result pointer to the next resultmssql_num_fields -- Gets the number of fields in resultmssql_num_rows -- Gets the number of rows in resultmssql_pconnect -- Open persistent MS SQL connectionmssql_query -- Send MS SQL querymssql_result -- Get result datamssql_rows_affected -- Returns the number of records affected by the query mssql_select_db -- Select MS SQL database Quote Link to comment https://forums.phpfreaks.com/topic/6590-php-with-mssql-is-this-possible/#findComment-23907 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.