<? /** * 载入资料库,由子类中根据是否需要资料库去调用。 * * @return Object 资料库类实体对象 */ function loadDBMSSQL($debug = true){ global $dbs; if (!isset($dbs)) { include_once (FILE_PATH."lib/adodb/adodb.inc.php"); $dbs = NewADOConnection("mssql"); $dbs->debug = $debug; $dbs->charPage =65001; $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; //$myDSN="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER={192.168.4.119};DATABASE=galaxybox;UID=justcall;PWD=123456;"; if (!$dbs->Connect("192.168.4.119", "justcall", "123456", "galaxybox")) { exit('<a href="/" target="_top">The MSQL server is busy</a>'); } } return $dbs; } $dbs = $this->loadDBMSSQL(); $sql = "select * from table_1"; $rs = $dbs->GetArray($sql); foreach($rs as $val){ echo $val['id'] . "-" . c($val['name']) . "</br>"; } ?>
发表评论