Brad's Entity Attribute Value Database

This plugin allows you to create an entity-atribute-value database for your custom data you would like to store

Author:Bradley Smith (profile at wordpress.org)
WordPress version required:5.6
WordPress version tested:5.7.2
Plugin version:2.13
Added to WordPress repository:23-03-2021
Last updated:30-06-2021
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
Rating, %:0
Rated by:0
Plugin URI:http://mobilebsmith.hopto.org
Total downloads:654
plugin download
Click to start download

Welcome to Brad’s Entity Attribute Value Database
This welcome page is where I will place ongoing information when I update this plugin. Also this will (I hope) have enough documentation to get you started. So what is an Entity Attribute Value Database? Well the easiest way is to have you read about with the links below, and if you have any other please let me know.

https://blog.greglow.com/2018/02/12/sql-design-entity-attribute-value-tables-part-1/
https://blog.greglow.com/2018/02/19/sql-design-entity-attribute-value-tables-part-2-pros-cons/
https://en.wikipedia.org/wiki/Entity-attribute-value_model

Okay so inshort this plugin is meant to allow people to track items (people,cars,etc) without the need to create a database table for each thing. All data is currently stored in 4 tables.

As things progress hopefully I will get default values, incrementing values, and many other things going. This is of course the first plugin I have released, so as always I am looking for ways to do things better.

This first version is more of a proof of concept and to see what others think as I develop more.

Okay so first there is very small amount of error checking, and onto the help section:

Admin Pages
Manage Records – This is where you will define the record names you want to keep things in
Mange Attributes – This is where you will define your fields
Manage Record Layout – This is where you will define what fields are in each of your records
SQL Default – This is where you will define sql for defaulting values

shortcodes – standalone
[eav_tbl table=tablenamehere] – currently this shows all the rows in for the table in the argument
– there is an additional option allowupd=y will allow the person to update the record
– also you can use flds=2,4,6 which will only show fields 2,4,6 – order must be low to high
[eav_add table=tablenamehere] – currently this allows you insert values into the table in the argument

shortcodes – group1
[eav_startadd table=tablenamehere] – this shortcode starts the selective data entry
[eav_field field=fieldnamehere] – this shortcode places the an entry box for tablenamehere.fieldnamehere. You can also add a “hidden=y” value as well and this field will be of type hidden instead of text.
[eav_subrec table=subtablehere] – this shortcode places an entry row for a child record on the page
[eav_endadd] – this is the shortcode you use to close the form, you can only have 1 eav_startadd/eav_endadd combination

There are 2 demo apps that you can see how things are done
– Guest Registration, this will create a all the fields, records and a page which will show you how to create a data entry page
– Apache Log, this will install record,field that you can now use the apache shortcut to load apache web data


Screenshots
FAQ
ChangeLog