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

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.
There is a dedicated section for commercial extensions.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Implemented but not released yet, probably later today or tomorrow morning.
www.dbtechnosystems.com
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Post by zinc »

Navaldesign wrote:Implemented but not released yet, probably later today or tomorrow morning.
:D :D :D :D :D :D :D :D Cheers!
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Ok, the new release is uploaded.

New / Improved Features:

New: Database Storage.
New: SMTP, Sendmail, Qmail mail engine (and the mail() as standard)).
New: tecnical info can be excluded
New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)

Improved: Mail can now be either HTML or Text, set by the administrator
Improved: HTML emails now have Alternative text with the same info
Improved: Timezone setting backward compatible with those servers that don't support the date_default_timezone_set() function


Please visit the Original Post in this very same thread to download.
www.dbtechnosystems.com
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Post by zinc »

Navaldesign wrote:Ok, the new release is uploaded.

New / Improved Features:

New: Database Storage.
New: SMTP, Sendmail, Qmail mail engine (and the mail() as standard)).
New: tecnical info can be excluded
New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)

Improved: Mail can now be either HTML or Text, set by the administrator
Improved: HTML emails now have Alternative text with the same info
Improved: Timezone setting backward compatible with those servers that don't support the date_default_timezone_set() function


Please visit the Original Post in this very same thread to download.
Superb George. Thank you.
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

You

1. Uncheck the "Use Built in Form Processor" and set the action and encoding type as per manual
2. Drag the DBTS Form Processor object, anywhere in your page, doesn't need to be on the form.
3. Add the hidden field "formid" and give it whatever value you want.
4. Double click the DBTS Form Processor object so that the Properties window opens, and setup the processor as you like.

Save, Publish, Refresh your browser, Test
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Navaldesign wrote: New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)
Naval a question not directly related to this extension.

If I create a multipage form which has 4 forms on 4 different pages interrelated and to submit and send email only when the last form in sequence is filled and submitted, do we have submit button on all the forms to move to the next page form or how this happens?
In this same situation, which page will bear this extension? The last one or all?
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

me.prosenjeet wrote:
Navaldesign wrote: New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)
Naval a question not directly related to this extension.

If I create a multipage form which has 4 forms on 4 different pages interrelated and to submit and send email only when the last form in sequence is filled and submitted, do we have submit button on all the forms to move to the next page form or how this happens?
In this same situation, which page will bear this extension? The last one or all?
All pages will have the extension. ALL pages will need the submit button.

Each form page will have as success page the next form page except the last one that will send the user to the success page.

First Form will have the Copy in Session enabled.

Intermediate form pages will have BOTH Copy From Session AND Copy in Session.

Last form page only needs the Copy From Session enabled.

Only the Last page should have mails and eventually storage enabled.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Navaldesign wrote: All pages will have the extension. ALL pages will need the submit button.

Each form page will have as success page the next form page except the last one that will send the user to the success page.

First Form will have the Copy in Session enabled.

Intermediate form pages will have BOTH Copy From Session AND Copy in Session.

Last form page only needs the Copy From Session enabled.

Only the Last page should have mails and eventually storage enabled.
That works perfect Naval! One issue, remember you helped me with the cost.php that calculated the cost...that is not showing. I tried various permutation combination but no success. The multi foerm can be viewed here :
http://lucknowwebs.com.au/page1.php

Since the fields covered in cost.php comes on the second page of the form, I had set the "After form data reception include" to cost.php in the second form. And on form three(the final submit page) the field "Page or Script to be include before script end" as cost.php.
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Page three has nothing to do with it as the values that contribute to the cost calculation only exist in the second form.


The include i made for you was for a single page form, not a multipage one.

You should change the ending part as follows:


.....................................
if ($_POST['Ecommerce_enable_$200'] == "Yes"){
$total += 200;
}
$POST['Total_Cost'] = "$". $total;
$fieldname[] = "Total Cost";
$fieldvalue[] = "$". $total;


?>

As you see only the last part changes.
Last edited by Navaldesign on Sun Aug 02, 2009 7:09 am, edited 1 time in total.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Since the fields covered in cost.php comes on the second page of the form, I had set the "After form data reception include" to cost.php in the second form. And on form three(the final submit page) the field "Page or Script to be include before script end" as cost.php.
The settings remain as mentioned above?
I am getting this error when I submit page 2:
Warning: Cannot modify header information - headers already sent by (output started at /home2/lucknoww/public_html/lucknowwebs.com.au/cost.php:46) in /home2/lucknoww/public_html/lucknowwebs.com.au/page2.php on line 503
and the browser is not moving to page3.php
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

1. Yes
2. This is --I believe-- because you had a white line in the cost.php script AFTER the closing ?> tag which resulted in a screen output.

I fixed it for you (still have your login details.....) please test it

However, practical feedback is the only way to test. Based on your experience i found out that the Autoresponder email might NOT be sent if the email field isn't in the last page. So i updated the extension.

Please download and install again version 1.9

Having updated it, you might now be receiving the Total Cost twice, if that is the case revert back to the previous cost.php version.
www.dbtechnosystems.com
User avatar
jerryco
 
 
Posts: 826
Joined: Fri Mar 27, 2009 2:42 pm
Location: Purmerend, Holland

Post by jerryco »

Can you make a Captcha error appear above the Captcha field without losing visitor input?
// Love is the acceptance of nothing / Account age is no guarantee of efficiency ;-) ->

Above, Beyond, and @wwonderfull! <- Genuinely helps you with a powered up site that counts! Four Times Excellence!
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Jerry82 wrote:Can you make a Captcha error appear above the Captcha field without losing visitor input?
This extension has nothing to do with the captcha.

Anyway, i will answer you: though it is possible to do what you are asking, it is not possible to do it with WB6's built in captcha. Further more, to acheive such a task, you would need to use Javascript or Ajax. Since spammers and bots have Javascript disabled, in order to overide whatever validation you might have set, this validation will also be disablesd.

So your only 100% sure solution, in order not to lose the filled in values (exeption made for the upload fields, where this is not possible anyway) would be to follow my instructions as seen in this thread: viewtopic.php?t=14938


However, if you want real visitors(which normally have Javascript enabled) to get an alert on the page itself (as the other WB6 built in validations) then a further extension would be able to do it. I might have a look if i have some time.
www.dbtechnosystems.com
User avatar
jerryco
 
 
Posts: 826
Joined: Fri Mar 27, 2009 2:42 pm
Location: Purmerend, Holland

Post by jerryco »

Thank you for your quick reply. Would an ajax check work if a visitor has javascript disabled?
// Love is the acceptance of nothing / Account age is no guarantee of efficiency ;-) ->

Above, Beyond, and @wwonderfull! <- Genuinely helps you with a powered up site that counts! Four Times Excellence!
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

No.

Ajax is based on a Javascript event listener, to trigger the HTTPRequest. If Javascript is disabled it will not work.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Naval...
http://lucknowwebs.com.au/check/page1.php
The settings for each page as under(screenshots):
http://lucknowwebs.com.au/cheeck/page1.jpg
http://lucknowwebs.com.au/cheeck/page2.jpg
http://lucknowwebs.com.au/cheeck/page3.jpg
This trial system is in a folder 'cheeck' and the cost.php is kept in it.

The issue is when the form is finally being submitted, the data from page1.php is not coming in the email and the page2.php data is starting with the total cost (which is supposed to go at the end of page2.php data)and the submit button of page2 is being displayed as a field.

See the screen shot of the mail here:
http://lucknowwebs.com.au/cheeck/mailtoadmin.jpg
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Did you update the extension / republished as i advised ?
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Yes, I suppose this is the latest update you uploaded and when I uploaded it to the trial folder, I did a 'full upload'
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

:Update:
Naval,
Actually if you look at the mail screen shot...

http://lucknowwebs.com.au/cheeck/mailtoadmin.jpg

it is sending the data of all the three forms but in a different order...
page2.php first (starting with the total value)
page1.php second (starting from 'Name')
page3.php third (starting from 'Need hosting at.....')

Further, after rectifying this anyway I can highlight the text or the field "Total cost" in the HTML email?
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

I update the extension approx 40 mins ago based on your remarks.

Did you update in the last 40 mins ???
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Oh no I didnt do it before 40mins... I will do it now and come back to you again
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Ok, I updated kept the settings of all the pages same as in the earlier posts..(check the jpeg)
http://lucknowwebs.com.au/cheeck/page1.jpg
http://lucknowwebs.com.au/cheeck/page2.jpg
http://lucknowwebs.com.au/cheeck/page3.jpg

Still not correct...this is the mail I got:
http://lucknowwebs.com.au/cheeck/mailtoadmin2.jpg
Please check that...it doesnt send the total cost and the page1.php part of the form is missing

Further in the settings, I have 'Yes' for sending mail to admin and automail on the page1.php and page2.php, I suppose I need to remove that. It is sending a mail moment any of the pages are submitted.
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Sure....
You changed folder and you didn't copy the "cost.php" file.

And, in page 1, you have NOT set the "Copy in Session" to be "Yes" . You have set the "Copy From Session" to be "Yes".
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Thanks Naval,
Thanks for pointing out the errors ...it seems to work perfect only that the first form Submit button (Button1 Submit) is coming as a field in the email.(Wonder why it is coming while the same button on form 2 isnt coming that way!)
Also please tell me how I can highlight the field "Total Cost" in the email...with some colour in text or background maybe.
Please see the screen shot of the email:

http://lucknowwebs.com.au/cheeck/mailtoadmin3.jpg
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

The button is included in the fields because you didn't name it "submit" as the manual instructs, you have left the default name "Button1"

If it is the same in the other pages too, only one value is received, so check also your other pages.

There is no way to highlight a specific cell of the HTML email directly from the script settings as this is not a planned function.

You can, however, try this, in your "cost.php"


$fieldvalue[] = "<font style=\"background-color:#FFFF00\">."$". $total."</font>";
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Naval,
Renamed it to submit and that was rectified!
I wonder how you seem to know everything...Thanks a lot!

One thing....
Navaldesign wrote:You can, however, try this, in your "cost.php"


$fieldvalue[] = "<font style="background-color:#FFFF00">."$". $total."</font>";
Getting this error with this line:

Code: Select all

Parse error: syntax error, unexpected '$' in /home2/lucknoww/public_html/lucknowwebs.com.au/cheeck/cost.php on line 41

Line 41 is the line that was edited
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Sorry, my mistake:

$fieldvalue[] = "<font style=\"background-color:#FFFF00\">$". $total."</font>";
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Thanks let me try that
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Naval,
There is an issue with that code you sent.
Whenever, I tried replacing the original -
$fieldvalue[] = "$". $total;
with this-
$fieldvalue[] = "<font style=\"background-color:#FFFF00\">$". $total."</font>";
--First, the mail that comes after submitting the form is going to the spam folder and thats not good.
--Second, the added background colour is not showing and it shows as it was before

Any suggestions?
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

I can't answer you on why it goes to the spam folder simply because we add a background color to a field text! It makes no sense.

I have still your login details, I'll check for myself.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Check it after 5 minutes form now, I just changed the code. Uploading the one with the edit you suggested in 2 minutes.
Update: You may try now
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

I can't know about the issue with the mail ending up in your spam folder. In my email it is all ok.

I fixed the background, download from your server the updated cost.php file.

I was forgetting that this is the second page, so it was the $POST[] =...... line that needed the background added.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Wow !!!!!!!!
It worked thanks a load once again...you are a Saviour for sure :lol:
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Re: Question about mail engine settings

Post by me.prosenjeet »

Sandyfishgirl wrote:I'm just trying this form and ok, until I get to the "I. Mail Engine Settings". Up to this point, I am following instructions to build the form - but I don't know anything about this section. Checking websites for this information, is not helping me a lot.

I "think" I should just leave the setting as Mail() function. I will not allow uploads or data storage.

Is there a place where I can read more on the subject of mail engine settings - in SIMPLE terms? Then I will know the correct information for my form.

Under "Visual Settings" the color picker is WAY

:roll: - - it JUST hit me what this extension does - I was thinking it WAS A FORM, with the auto responder built-in :shock: ha ha
Now, that I'm with the "program" I think I still need the first issue (mail engine settings) answered. BUT now, I should also know - - WHERE on my page should this extension be placed in relation to my form? Next to it? on top of it? Within the "grid"? Under the kitchen sink?


THANK YOU!!
If you read the pdf thats enclosed along with the download that may sort some of the questions in mind.
Regarding your last question whether to place the extension under the kitchen sink, yes you may do that and still it will work...thats the beauty of this extension just put it on any damn place on the form page and wallah! it fires! :wink:
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: Question about mail engine settings

Post by Navaldesign »

Sandyfishgirl wrote:I "think" I should just leave the setting as Mail() function. I will not allow uploads or data storage.
mail() will be ok in most cases. Just in those "difficult" cases where SMTP authentication is required or the mail() is not enabled, you should use SMTP.
Last, for those rare cases where everything else will fail, Sendmail is the last alternatice.
Under "Visual Settings" the color picker is WAY

:roll: - - it JUST hit me what this extension does - I was thinking it WAS A FORM, with the auto responder built-in :shock: ha ha
Now, that I'm with the "program" I think I still need the first issue (mail engine settings) answered. BUT now, I should also know - - WHERE on my page should this extension be placed in relation to my form? Next to it? on top of it? Within the "grid"? Under the kitchen sink?
Under the sink is as good as any other place. In other words, anywhere.

To be honest, This form processor is actually an evolution of ABVFP. The next update, will allow php validations:

required field, list of values, text , number, email, zip codes, passwords, password strength, equal fields, credit cards, and probably more.

The Includes allow advanced users to embed their own code in the script so it can perform calculations, validations, cross checks, create files, update multiple database tables, whatever other task you can think of, that can be performed using php code. It also allows for preview pages and multipage forms. It allows (just as me.prosenjeet did) to create a calculation script and add it's results in the mail. And much more!
www.dbtechnosystems.com
User avatar
jerryco
 
 
Posts: 826
Joined: Fri Mar 27, 2009 2:42 pm
Location: Purmerend, Holland

Post by jerryco »

Navaldesign wrote:No.

Ajax is based on a Javascript event listener, to trigger the HTTPRequest. If Javascript is disabled it will not work.
What about 'sending' the info to the next page with the error message. Would that be a watertight solution?
// Love is the acceptance of nothing / Account age is no guarantee of efficiency ;-) ->

Above, Beyond, and @wwonderfull! <- Genuinely helps you with a powered up site that counts! Four Times Excellence!
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Jerry82 wrote: What about 'sending' the info to the next page with the error message. Would that be a watertight solution?
I'm not sure what the purpose of this would be. I mean, as i said, Javascript (or Ajax) validation is fine as long as the user is not a spammer / hacker.

When it comes to those, only PHP validation can really protect you.
And PHP validation will be the next implementation to the form processor.

However, PHP validation means that the script finds the errors, and displays an error page which reports the errors, it then has a "Back" button to get the user back to the form page.
Or, it can also return the user back to the form page, and display the errors in a "error" div.
Now, assuming that the form also has a captcha, this means that most probably the values that the user had filled in will be lost. So you need to implement a mechanism that will allow to keep these values.

There are many ways to aceive this, from using sessions to posting back the values (others too, more complicated)

Al of these solutions require some experience from the user, as they are not of standard implementation.

DBTS Form processor has two cool features that makes this implementation easier: the Copy in Session tool, and the User Includes. The first will automatically copy the submitted values in the $_SESSION superglobal, so they can be retrieved easily. The second will allow advanced users to include in the processor whatever code snippet of their own, to acheive similar tasks.

Of course, you will need to add some code in the original WB form, in order to make it retrieve these values from the SESSIOn array or the POST array.

I plan to publish some tutorials on how to perform all of these tasks using DBTS Form Processor Extension, but it requires quite some time....
www.dbtechnosystems.com
User avatar
jerryco
 
 
Posts: 826
Joined: Fri Mar 27, 2009 2:42 pm
Location: Purmerend, Holland

Post by jerryco »

Thank you for explaining that.
// Love is the acceptance of nothing / Account age is no guarantee of efficiency ;-) ->

Above, Beyond, and @wwonderfull! <- Genuinely helps you with a powered up site that counts! Four Times Excellence!
User avatar
heg
 
 
Posts: 4
Joined: Sun Nov 09, 2008 10:22 pm
Location: Death Valley

Post by heg »

Wow! this is great!!! Thanks Navaldesign... Tested and working! :D
User avatar
kevinp
 
 
Posts: 96
Joined: Wed Feb 21, 2007 2:51 pm
Location: Preston, Lancashire, England

Post by kevinp »

What a fantastic script. It seems the posibilities are endless.

I've added the file below to 'After Form Data Reception Include URL' on the includes section.

Code: Select all

<? 
//set the random id length 
$random_id_length = 8; 

//generates a random id encrypt it and store it in $rnd_id 
$rnd_id = crypt(uniqid(rand(),1)); 

//removes any slashes that might have been generated 
$rnd_id = strip_tags(stripslashes($rnd_id)); 

//Removing any . or / and reversing the string 
$rnd_id = str_replace(".","",$rnd_id); 
$rnd_id = strrev(str_replace("/","",$rnd_id)); 

//finally take the first 8 characters from the $rnd_id 
$rnd_id = substr($rnd_id,0,$random_id_length); 
// I've added this later in the echo and e-mail 
//echo "When contacting us please quote: $rnd_id"; 
//Converts the reference to uppercase 
$rnd_id = strtoupper($rnd_id); 

$_POST['Submission ID'] = $rnd_id; // This line adds in the POST superglobal the unique ID you created 
$autoresponderend .= "\nWhen contacting us please quote: $rnd_id"; // This line adds to the autoresponder footer the message with the quote ID 
?>
which adds a unique ID to each email. This works fine but the ID doesn't save to the csv file. Is there a way to make the script include $rnd_id when it creates the CSV.

Also, If I wanted to echo some of the form fields to the success page as a confirmation of the submission is this possible using the Copy in or Copy from session options. I can't seem to identify the correct $names to show the fields.

Cheers
Kev
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

kevinp wrote:Also, If I wanted to echo some of the form fields to the success page as a confirmation of the submission is this possible using the Copy in or Copy from session options. I can't seem to identify the correct $names to show the fields.
Kev
That will be so nice Naval, if it can be done...for example remember my cost.php so in the Thank you page it shows the total tentative cost.
Can that be done?
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

kevinp wrote:What a fantastic script. It seems the posibilities are endless.

I've added the file below to 'After Form Data Reception Include URL' on the includes section which adds a unique ID to each email. This works fine but the ID doesn't save to the csv file. Is there a way to make the script include $rnd_id when it creates the CSV.
Change the code to

Code: Select all

<?
//set the random id length
$random_id_length = 8;

//generates a random id encrypt it and store it in $rnd_id
$rnd_id = crypt(uniqid(rand(),1));

//removes any slashes that might have been generated
$rnd_id = strip_tags(stripslashes($rnd_id));

//Removing any . or / and reversing the string
$rnd_id = str_replace(".","",$rnd_id);
$rnd_id = strrev(str_replace("/","",$rnd_id));

//finally take the first 8 characters from the $rnd_id
$rnd_id = substr($rnd_id,0,$random_id_length);
// I've added this later in the echo and e-mail
//echo "When contacting us please quote: $rnd_id";
//Converts the reference to uppercase
$rnd_id = strtoupper($rnd_id);

$POST['Submission ID'] = $rnd_id; // This line adds in the POST array the unique ID you created
$autoresponderend .= "\nWhen contacting us please quote: $rnd_id"; // This line adds to the autoresponder footer the message with the quote ID
?>
Note the changed $POST instead of $_POST


Also, If I wanted to echo some of the form fields to the success page as a confirmation of the submission is this possible using the Copy in or Copy from session options. I can't seem to identify the correct $names to show the fields.
The easiest way is to add another include.
Lets suppose that you have created a success page, named "success.php". Write the text that you want to have in the page, and in the place of the variables that need to be merged, place this text (as an example):

'.$Name.'

This can be in the middle of a sentence, in which case it will be something like:

Hello '.$Name.' Thank you for your Submission! '

Obviously, $Name is the variable, EXACTLY as your form field (Name)

AVOID form field names with white spaces, in example "How did you find us", use underscores "How_did_you_find_us". The script will strip the underscores off when mailing you.

Right click the text and add the following in the Before tag of the text html:

<?
echo '


and in the After tag,

';
?>

Now, in Start of page add:

<?
extract($POST, EXTR_OVERWRITE);
?>


Set the form processor as follows:

After Processing Befavior : Include
Immediately the next field:

Page or script to include before script ends: success.php

Published the changed form page and the success page and test.
Last edited by Navaldesign on Sat Aug 08, 2009 9:52 am, edited 2 times in total.
www.dbtechnosystems.com
User avatar
me.prosenjeet
 
 
Posts: 1265
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet »

Navaldesign wrote:
Set the form processor as follows:

After Processing Befavior : Include
Immediately the next field:

Page or script to include before script ends: success.php

Published the changed form page and the success page and test.
Naval, when I am using the cost.php, it is set at "Page or script to include before script ends:"(where you suggest to put success.php) when "After Processing Befavior" is set to 'Redirect'
So how do I alter the processor to get the $total from the cost.php in the success.php?
Check the new Chat GPT and Malware detect extensions at the link below

Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Not sure I understand what you are saying.

cost.php should be included as "After Form Data Reception Include". And this ends the issue of calculating the Total cost.

To transmit the data to the success page follow the instructions in my previous post.
Last edited by Navaldesign on Sat Aug 08, 2009 9:49 am, edited 1 time in total.
www.dbtechnosystems.com
User avatar
kevinp
 
 
Posts: 96
Joined: Wed Feb 21, 2007 2:51 pm
Location: Preston, Lancashire, England

Post by kevinp »

Thanks Naval, that works a treat. The id is stored and the info echo'd on the success page.

I get the following php warning messages at the top of the page;

Code: Select all

Warning: fread() [function.fread]: Length parameter must be greater than 0 in /home/a9368701/public_html/lcccsv/dbts_includes/dbts_functions.php on line 44
and

Code: Select all

Warning: unlink(database.csv) [function.unlink]: Permission denied in /home/a9368701/public_html/lcccsv/dbts_includes/dbts_functions.php on line 68
but it all seems to work OK.

I tried adding

Code: Select all

error_reporting(0); // Turn off all error reporting
to the start of page in the success.php file but this still shows the warnings

Cheers

Kev
User avatar
kevinp
 
 
Posts: 96
Joined: Wed Feb 21, 2007 2:51 pm
Location: Preston, Lancashire, England

Post by kevinp »

Scrub that, I've sorted it.

Just add

Code: Select all

ini_set('display_errors', 1);
error_reporting(0);
to the start page section of the success.php page.

Thanks again Naval, you're a superstar.

Kev
User avatar
star57
 
 
Posts: 129
Joined: Fri Mar 02, 2007 10:45 am

Post by star57 »

Naval,
Thank you for all the hard work on the Form Processor, really amazing.

I looked through the forum, and PDF and I have a question. Is there a way to have when a user submits the form that it will display on a webpage or pop up with the info for verification before actually submitting the info.

Also, when there is an error in the form, when a user goes back to the form that the info is still filled out! and not blank!

Thanks
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

Not sure what you mean "interconnected".
You mean that it is a multipage form ?

Anyway, the manual clearly says that you need to add a formid IF you have more than one forms in the same page.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign »

star57 wrote:Naval,
Thank you for all the hard work on the Form Processor, really amazing.

I looked through the forum, and PDF and I have a question. Is there a way to have when a user submits the form that it will display on a webpage or pop up with the info for verification before actually submitting the info.

Also, when there is an error in the form, when a user goes back to the form that the info is still filled out! and not blank!

Thanks
I will soon (probably tomorrow) post an updated version with minor improvements. In the new manual there will also be a "How to" section that will explain how to create preview pages, data merge success pages, and how to avoid the form being blank after a captcha error. Please note that this can NOT be acheived with the WB6 built in captcha, you will need to use the captcha as explained in the tutorial in viewtopic.php?t=6153
www.dbtechnosystems.com
User avatar
star57
 
 
Posts: 129
Joined: Fri Mar 02, 2007 10:45 am

Post by star57 »

Awesome Naval! Thank you!
Post Reply