Connecting with PHP to Sybase on WAMP Server

Sybase is one of those systems that can be sometimes finicky to setup on the client side. I was pleasantly surprised to see that PHP has support for Sybase. When you need to quickly prototype a new feature or give your user’s a quick dynamic report, PHP can be a great path to go.

It took a little research to get all the parts necessary, but the installation is very smooth.

1. Install WAMP
   
2. Install Sybase client (you want the open client; login/pass required)
   
3. Update php.ini to: enable sybase extension (extension=php_sybase_ct.dll)
   
4. specify location of sybase sql.ini file (sybase.interface_file = “c:\sybase\ini\sql.ini”)

To test the connection we can do a simle query against a table: