***UPDATED*** DB Technosystems Form Processor 02/09/2011

[wbdesigner]

You will love this form processor there just isn't anything so easy to run and yet so powerful if you want to go further with it.
click on the DTBS form processor in your extensions go to anywhere on the page ( I put mine at the top.. but it doesn't matter where you put it) and draw a box the processor will appear click on it and fill out the fields.

[itsme]

thanks wbdesigner for your prompt reply, i actually read about it a lot, but i am not able to understand the mechanism,
do you mean just put the fields and everything needed from wbb form control stuff in the page and include the form processor dbts icon on the page? what box you mean? anybox? so how this box will know that this is part of the form that will be processed with this dbts form processor?! what about checkboxes and radiobuttons, is it the same issue with the built in (putting them as q[1] q[2] and use their built-in validation issues? i think yet im missing the principles in this regard, sorry

[Navaldesign]

From the manual (Page 15):


The Form and its settings:
DBTS Form Processor does NOT create the form for you!
You need to create a form in your page using the WB Form Wizard or the WB form
tools. Once you have created the form, make sure to respect the following
settings:
The form page MUST be published as PHP.
The form action MUST be set to be “<?php echo basename(__FILE__);?>
The form encoding type MUST be “multipart/form-data”
The submit button MUST be named “submit” though its value can be anything
(like “Send”, “Send Info Now” or anything else).


Differences berween the Built in form Processor and the DBTS Form Processor ?

A LOT !

Too many to list here. If you read the manual you will see that the DBTS Form Processor does things that even commercial products that cost more than $100 simply can't do:

Particular "from" email address structure to guarantee deliverability
Custom named "email" field
Timezone and time formatting
Further posting
Storing values in SESSION (allows to create preview - confirmation pages, multipage forms, preserve values when going back after an error)
User defined behavior after processing
Custom processing and includes in user defined position (allows tou to embed practically any type of custom code in the processor)
Exclude fields if necessary.
Include or exclude null fields
Include or exclude info in the autoresponder mail
Include or exclude server detected info (time, IP address, etc)
Attach one or more files in the autoresonder mail
Send email to specific departments(example sales or support or anything else)
Ban IP addresses
Set the script behavior for spam mails and banned IP addresses
Send HTML emails (fully customizable) with your logo if you like
Select mail engine (PHP mail() or SMTP or Sendmail or Qmail) . Send mails through your Gmail, Yahoo, AOL or other accounts
Of course Database and CSV storing, settable through the processor.

and much more..........

Of course it is more complicated, because it does a LOT more..... However, it is very intuitive and well documented.

[itsme]

Navaldesign! you are genious dear, i read most of your replies in this post, i really appreciate all ur help to ppl here, including help me few minutes ago, i was reading the manual and didn't notice that information, i see other information now in page 15, however, this is really great and it is EXACTLY what i needed to know thanks a lot again dear, much appreciated. also thanks wbdesignser

i will try this invention in details

warm regards

[wbdesigner]

First of all thanks again for the form processor it's the best ever!

I filled out the DB section with all of my info
but then I'm not sure how I fillout my form which field names are which in the DB

In other words I have a field named 'title' in my DB where do I put 'title' in the form?
Patti

[Navaldesign]

# Patti: the processor will create columns with names depending on the form field names. So I'm unsure what you are asking me.

@ Hans: I will have to check this, no, it is not by design.

[wbdesigner]

where in the form do I put the form field names for a table I already have field names for?

[Navaldesign]

The processor will create (if not already existing) a column in the database that will have the name of the field, all lowercased, (ex. field name Title will create a column in the database named "title") and will replace whitespaces with underscores (ex. Field name Your Hobbies will give place in a column named "your_hobbies")

Order is not important.

[wbdesigner]

but if I already have a MySql DB all set up with fields and I have my DBTS form all working where in the wb5 form fields do I put the name of the DB field that I already have.

when I look at the properties of the form field there's a place for a title is that where it goes?

[Navaldesign]

No. As I said, it is each form field name that defines the column name in the database.
So, if you already have a column in the database named (in example) "contact_by" , your form field that should capture this piece of info, MUST be named the same way (contact_by)

[Navaldesign]

The reason why the visitor's email doesn't appear in the "from" is that many email addresses belong to blacklisted domains. Also many hosting companies, disallow emails from "free" (gmail, yahoo, aol, hotmail etc) email providers as they are used for spamming.

However, the "reply to" is set to be the visitor's email address! so if you click on "Reply", the reply email will actually be sent to the correct (the visitor's) email address.

[Navaldesign]

First, you can use the built in autoresponder, instead of using an external autoreply tool. The built in autoresponder can also attach files (if you need to send an attachment).

With this said, you can use the following trick: in the "From" property, type

".$_POST['email']."

(including the quotes)

. This, on the assumption that the user's email address field is named email . If not, use the actual field name.

[Navaldesign]

I meant the DBTS Form Processor autoresponder, not the WWB built in form processor autoresponder. Why would you want to use both ??

[Navaldesign]

A link to the form please ? Does the email arrive correct ?
Did you enable the "Store in CSV file?
Do NOT create the CSV (delete it from the server). The script will create it automatically. If the file structure is not correct, no values will be stored.

[Patrik iden]

Hello im using the DBTS Formprocessor and i'm trying to make my own captcha like function.
I have one edit box with the name: captcha_code and this value to get random code: <?php $random = substr(number_format(time() * rand(),0,'',''),0,6); echo $random?>
this field is set to red only. Then i have a second edit box named: captcha_answer this edit box is set to Data required Min:6 Max:6 and to have the same value as the first edit box.
Now averything semes to work but in the recived mail there are no data only Header and Footer.
Can you think of somthing pleas?

Regards

//Patrik Iden