NIUCLOUD是一款SaaS管理后台框架多应用插件+云编译。上千名开发者、服务商正在积极拥抱开发者生态。欢迎开发者们免费入驻。一起助力发展! 广告
``` <?php $serverName = "11.1.111.111,11111"; $database = "XXX"; $username = 'XXX'; $password = 'XXX'; try { $conn = new PDO( "sqlsrv:server=$serverName;Database=$database", $username, $password, array( //PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ) ); $stmt = $conn->prepare("INSERT INTO table_name ( KEYWORD ,LID ) VALUES ( :KEYWORD ,:LID )"); $stmt->bindParam(':KEYWORD', $KEYWORD); $stmt->bindParam(':LID', $LID); // insert a row $KEYWORD = '27'; $LID = '25'; $stmt->execute(); echo "New records created successfully"; } catch(PDOException $e) { die("Error connecting to SQL Server: " . $e->getMessage()); } $conn = null; ```