First steps

We already have explained how easy it is to build a solution for CRUD operations, but that was a very basic description.

Now, since the power of WhizBase lies in the simplicity of connecting the database and a web page, we’ll start with the simplest code for displaying database records on the web page.

Open your existing, ordinary HTML web page in text editor (not WYSIWYG editor) and place the following code where you want your database records displayed in a form of HTML table:

#*
[FormFields]
wb_basename=biblio.mdb
wb_rcdset=titles
wb_command=q
*#
$wbdetail[T]

Of course, replace the biblio.mdb and titles with your own values (file name of the database file and table name - wb_rcdset=titles). This simple code will produce a database report containing first 20 records from your database table and navigation links (links to first, last, next and previous page, and direct links to individual pages).

Here are some other simple examples:

Simple database example Run example View code
Formatted database table Run example View code
Joined tables Run example View code
Simple search form Run example View code
Header and footer example Run example View code
Environment variables Run example View code
Uploading files Run example View code

 


Whizbase lite