PHP Cagartner SQLAnywhereClient示例

示例#1

文件： insert.php 项目： cagartner/sql-anywhere-client

<?php

require '../vendor/autoload.php';
use Cagartner\SQLAnywhereClient as PDO;
try {
    $dns = "uid=teste;pwd=teste;ENG=teste;commlinks=tcpip{host=127.0.0.1;port=2638}";
    $con = new PDO($dns);
} catch (Exception $e) {
    echo $e->getMessage();
}
// SQL
$sql = "INSERT INTO usuario (name, email, password, status) VALUES ('Carlos', '*****@*****.**', '" . md5('teste') . "', 1) ";
$result = $con->exec($sql);
$con->commit();
if ($result) {
    echo "Novo registro inserido: " . $con->lastInsertId();
} else {
    $con->rollback();
}

示例#2

文件： index.php 项目： cagartner/sql-anywhere-client

<?php

require '../vendor/autoload.php';
use Cagartner\SQLAnywhereClient as PDO;
try {
    $dns = "uid=teste;pwd=teste;ENG=teste;commlinks=tcpip{host=127.0.0.1;port=2638}";
    $con = new PDO($dns);
    $sql = "INSERT INTO usuario (name, email, status) VALUES ('Carlos', '*****@*****.**', 1) ";
    $result = $con->exec($sql);
    var_dump($result);
    exit;
} catch (Exception $e) {
    echo $e->getMessage();
}

示例#3

文件： statement.php 项目： cagartner/sql-anywhere-client

<?php

require '../vendor/autoload.php';
use Cagartner\SQLAnywhereClient as PDO;
try {
    $dns = "uid=base;pwd=password;ENG=base;commlinks=tcpip{host=127.0.0.1;port=2638}";
    $con = new PDO($dns);
    $sql = "SELECT * FROM bludata.Usuario WHERE Id = ? and status = ? and email = ?";
    // $sql = 'update "usuario" set "updated_at" = :data, "remember_token" = :token where "pkUsuario" = :pk';
    // $pk    = 2;
    // $token = "K8jIUBDWlXCFz7WzxtXMnHpcbdcEddK1zlwx8qTKewb4nwbpXxGaMBOtk5E3";
    // $data  = "2014-06-04 11:00:54";
    $stmnt = $con->prepare($sql);
    // $stmnt->bindParam( ':pk', $pk );
    // $stmnt->bindParam( ':token', $token );
    // $stmnt->bindParam( ':data', $data );
    $stmnt->execute(array('2', '1', '*****@*****.**'));
    echo "<pre>";
    print_r($stmnt->fetchAll());
    echo "</pre>";
    exit;
} catch (Exception $e) {
    echo $e->getMessage();
}