May 25, 2011

Sending an email with embedded images using WhizBase

WhizBase has a built-in functions for sending a rich-text (HTML) emails. In your email you can easily include

How to collect data from web visitors and save them in your database

It is very easy to make data collecting web application using the WhizBase. We will do it using only two WBSP files - one containing the form (form.htm) and the other that saves received data into the database (add.wbsp).

Database structure for subscribers.mdb
Table Mlist
FistName Text 50
LastName Text 50
Email    Text 50


File form.htm
<html>
<head>
<title>Subscribe to mailing list</title>
</head>
<body>
<form action="add.wbsp" method="POST">
<table border="1" cellspacing="0"" cellpadding="3" bordercolor="#000000" bgcolor="#FFFFFF" style="border-collapse:collapse;">
<tr><td valign="top"><strong>First Name</strong></td><td valign="top"><input type="text" name="WBF_FirstName" value=""></td></tr>
<tr><td valign="top"><strong>Last Name</strong></td><td valign="top"><input type="text" name="WBF_LastName" value=""></td></tr>
<tr><td valign="top"><strong>Email Address</strong></td><td valign="top"><input type="text" name="WBF_email" value=""></td></tr>

</table>

<input type='submit' value='Submit'> <input type='reset' value='Reset'>
</form>
</body>
</html>


File add.wbsp
<!--
[FormFields]
WB_BaseName=subscribers.mdb
WB_Command=A
WB_RcdSet=mlist
-->
<!--WB_BeginTemplate-->
<html>
<head>
<title>Thank you for subscribing</title>
</head>
<body>
Thank you for subscribing with us!<br>
Added data:<br>
$wbf[FirstName] $wbf[LastName], $wbf[email]
</body>
</html>

As you can see, first file is ordinary HTML file with form, text input fields and submit/reset buttons. Second file is a simple WhizBase program that instruct WhizBase to use the table mlist from database file subscribers.mdb, to add data received in WBF_ form fields and to display added data using $wbf function.

May 18, 2011

Whiz your database to the web, now as a SaaS!

DSD WhizBase has released version 6.1 of WhizBase, a powerful tool primarily focused on publishing databases on the web with little or no programming knowledge.

WhizBase is the friendly middleman between your database, where you keep your data, and the web, where you need it to be!
It does the talking between the two, so you can make the most out of your time and resources! It enriches your HTML with powerful yet extremely easy to use dynamic features, such as: merging your pages with database contents, uploading files, password protecting files, adding, updating and deleting database records, conditional statements, loops, math functions, and more than 200 other functions.

So whenever you need to get content from a database to the web, or from the web into a database, WhizBase is the fastest and most effective solution!
Even if you have no programming experience whatsoever, with minimal HTML and excel sheet skills, you will see results in less than 30 minutes!
And if you're an IT professional, WhizBase can truly shine for you because it allows you to bridge platforms, technologies, and doesn't require picking up whole new language skill sets! WhizBase is a great platform for building professional web based applications, SaaS, intranet solutions and any other kind of dynamic web content.

WhizBase supports all database types, including: Access 2.0 to 2010, dBASE III, IV and 5.0, Paradox 3.x, 4.x and 5.x, FoxPro 2.0, 2.5, 2.6 and 3.0, MS Excel files, TXT and CSV files, MySQL, MS SQL, Oracle, Firebird, Informix, etc.
Output is exportable to RTF, XML, HTML, DHTML, TXT, RSS, JavaScript, CSS, VB Script, WML, Adobe® FLASH® external data file, XHTML, XAML, WAP and more.

New version brings numerous enhancements including the support for virtual directories, tools for stronger administration of hosted sites, native support for Microsoft® Access 2010 databases and many new functions and system variables.

With this version WhizBase is offered also as a SaaS, so instead of buying the license you can simply rent it for only $15/month, along with your choice of offered hosting plans (price varies), or integrate WhizBase service with your own existing hosting plans for only $20/month.

WhizBase 6 runs under Windows 95 / 98 / NT4 / 2000 / Me / XP / 2003 / Vista / 2008 /Windows7 and supports many popular Windows-based web servers that support standard CGI applications and filtering including IIS, Apache, Xitami, Abyss, and many others.

A 14 day risk-free all-inclusive trial of WhizBase software solution combined with hosting services is available free of charge, and you can also download a fully functional trial version of WhizBase 6.1 from http://www.whizbase.com/.

WhizBase 6.1 costs $299 (US) for a single-domain license. Server and Developer licenses are available. For more information, contact Becky R. Northaven, 803 E. 1st Street, Port Angeles, WA 98362; Skype: BeckyNorthaven; Email: info@whizbase.com Internet: http://www.whizbase.com/ Phone: +1 (360) 775-2844.