ADOdb: Replace Data

Try to update a record, and if the record is not found, an insert statement is generated and executed. Returns 0 on failure, 1 if update statement worked, 2 if no record was found and the insert was executed successfully. This differs from MySQL's replace which deletes the record and inserts a new record. This also means you cannot update the primary key. The only exception to this is Interbase and its derivitives, which uses delete and insert because of some Interbase API limitations.

Formula:

Replace($table, $arrFields, $keyCols,$autoQuote=false)

The parameters are $table which is the table name, the $keyCols which is an associative array where the keys are the field names, and keyCols is the name of the primary key, or an array of field names if it is a compound key. If $autoQuote is set to true, then Replace() will quote all values that are non-numeric; auto-quoting will not quote nulls. Note that auto-quoting will not work if you use SQL functions or operators.

 # single field primary key 
    $ret = $db->Replace('atable', 
    array('id'=>1000,'firstname'=>'Harun','lastname'=>'Al-Rashid'), 
        'id', 
        'firstname',$autoquote = true); 
    # generates UPDATE table SET 
    # firstname='Harun',lastname='Al-Rashid' 
    # WHERE id=1000 
    # or INSERT INTO atable (id,firstname,lastname) 
    # VALUES (1000,'Harun','Al-Rashid') 

    # compound key 
    $ret = $db->Replace('atable2', 
    array('firstname'=>'Harun','lastname'=>'Al-Rashid', 'age' => 33, 'birthday' => 'null'), 
    array('lastname','firstname'), 
        'firstname',$autoquote = true); 

    # no auto-quoting 
    $ret = $db->Replace('atable2', 
    array('firstname'=>"'Harun'",'lastname'=>"'Al-Rashid'", 'age' => 'null'), 
    array('lastname','firstname'), 
        'firstname');