<?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();
}
<?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();
}
<?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();
}