一个不错的简单的数据库连接类程序,有需php mysql数据库连接类的同学可参考本文章,类文件可到网上下载,代码如下:
- <?PHP
- require_once("mssql.class.php");
-
- $db = new mssql("dns=aaa;uid=sa;pwd=sa;dbname=test");
-
- $conn = $db->config("dns=aaa;uid=sa;pwd=sa;dbname=test");
-
- $dbname = $db->select_db("test");
-
- $db->debug = true;
-
- $db->execute("insert into test01(name) values('这是一个测试!')");
-
-
- $rs = $db->query("select * from test01");
-
- echo "<br>以row方式显示结果集<br>";
- while($r = $db->fetch_row($rs)){
- echo $r[0].":".$r[1]."<br>";
- }
-
-
- $rs2 = $db->query("select * from test01");
-
- echo "<br>以array方式显示结果集<br>";
- while($r = $db->fetch_array($rs2)){
- echo $r["id"] . ":" . $r["name"] . "<br>";
- }
-
-
- $db->db_close();
-
- ?>
|