tlangelani/sybase-database

此软件包的最新版本(v1.0.1)没有可用的许可证信息。

适用于Sybase/SAP ASE的简单数据库软件包

v1.0.1 2015-07-23 13:22 UTC

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');