<?$dbhost = '111.40.7.93,1433'; $dbuser ='sa'; //你的mssql用户名 $dbpass = '123456AAA'; //你的mssql密码 $dbname = 'sun1'; //你的mssql库名 $connect=odbc_connect("Driver={SQL Server};Server=$dbhost;Database=$dbname",$dbuser,$dbpass); if($connect){echo "连接成功!<br/>";} else {echo "链接失败!";}$sql="select * from table1";$rs=odbc_exec($connect,$sql); //$rs=odbc_do($connect,$sql); //do和exec都可以if (!$rs) {exit("Error in SQL");} while (odbc_fetch_row($rs)) { $a_id=odbc_result($rs,"a_id"); $name=odbc_result($rs,"name"); echo $a_id."**".$name."<br>"; } $sql5="select * from table1";$rs5=odbc_exec($connect,$sql5); while( $row = odbc_fetch_array($rs5)) { print_r($row); } $sql2="INSERT INTO [sun1].[dbo].[table1] ( [name], [beizhu]) VALUES ( 'sun33', '5533')";odbc_exec($connect,$sql2); //odbc_free_result($Result);$Result = odbc_exec($connect, "select @@identity");$NewID = odbc_result($Result, 1);echo $NewID."<BR>";//刚才插入的idodbc_free_result($Result);$sql3="UPDATE [sun1].[dbo].[table1] SET [name]='sun334', [beizhu]='55334' WHERE ([a_id]='14')";odbc_exec($connect, $sql3);$sql4="delete from [sun1].[dbo].[table1] WHERE ([a_id]='$NewID')";odbc_exec($connect, $sql4);$result=odbc_do($connect,$sql); $q=odbc_num_rows($result);echo $q;//显示的行数odbc_close($connect); ?>
SQL 创建表的语句:
-- ------------------------------ Table structure for table1-- ----------------------------DROP TABLE [dbo].[table1]GOCREATE TABLE [dbo].[table1] ([a_id] int NOT NULL IDENTITY(1,1) ,[name] varchar(60) NOT NULL ,[beizhu] text NOT NULL )GODBCC CHECKIDENT(N'[dbo].[table1]', RESEED, 23)GO-- ------------------------------ Indexes structure for table table1-- ------------------------------ ------------------------------ Primary Key structure for table table1-- ----------------------------ALTER TABLE [dbo].[table1] ADD PRIMARY KEY ([a_id])GO
如果觉得《通达OA版连接sqlserver数据库》对你有帮助,请点赞、收藏,并留下你的观点哦!