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:		11
message%database:		DB Error: unknown error
%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=>''
session%database:queryaction:		select
session%database:query:		select * from PhoneBook where Height > 350
session%database:select:		select * from PhoneBook where Height > 350

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