description

This is just a simple wordpress plugIn to submit values to a specific mySQL database.

You can configure the plugIn to either add the given values to a mySQL database or to send those values to a specific e-mail address.

Additional features are:
* Confirmation mail
* Custom mail subjects
* Custom mail messages
* Custom message after form is submitted
* Custom stylesheet selection

Please make sure to read the following text before using the plugIn.
It is important.

download

Get the latest release right here.
latest version: 1.1.1

Download db-form 1.1.1

installation

1. Download the above .zip file.
2. Put the "db-form" folder in your wordpress plugin directory "/wp-content/plugins/".
3. Acitivaty your form in the wordpress plugin admin panel.
4. Set the plugin up using the admin panel "db-form" in the settings tab.
5. Make sure to provide all the data you need. For database usage all DB fields are required.

shortcodes

You will configure the form using shortcodes
The available shortcodes are:

* [db_form] - Encloses your form.
* [input]
* [mail]
* [hidden]
* [textarea]
* [radio]
* [select]
* [checkbox]
* [submit]

Each of those shortcodes, except [db_form], can handle specific attributes. Those attributes are:

* label
* value
* name
* required

Special attribute for [radio] and [select] is:
* description

label

This will be the label which will be returned infront of input fields, behind radio buttons and checkboxes and on the submit button
Any caption can be used.
Default: NULL

value

Specify this attribute to either give input fields a standard text or to define the submit values of radio buttons and checkboxes
Any caption can be used.
Default: NULL

name

The name attribute specifies in which column in your mySQL database the value should be submitted.
Any caption can be used.
Default: NULL

Important:
The name-attribute needs to be identical with the column name in your mySQL database
Note:
Don't use spaces neither within your name-attribute nor as your mySQL column name.
This plugIn is not tested with spaces within the name-attribute.

required

Use this attribute to set whether the field is required or not.
Takes only true and false as values.
Default: false

description

This attribute can only be used with the [radio] and [select] shortcodes.
It can be used to put a text in front of your radio buttons / select dropdown.
Default: NULL

shortcode example usage

example 1

Form to submit firstname, lastname and an e-mail adress.
Firstname and e-mail are required lastname isn't.
E-Mail field will have the default value "xx@yy.zz"

[db_form]
[input label="Firstname *" name="sql_firstname" required="true"]
[input label="Lastname" name="sql_lastname" ]
[mail label="E-Mail *" value="xx@yy.zz" name="sql_mail" required="true"]
[submit label="Send!"]
[/db_form]

This will produce the following:

example 2

Form to submit the answer to 2 questions and an e-mail adress.
Everything is required.

[db_form]
[radio description="Choose your gender. *" label="Male;Female" value="m;f" name="sql_gender" required="true"]
[radio description="What's the right answer to 2+2? *" label="3;7;4;2" value="3;7;4;2" name="sql_math" required="true"]
[mail label="E-Mail *" name="sql_mail" required="true"]
[submit label="Transmit data."]
[/db_form]

This will produce the following:

example 3

Form to submit 2 text fields and the value of a checkbox.
Only the checkbox is required.

[db_form]
[input label="Your location" name="sql_location"]
[input label="Your destination" name="sql_destination"]
[checkbox label="I'd love to use your plugIn" value="yes" name="sql_use" required="true"]
[submit label="Submit my choice."]
[/db_form]

Note:
The checkbox-shortcode can also work as an enclosing element. That's especially useful whenever you want to use a lot of code or even HTML markup behind your checkbox.
[checkbox value="yes" name="sql_use" required="true"]I'd love to use your plugIn[/checkbox]

This will produce the following:

mail message examples

You can set up custom mail and mail confirmation messages including the values submitted by the frontend-user.
To do so you have to use the field's name-attribute enclosed in "%".
In addition to that you can use full HTML markup.

See the examples below.

example 1

Corresponding to shortcode example 1

<strong>Firstname:<strong> %sql_firstname%
<strong>Lastname:<strong> %sql_lastname%
<strong>E-Mail:<strong> %sql_mail%

The mail you recieve will look like this:

Firstname: user's firstname
Lastname: user's lastname
E-Mail: user's e-mail

example 2

Corresponding to shortcode example 2

Your user's gender is <strong>%sql_gender%<strong>
and he/she believes that <strong>%sql_math%<strong> is correct.
Contact him/her by mail: <a href="mailto: %sql_mail% >%sql_mail%</a>

The mail you recieve will look like this:

Your user's gender is m
and he/she believes that 4 is correct.
Contact him/her by mail: mail@mail.mail

custom stylesheets

Note:
Right now in Version 1.1.1 this feature is not supported.
It will be updated to work again in Version 1.1.2
Planed release: Mai 16th

To use custom stylesheets with the db-form plugIn you need to create a folder outside of the actual db-form folder.

Create this folder using the plugIn's function to do so.
Go to the "db-form" settings and scroll down to Styling.
A message should appear which will let you create the "db-form-assets" folder.

Upload custom stylesheets to the "db-form-assets" within your plugin folder.
Stylesheets within subfolders won't be detected.

contact

Official wordpress plugIn page: http://wordpress.org/extend/plugins/db-form/

Send bug reports, feedback and other notes using this mail:
v.alisch@gmx.de