function CreateDatabase()
{
global $dcl_domain_info, $dcl_domain;
$conn = sybase_connect($dcl_domain_info[$dcl_domain]['dbHost'], $dcl_domain_info[$dcl_domain]['dbUser'], $dcl_domain_info[$dcl_domain]['dbPassword']);
$query = sprintf('Create Database %s', $dcl_domain_info[$dcl_domain]['dbName']);
return sybase_query($query, $conn) > 0;
}
/**
* Connect
*
* @param bool reconnect default FALSE
* @return bool success
* @throws rdbms.SQLConnectException
*/
public function connect($reconnect = false)
{
if (is_resource($this->handle)) {
return true;
}
// Already connected
if (!$reconnect && false === $this->handle) {
return false;
}
// Previously failed connecting
$this->_obs && $this->notifyObservers(new \rdbms\DBEvent(\rdbms\DBEvent::CONNECT, $reconnect));
if ($this->flags & DB_PERSISTENT) {
$this->handle = sybase_pconnect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword(), 'utf8');
} else {
$this->handle = sybase_connect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword(), 'utf8');
}
if (!is_resource($this->handle)) {
$e = new \rdbms\SQLConnectException(trim(sybase_get_last_message()), $this->dsn);
\xp::gc(__FILE__);
throw $e;
}
\xp::gc(__FILE__);
$this->_obs && $this->notifyObservers(new \rdbms\DBEvent(\rdbms\DBEvent::CONNECTED, $reconnect));
return parent::connect();
}
function __construct()
{
// Load Configuration for this Module
global $configArray;
$this->hipUrl = $configArray['Catalog']['hipUrl'];
$this->hipProfile = $configArray['Catalog']['hipProfile'];
$this->selfRegProfile = $configArray['Catalog']['selfRegProfile'];
// Connect to database
if (!isset($configArray['Catalog']['useDb']) || $configArray['Catalog']['useDb'] == true) {
try {
if (strcasecmp($configArray['System']['operatingSystem'], 'windows') == 0) {
sybase_min_client_severity(11);
$this->db = @sybase_connect($configArray['Catalog']['database'], $configArray['Catalog']['username'], $configArray['Catalog']['password']);
} else {
$this->db = mssql_connect($configArray['Catalog']['host'] . ':' . $configArray['Catalog']['port'], $configArray['Catalog']['username'], $configArray['Catalog']['password']);
// Select the database
mssql_select_db($configArray['Catalog']['database']);
}
} catch (Exception $e) {
global $logger;
$logger->log("Could not load Horizon database", PEAR_LOG_ERR);
}
} else {
$this->useDb = false;
}
}
/**
* Non-persistent database connection
*
* @access private called by the base class
* @return resource
*/
function db_connect()
{
if ($this->port != '') {
$this->hostname .= ',' . $this->port;
}
return @sybase_connect($this->hostname, $this->username, $this->password);
}
protected function getDB()
{
$link = @sybase_connect('sulcmis3', 'sa', '*****') or die("不能连接数据库!");
//连接数据库，第一空必须写服务名称，不能是ip;
$db = @sybase_select_db("sulcmis", $link) or die("数据库没有选择");
echo "getDB";
echo $link;
return $link;
}
function db_sybase($host, $user, $passwd, $db = null)
{
$this->db_name = $db;
$this->db_user = $user;
$this->db_passwd = $passwd;
$this->db_host = $host;
$this->db_link_ptr = sybase_connect($host, $user, $passwd) or die("Couldn't connect to Sybase Server on {$host}");
$this->dbhandler = @sybase_select_db($db);
}
public function connect($config = array())
{
$this->config = $config;
$this->connect = $this->config['pconnect'] === true ? @sybase_pconnect($this->config['host'], $this->config['user'], $this->config['password'], $this->config['charset'], $this->config['appname']) : @sybase_connect($this->config['host'], $this->config['user'], $this->config['password'], $this->config['charset'], $this->config['appname']);
if (empty($this->connect)) {
die(getErrorMessage('Database', 'mysqlConnectError'));
}
sybase_select_db($this->config['database'], $this->connect);
}
function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
{
$this->_connectionID = sybase_connect($argHostname, $argUsername, $argPassword);
if ($this->_connectionID === false) {
return false;
}
if ($argDatabasename) {
return $this->SelectDB($argDatabasename);
}
return true;
}
/**
* Connects to the database using options in the given configuration array.
*
* @return boolean True if the database could be connected, else false
*/
function connect()
{
$config = $this->config;
$this->connected = false;
if (!$config['persistent']) {
$this->connection = sybase_connect($config['host'], $config['login'], $config['password'], true);
} else {
$this->connection = sybase_pconnect($config['host'], $config['login'], $config['password']);
}
if (sybase_select_db($config['database'], $this->connection)) {
$this->connected = true;
}
return $this->connected;
}
/**
* Connects to the database using options in the given configuration array.
*
* @return boolean True if the database could be connected, else false
*/
function connect()
{
$config = $this->config;
$port = '';
if ($config['port'] !== null) {
$port = ':' . $config['port'];
}
if ($config['persistent']) {
$this->connection = sybase_pconnect($config['host'] . $port, $config['login'], $config['password']);
} else {
$this->connection = sybase_connect($config['host'] . $port, $config['login'], $config['password'], true);
}
$this->connected = sybase_select_db($config['database'], $this->connection);
return $this->connected;
}
/**
* Connect to the database server and select the database
*/
protected function connect()
{
$strHost = $GLOBALS['TL_CONFIG']['dbHost'];
if ($GLOBALS['TL_CONFIG']['dbPort']) {
$strHost .= ':' . $GLOBALS['TL_CONFIG']['dbPort'];
}
if ($GLOBALS['TL_CONFIG']['dbPconnect']) {
$this->resConnection = @sybase_pconnect($strHost, $GLOBALS['TL_CONFIG']['dbUser'], $GLOBALS['TL_CONFIG']['dbPass'], $GLOBALS['TL_CONFIG']['dbCharset']);
} else {
$this->resConnection = @sybase_connect($strHost, $GLOBALS['TL_CONFIG']['dbUser'], $GLOBALS['TL_CONFIG']['dbPass'], $GLOBALS['TL_CONFIG']['dbCharset']);
}
if (is_resource($this->resConnection)) {
@sybase_select_db($GLOBALS['TL_CONFIG']['dbDatabase']);
}
}
function connect($dbuser = '', $dbpassword = '', $dbhost = 'localhost')
{
global $ezsql_sybase_str;
$return_val = false;
// Must have a user and a password
if (!$dbuser) {
$this->register_error($ezsql_sybase_str[1] . ' in ' . __FILE__ . ' on line ' . __LINE__);
$this->show_errors ? trigger_error($ezsql_sybase_str[1], E_USER_WARNING) : null;
} else {
if (!($this->dbh = @sybase_connect($dbhost, $dbuser, $dbpassword))) {
$this->register_error($ezsql_sybase_str[2] . ' in ' . __FILE__ . ' on line ' . __LINE__);
$this->show_errors ? trigger_error($ezsql_sybase_str[2], E_USER_WARNING) : null;
} else {
$this->dbuser = $dbuser;
$this->dbpassword = $dbpassword;
$this->dbhost = $dbhost;
$return_val = true;
}
}
return $return_val;
}
/**
* Connect
*
* @param bool reconnect default FALSE
* @return bool success
* @throws rdbms.SQLConnectException
*/
public function connect($reconnect = FALSE)
{
if (is_resource($this->handle)) {
return TRUE;
}
// Already connected
if (!$reconnect && FALSE === $this->handle) {
return FALSE;
}
// Previously failed connecting
if ($this->flags & DB_PERSISTENT) {
$this->handle = sybase_pconnect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword(), 'iso_1');
} else {
$this->handle = sybase_connect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword(), 'iso_1');
}
if (!is_resource($this->handle)) {
$e = new SQLConnectException(trim(sybase_get_last_message()), $this->dsn);
xp::gc(__FILE__);
throw $e;
}
xp::gc(__FILE__);
$this->_obs && $this->notifyObservers(new DBEvent(__FUNCTION__, $reconnect));
return parent::connect();
}
function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
{
if (!function_exists('sybase_connect')) return null;
if ($this->charSet) {
$this->_connectionID = sybase_connect($argHostname,$argUsername,$argPassword, $this->charSet);
} else {
$this->_connectionID = sybase_connect($argHostname,$argUsername,$argPassword);
}
$this->_connectionID = sybase_connect($argHostname,$argUsername,$argPassword);
if ($this->_connectionID === false) return false;
if ($argDatabasename) return $this->SelectDB($argDatabasename);
return true;
}
function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
{
if (!function_exists('sybase_connect')) {
return null;
}
$this->_connectionID = sybase_connect($argHostname, $argUsername, $argPassword);
if ($this->_connectionID === false) {
return false;
}
if ($argDatabasename) {
return $this->selectDB($argDatabasename);
}
return true;
}
function db_connect()
{
global $base_host, $base_port, $base_name, $base_user, $base_pass, $base, $conn, $charset;
$RST = '';
if ($base == 'pgsql') {
$conn = "host=" . $base_host . " port=" . $base_port . " dbname=" . $base_name . " user="******" password="******"";
$db = pg_connect($conn);
}
if ($base == 'mysqlPDO') {
//$conn=mysql_connect($base_host,$base_user,$base_pass) or die ("Erro de Conexao !");
$txt = 'mysql:host=' . $base_host . ';dbname=' . $base_name . ';charset=utf8';
//.$charset;
$conn = new PDO($txt, $base_user, $base_pass);
//$banco=mysql_select_db(trim($base_name),$conn) or die ("Erro ao Selecionar o Banco !");
$RST = 'MYSQL';
}
if ($base == 'mysql') {
$conn = mysql_connect($base_host, $base_user, $base_pass) or die("Erro de Conexao !");
$banco = mysql_select_db(trim($base_name), $conn) or die("Erro ao Selecionar o Banco !");
$RST = 'MYSQL';
}
if ($base == 'mssql') {
$conn = mssql_connect($base_host, $base_user, $base_pass) or die("Erro de Conex�o !");
$banco = mssql_select_db($base_name, $conn) or die("Erro ao Selecionar o Banco !");
$RST = 'MSSQL';
}
if ($base == 'sybase') {
$conn = sybase_connect($base_host, $base_user, $base_pass) or die("Erro de Conex�o !");
$banco = sybase_select_db($base_name, $conn) or die("Erro ao Selecionar o Banco !");
$RST = 'MSSQL';
}
return $RST;
}
function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {
case "MySQL":
$dbi = @mysql_connect($host, $user, $password);
mysql_select_db($db);
return $dbi;
break;
case "mSQL":
$dbi = msql_connect($host);
msql_select_db($db);
return $dbi;
break;
case "postgres":
$dbi = @pg_connect("host={$host} user={$user} password={$password} port=5432 dbname={$db}");
return $dbi;
break;
case "postgres_local":
$dbi = @pg_connect("user={$user} password={$password} dbname={$db}");
return $dbi;
break;
case "ODBC":
$dbi = @odbc_connect($db, $user, $password);
return $dbi;
break;
case "ODBC_Adabas":
$dbi = @odbc_connect($host . ":" . $db, $user, $password);
return $dbi;
break;
case "Interbase":
$dbi = @ibase_connect($host . ":" . $db, $user, $password);
return $dbi;
break;
case "Sybase":
$dbi = @sybase_connect($host, $user, $password);
sybase_select_db($db, $dbi);
return $dbi;
break;
default:
break;
}
}
/**
* Initialize the driver.
*
* Validate configuration and perform all resource-intensive tasks needed to
* make the driver active.
*
* @throws ILSException
* @return void
*/
public function init()
{
parent::init();
// initialize DAIA parent
if (isset($this->config['Catalog']['opaciln'])) {
$this->opaciln = $this->config['Catalog']['opaciln'];
}
if (isset($this->config['Catalog']['opacfno'])) {
$this->opacfno = $this->config['Catalog']['opacfno'];
}
if (isset($this->config['Catalog']['opcloan'])) {
$this->opcloan = $this->config['Catalog']['opcloan'];
}
if (isset($this->config['Catalog']['database'])) {
putenv("SYBASE=" . $this->config['Catalog']['sybpath']);
$this->db = sybase_connect($this->config['Catalog']['sybase'], $this->config['Catalog']['username'], $this->config['Catalog']['password']);
sybase_select_db($this->config['Catalog']['database']);
} else {
throw new ILSException('No Database.');
}
}
protected function connect(&$username, &$password, &$driver_options)
{
$host = isset($this->dsn['host']) ? $this->dsn['host'] : 'SYBASE';
$dbname = isset($this->dsn['dbname']) ? $this->dsn['dbname'] : '';
$charset = isset($this->dsn['charset']) ? intval($this->dsn['charset']) : '';
if (isset($driver_options[PDO::ATTR_PERSISTENT]) && $driver_options[PDO::ATTR_PERSISTENT]) {
$this->link = @sybase_pconnect($host, $username, $password, $charset);
} else {
// hope this opens a new connection every time
$app_name = uniqid('phppdo_');
$this->link = @sybase_connect($host, $username, $password, $charset, $app_name);
}
if (!$this->link) {
$this->set_driver_error('28000', PDO::ERRMODE_EXCEPTION, '__construct');
}
if ($dbname) {
if (!@sybase_select_db($dbname, $this->link)) {
$this->set_driver_error(null, PDO::ERRMODE_EXCEPTION, '__construct');
}
}
}
<?php
//phpinfo();
$link = @sybase_connect('lltang2000', 'sa', '******') or die("Could not connect !");
//连接数据库，第一空必须写服务名称，不能是ip;
echo "Connected successfully<br>";
$db = @sybase_select_db("sulcmis", $link) or die("数据库没有选择");
echo "数据库选择成功<br>";
$sql = "select ctrlNo,F200,F210c from b_brief where ctrlNo<100";
$rs = sybase_query($sql, $link);
//查询表
if (!$rs) {
echo "SQL:" . $sql . "执行失败！";
exit;
}
//$sybase = sybase_fetch_array($rs);
//print_r($sybase);//结束
echo '<table border="1"><tr><td>CtrlNO</td><td>F200</td><td>F210c</td>';
while ($row = sybase_fetch_array($rs)) {
$id = $row["ctrlNo"];
$F200 = $row["F200"];
$F210c = $row["F210c"];
echo '<tr><td>' . $id . '</td><td>' . $F200 . '</td><td>' . $F210c . '</td></tr>';
}
echo '</table>';
sybase_free_result($rs);
sybase_close($link);
?>
function connect_sybase($host, $user, $pass, $db)
{
$this->sybase_link = sybase_connect($host, $user, $pass);
if ($this->sybase_link == 0) {
return false;
}
if (!sybase_select_db($db, $this->sybase_link)) {
print "Database Error. \n";
return false;
}
return $this->sybase_link;
}
<head>
<title>Prescription médicale</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link href="../stylePrint.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?php
// Récupération des données du patient
$queryPat = "SELECT * FROM patient_admin INNER JOIN patient_treat ON patient_admin.idStluc=patient_treat.idStluc WHERE patient_admin.idStluc='{$_SESSION['idPatStluc']}' AND patient_treat.volcible='{$_SESSION['volcible']}' AND patient_treat.req='{$_SESSION['req']}' AND patient_treat.ptv='{$_SESSION['ptv']}' AND patient_treat.plan='{$_SESSION['plan']}' AND patient_treat.status='{$_SESSION['statusPat']}'";
$resultPat = mysql_query($queryPat);
$coordPat = mysql_fetch_array($resultPat);
//echo "TEST<pre>"; print_r($coordPat); echo "</pre>";
//recherche des infos autres sur le patient dans VISIR
$link = sybase_connect('10.96.4.201:5000', 'visiruse', 'visirdb') or die("Impossible de se connecter !");
//print ("Connexion établie");
sybase_select_db("visir");
//Va falloir trouver qque chose pour récupérer le PIDno du patient dans Visir ...
$pidno = $coordPat[idStluc];
//requete sur les coordonnées -- (patient.Lastname='$coordPat[lastname]') AND AND (patient.Firstname='$coordPat[firstname]')
$queryCOORD = "SELECT patient.Tel1, patient.Tel2, patient.Tel3, patient.PersNo, patient.BirthDate FROM patient\n\t\t\tWHERE ( (patient.PIDno={$pidno}))";
//echo $queryCOORD;
$requeteCOORD = sybase_query($queryCOORD, $link);
//while($row=sybase_fetch_array($requeteCOORD)) {
$row = sybase_fetch_array($requeteCOORD);
//echo "TEST<pre>"; print_r($row); echo "</pre>";
$tel1 = $row[Tel1];
$tel2 = $row[Tel2];
$tel3 = $row[Tel3];
$persno = $row[PersNo];
<?php
ini_set('display_errors', true);
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT);
require_once 'bootstrap.php';
global $configArray;
global $logger;
try {
if (strcasecmp($configArray['System']['operatingSystem'], 'windows') == 0) {
sybase_min_client_severity(11);
$db = @sybase_connect($configArray['Catalog']['database'], $configArray['Catalog']['username'], $configArray['Catalog']['password']);
} else {
$db = mssql_connect($configArray['Catalog']['host'] . ':' . $configArray['Catalog']['port'], $configArray['Catalog']['username'], $configArray['Catalog']['password']);
// Select the database
mssql_select_db($configArray['Catalog']['database']);
}
echo "Connected to Horizon Database correctly";
} catch (Exception $e) {
echo "Could not load Horizon database ";
echo $e;
}
function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
{
if (!function_exists('sybase_connect')) {
return null;
}
// Sybase connection on custom port
if ($this->port) {
$argHostname .= ':' . $this->port;
}
if ($this->charSet) {
$this->_connectionID = sybase_connect($argHostname, $argUsername, $argPassword, $this->charSet);
} else {
$this->_connectionID = sybase_connect($argHostname, $argUsername, $argPassword);
}
if ($this->_connectionID === false) {
return false;
}
if ($argDatabasename) {
return $this->SelectDB($argDatabasename);
}
return true;
}
function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {
case "MySQL":
$dbi = @mysql_connect($host, $user, $password);
if (!mysql_select_db($db)) {
mysql_query("CREATE DATABASE {$db}");
mysql_select_db($db);
include 'install.php';
die;
}
return $dbi;
break;
case "mSQL":
$dbi = msql_connect($host);
if (!msql_select_db($db)) {
msql_query("CREATE DATABASE {$db}");
msql_select_db($db);
include 'install.php';
die;
}
return $dbi;
break;
case "PostgreSQL":
$dbi = @pg_connect("host={$host} user={$user} password={$password} port=5432 dbname={$db}");
return $dbi;
break;
case "PostgreSQL_local":
$dbi = @pg_connect("user={$user} password={$password} dbname={$db}");
return $dbi;
break;
case "ODBC":
$dbi = @odbc_connect($db, $user, $password);
return $dbi;
break;
case "ODBC_Adabas":
$dbi = @odbc_connect($host . ":" . $db, $user, $password);
return $dbi;
break;
case "Interbase":
$dbi = @ibase_connect($host . ":" . $db, $user, $password);
return $dbi;
break;
case "Sybase":
$dbi = @sybase_connect($host, $user, $password);
if (!sybase_select_db($db, $dbi)) {
sybase_query("CREATE DATABASE {$db}", $dbi);
sybase_select_db($db, $dbi);
include 'install.php';
die;
}
return $dbi;
break;
default:
break;
}
}
public function open($name, $username, $password, $db, $charset)
{
$this->link = @sybase_connect($name, $username, $password, $charset) or die("sybase link defail");
$this->db = @sybase_select_db($db, $this->link) or die("数据库没有选择");
}
<html>
<body bgcolor=white>
<?php
$dbproc = sybase_connect("JDBC", "guest", "sybase");
if (!$dbproc) {
return;
}
$res = sybase_query("select * from test", $dbproc);
if (!$res) {
return;
}
while ($arr = sybase_fetch_array($res)) {
print $arr["i"] . " " . $arr["v"] . "<br>\n";
}
?>
</body>
</html>
