dbase_replace_record

(PHP 4, PHP 5, PHP 7)

dbase_replace_record — Replaces a record in a database

Description

bool dbase_replace_record ( int $dbase_identifier , array $record , int $record_number )

Replaces the given record in the database with the given data.

Parameters

dbase_identifier: The database link identifier, returned by dbase_open() or dbase_create().
record: An indexed array of data. The number of items must be equal to the number of fields in the database, otherwise dbase_replace_record() will fail.

Note:
If you're using dbase_get_record() return value for this parameter, remember to reset the key named deleted.
record_number: An integer which spans from 1 to the number of records in the database (as returned by dbase_numrecords()).

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Example #1 Updating a record in the database


<?php

// open in read-write mode
$db = dbase_open('/tmp/test.dbf', 2);

if ($db) {
  // gets the old row
  $row = dbase_get_record_with_names($db, 1);
  
  // remove the 'deleted' entry
  unset($row['deleted']);
  
  // Update the date field with the current timestamp
  $row['date'] = date('Ymd');
  
  // Replace the record
  dbase_replace_record($db, $row, 1);
  dbase_close($db);
}

?>

User Contributed Notes

rlundp at lunds dot us

3 years ago


It took me a while to figure this out, so even though this is near-obsolete, maybe it will be useful to someone else.

I have a dBase file that contains a boolean value. I created a new row in the file with the boolean value at 0, and that worked without issues.

But then I tried to set that value to 1, and it did not work. I tried 1, "1", true - all without success.

Turns out that you need to use "Y" to set a boolean value to 1.

When you load the row later and output it using var_dump, the value will show as integer with the value 1.

3Famous at gmail dot com

8 years ago


Actually you have to change the read array from key based to element (numeric) based and everything works correctly!



<?php

     $db = dbase_open( "yourfile.dbf", 2); // 0=RO, 1=WO, 2=RW

     if ($db) {

        $row = dbase_get_record_with_names($db, 1);

        unset($row["deleted"]); // drop the field

// do whatever it is you want to the $row["elements"]

// then convert to numeric to store:

        $rarr = array(); 

        foreach ($row as $i=>$vl) $rarr[] = $vl;

        dbase_replace_record($db, $rarr, 1);

        dbase_close($db);

    }

?>



That code actually works!

hassan at datakillarna dot se

10 years ago


If you get "unexpected error", try to change the assoc array, $row, to an indexed array with array_values().



Example:

<?php

$row = array_values($row);

dbase_replace_record($db, $row, 1);

?>



The dbase_replace-function cannot handle an assoc array.



Hope this will save someone a headache! ;)

Anonymous

11 months ago


Make sure you opened the database for WRITE!
dbase_open( "yourfile.dbf", 2)

wysocki at wildworld dot net

11 years ago


The dbase add and replace functions do NOT like to use the associative array. 



<?php

//This gives "unspecified error" on replace and add:

$row = dbase_get_record_with_names($db, 1);

unset($row['deleted']);

dbase_replace_record($db, $row, 1);

dbase_add_record($db, $row);



//To further prove the point,

//The first add works, the second one fails:

$testrow1=array('one','2','three');

dbase_add_record($db,$testrow1);

$testrow2=array('FIELDA' => 'xxx','FIELDB' => '9','FIELDC' => 'yyyyy');

dbase_add_record($db,$testrow2);

?>

xamkan at yahoo dot com

5 years ago


// simply use 'dbase_get_record' instead of 'dbase_get_record_with_names', for 'dbase_replace_record', 'dbase_add_record', or 'dbase_delete_record', to work

<?php

// open in read-write mode
$db = dbase_open('/tmp/test.dbf', 2) or die("Error! Could not open dbase database file /tmp/test.dbf.");        // 0=RO, 1=WO, 2=RW

// gets the old row
$row = dbase_get_record($db, 1);

// remove the 'deleted' entry from the array
unset($row['deleted']);

// Update the date field with the current timestamp
$row['date'] = date('Ymd');

// Replace the record
dbase_replace_record($db, $row, 1);
dbase_close($db);

?>