PDO radi posao !
Potrebno je u PHP.ini odkomentarisati linije za PDO drajvere za zeljenu bazu podataka.
Ja sam to uradio samo za pdo_odbc.dll
Primer:
Code:
<?php
/* Konekcija na bazu preko ODBC drajvera */
$dsn = 'odbc:MojDSN';
$user = 'AdsSys';
$password = '';
try {
$conn = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
try{
$conn->beginTransaction();
$sql1 = "Insert into klijenti(kl_sifra, kl_sifkom, kl_tip) values('101', '000017', '1')";
$sql2 = "Insert into klijenti(kl_sifra, kl_sifkom, kl_tip) values('102', '000018', '2')";
$conn->query($sql1);
$conn->query($sql2);
$conn->commit();
}
catch (Exception $e) {
print 'Transakcija nije izvrsena!';
$conn->rollBack();
}
@Nikola, hvala na sugestijama
Srecno PHP-ovci
Every program is either trivial or it contains at least one bug.