ABASE MySQL search, add, edit, and delete features – actual working examples

Thank you to the developer, Richard, for making this capability available in this excellent database plugin!

After carefully following the instructions and browsing some of the ABASE forum messages, the Search, Add, Edit, and Delete features work great! I am sharing my actual working code with others in hopes of helping the Open Source community.

Search (domain.com/parts, search results appear on the same page through the ABASE program’s javascript codes)

[abase form="1,search,/parts/" 
table="inventory" 
columns="PART_NUMBER=%PART_NUMBER%$Search Part Number" 
elements="PART_NUMBER"]
[abase table="inventory" 
columns="PART-NUMBER^PART_NUMBER!'text 150;30;-5',DESCRIPTION!'text 150;30;-5',MANUFACTURER!'text 150;30;-5',QUANTITY!'text 150;30;-5',PDF!'width:48px;vertical-align:-25px;',IMAGE!'width:50px;vertical-align:-25px;'" 
images="PDF,IMAGE" 
files="PDF" 
notitle="0" 
rlink="PART_NUMBER" 
limit="1" 
ack="1,GREEN"]

Add (/private/admin-add.html)

[abase form="1,insert" 
table="inventory" columns="PART_NUMBER!'325',DESCRIPTION!'325',MANUFACTURER!'325',QUANTITY!'325',PDF!325,IMAGE!'325'$Add Part" elements="PART_NUMBER,DESCRIPTION,MANUFACTURER,QUANTITY,PDF,IMAGE" 
files="PDF" 
images="PDF,IMAGE" 
ack="green" 
notable="1"]

Edit (/private/admin-edit.html)

[abase table="inventory" columns="PART_NUMBER!'325',DESCRIPTION!'325',MANUFACTURER!'325',QUANTITY!'325'" 
ack="GREEN" 
rlink="PART_NUMBER"]

[abase form="1,update" 
table="inventory" 
columns="PART_NUMBER!'600',DESCRIPTION!'600',MANUFACTURER!'600',QUANTITY!'600',PDF!'600',IMAGE!'600'$Update Part" 
elements="PART_NUMBER,DESCRIPTION,MANUFACTURER,QUANTITY,PDF,IMAGE" 
files="PDF" 
images="PDF,IMAGE" 
ack="GREEN" 
notable="1"]

Delete (/private/admin-delete.html)

[abase table="inventory" 
columns="PART_NUMBER!'325',DESCRIPTION!'325',MANUFACTURER!'325',QUANTITY!'325'" 
ack="1,GREEN" 
rlink="PART_NUMBER"]

[abase form="1,update,4" 
table="inventory" 
columns="PART_NUMBER!'600',DESCRIPTION!'600',MANUFACTURER!'600',QUANTITY!'600',PDF!'600',IMAGE!'600'$Delete Part" 
elements="PART_NUMBER,DESCRIPTION,MANUFACTURER,QUANTITY,PDF,IMAGE" 
files="PDF" 
image="PDF,IMAGE" 
ack="green" 
notable="1"]