- Notifications
You must be signed in to change notification settings - Fork12
Cliente of connection for slqanywhere/sybase based on PHP class PDO
License
cagartner/sql-anywhere-client
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Classe para conexão com banco de dados Sybase com PHP baseada na biblioteca sqlanywhere.Class for connection with database Sybase with PHP, created for PHP library SqlAnywhere.
The development was based on PDO Native Class.
TODO:
- More tests.
=================
1- First install sqlanywhere module for PHPClick Here!.
2- Use composer to install this package adding the lines bellow in the require sectionrequire:// ..."require": {"cagartner/SQLAnywhereClient": "dev-master"},// ...
Bellow have some examples of how to use this class.
<?phprequire'../vendor/autoload.php';useCagartner\SQLAnywhereClient;try {$dns ="uid={user};pwd={password};ENG={database-name};commlinks=tcpip{host={host};port={port}}";$con =newSQLAnywhereClient($dns ); }catch (Exception$e) {echo$e->getMessage(); }?>
Você pode definir duas opções iniciais junto com a conexão, que são as seguintes:auto_commit eis_persistent.You can define two initials configuration params with the connection:auto_commit andis_persistent.
auto_commitEnable auto commit, default istrue;is_persistentDefine persistent mode, default isfalse;
<?phprequire'../vendor/autoload.php';useCagartner\SQLAnywhereClient;try {$dns ="uid={uid};pwd={password};ENG={};commlinks=tcpip{host={host};port={password}}";$autocommit =false;$persistent =true;$con =newSQLAnywhereClient($dns,$autocommit,$persistent ); }catch (Exception$e) {echo$e->getMessage(); }?>
<?php$sql ="SELECT * FROM users";$result =$con->exec($sql );echo"<pre>";print_r($result->fetch());echo"</pre>";exit;?>
This method return an array with the data
<?php$sql ="SELECT name, email FROM users";foreach ($con->query($sql )as$result) {print_r($result); }exit;?>
Return first row
<?php$sql ="SELECT name, email FROM users";$result =$con->exec($sql );$user =$result->fetch();print_r($user);exit;?>
You can choose how is the format that your data is retrieveSQLAnywhereClient
<?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;?>
Example:
<?php$sql ="SELECT name, email FROM users";$result =$con->exec($sql );$user =$result->fetch( SQLAnywhereClient::FETCH_OBJECT );print_r($user);exit;?>
Return all selected rows
<?php$sql ="SELECT name, email FROM users";$result =$con->exec($sql );$user =$result->fetchAll();print_r($user);exit;?>
In this method you also can choose the format of return too:
<?php$sql ="SELECT name, email FROM users";$result =$con->exec($sql );$user =$result->fetchAll( SQLAnywhereClient::FETCH_OBJECT );print_r($user);exit;?>
Return the count of rows
<?php$sql ="SELECT name, email FROM users";$result =$con->exec($sql );echo"We find" .$result->rowCount() ." itens.";exit;?>
Or withcount alias:
<?php$sql ="SELECT name, email FROM user";$result =$con->exec($sql );echo"We find" .$result->count() ." itens.";exit;?>
Return the total of fields
<?php$sql ="SELECT name, email FROM user";$result =$con->exec($sql );echo"We find" .$result->fieldCount() ." fields.";exit;?>
Return the last inserted ID
<?php$sql ="INSERT INTO user name, email VALUES ('Carlos', 'contato@carlosgartner.com.br')";if ($con->exec($sql )) {echo$con->lastInsertId(); }exit;?>
Prepared Statement with?:
<?php$sql ="INSERT INTO users name, email VALUES (?, ?)";$stmnt =$con->prepare($sql );if ($stmnt->execute(array('Carlos','contato@carlosgartner.com.br'))) {echo$con->lastInsertId(); }exit;?>
And this params names:
<?php$sql ="INSERT INTO users name, email VALUES (:name, :email)";$stmnt =$con->prepare($sql );if ($stmnt->execute(array(':name' =>'Carlos',':email' =>'contato@carlosgartner.com.br' ))) {echo$con->lastInsertId(); }exit;?>
<?php$sql ="INSERT INTO users name, email VALUES (:name, :email)";$stmnt =$con->prepare($sql );$name ="Carlos A.";$email ="contato@carlosgartner.com.br";$stmnt->bindParam(':name',$name);$stmnt->bindParam(':email',$email);if ($stmnt->execute()) {echo$con->lastInsertId(); }exit;?>
About
Cliente of connection for slqanywhere/sybase based on PHP class PDO
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
Packages0
Contributors2
Uh oh!
There was an error while loading.Please reload this page.