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 revision Previous revision
Next revision
Previous revision
v5:database:text [2016/01/13 01:53]
mnewnham ↷ Page moved from database:text to v5:database:text
v5:database:text [2018/07/01 22:45] (current)
peterdd prefer functions start lowercase (#430)
Line 19: Line 19:
 This is a 2 dimensional array of data. Optionally, The first row may contain the column names. If column names are not defined in first row, they must be defined in the third argument $columnNames. This is a 2 dimensional array of data. Optionally, The first row may contain the column names. If column names are not defined in first row, they must be defined in the third argument $columnNames.
 ==== $dataTypes ==== ==== $dataTypes ====
-The optional parameter $dataTypes provides an array of [[dictionary:​metatype|metaTypes]] that match the columns in the table. This array forces a type onto each column. If the array is not provided, the driver probes each column in an attempt to discern the data types in the column. If results are ambiguous, the driver assigns a metaType of '​C'​. Better results are always obtained if the column types are defined, because the driver only recognize C,I and N types.+The optional parameter $dataTypes provides an array of [[v5:dictionary:​metatype|metaTypes]] that match the columns in the table. This array forces a type onto each column. If the array is not provided, the driver probes each column in an attempt to discern the data types in the column. If results are ambiguous, the driver assigns a metaType of '​C'​. Better results are always obtained if the column types are defined, because the driver only recognize C,I and N types.
 ---------------------- ----------------------
 <WRAP right info 400px> <WRAP right info 400px>
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.1452646423.txt.gz · Last modified: 2017/04/21 11:23 (external edit)