Database Engine

This is an Engine to test drive the "database" BEE command.
Please click "Go" at the end of the page.
BEE Tag
<beedatabase "" query="" action="" seek="">
Output Variables
status%database:0
message%database:
%thisrecord|list:0=>''
%lastrecord|list:0=>''
%datacount|list:0=>''
%tablelist|list:0=>''
%fieldlist|list:0=>''
%mustfields|list:0=>''
%page|list:0=>''
%sought|list:0=>''
%first|list:0=>''
%last|list:0=>''
Output Records (if any)
<beedatabase
 database= eg database=mydb     Note: Set to blank to clear all settings
query=
action= ! : Note: action is effective only if query="".
seek= eg seek=3,5,10 shows 5 records from the 3rd; the last is page-per-block (not used in this page)
>

Arguments:

(The database result name in front of the % sign is understood.)
%table=
%selectfrom=
%where=
%orderby=
%keyfield=
%wild=

The followings are entered in array format. eg Tel=>029281*, Price=>250
%encode= eg Expiry=>strtotime, ...
%decode= eg Expiry=>strftime:%Y-%m-%d, ...
%search= eg Name=>John Chan, FromPrice=>100
%match= eg Tel=>regexp, FromPrice=>min:Price, ...

The followings are for matrix input (may not be applicable in this page but included here as documentation):
%fields=
%keys=
%fieldcount=
%keycount=

Back home