在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
1.下载sqlserver扩展 https://www.microsoft.com/en-us/download/details.aspx?id=20098 解压到 \phpStudy\PHPTutorial\php\php-7.2.1-nts\ext
php.int
安装 msodbcsql.msi 这货要按照 64位 https://www.microsoft.com/en-us/download/details.aspx?id=36434
不然报错 This extension requires the Microsoft ODBC Driver for SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64
代码:sqlcon.php $serverName = "localhost"; $connectionInfo = array( "Database"=>"DBWMS", "UID"=>"sa", "PWD"=>"123123"); $conn = sqlsrv_connect( $serverName, $connectionInfo ); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } if( $conn === false ) { echo "Unable to connect."; die(var_dump(sqlsrv_errors(), true)); } header("Content-type: text/html; charset=utf-8"); include "sqlcon.php"; $order = $_POST['OrderNum']; //$order = "TY20171121103652803442"; $sql = "SELECT ID,ExpressNum,OrderNum,NetWeight,GrossWeight FROM dbo.St_UserOrder where OrderNum= '{$order}'"; $stmt = sqlsrv_query( $conn, $sql ); $stmt = sqlsrv_fetch_array($stmt); echo json_encode($stmt); INSERT INTO 语句INSERT INTO 语句用于向表格中插入新的行。 语法INSERT INTO 表名称 VALUES (值1, 值2,....) 我们也可以指定所要插入数据的列: INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....) public function __construct() mysql $this->b = $config; } $sth = $this->pdo->prepare('SELECT * FROM xxx WHERE id =:id');//双引号失效 SELECT * FROM `pmw_St_UserOrder` WHERE id = :id $sth->execute(array(':id'=>'1'));
|
2022-07-29
2022-08-17
2022-11-06
2022-07-30
2022-08-17
请发表评论