Differences

This shows you the differences between two versions of the page.

--- v5:database:text [2019/12/31 05:46] – fix the execute() call in example as intended peterdd
+++ v5:database:text [2020/01/13 13:17] (current) – fix invalid tag specification dregad
@@ Line 66: / Line 66: @@
 ---------------------
 <code php>
-$rs = $db->execute('select * from table',false,"\$COL1='abc' and \$COL2=3");
+// 3rd parameter is evaled PHP code, not SQL, so watch the '==' vs. '='
+$rs = $db->execute('select * from table', false, "\$COL1=='abc' and \$COL2==3");
-/*
-* the 3rd param is searched -- make sure that $COL1 is a legal column name
-*/
 </code>
@@ Line 89: / Line 86: @@
 =>array(10002,'1964-06-02','Bezalel','Simmel','F','1985-11-21'),
 =>array(10003,'1959-12-03','Parto','Bamford','M','1986-08-28'),
-=>array(10004,'1954-05-01','Chirstian','Koblick','M','1986-12-01'),
+=>array(10004,'1954-05-01','Christian','Koblick','M','1986-12-01'),
 =>array(10005,'1955-01-21','Kyoichi','Maliniak', 'M','1989-09-12'),
 =>array(10006,'1953-04-20','Anneke','Preusig','F','1989-06-02')
@@ Line 103: / Line 100: @@
 $sql = 'select * from table';
+// Does not work with PHP 5.3 or later, see workaround below
 $result = $db->execute($sql, false, "\$EMPNO==10005");
@@ Line 109: / Line 107: @@
 }
 </code>
+===== Workaround =====
+For PHP 5.3 or later, the following workaround can be used (tested with ADOdb 5.20.15).
+Replace the ''$result = $db->execute($sql, false, "\$EMPNO==10005");'' statement in the above sample by the following code.
+<code php>
+$db->evalAll = "\$EMPNO==10005";
+$result = $db->execute($sql);
+$db->evalAll = false;
+</code>
+{{tag>text deprecated}}