Differences

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

--- v5:userguide:portable_sql [2018/06/27 16:14] – start functions lowercase #430 dregad
+++ v5:userguide:portable_sql [2020/12/30 21:32] (current) – [Prepare/Execute] fix obvious variable case typos peterdd
@@ Line 126: / Line 126: @@
 */
-$sql = 'insert into table (col1,col2) values ('.$DB->Param('a').','.$DB->Param('b').')';
+$sql = 'insert into table (col1,col2) values ('.$db->param('a').','.$db->param('b').')';
 # generates 'insert into table (col1,col2) values (?,?)'
 # or        'insert into table (col1,col2) values (:a,:b)'
-$stmt = $DB->prepare($sql);
+$stmt = $db->prepare($sql);
-$stmt = $DB->execute($stmt,array('one','two'));
+$stmt = $db->execute($stmt, array('one','two'));
 </code>
@@ Line 174: / Line 174: @@
   AGE N(16) DEFAULT 0
 ";
-$sql1 = $datadict->CreateTableSQL('tabname', $flds);
+$sql1 = $datadict->createTableSQL('tabname', $flds);
-$sql2 = $datadict->CreateIndexSQL('idx_name_age', 'tabname', 'NAME,AGE');
+$sql2 = $datadict->createIndexSQL('idx_name_age', 'tabname', 'NAME,AGE');
 </code>