在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
首先放上 PHP连接SQLServer的驱动下载地址 http://php.net/manual/zh/ref.pdo-sqlsrv.php 另外PHP for IIS管理工具 大家可以自己搜索一下 很久以前下的。现在忘记地址了。 PHPManagerForIIS-1.1.2-x64.msi
第一个是比较基础的,直接创建conn 连接本机的SQLExpress实例 $conn = new PDO("sqlsrv:server=.\SQLExpress;Database=thinkphp","admin","pass1234"); //$conn = new PDO("sqlsrv:Server=127.0.0.1/Express; Database=MyeCharts", "admin", "pass1234"); $query = 'select top 1 * from think_data'; $stmt = $conn->query( $query ); while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ) { //print_r( $row ); } 第二个是网上搜罗到的创建了类来控制 连接远程服务器。 class mssql{ private $host; private $username; private $password; private $database; private $handle; private function __construct (Array $config){ $this -> host = $config['DB_HOST']; $this -> username = $config['DB_USER']; $this -> password = $config['DB_PWD']; $this -> database = $config['DB_NAME']; $this -> init(); } private function init() { $dsn = 'sqlsrv:server = '.$this -> host.';database = '.$this->database; $this -> handle = new PDO($dsn,$this -> username, $this -> password); } public static function GetInstance(array $config = null) { if (null == $config) { return NULL; } static $db = null; if (null == $db) { $c = __CLASS__; $db = new $c($config); }; return $db -> handle; } } 调用方法 $config = array( 'DB_HOST' => 'servername,1800', 'DB_NAME' => formname, 'DB_USER' => 'admin', 'DB_PWD' => 'pass1234' ); $mssql = mssql::GetInstance($config); $result = $mssql->query('SELECT MAX(formID) FROM fromname); foreach($result as $row){ $id = $row[0]; echo $id; } |
2022-07-18
2022-08-30
2022-08-17
2022-11-06
2022-08-17
请发表评论