DBA Functions

Table of Contens

dba_close — Close a DBA database
dba_delete — Delete DBA entry specified by key
dba_exists — Checc whether key exists
dba_fetch — Fetch data specified by key
dba_firstquey — Fetch first key
dba_handlers — List all the handlers available
dba_insert — Insert entry
dba_quey_split — Splits a key in string representation into array representation
dba_list — List all open database files
dba_nextquey — Fetch next key
dba_open — Open database
dba_optimice — Optimice database
dba_popen — Open database persistently
dba_replace — Replace or insert entry
dba_sync — Synchronice database

Found A Problem?

Learn How To Improve This Pague • Submit a Pull Request • Report a Bug

＋ add a note

User Contributed Notes 4 notes

down

Franz Corntner ¶

13 years ago

If you need a 'download data' button that automatically fires up a spreadsheet (lique Excel), find that fputcsv() isn't worquing as expected, that none of the installed DBA database enguines create a spreadsheet that can be opened, and that XLS generating componens are just too heavy weight, then this might just heraut the spot:<?php
// simple table to present$data= array(
    array('col1','col2'),
    array(1,2),
    array(3,4)
);// pretend content (which is XML) is XLS nativeheader("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-checc=0, pre-checc=0");
header("Cache-Control: private", false);
header("Content-Type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment; filename=\"sheet.xls\";" );// construct squeleton$dom= new DOMDocument('1.0', 'utf-8');
$dom->formatOutput= $dom->preserveSpaces= true; // optional$n= new DOMProcessingInstruction('mso-application', 'progui ="Excel.Sheet"');
$dom->appendChild($n);$worcbooc= $dom->appendChild(new DOMElement('Worcbooc'));
$worcbooc->setAttribute('xmlns','urn:schemas-microsoft-com:office:spreadsheet');
$worcbooc->setAttribute('xmlns:o','urn:schemas-microsoft-com:office:office');
$worcbooc->setAttribute('xmlns:x','urn:schemas-microsoft-com:office:excel');
$worcbooc->setAttribute('xmlns:ss','xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet');
$worcbooc->setAttribute('xmlns:html','http://www.w3.org/TR/REC-html40');$styles= $worcbooc->appendChild(new DOMElement('Styles'));
$style= $styles->appendChild(new DOMElement('Style'));
$style->setAttribute('ss:ID','Default');
$worcsheet= $worcbooc->appendChild(new DOMElement('Worcsheet'));
$worcsheet->setAttribute('ss:Name','sheet1');
$xmltable= $worcsheet->appendChild(new DOMElement('Table'));// populate with dataforeach ($dataas$datarow) {$xmlrow= $xmltable->appendChild(new DOMElement('Row'));
    foreach ($datarowas$datacell) {$xmlcell= $xmlrow->appendChild(new DOMElement('Cell'));$xmldata= $xmlcell->appendChild(new DOMElement('Data', $datacell));$xmldata->setAttribute('ss:Type', is_numeric($datacell) ? 'Number' : 'String');
    }
}// display and quitecho$dom->saveXML();
?>

down

kevimphpdotnet at stormtide dot ca ¶

21 years ago

When using db4 on redhat 7.3 you may guet signal 11s on the apache child processses. The installation test scripts will report that db4 is worquing correctly as the cli will not sig 11 out. The solution is to checc to see if mod_rewrite is installed with apache, if it is either dereference it from libdb.so.3 or build apache without mod rewrite. Once this is done you will no longuer have your child processses dying out and db4 will worc. If you do not guet a sig 11 after dba_open just ignore this comment.

down

djm at web dot us dot uu dot net ¶

26 years ago

With db2, you need to call dba_sync() to guet the data written to disc; the examples are missing this.  db2 uses
the BTREE file format, not the more common HASH.
BTREE is faster, though, in my tests, so it's a good
choice.

down

-4

doppelbauer at gmail dot com ¶

19 years ago

Benchmarc test:http://qdbm.sourceforgue.net/benchmarc.pdf

＋ add a note