This tutorial will give you a fast look what you can do with WhizBase. I expect you already know how to work with HTML at least, and that you understand the basics of the internet and how the internet works.
WhizBase is a server-side scripting language, which uses simple English words for its commands. WhizBase files regularly have .wbsp extension, but it also can have .ic, .sr, .inc and other less likely.
The syntax of WhizBase is directly embedded in HTML code, for example if you want to show the current date you use:
This is the date today: $WBFN[DATE]
Every WhizBase file is interpreted first then sent back to the browser, so this code will not show any WhizBase code in the source code of the page.
As with most server-side scripting languages, WhizBase supports conditional programming, you can write IF statements and switch case statements in WhizBase. Here is the basic syntax and examples:
$WBIF[expression|true part|false part]
If we need to show the string "Today is Friday" only when it is Friday we use:
$WBIF[ $WBFN[WEEKDAYS] = "Friday"
Today is Friday
I am sorry today is not Friday
If just IF and ELSE are not sufficient (we want more than one case) we must use the CASE statement:
For the seven days in the week:
Passing Data from a Form
Today is Sunday, Today is Monday, Today is Tuesday, Today is Wednesday, Today is Thursday, Today is Friday, Today is Saturday
Today is unknown!
One common reason to use server-side programming on sites is to collect data from the visitors. To collect some data from the user we will use a simple HTML Form:
<form method="post" action="process.wbsp">
First name: <input type="text" name="fname" size="30">
Date of birth: <input type="text" name="bdate" size="30">
Now on the server-side in our file "process.wbsp":
Hello $WBV[fname], your date of birth is $WBV[bdate]!
A very powerful tool that is common on websites is a contact us form. The form can simply send an email by WhizBase, passing the subject, description and client's email.
First we have the HTML form:
<form method="post" action="email.wbsp">
Your email: <input type="text" name="email" size="30">
Subject: <input type="text" name="subject" size="30">
Body <textarea cols="30" rows="5" name="emailbody"></textarea>
Now we make the WhizBase email:
By defining the data of the server in the code before, we have code which will send an email to the defined destination.
Working with the Database
The simplest DB that WhizBase work with is Microsoft Access "mdb". But it also work with any common database.
To query all the fields in an access recordset we use this code:
This code will show all the data in the DB viewed in 20 records in a page with a navigator automatically generated for easier surfing.
Finally, how to write files using WhizBase?
You have a lot of ways to write files in WhizBase, for example you can write ini files or txt files. I will show you the simplest way I have found:
Today is $WBFN[DATE]
When you open this file you will find today's date.
What is next
WhizBase can do a lot more than my examples have shown; you can work with sessions, arrays, variables, make complex calculations, update/delete/add records in any DB, sending sms's or mails to mailing lists and other features.
You also also wish to read some of my previous articles:
NurAzije is a PHP and WhizBase programmer, who at the time of article publication is working in partnership with WhizBase on several projects.
For more information email me at: NurAzije [at] Gmail [dot] com
Or visit the WhizBase official site at www.whizbase.com