MICROSOFT WEBMATRIX ACCESS DATABASE HOW TO
MICROSOFT WEBMATRIX ACCESS DATABASE CODE

We only must take into account one thing, how we will name our inputs, because WBSP have its automatic mechanism for catching get and post values.ДЄs you can see we have used a pure HTML, but we have also used a specific naming method in the input names. In the previous step we have made a report page, now we need a filtering form, for example what if we do not want to view all the records, we want to view just records for the publish year 2007.Д¬reate a file named as 'search.htm', in this file we will not need any WBSP code, we will only make a HTML form with inputs and a submit.

MICROSOFT WEBMATRIX ACCESS DATABASE CODE

We will save all this as defaut.wbsp file, where the extension wbsp will say to the server that this file have a WBSP code in it. Between these two commands we will show the records using the function $wbf, in our case we are viewing four fields in the table and WBSP will replace every one with the field value in the table.ДЇinally we have First page Last page which will generate for us the navigation links automatically, this is a very cool command, we do not need to calculate anything, it will automatically create as many pages as we need. If the query returned 10 records it will loop for ten times. The most important code in this template is and which represents the start and the end of the looping function, everything between these two will loop for as many times as records we want to show.

In the template we want to view ten records in a table and then show the navigation bar where users can go next or previus page to see more records. Create the body (template):ДЄfter creating the header setion we have to create the template, and that is very simple, it is our HTML code with simple lines of WBSP code where we want to show our data. Now give the server a simple comment like command which says to the server begin interpreting the template. We can skip this line and it will list the whole table, but what if we have a table with 10 000 records or more, do you really want to show it all in one page? So we will use WB_MaxRec=10 and that is all what we need. Finally we want to limit our results, let us show 10 records by page. We told the server which database file to connect and which table to select, now we need to tell it what to do, and in our case is query, using the command WB_Command we give it a value Q and we did it. To specify which table we will select we use wb_rcdset=Titles, as you see I will select the table Titles. The server will look for the file name what ever we give as a path for it after wb_basename and connect to the database file. wb_basename=biblio.mdb is our database file, I have putted our database in the same folder as my HTML file so I am calling it directly. is the starting tag for the section, when the server sees this code it will start receiving our commands. We will simply say for the server to connect to our access database and select a table, list for example 10 records only and make a pagiation. Here you put information about the database, recordset, template, error template, log file, redirection, etc. This section contains the variables that are essential for processing WBSP file. Create the header:Д®very WBSP page have a header, it is a place where we put some information needed by the server, everything we write in this section will not apear in our page.

WBSP is a very powerful tool for publishing databases online with a very simple code, it is not like classic web programing languages. I will use a simple example using WhizBase Server Pages (WBSP) to develop this report. If you have a design for your report you will need to slice it and make a HTML page, you can use GIMP on linux or Photoshop on windows, then use any HTML editor or text editor to make the HTML code. I will fill it with some data and save it, and we have a database file.

ID as number data type which will be our primary key also.

We will create the databse in Microsoft access, I will create a database and name it as biblio and create a table and name it Titles, we will make these fields: To show your report online, you will need a database access file and a HTML file which will show the report or the query results.

MICROSOFT WEBMATRIX ACCESS DATABASE HOW TO

This method is best way for web designers, who know how to make a web page in HTML, but do not know how to connect it with the database, without using PHP or ASP. Will need a couple of thousands of Euros to make a simple website to present your company.In this article I will give a simple tutorial how to publish your database report without the need for a web-developer, something simple but yet very powerful, with your Microsoft access database. Not have yet a budget for making a website, they think it is very expensive, and they are right. Today every company had to have a website, it is something like having a telephone number or a company address.

Microsoft webmatrix access database