DBA 函数

dba_close — Close a DBA database
dba_delete — Delete DBA entry specified by key
dba_exists — Check whether key exists
dba_fetch — Fetch data specified by key
dba_firstkey — Fetch first key
dba_handlers — List all the handlers available
dba_insert — Insert entry
dba_key_split — Splits a key in string representation into array representation
dba_list — List all open database files
dba_nextkey — Fetch next key
dba_open — Open database
dba_optimize — Optimize database
dba_popen — Open database persistently
dba_replace — Replace or insert entry
dba_sync — Synchronize database

User Contributed Notes

Franz Korntner 21-Feb-2012 09:10


If you need a 'download data' button that automatically fires up a spreadsheet (like Excel), find that fputcsv() isn't working as expected, that none of the installed DBA database engines create a spreadsheet that can be opened, and that XLS generating components are just too heavy weight, then this might just hit 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 native

header("Pragma: public");

header("Expires: 0");

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Cache-Control: private", false);

header("Content-Type: application/vnd.ms-excel"); 

header("Content-Disposition: attachment; filename=\"sheet.xls\";" );



// construct skeleton

$dom = new DOMDocument('1.0', 'utf-8');

$dom->formatOutput = $dom->preserveSpaces = true; // optional

$n = new DOMProcessingInstruction('mso-application', 'progid="Excel.Sheet"');

$dom->appendChild($n);



$workbook = $dom->appendChild(new DOMElement('Workbook'));

$workbook->setAttribute('xmlns','urn:schemas-microsoft-com:office:spreadsheet');

$workbook->setAttribute('xmlns:o','urn:schemas-microsoft-com:office:office');

$workbook->setAttribute('xmlns:x','urn:schemas-microsoft-com:office:excel');

$workbook->setAttribute('xmlns:ss','xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet');

$workbook->setAttribute('xmlns:html','http://www.w3.org/TR/REC-html40');



$styles = $workbook->appendChild(new DOMElement('Styles'));

$style = $styles->appendChild(new DOMElement('Style'));

$style->setAttribute('ss:ID','Default');

$worksheet = $workbook->appendChild(new DOMElement('Worksheet'));

$worksheet->setAttribute('ss:Name','sheet1');

$xmltable = $worksheet->appendChild(new DOMElement('Table'));



// populate with data

foreach ($data as $datarow) {

    $xmlrow = $xmltable->appendChild(new DOMElement('Row'));

    foreach ($datarow as $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 quit

echo $dom->saveXML();

?>

doppelbauer at gmail dot com 14-Oct-2006 07:47


Benchmark test:



http://qdbm.sourceforge.net/benchmark.pdf

kevinphpdotnet at stormtide dot ca 17-Mar-2004 11:10


When using db4 on redhat 7.3 you may get signal 11s on the apache child processes. The installation test scripts will report that db4 is working correctly as the cli will not sig 11 out. The solution is to check 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 longer have your child processes dying out and db4 will work. If you do not get a sig 11 after dba_open just ignore this comment.

djm at web dot us dot uu dot net 17-Oct-1999 03:28


With db2, you need to call dba_sync() to get the data written to disk; 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.

DBA 函数

Table of Contents

User Contributed Notes