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 ;
?>