Examples

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:

HTTP Error 404.0 - Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Most likely causes:

  • The directory or file specified does not exist on the Web server.
  • The URL contains a typographical error.
  • A custom filter or module, such as URLScan, restricts access to the file.

Things you can try:

  • Create the content on the Web server.
  • Review the browser URL.
  • Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here.

Detailed Error Information:

Module   IIS Web Core
Notification   MapRequestHandler
Handler   StaticFile
Error Code   0x80070002
Requested URL   http://new.whizbase.com:80/blogcodes/39.html
Physical Path   c:\wwwroot\whizbase\blogcodes\39.html
Logon Method   Anonymous
Logon User   Anonymous

More Information:

This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.

View more information »

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

There’s much more in WhizBase than basic functions for creating, reading, updating and deleting database records.

Using programming model "we do complicated stuff, so you don’t have to”, we added many advanced features enabling our users to include complex functionality with just a few lines of code.

These features include:

Reading RSS feed
Reading Atom feed
Reading any XML document
Using XPATH
Caching pages or individual sections
Encryption/Decryption
Calculating HASH
User authentication
Sending email
Creating captcha code
Using sessions
Using regular expressions
… and many others

The examples for using some of these functions
are listed in the table below:


Reading RSS feed from Facebook page
Run example View code
List video clips from YouTube channel using WBGetXML Run example View code
Reading Atom feed from Blogger Run example View code
Calculating HASH Run example View code
Cached code
First call can be slower (if cache has expired), but second
(and all others in period of 5 minutes) will be cached.
To see the speed of non-cached content please click here.
Run example View code
Password protected page - basic authentication
User: wbuser / Password: wbpassword
Run example View code
Password protected page - digest authentication
User: wbuser / Password: wbpassword
Run example View code