<?
/**
* 载入资料库,由子类中根据是否需要资料库去调用。
*
* @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>";
}
?>
发表评论