Hi,
I've been working on some of the bugs for ODBC in the bugs db, mainly
those dealing with Windows and ODBC.
One of the common bugs seems to be using odbc_prepare() and
odbc_execute() in conjuction with each other. I was hoping someone
might be able to do an ODBC test case for me, on something other than
Microsoft Access (which is all I have MS wise).
Two tables should be created, odbcetest1 and odbctest2. Any writes in
this script to odbctest1 should fail, but I believe odbctest2 should
work fine. If anyone can send me some results confirming or denying my
theory, they would be appriciated. :)
<?
//
// this is just a quick and dirty proof of concept script
//
//
// please setup this script to connect to your database
//
$conn = odbc_connect("phptest","","");
if (!$conn)
{
print "Error in connecting<BR>\n";
exit;
}
odbc_exec($conn,"DROP TABLE odbctest1");
odbc_exec($conn,"CREATE TABLE odbctest1 (id INT, firstname CHAR(24),
lastname CHAR(24))");
odbc_exec($conn,"DROP TABLE odbctest2");
odbc_exec($conn,"CREATE TABLE odbctest2 (id CHAR(2), firstname CHAR(24),
lastname CHAR(24))");
odbc_exec($conn,"INSERT INTO odbctest1 (id,firstname,lastname) VALUES
(0,'Zend','PHP')");
odbc_exec($conn,"INSERT INTO odbctest2 (id,firstname,lastname) VALUES
('99','Apache','Origami')");
$stmt1 = odbc_prepare($conn,"INSERT INTO odbctest1
(id,firstname,lastname) VALUES (?,?,?)");
if ($stmt1) {
print "Trying execute stat1<br>";
$stmt1 = odbc_execute($stmt1,array(1,"This","Fails"));
}
$stmt2 = odbc_prepare($conn,"INSERT INTO odbctest2
(id,firstname,lastname) VALUES (?,?,?)");
if ($stmt2) {
print "Trying execute stat2<br>";
$stmt1 = odbc_execute($stmt1,array("1","This","Works"));
}
?>
--
Dan Kalowsky "Tonight I think I'll walk alone,
Worldgate Communications I'll find my soul as I go home."
Software Engineer - TICS Group - Temptation
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
