Table
[abase]
[abase form=”1,insert” table=”Staff” elements=”SurName,FirstName,OtherNames,PhoneNo,Email,DateReg,Amount,Picture” columns=”SurName!’100′,FirstName!’100′,OtherNames!’100′,PhoneNo!’100′,Email!’100′,DateReg!’100′,Amount!’100′,Picture!100$Add Employee” images=”Picture” ack=”green”]
[abase table=”Staff” columns=”Picture!’width:50px;vertical-align:-25px;’,Staff_id,SurName,FirstName,OtherNames,PhoneNo,Email,DateReg” images=”Picture” style=”width:500px;”]
[abase form=”1,search” table=”Staff” columns=”SurName,FirstName$Search Staff” elements=”SurName,FirstName”]
[abase table=”Staff” columns=”SurName,FirstName” rlink=”SurName” echo=”blue”]
[abase form=”1,update” table=”Staff” elements=”SurName,FirstName,OtherNames,PhoneNo,Email,DateReg,Amount,Picture” fields=”SurName,FirstName,OtherNames,PhoneNo,Email,DateReg,Amount,Picture$Update Staff” images=”Picture” ack=”brown” echo=”blue”]
ABASE emailto=columns=”SurName] Bassey, here is the contents of the Staff table: [abase table=”Staff”] BAS. [/ABASE
[abase form=”1,insert” table=”employees” elements=”first_name,last_name,picture” columns=”first_name!’100′,last_name!’100′,picture!100$Add Employee” images=”picture” ack=”green”]
Displaying the employees table with pictures would be as follows:
[abase table=”Staff” columns=”picture!’width:50px;vertical-align:-25px;’,first_name,last_name” images=”picture” style=”width:500px;”]
[abase form=”1,search” table=”employees” columns=”first_name,last_name$Search Employees” elements=”first_name,last_name”]
[abase table=”employees” columns=”first_name,last_name” rlink=”first_name” echo=”blue”]
The first name will appear as a link. Clicking on a link first name will re-display the page with the primary key and value in the query string. To create the form, place the following shortcode on the same page.
[abase form=”1,update” table=”employees” elements=”first_name,last_name” fields=”first_name,last_name$Update Employee” ack=”brown” echo=”blue”]
When a record identified by its primary key is in the query string, an update form for that record will be produced.