ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:portable_sql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:userguide:portable_sql [2016/03/13 23:52] – [Inserting Records] mnewnhamv5:userguide:portable_sql [2020/12/30 21:32] (current) – [Prepare/Execute] fix obvious variable case typos peterdd
Line 29: Line 29:
  
 <code php> <code php>
-$connection->SelectLimit('select * from table', 10);+$connection->selectLimit('select * from table', 10);
 </code> </code>
  
Line 49: Line 49:
  
 <code php> <code php>
-$rs = $db->Execute("select * from table where state=$state"); +$rs = $db->execute("select * from table where state=$state"); 
-$numrows = $rs->PO_RecordCount('table', "state=$state");+$numrows = $rs->po_recordCount('table', "state=$state");
 </code> </code>
  
Line 60: Line 60:
  
 <code php> <code php>
-$connection->BeginTrans( ); +$connection->beginTrans( ); 
-$connection->RowLock($table, $where); +$connection->rowLock($table, $where); 
 # some operation # some operation
-if ($ok) $connection->CommitTrans( ); +if ($ok) $connection->commitTrans( ); 
-else $connection->RollbackTrans( );+else $connection->rollbackTrans( );
 </code> </code>
  
Line 107: Line 107:
  
 <code php> <code php>
-$id = $connection->GenID('sequence_name'); +$id = $connection->genID('sequence_name'); 
-$connection->Execute("insert into table (id, firstname, lastname) +$connection->execute("insert into table (id, firstname, lastname) 
           values ($id, $firstname, $lastname)");           values ($id, $firstname, $lastname)");
  
Line 120: Line 120:
 ===== Prepare/Execute ===== ===== Prepare/Execute =====
 <code php> <code php>
-$stmt = $db->Prepare('select * from customers where custid=? and state=?'); +$stmt = $db->prepare('select * from customers where custid=? and state=?'); 
-$rs = $db->Execute($stmt, array($id,'New York'));+$rs = $db->execute($stmt, array($id,'New York'));
 /* /*
 Oracle uses named bind placeholders, not "?", so to support portable binding, we have Param() that generates the correct placeholder Oracle uses named bind placeholders, not "?", so to support portable binding, we have Param() that generates the correct placeholder
 */ */
  
-$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 (?,?)' # generates 'insert into table (col1,col2) values (?,?)'
 # or        'insert into table (col1,col2) values (:a,:b)' # 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> </code>
Line 174: Line 174:
   AGE N(16) DEFAULT 0   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> </code>
Line 186: Line 186:
  
 <code php> <code php>
-$date1 = $connection->DBDate(time( )); +$date1 = $connection->dbDate(time( )); 
-$date2 = $connection->DBTimeStamp('2002-02-23 13:03:33');+$date2 = $connection->dbTimeStamp('2002-02-23 13:03:33');
 </code> </code>
 We also provide functions to convert database dates to Unix timestamps: We also provide functions to convert database dates to Unix timestamps:
  
 <code php> <code php>
-$unixts = $recordset->UnixDate('#2002-02-30#'); # MS Access date =gt; unix timestamp+$unixts = $recordset->unixDate('#2002-02-30#'); # MS Access date =gt; unix timestamp
 </code> </code>
  
Line 198: Line 198:
  
 <code php> <code php>
-$sql = 'update table set dtimefld='.$db->OffsetDate($db->sysTimeStamp, 6/24).' where ...';+$sql = 'update table set dtimefld='.$db->offsetDate($db->sysTimeStamp, 6/24).' where ...';
 </code> </code>
  
Line 205: Line 205:
 <code php> <code php>
 # for oracle  # for oracle 
-$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1,empty_blob())'); +$conn->execute('INSERT INTO blobtable (id, blobcol) VALUES (1,empty_blob())'); 
-$conn->UpdateBlob('blobtable','blobcol',$blobvalue,'id=1');+$conn->updateBlob('blobtable','blobcol',$blobvalue,'id=1');
  
 # non-oracle databases # non-oracle databases
-$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); +$conn->execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); 
-$conn->UpdateBlob('blobtable','blobcol',$blobvalue,'id=1');+$conn->updateBlob('blobtable','blobcol',$blobvalue,'id=1');
  
 </code> </code>
Line 237: Line 237:
 } }
 # @RETVAL = SP_RUNSOMETHING @myid,@group # @RETVAL = SP_RUNSOMETHING @myid,@group
-$stmt = $db->PrepareSP($sql); +$stmt = $db->prepareSP($sql);
 $db->inParameter($stmt,$id,'myid'); $db->inParameter($stmt,$id,'myid');
-$db->Parameter($stmt,$group,'group');+$db->parameter($stmt,$group,'group');
 # true indicates output parameter # true indicates output parameter
-$db->Parameter($stmt,$ret,'RETVAL',true); +$db->parameter($stmt,$ret,'RETVAL',true); 
-$db->Execute($stmt); +$db->execute($stmt); 
 </code> </code>
  
Line 253: Line 253:
 <code php> <code php>
 $sqlGetPassword = 'select password from users where userid=%s'; $sqlGetPassword = 'select password from users where userid=%s';
-$sqlSearchKeyword = quot;SELECT * FROM articles WHERE match (title,body) against (%s)";+$sqlSearchKeyword = "SELECT * FROM articles WHERE match (title,body) against (%s)";
  
 </code> </code>
Line 263: Line 263:
 include_once("$database-lang.inc.php"); include_once("$database-lang.inc.php");
  
-$db = NewADOConnection($database); +$db = newADOConnection($database); 
-$db->PConnect(...) or die('Failed to connect to database');+$db->pConnect(...) or die('Failed to connect to database');
  
 # search for a keyword $word # search for a keyword $word
-$rs = $db->Execute(sprintf($sqlSearchKeyWord,$db->qstr($word)));+$rs = $db->execute(sprintf($sqlSearchKeyWord,$db->qstr($word)));
  
 </code> </code>
v5/userguide/portable_sql.1457909548.txt.gz · Last modified: 2017/04/21 11:39 (external edit)