测试连接数据库

mssql测试连接数据:

 

$dbhost='192.168.6.3/SQLPRODUCT01,1433';
$dbuser='dgzq';
$dbpw='123456';
$dbname='dg';

$_connid=@mssql_connect($dbhost,$dbuser,$dbpw);
 mssql_select_db($dbname,$_connid);
 
$result=mssql_query('select * from dg_sclx');
$array=array();
$i=0;
while($row=mssql_fetch_array($result)){
    foreach ($row as $k=>$v){
        if(is_string($k)){
            $array[$i][$k]=$v;
        }
    }
    $i++;
}
//print_r($array);

try {
   $dbh=new PDO("mssql:host={$dbhost};dbname={$dbname}",$dbuser,$dbpw);
   foreach ($dbh->query('select * from dg_sclx') as $row) {
      //print_r($row);
   }
   $dbh = null;
} catch (PDOException $e) {
   //print "Error!: " . $e->getMessage() . "<br/>";
   die();
}

 

oracle测试连接数据:

 

$dbname='//'.'192.168.6.8'.'/'.'orcl';
$conn=oci_connect('dc_cjh','dccjh123456','192.168.6.8/orcl','utf-8');
$stmt = oci_parse($conn,'select * from dc_bolansd');
oci_execute($stmt);
while($row=oci_fetch_array($stmt,OCI_ASSOC+OCI_RETURN_LOBS)){
 $qustionresult[]=$row; 
}
oci_close($conn);
print_r($qustionresult);