ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:getupdatesql

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
Next revisionBoth sides next revision
v5:reference:getupdatesql [2016/01/13 02:31] – ↷ Links adapted because of a move operation mnewnhamv5:reference:connection:getupdatesql [2019/12/26 05:50] – fix typo in example peterdd
Line 72: Line 72:
  
 $SQL = 'SELECT * FROM employees WHERE emp_no=10001'; $SQL = 'SELECT * FROM employees WHERE emp_no=10001';
-$result = $db->Execute($SQL);+$result = $db->execute($SQL);
  
 $updateArray = array('first_name'=>'Jerry', $updateArray = array('first_name'=>'Jerry',
Line 78: Line 78:
       'gender'=>'M');       'gender'=>'M');
  
-$SQL = $db->getUpdateSql($result,$updateArray); +$SQL = $db->getUpdateSql($result, $updateArray);
- +
-print $SQL+
 /* /*
- * returns: UPDATE employees + * returns 
 + * UPDATE employees 
               SET FIRST_NAME='Jerry',                SET FIRST_NAME='Jerry', 
                   LAST_NAME='O\'reilly'                    LAST_NAME='O\'reilly' 
Line 94: Line 93:
  
 <code php> <code php>
-$SQL = $db->getUpdateSql($result,$updateArray.true);+$SQL = $db->getUpdateSql($result, $updateArray, true);
 /* /*
  * returns  * returns
v5/reference/connection/getupdatesql.txt · Last modified: 2023/09/26 17:43 by dregad