<?php
define('HOST', getenv('PHP_SYBASE_HOST'));
define('USER', getenv('PHP_SYBASE_USER'));
define('PASSWORD', getenv('PHP_SYBASE_PASS'));
define('TEMPDB', 'tempdb');
function sybase_msg_handler($msgnumber, $severity, $state, $line, $text) {
printf(
"*** Caught Sybase Server Message #%d [Severity %d, state %d] at line %d\n '%s'\n",
$msgnumber,
$severity,
$state,
$line,
chop($text)
);
}
class sybase {
static function static_handler($msgnumber, $severity, $state, $line, $text) {
return sybase_msg_handler($msgnumber, $severity, $state, $line, $text);
}
function handler($msgnumber, $severity, $state, $line, $text) {
return sybase_msg_handler($msgnumber, $severity, $state, $line, $text);
}
}
function sybase_set_messagehandler_ex($handler) {
var_dump(sybase_set_message_handler($handler));
}
function sybase_connect_ex($charset= NULL, $appname= NULL, $new= FALSE) {
sybase_min_server_severity(11); if (!($db= sybase_connect(HOST, USER, PASSWORD, $charset ? $charset : 'iso_1', $appname, $new))) {
die('Connect to '.USER.'@'.HOST.' failed (using password: '.(PASSWORD ? 'yes' : 'no').')');
}
return $db;
}
function sybase_select_ex($dbh, $query) {
printf(">>> Query: %s\n", $query);
$h= sybase_query($query, $dbh);
printf("<<< Return: %s\n", gettype($h));
flush();
if (!is_resource($h)) return $h;
$return= array();
while ($row= sybase_fetch_assoc($h)) {
$return[]= $row;
}
return $return;
}
function sybase_select_single($dbh, $query) {
$a = sybase_fetch_row(sybase_query($query, $dbh));
return array_shift($a);
}
?>