sql anywhere client

SQLAnywhere客戶端

Sybase 銀行與 sqlanywhere 圖書館的 PHP 庫相關的類別。用於使用 PHP 連接資料庫 Sybase 的類，為 PHP 庫 SqlAnywhere 建立。

開發基於PDO Native Class。

待辦事項：

• 更多測試。

安裝

===================

1- 首先安裝 PHP 的 sqlanywhere 模組，點擊這裡！ 。

2- 使用 Composer 安裝此軟體包，在 require 部分新增以下行require : // ... "require": { "cagartner/SQLAnywhereClient": "dev-master" }, // ...

如何使用

下面有一些如何使用此類的範例。

連接SQLAnywhereClient::__construct ：

 <?php
    require ' ../vendor/autoload.php ' ;

    use Cagartner  SQLAnywhereClient ;

    try {
        $ dns = " uid={user};pwd={password};ENG={database-name};commlinks=tcpip{host={host};port={port}} " ;
        $ con = new SQLAnywhereClient ( $ dns );
    } catch ( Exception $ e ) {
        echo $ e -> getMessage ();
    }
?>

您可以定義兩個初始操作，例如： auto_commit和is_persistent 。您可以使用連線定義兩個首字母設定參數： auto_commit和is_persistent 。

• auto_commit啟用自動提交，預設為true ；
• is_persistent定義持久化模式，預設為false ；

 <?php
    require ' ../vendor/autoload.php ' ;

    use Cagartner  SQLAnywhereClient ;

    try {
        $ dns = " uid={uid};pwd={password};ENG={};commlinks=tcpip{host={host};port={password}} " ;
        $ autocommit = false ;
        $ persistent = true ;

        $ con = new SQLAnywhereClient ( $ dns , $ autocommit , $ persistent );
    } catch ( Exception $ e ) {
        echo $ e -> getMessage ();
    }
?>

執行 SQL 指令SQLAnywhereClient::exec() ：

 <?php

    $ sql = " SELECT * FROM users " ;
    $ result = $ con -> exec ( $ sql );

    echo " <pre> " ;
    print_r ( $ result -> fetch ());
    echo " </pre> " ;
    exit ;
?>

執行 SQL 指令並擷取資料SQLAnywhereClient::query() ：

此方法傳回一個包含資料的數組

 <?php

    $ sql = " SELECT name, email FROM users " ;

    foreach ( $ con -> query ( $ sql ) as $ result ) {
        print_r ( $ result );
    }
    exit ;
?>

僅檢索一行SQLAnywhereQuery::fetch

傳回第一行

 <?php
    $ sql = " SELECT name, email FROM users " ;
    $ result = $ con -> exec ( $ sql );
    $ user = $ result -> fetch ();

    print_r ( $ user );
    exit ;
?>

資料格式傳回

您可以選擇SQLAnywhereClient檢索資料的格式

 <?php
    // Retornar em um array com idexação por numero e coluna
    SQLAnywhereClient:: FETCH_ARRAY ;

    // Retornar em um array com idexação por coluna
    SQLAnywhereClient:: FETCH_ASSOC ; // Formato Padrão!

    // Retornar em um array com idexação por coluna
    SQLAnywhereClient:: FETCH_OBJECT ;

    // Retornar em um array com idexação por linha de dados
    SQLAnywhereClient:: FETCH_ROW ;

    // Retornar em um array com idexação por colunas
    SQLAnywhereClient:: FETCH_FIELD ;
?>

例子：

 <?php

    $ sql = " SELECT name, email FROM users " ;
    $ result = $ con -> exec ( $ sql );
    $ user = $ result -> fetch ( SQLAnywhereClient:: FETCH_OBJECT );

    print_r ( $ user );
    exit ;
?>

傳回所有行SQLAnywhereQuery::fetchAll

傳回所有選取的行

 <?php
    $ sql = " SELECT name, email FROM users " ;
    $ result = $ con -> exec ( $ sql );
    $ user = $ result -> fetchAll ();

    print_r ( $ user );
    exit ;
?>

在此方法中您也可以選擇傳回的格式：

 <?php

    $ sql = " SELECT name, email FROM users " ;
    $ result = $ con -> exec ( $ sql );
    $ user = $ result -> fetchAll ( SQLAnywhereClient:: FETCH_OBJECT );

    print_r ( $ user );
    exit ;
?>

行計數SQLAnywhereQuery::rowCount

傳回行數

 <?php
    $ sql = " SELECT name, email FROM users " ;
    $ result = $ con -> exec ( $ sql );

    echo " We find " . $ result -> rowCount () . " itens. " ;
    exit ;
?>

或使用count別名：

 <?php
    $ sql = " SELECT name, email FROM user " ;
    $ result = $ con -> exec ( $ sql );

    echo  " We find " . $ result -> count () . " itens. " ;
    exit ;
?>

字段計數SQLAnywhereQuery::fieldCount

傳回欄位總數

 <?php
    $ sql = " SELECT name, email FROM user " ;
    $ result = $ con -> exec ( $ sql );
    
    echo  " We find " . $ result -> fieldCount () . " fields. " ;
    exit ;
?>

最後 ID SQLAnywhereClient::lastInsertId()

返回最後插入的ID

 <?php
    $ sql = " INSERT INTO user  name, email VALUES ('Carlos', '[email protected]') " ;
    if ( $ con -> exec ( $ sql )) {
        echo $ con -> lastInsertId ();
    }
    exit ;
?>

準備語句SQLAnywhereClient::prepare() ：

準備聲明與? :

 <?php
    $ sql = " INSERT INTO users  name, email VALUES (?, ?) " ;
    $ stmnt = $ con -> prepare ( $ sql );
    if ( $ stmnt -> execute ( array ( ' Carlos ' , ' [email protected] ' ))) {
         echo $ con -> lastInsertId ();
    }
    exit ;
?>

這個參數名稱：

 <?php
    $ sql = " INSERT INTO users  name, email VALUES (:name, :email) " ;
    $ stmnt = $ con -> prepare ( $ sql );
    if ( $ stmnt -> execute ( array (
        ' :name ' => ' Carlos ' , 
        ' :email ' => ' [email protected] '
    ))) {
         echo $ con -> lastInsertId ();
    }
    exit ;
?>

綁定參數SQLAnywherePrepared::bindParam() ：

 <?php
    $ sql = " INSERT INTO users  name, email VALUES (:name, :email) " ;
    $ stmnt = $ con -> prepare ( $ sql );

    $ name = " Carlos A. " ;
    $ email = " [email protected] " ;

    $ stmnt -> bindParam ( ' :name ' , $ name );
    $ stmnt -> bindParam ( ' :email ' , $ email );

    if ( $ stmnt -> execute ()) {
         echo $ con -> lastInsertId ();
    }
    exit ;
?>