ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:activerecord:getactiverecords

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
activerecord:getactiverecords [2015/12/05 01:12] – mnewnhamactiverecord:getactiverecords [2015/12/05 01:55] – mnewnham
Line 2: Line 2:
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP right box> <WRAP right box>
-== syntax ==+== Syntax ==
   void getActiveRecords(   void getActiveRecords(
     string $tableName,     string $tableName,
Line 23: Line 23:
  Where clause  Where clause
 ==== $bindarr ==== ==== $bindarr ====
 +For more information on the use of ''Bind'' variables, see [[reference:execute()]].
 ==== $primaryKeyArray ==== ==== $primaryKeyArray ====
    
Line 34: Line 34:
 $db->connect('','user','password','employees'); $db->connect('','user','password','employees');
  
-$activeRecs = $db->GetActiveRecords('departments'); +$table        = 'departments'; 
-           +$whereOrderBy = "name LIKE 'A%' ORDER BY Name"; 
 +$primaryKeys  = array('id'); 
 +$activeRecArr = $db->GetActiveRecords($table, $whereOrderBy,$primaryKeys); 
 +foreach($activeRecArr as $rec)  
 +{ 
 +    $rec->id = rand(); 
 +    $rec->save(); 
 +}           
 </code> </code>
 {{tag>[Active_Record]}}        {{tag>[Active_Record]}}       
v5/activerecord/getactiverecords.txt · Last modified: 2018/07/02 14:19 by peterdd