DEMO of MSSQL connection based on PDO and demo of pdomssql

DEMO of MSSQL connection based on PDO and demo of pdomssql

This example describes how to connect to MSSQL Based on PDO in php. We will share this with you for your reference. The details are as follows:

<? Phptry {$ hostname = '2017. 79.93.222 '; $ port = 1433; // port $ dbname = "csdn"; // database name $ username = "csdn_admin"; // user $ pw = "123456 "; // password $ dbh = new PDO ("dblib: host = $ hostname: $ port; dbname = $ dbname", "$ username", "$ pw ");} catch (PDOException $ e) {echo "Failed to get DB handle :". $ e-> getMessage (). "n"; exit;} echo 'connent MSSQL succeed'; $ stmt = $ dbh-> prepare ("SELECT * FROM CSDNUser"); $ stmt-> execute (); while ($ row = $ stmt-> fetch () {print_r ($ row);} unset ($ dbh); unset ($ stmt );