Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : dBase Functions : dbase_add_record

dbase_add_record

Adds a record to a database (PHP 4, PHP 5)
bool dbase_add_record ( int dbase_identifier, array record )

Adds the given data to the database.

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_add_record() will fail.

Note:

If you're using dbase_get_record() return value for this parameter, remember to reset the key named deleted.

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Example 474. Inserting a record in a dBase database

<?php

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

if (
$db) {
 
dbase_add_record($db, array(
     
date('Ymd'),
     
'Maxim Topolov',
     
'23',
     
'max@example.com',
     
'T'));  
 
dbase_close($db);
}

?>


Code Examples / Notes » dbase_add_record

dahlmann

I had some problems with old dbase3 database. Odd behaviour of the php-progs and incomplete file copies.
I assume that the header was partly corrupt, but clipper-progs worked fine. I copied structure to file (copy to test structure extended), then rebuilt the  database from the structure file again and made an append from the original file.
That fixed the error.


heinrich

Field type incompatible inputs can cause PHP to crash or strange errors to occur. After finding that out it was easy to fill also "big" dbase-files with size bigger than 15 MB. Don't let your enthusiasm be broken by inexact error messages! :-)

michele dot manzato

Apparently, one cannot use associative arrays in order to compose the record to be written to the dbf file. The following code will not work and will raise an unexpected error:
<?php
$record = array("ID" => 10, "VALUE" => 'Hello');
dbase_add_record($dbid, $record);
?>
Instead:
<?php
$record = array(0 => 10, 1 => 'Hello');
dbase_add_record($dbid, $record);
?>


Change Language


Follow Navioo On Twitter
dbase_add_record
dbase_close
dbase_create
dbase_delete_record
dbase_get_header_info
dbase_get_record_with_names
dbase_get_record
dbase_numfields
dbase_numrecords
dbase_open
dbase_pack
dbase_replace_record
eXTReMe Tracker