Home >Backend Development >PHP Tutorial >Solution to garbled characters in php query mssql_PHP tutorial
Solution to garbled characters in php query mssql_PHP tutorial
- WBOYOriginal
- 2016-07-13 10:10:30800browse
Solution to garbled characters in php query mssql
The specific analysis is as follows:
When php connects to mssql, all the results are garbled. I know from experience that this problem is an encoding problem. Let me summarize the solution for you.
Method one, modify the php.ini file. Of course, it can be set to UTF-8 encoding according to the situation of your page. The code is as follows:
The code is as follows:
mssql.charset = "GBK"
Method 2, convert directly in the program, the code is as follows:
The code is as follows:
Method three, use Ado connection to set the encoding when connecting, the code is as follows:
The code is as follows:
PHP example, the code is as follows:
The code is as follows:
");
//printaline("PLEASE?");
//print("This will not be displayed due to the above error.");
?>
$conn = new COM("ADODB.Connection", NULL, CP_UTF8) or die("Cannot start ADO");
//access database opening method
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
//$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");
$conn->Open("Driver={SQL Server};Server={192.168.22.40};Database=sugarcrm_db;UID=sa;PWD=123456;") ;
//Execute query and output data
$rs = $conn->Execute('SELECT * FROM accounts') or die ("error query");
?>