Solution to the problem that php5.3 cannot connect to mssql database, php5.3mssql_PHP tutorial

Solution to the problem that php5.3 cannot connect to mssql database, php5.3mssql

The example in this article describes the solution to the problem that php5.3 cannot connect to the mssql database. Share it with everyone for your reference. The specific analysis is as follows:

Since php5.3, the system does not support the mssql_connect function. In the past, I also said that you can use the com interface to achieve it. Now I will introduce another method to solve the problem that php5.3 cannot connect to the mssql database.

Under Windows systems, versions above PHP5.3 no longer support mssql extension.

First http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx click get it to download SQLSRV20.EXE.

Extract the file to the php extension folder ext, open php.ini and add:
at the end

Copy code The code is as follows:

[PHP_PDO_SQLSRV]
extension=php_pdo_sqlsrv_53_nts_vc6.dll
[PHP_SQLSRV]
extension=php_sqlsrv_53_nts_vc6.dll

Just restart apache after saving. Attached is a simple PHP connection example. The code is as follows:

Copy code The code is as follows:

$serverName = "(127.0.0.1)";
$connectionInfo = array( "UID"=>"root",
"PWD"=>"root2010",
"Database"=>"master");

$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn )
{
echo "Connection established.n";
}
else
{
echo "Connection could not be established.n";
die( print_r( sqlsrv_errors(), true));
}
?>

I used the wamp5.1 integrated installation package and tested it on Windows Server 2008. The test on php5.4 or above was not successful.

If you use this extension to connect to sql server 2005 or above (such as sql server 2008), you also need to install SQL Server Native Client on the machine first: http://download.microsoft.com/download/0/ E/6/0E67502A-22B4-4C47-92D3-0D223F117190/sqlncli.msi

This extension adds a series of functions starting with sqlsrv_ to PHP. The function reference is as follows:

Copy code The code is as follows:

sqlsrv_begin_transaction
sqlsrv_cancel
sqlsrv_client_info
sqlsrv_close
sqlsrv_commit
sqlsrv_configure
sqlsrv_connect
sqlsrv_errors
sqlsrv_execute
sqlsrv_fetch
sqlsrv_fetch_array
sqlsrv_fetch_object
sqlsrv_fetch_metadata
sqlsrv_free_stmt
sqlsrv_get_config
sqlsrv_get_field
sqlsrv_has_rows
sqlsrv_next_result
sqlsrv_num_fields
sqlsrv_num_rows
sqlsrv_prepare
sqlsrv_query
sqlsrv_rollback
sqlsrv_rows_affected
sqlsrv_send_stream_data
sqlsrv_server_info

More detailed instructions can be found in the SQLServerDriverForPHP.chm help file in the self-extracting file just now. Open it and click the API Reference node.

Look at another odb connection method, the code is as follows:

Copy code The code is as follows:

$dbhost = '';
$dbuser = ''; //Your mssql username
$dbpass = ''; //Your mssql password
$dbname = ''; //Your mssql library name
$connect=odbc_connect("Driver={SQL Server};Server=$dbhost;Database=$dbname","$dbuser","$dbpass");
$sql="select * from content";
$exec=odbc_exec($connect,$sql);
while($row = (odbc_fetch_array($exec)))
{
$row['id'] //?Get field value
…
}

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/933598.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/933598.htmlTechArticleSolution to the problem that php5.3 cannot connect to mssql database, php5.3mssql This article tells the example of php5.3 not being able to connect to mssql Database solutions. Share it with everyone for your reference. The specific analysis is as follows...