CXLIII. Sybase Functions

简介

需求

安装

To enable Sybase-DB support configure PHP --with-sybase[=DIR]. DIR is the Sybase home directory, defaults to /home/sybase. To enable Sybase-CT support configure PHP --with-sybase-ct[=DIR]. DIR is the Sybase home directory, defaults to /home/sybase.

运行时配置

这些函数的行为受 php.ini 的影响。

表格 1. Sybase configuration options

Name	Default	Changeable	Changelog
sybase.allow_persistent	"1"	PHP_INI_ALL	Available since PHP 4.0.3.
sybase.max_persistent	"-1"	PHP_INI_ALL	Available since PHP 4.0.3.
sybase.max_links	"-1"	PHP_INI_ALL	Available since PHP 4.0.3.
sybase.interface_file	"/usr/sybase/interfaces"	PHP_INI_SYSTEM
sybase.min_error_severity	"10"	PHP_INI_ALL
sybase.min_message_severity	"10"	PHP_INI_ALL
sybase.compatability_mode	"0"	PHP_INI_ALL
magic_quotes_sybase	"0"	PHP_INI_ALL

以下是配置选项的简要解释。

sybase.allow_persistent boolean: Whether to allow persistent Sybase connections.
sybase.max_persistent integer: The maximum number of persistent Sybase connections per process. -1 means no limit.
sybase.max_links integer: The maximum number of Sybase connections per process, including persistent connections. -1 means no limit.
sybase.min_error_severity integer: Minimum error severity to display.
sybase.min_message_severity integer: Minimum message severity to display.
sybase.compatability_mode boolean: Compatibility mode with old versions of PHP 3.0. If on, this will cause PHP to automatically assign types to results according to their Sybase type, instead of treating them all as strings. This compatibility mode will probably not stay around forever, so try applying whatever necessary changes to your code, and turn it off.
magic_quotes_sybase boolean: If magic_quotes_sybase is on, a single-quote is escaped with a single-quote instead of a backslash if magic_quotes_gpc or magic_quotes_runtime are enabled.
注: Note that when magic_quotes_sybase is ON it completely overrides magic_quotes_gpc. In this case even when magic_quotes_gpc is enabled neither double quotes, backslashes or NUL's will be escaped.

表格 2. Sybase-CT configuration options

Name	Default	Changeable	Changelog
sybct.allow_persistent	"1"	PHP_INI_SYSTEM	Available since PHP 4.0.4.
sybct.max_persistent	"-1"	PHP_INI_SYSTEM	Available since PHP 4.0.4.
sybct.max_links	"-1"	PHP_INI_SYSTEM	Available since PHP 4.0.4.
sybct.min_server_severity	"10"	PHP_INI_ALL	Available since PHP 4.0.4.
sybct.min_client_severity	"10"	PHP_INI_ALL	Available since PHP 4.0.4.
sybct.hostname	NULL	PHP_INI_ALL	Available since PHP 4.0.4.
sybct.deadlock_retry_count	"0"	PHP_INI_ALL	Available since PHP 4.3.0.

以下是配置选项的简要解释。

sybct.allow_persistent boolean: Whether to allow persistent Sybase-CT connections. The default is on.
sybct.max_persistent integer: The maximum number of persistent Sybase-CT connections per process. The default is -1 meaning unlimited.
sybct.max_links integer: The maximum number of Sybase-CT connections per process, including persistent connections. The default is -1 meaning unlimited.
sybct.min_server_severity integer: Server messages with severity greater than or equal to sybct.min_server_severity will be reported as warnings. This value can also be set from a script by calling sybase_min_server_severity(). The default is 10 which reports errors of information severity or greater.
sybct.min_client_severity integer: Client library messages with severity greater than or equal to sybct.min_client_severity will be reported as warnings. This value can also be set from a script by calling sybase_min_client_severity(). The default is 10 which effectively disables reporting.
sybct.login_timeout integer: The maximum time in seconds to wait for a connection attempt to succeed before returning failure. Note that if max_execution_time has been exceeded when a connection attempt times out, your script will be terminated before it can take action on failure. The default is one minute.
sybct.timeout integer: The maximum time in seconds to wait for a select_db or query operation to succeed before returning failure. Note that if max_execution_time has been exceeded when an operation times out, your script will be terminated before it can take action on failure. The default is no limit.
sybct.hostname string: The name of the host you claim to be connecting from, for display by sp_who. The default is none.
sybct.deadlock_retry_count int: Allows you to define how often deadlocks are to be retried. The default is -1, or "forever".

有关 PHP_INI_* 常量进一步的细节与定义参见附录 G。

资源类型

预定义常量

本扩展模块未定义任何常量。

目录
sybase_affected_rows -- Gets number of affected rows in last query
sybase_close -- Closes a Sybase connection
sybase_connect -- Opens a Sybase server connection
sybase_data_seek -- Moves internal row pointer
sybase_deadlock_retry_count -- Sets the deadlock retry count
sybase_fetch_array -- Fetch row as array
sybase_fetch_assoc -- Fetch a result row as an associative array
sybase_fetch_field -- Get field information from a result
sybase_fetch_object -- Fetch a row as an object
sybase_fetch_row -- Get a result row as an enumerated array
sybase_field_seek -- Sets field offset
sybase_free_result -- Frees result memory
sybase_get_last_message -- Returns the last message from the server
sybase_min_client_severity -- Sets minimum client severity
sybase_min_error_severity -- Sets minimum error severity
sybase_min_message_severity -- Sets minimum message severity
sybase_min_server_severity -- Sets minimum server severity
sybase_num_fields -- Gets the number of fields in a result set
sybase_num_rows -- Get number of rows in a result set
sybase_pconnect -- Open persistent Sybase connection
sybase_query -- Sends a Sybase query
sybase_result -- Get result data
sybase_select_db -- Selects a Sybase database
sybase_set_message_handler -- Sets the handler called when a server message is raised
sybase_unbuffered_query -- Send a Sybase query and do not block

add a note User Contributed Notes

sean dot healey at bayernlb dot co dot uk
28-Oct-2005 06:42


I've finally got PHP 5.0.5 running under Apache2 on Solaris 8 ... connecting to Sybase ASE servers 12.0 and 12.5 using CT-LIB 12.5.



The following was my build procedure -



Build Apache:



./configure \

  --prefix=/usr/local/apache2 \

  --enable-so



make

make install



Edit httpd.conf, adjusting directives to suit the local environment.



Following advice given above, update the Sybase version string in the PHP sybase_ct module header file:



vi /var/build/php-5.0.5/ext/sybase_ct/php_sybase_ct.h



change this line ...

#define CTLIB_VERSION CS_VERSION_100

...to...

#define CTLIB_VERSION CS_VERSION_125



Build PHP:



SYBASE=/..../..../sybase12_5  <<-- path to your Sybase distribution root

SYBASE_OCS=OCS-12_5

LD_LIBRARY_PATH=$SYBASE/$SYBASE_OCS/lib



export SYBASE SYBASE_OCS PATH LD_LIBRARY_PATH



./configure \

  --prefix=/usr/local/php \

  --with-sybase-ct=$SYBASE/$SYBASE_OCS \

  --enable-static=sybase-ct \

  --with-apxs2=/usr/local/apache2/bin/apxs \

  --enable-sysvmsg \

  --enable-sysvsem \

  --enable-sysvshm



make

make test



NOTE: 'make test' will almost certainly fail all of the Sybase functionality, unless you update the test include file to use valid connectivity details for your local server:



vi /var/build/php-5.0.5/ext/sybase_ct/tests/test.inc



  // Change if needed

  define('HOST',     '****');

  define('USER',     '****');

  define('PASSWORD', '****');



make install



Edit Apache's httpd.conf file to associate .php files with a MIME type:



  #

  # PHP script support

  #

  AddType application/x-httpd-php .php .phtml

  AddType application/x-httpd-php-source .phps



Edit the apachectl script, inserting the following variable declarations after environment variables are imported:



  SYBASE=/..../..../sybase12_5

  SYBASE_OCS=OCS-12_5

  LD_LIBRARY_PATH=$SYBASE/$SYBASE_OCS/lib:$LD_LIBRARY_PATH

  export SYBASE SYBASE_OCS LD_LIBRARY_PATH



Ensure you have an 'interfaces' file in the root of your sybase distribution (Above the OCS-12_5 subdirectory), containing a server entry in the following format for each server you want to connect to:



  dataservername_ds

   <tab> master tcp ether <hostname> <port>

   <tab> query tcp ether <hostname> <port>



(if this is your dataserver machine, there will be at least 1 entry already for the local dataserver. It is advisable to install all of the above on a separate machine though, with its own copy of the sybase client)



Cross fingers, and:



apachectl start



If you get 'relocation' errors when starting Apache with the php module configured to load, check the output of 'ldd libphp5.so'. Each of the Sybase libraries should link to files under your Sybase client distribution:



ldd /usr/local/apache2/modules/libphp5.so 

    libtcl.so =>     /.../sybase12_5/OCS-12_5/lib/libtcl.so

    libintl.so.1 => /.../sybase12_5/OCS-12_5/lib/libintl.so.1

    libcomn.so => /.../sybase12_5/OCS-12_5/lib/libcomn.so

    libct.so =>      /.../sybase12_5/OCS-12_5/lib/libct.so

    libcs.so =>      /.../sybase12_5/OCS-12_5/lib/libcs.so

    ...

   <snip other libraries>

    ...



If you see 'libintl.so' linking anywhere else, this is likely because the PHP build has incorrectly linked to a slightly different filename - libintl.so.1 - which doesn't exist in the Sybase client. Unfortunately a completely unrelated library of the same name does exist elsewhere in Unix! (Apparently the Sybase version was created before the duplicate was introduced into Unix).



My workaround was to create the following symlink in sybase client library 'lib' directory -



  libintl.so.1 -> ./libintl.so*



'make distclean' in your PHP build directory, and repeat the build as above.

zeldorblat at gmail dot com
19-Sep-2005 04:43


In response to the post by jon dot bertsch at ucop dot edu, it is possible to install both the FreeTDS libraries and the Sybase libraries.  The problem is that the Sybase extension alias's its function names to the mssql_ functions.



Take a look in your PHP source directory under /ext/sybase_ct/php_sybase_ct.c near the top where the sybase_functions[] declaration is.  You can comment out the part that alias's the function names, recompile with FreeTDS and Sybase, and you're all set!

jon dot bertsch at ucop dot edu
25-Jun-2005 02:41


Up to php 5.0.4 you cannot install both sybase and mssql (they use the same function names). It turns out though that if you use the Freetds library you can connect to sybase using the mssql functions (and visa versa I assume). Setup your servers in the freetds.conf file (for sybase use specify version 5.0, for mssql 7 or 8.0) and call the database connection as you would with mssql (mssql_conect). You should be able to connect either sql server or sybase. I don't know if all sybase functions will work as expected but basic querying is succesful. Hope this helps someone.

punkarruso at despammed dot com
14-Dec-2004 09:50


I just want to report that, like explained in bug #27562, selective stored procedures (like sp_helpdb) don't return a resultset with freeTDS >= 0.62. (using php <= 4.3.9)

If you have installed such releases of freeTDS, downgrade to 0.61.x.

matt dot sawyer at gmail dot com
01-Dec-2004 12:46


I've noticed (after days of frustration) that setting the sybase.interface_file to a location other than the default ($SYBASE/interfaces) in php.ini doesn't always work.  I finally gave up and copied my interface entries to the default location, and it works consistently now.  (This is even with sybase.interface_file still set to the non-default location).

greg dot fenton at ianywhere dot com
23-Nov-2004 06:07


For Sybase/iAnywhere SQL Anywhere (a.k.a Adaptive Server Anywhere, a.k.a. ASA), you likely should try the SQLAnywhere PHP module [which now ships with ASA as of 9.0.2]:



    http://www.ianywhere.com/developer/code_samples/sqlany_php_module.html



ASA can work with TDS (Open Client), but if performance is something you care about you likely want to use the native ASA interface.  For info/help, consider posting to sybase.public.sqlanywhere.general or sybase.public.sqlanywhere.linux  (http://www.ianywhere.com/support/newsgroups.html)



Hope this helps,

greg.fenton

info(at)sovall(dot)cz
04-Aug-2004 07:10


This is way to compile Sybase ASE 12.5 with PHP5.0.0 and Apache 2 on Linux:

- install apache

- install ase1252_de_linux.tgz to /opt/sybase-12.5

- shell:# ln -s /opt/sybase-12.5 /opt/sybase

- edit phpsrc/configure and remove all '-linsck'

- edit phpsrc/ext/sybase-ct/php_sybase_ct.h and change CTLIB_VERSION CS_VERSION_100 to 125

- shell:# export SYBASE=/opt/sybase

- phpsrc/configure --with-sybase-ct=/opt/sybase/OCS-12_5

- phpsrc/make and make install

- edit apache2/conf/httpd.conf and add AddType... .php

- create /opt/sybase/interfaces file

SERVERNAME

[tab!]master tcp ether ipAddress port

[tab!]query tcp ether ipAddress port

- apache2/bin/apachectl start



I hope, that I save your time.

1rsv_sign_mail.ru (stas_aka_rsv)
24-Mar-2004 02:20


There is a way how to force php work with both php_mssql.dll and php_sybase_ct.dll. Just open php_sybase_ct.dll in any editor (dont use MS WORD :0) ) and replace all "mssql_" on something like that "masql_".

After that there will not be warnings about double function definitions and php can use php_sybase_ct.dll to access to sybase and php_mssql.dll to access to mssql.

The reason why I did such thing is that I couldnt connect to mssql using php_sybase_ct.dll.

ms at klmoberg dot no
15-Mar-2004 09:10


I solved my connection problems by setting ENV variables directly in PHP.



putenv ("SYBASE=/opt/sybase");

putenv ("SYBPLATFORM=linux");

putenv ("LD_LIBRARY_PATH=/opt/sybase/lib"); 

putenv ("LC_ALL=default");

putenv ("PATH=\"/opt/sybase/bin:$PATH\"");

putenv ("DSQUERY=SYBASE");



--

Martin Sarajervi

ddc at portalframework dot com
07-Oct-2002 09:05


If you would like to use the wide table support of Sybase ASE 12.5, take advantage of XML/XQL embedded in the database and use varchars of more than 255 char, you'll need to recompile PHP changing this line in the

    php_sybase_ct.h file:



From:



#define CTLIB_VERSION CS_VERSION_100



To:



#define CTLIB_VERSION CS_VERSION_125



This will only run if you have installed Sybase ASE Open Client v. 12.5 and configured PHP telling it where the OCS is... (./configure --with-sybase-ct=$SYBASE_HOME/OCS [...])



--

Diego Dal Cero.

aj at bootsector dot org
05-Sep-2002 05:10


A note for all who may be struggling...  Microsoft did away with the ct-lib support in SQL Server 2000.



I played with it and found a couple of articles related to it on google.  A workaround/different method would be preferrable.  Anybody?

AnatolyKoval at hotmail dot com
17-Jun-2002 06:25


The way to use Sybase Adaptive Server Anywhere+PHP+Apache on Unix http://www.sybase.com/detail?id=1019695

ddc at portalframework.com
15-May-2002 02:19


Compiling PHP with Sybase ASE 12.5 on Linux.



Assuming that you have installed the Sybase ASE 12.5 client in linux, and you have the SYBASE env variable set, you can compile PHP >= 4.0.6 with Sybase ASE 12.5.

Just use:



  --with-sybase-ct=$SYBASE/OCS

instead of

  --with-sybase-ct=$SYBASE

elee at kinwai dot net
15-Apr-2002 05:28


Freetds 5.2 bugs!!



For those who use Freetds 5.2 running under linux connect to sqlserver2000, there is a bugs in selecting NVARCHAR field that data will either duplicated or truncated. To avoid this problem, please use CAST or CONVERT function in sql statement such as:

$query="select CAST(fieldname as nchar(1000)) as fieldname from table"



Feel free to contact us at 

aikok@netfront.net

or

elee@kinwai.net



German Chu & Eagle Lee

rudolf at 1stomni dot com
28-Feb-2002 04:44


PhpSybaseAdmin

http://freshmeat.net/projects/phpsybaseadmin/

basilio_mail at chat dot ru
26-Oct-2001 06:56


For those, who might want to use SyBase client not only under Linux, you may try to use open-source FreeTDS library - http://www.freetds.org 





Also there's how-to for FreeTDS and PHP:


http://www.freetds.org/userguide/php.html

borreo at softhome dot net
15-Sep-2001 02:29


If you have a Linux machine with Sybase ASE 11.9.2, Php 4.0.6, Apache and Sybase-ct library, don't upgrade to Sybase ASE 12.5 yet, or Apache will stop working.


Since 12.5 is newer than 4.0.6, I guess this will be fixed soon.

borreo at softhome dot net
15-Sep-2001 02:22


If you use IIS and sybase-ct library, be sure to use PHP 4.0.6 or higher, since older version caused crashes.

rbuico at ntep dot nec dot co dot jp
28-Aug-2001 11:54


maybe it can help.


my database is ASE





this is my script....





<?


$cnn = sybase_connect("db_server","sa","password");


$result = sybase_query("Select itemno,stockno from your_db..your_table");


$i = 0;


while ($r = sybase_fetch_array($result)) {


$i++;


$itemno = $r["itemno"];


$stockno = $r["stockno"];


echo "$i    $stockno   $itemno <br>";


}


?>





note that I did not use the


sybase_select_db("db") function because ASE had a default database.


thx...

mad at dactar dot ch
05-Jul-2001 04:16


The best place to get Sybase for Debian : 





http://www.dactar.ch/sybase

borreo at softhome dot net
28-Jun-2001 09:33


It's important to note that sybase_ct connect or pconnect were causing GPF.


If you experienced this problem, just update PHP to 4.0.6.

heumann at s-und-i dot com
13-Oct-2000 04:17


This should make the image/blob subject rather complete:


PHP 3 seems to have a bug with image columns in sybase. Apache gets a segmentation fault when trying to retrieve an image column with more than a certain amount of characters (even when using set textsize).


The work around is to use text columns instead. They have the same capacity, only you need to convert the data to ASCII (e.g. Hex, see examples in earlier contributions, bin2hex). Remember to put the data in quotes, too, when INSERTing.

koos at kzdoos dot xs4all dot nl
10-Oct-2000 02:20


A bit more about blobs:


<P>


If you want to retrieve blobs without them getting truncated, do a 'set textsize value' query first.

chptma at hydra dot esfm dot ipn dot mx
06-Sep-2000 04:13


about sybase-ct library 





You can download the file from php.net but the samples in the tar (and php) maybe not compile I have this problem in some systems (but not in others with old librarys and old gcc).





Try freetds from www.freetds.org that is ok!





System wthout trouble


Debian 2.1 gcc (2.7.2.3) libc-2.0.7.so


System With trouble


Debian 2.2 gcc (2.95.2) libc-2.1.3.so


RedHat 6.2 gcc [egcs] (2.91.66) libc-2.1.3.so





Please refer to mssql if you try to connect to MS SQL Server!!!

hoadley at xoom dot com
19-Aug-2000 05:41


I would STRONGLY recommend using the ct library over the db library when compiling sybase support with php4+. I ran into strange http child seg faults when trying to issue multiple sql statements in one php page.  Using ct-library there is no problem.

ilya at vtrails dot com
09-Jul-2000 10:03


Amigos, pay attention: sybase_get_last_message() is gone! Read logs or set track_errors=On and use $php_errormsg instead.

james at lasolas dot com
22-Mar-2000 10:28


If you get a segfault with sybase-ct, add a en_US entry to your  $SYBASE/locales/locales.dat file: 


<PRE>


[linux]


    locale = en_US, us_english, iso_1


    ...


</PRE>

ericnewman at aol dot com
07-Mar-2000 05:57


I struggled to get this to work for a week. Here's a tip. Log on to your system using the same login as your web server, probably "nobody". Using this account, make sure you can get isql to work. In my case, I had to change the permissions on the /opt/sybase folder, as well as chmod the /opt/sybase/interfaces file to 644. (It was 600 by default, and did not allow anyone but root to read it.) Once I did this, things started to happen...

tcurdt at dff dot st
02-Mar-2000 05:34


Poor documentation on sybase support!! Here's how I made it work... First get the linux ASE from sybase (maybe the ctlibs provided at php.net will do fine, too) Install the ASE rpm. (some distributions don't have system libs etc in the rpm database so you might get some dependency errors. If your systems fits the requirements install with "ignore dependencies") Recompile php with option --with-sybase-ct=/dirtoyoursybasehome. Then you need to set the env variable for (at least)your apache user by export SYBASE=/dirtoyoursybasehome. Now you need to set up your servers (like DSNs for ODBC). Edit the file $SYBASE/interfaces and add your server entries:





SERVERNAME


  query tcp ether 172.16.1.4 4100


  master tcp ether 172.16.1.4 4100





(change IP/FQHN and port to your setup) Now you can check your config by using 


$SYBASE/bin/isql -S SERVERNAME -U DBUSER -P PASSWD


If you get a prompt you have connected to your sybase! Hurray! Now you can try with php


$db=sybase_connect("SERVERNAME","DBUSER","DBPASSWD");


And... Voila!

Xtof at fromages-et-desserts dot com
21-Feb-2000 02:18


To store an image file into Sybase try this :





$data = bin2hex(fread(fopen($image,"r"), filesize($image)));


//don't forget the 0x before the hex data.


if(! sybase_query("INSERT INTO test_image (image) VALUES (0x".$data.")")) die ("Unable to store the image.");





To retrieve it just do a select and use a hex2bin function (this one has been submitted by carl@five-ten-sg.com and is the fastest) :





function hex2bin($data) {


     $len = strlen($data);


      return pack("H" . $len, $data);


}





PS : use CT-lib rather than DB-lib (Sybase doesn't work on it anymore!)

add a note