Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Form Toolkit › Check value between two data

Check value between two data

Thread began 4/27/2011 7:49 am by federicosintucci | Last modified 4/29/2011 9:26 am by Jason Byrnes | 1352 views | 7 replies |

4/27/2011 7:49 am | #1 federicosintucci

Check value between two data

I have two datapicker that beautifully work, but how should I check if the number of day between the two datas are <= of 5 days?

Ex. The event starts on Apr. 21th, if it ends on/before Apr. 26th the form should validate, otherwise it shows an error message.

Thanks!

4/27/2011 12:33 pm | #2 Jason ByrnesWebAssist

use Server side validation for this.

select Date validation type.

for the server variable, click the lightning bolt and select the endDate form element.

for the start date, enter:

php:

<?php echo((isset($_POST["startDate"]))?$_POST["startDate"]:"") ?>

for the end date enter:

php:

<?php echo((isset($_POST["startDate"]))?date("m/d/Y", mktime(0,0,0,date("m",strtotime($_POST["startDate"])),date("d",strtotime($_POST["startDate"]))+5,date("Y",strtotime($_POST["startDate"])))):""); ?>

this code is assuming your start date form element is named "startDate", you will need to adjust the code if you use a different name.

4/28/2011 2:28 pm | #3 federicosintucci

it gives an error:

$WAFV_Errors .= WAValidateDT(((isset($_POST["eventoDATA"]))?$_POST["eventoDATA"]:"") . "",true,".*","","",false,".*","","",true,3);
$WAFV_Errors .= WAValidateDT(((isset($_POST["eventoFINE"]))?$_POST["eventoFINE"]:"") . "",true,".*","".((isset($_POST["eventoDATA"]))?$_POST["eventoDATA"]:"") ."","".((isset($_POST["eventoDATA"]))?date("m/d/Y",*mktime(0,0,0,date("m",strtotime($_POST["eventoDATA"])),date("d",strtotime($_POST["eventoDATA"]))+5,date("Y",strtotime($_POST["eventoDATA"])))):"");* ."",false,".*","","",true,5);

the error it's between
$WAFV_Errors .= WAValidateDT(((isset($_POST["eventoFINE"]))?$_POST["eventoFINE"]:"") . "",true,".*"
and
* ."",false,".*","","",true,5);

4/28/2011 2:38 pm | #4 Jason ByrnesWebAssist

send me a copy of your page in a zip archive so I can see the code in context and test it.

4/28/2011 2:41 pm | #5 federicosintucci

onence from

ok, thanks!
do you need the script folder too?

Attached Files

inserisci.php.zip

4/28/2011 11:55 pm | #6 Jason ByrnesWebAssist

change line 23:

php:

$WAFV_Errors .= WAValidateDT(((isset($_POST["eventoFINE"]))?$_POST["eventoFINE"]:"") . "",true,".*","".((isset($_POST["eventoDATA"]))?$_POST["eventoDATA"]:"")  ."","".((isset($_POST["eventoDATA"]))?date("m/d/Y",*mktime(0,0,0,date("m",strtotime($_POST["eventoDATA"])),date("d",strtotime($_POST["eventoDATA"]))+5,date("Y",strtotime($_POST["eventoDATA"])))):"");*  ."",false,".*","","",true,5);

to:

php:

$WAFV_Errors .= WAValidateDT(((isset($_POST["eventoFINE"]))?$_POST["eventoFINE"]:"") . "",true,".*","".((isset($_POST["eventoDATA"]))?$_POST["eventoDATA"]:"")  ."","".((isset($_POST["eventoDATA"]))?date("m/d/Y", mktime(0,0,0,date("m",strtotime($_POST["eventoDATA"])),date("d",strtotime($_POST["eventoDATA"]))+5,date("Y",strtotime($_POST["eventoDATA"])))):"")  ."",false,".*","","",true,5);

4/29/2011 4:33 am | #7 federicosintucci

Great, now it works on insert page!
I've to fix the update one not to show the error message on load, but it's ok.

Thank you Jason!

4/29/2011 9:26 am | #8 Jason ByrnesWebAssist

you're welcome.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.