tlangelani / sybase-database
此软件包的最新版本(v1.0.1)没有可用的许可证信息。
适用于Sybase/SAP ASE的简单数据库软件包
v1.0.1
2015-07-23 13:22 UTC
Requires
- php: >=5.3.0
This package is not auto-updated.
Last update: 2024-10-02 09:59:29 UTC
README
此软件包允许您将PHP应用程序连接到Sybase/SAP ASE数据库。
这假设您已经使用Sybase客户端库或FreeTDS库安装了PHP sybase_ct扩展。
用法
// add Sybase class to your project, you can use composer autoload as well require 'Sybase.php'; use Tlangelani\Database\Sybase; // initialize Sybase with credentials. // NB: DEV_HOST must be configured in your Sybase interfaces file, or freetds conf file. $sybase = new Sybase('DEV_HOST', 'DEV_DB', 'USER', 'PASS'); // list databases $dbs = $sybase->getDB(); // list database tables $tables = $sybase->getTables('live_db'); // list table columns $columns = $sybase->getTableColumns('users'); // run query $users = $sybase->query('SELECT * FROM users'); // run query with and return data as object $users = $sybase->query('SELECT * FROM users', 'OBJ');