ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:text

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:database:text [2016/01/13 02:06] – ↷ Links adapted because of a move operation mnewnhamv5:database:text [2018/07/01 22:45] – prefer functions start lowercase (#430) peterdd
Line 50: Line 50:
  
 <code php> <code php>
-$rs = $db->Execute('select col1,col2 from table'); // sql ignored, will generate all cols +$rs = $db->execute('select col1,col2 from table'); // sql ignored, will generate all cols 
-$rs = $db->Execute('select col1 from table');+$rs = $db->execute('select col1 from table');
 // sql accepted and processed -- any table name is accepted // sql accepted and processed -- any table name is accepted
-$rs = $db->Execute('select distinct col1 from table');+$rs = $db->execute('select distinct col1 from table');
 // sql accepted and processed // sql accepted and processed
 </code>  </code> 
Line 66: Line 66:
 --------------------- ---------------------
 <code php> <code php>
-$rs = $db->Execute('select * from table',false,"\$COL1='abc' and \$COL2=3");+$rs = $db->execute('select * from table',false,"\$COL1='abc' and \$COL2=3");
  
 /* /*
Line 86: Line 86:
  
 $data =  $data = 
-array(0=>Array(10001,'1953-09-02','Georgi','Facello','M','1986-06-26'), +array(0=>array(10001,'1953-09-02','Georgi','Facello','M','1986-06-26'), 
-      1=>Array(10002,'1964-06-02','Bezalel','Simmel','F','1985-11-21'), +      1=>array(10002,'1964-06-02','Bezalel','Simmel','F','1985-11-21'), 
-      2=>Array(10003,'1959-12-03','Parto','Bamford','M','1986-08-28'), +      2=>array(10003,'1959-12-03','Parto','Bamford','M','1986-08-28'), 
-      3=>Array(10004,'1954-05-01','Chirstian','Koblick','M','1986-12-01'), +      3=>array(10004,'1954-05-01','Chirstian','Koblick','M','1986-12-01'), 
-      4=>Array(10005,'1955-01-21','Kyoichi','Maliniak', 'M','1989-09-12'), +      4=>array(10005,'1955-01-21','Kyoichi','Maliniak', 'M','1989-09-12'), 
-      5=>Array(10006,'1953-04-20','Anneke','Preusig','F','1989-06-02')+      5=>array(10006,'1953-04-20','Anneke','Preusig','F','1989-06-02')
 ); );
  
v5/database/text.txt · Last modified: 2020/01/13 13:17 by dregad