Codeigniter - Date format - Form Validation


Codeigniter - Date format - Form Validation



I'm using codeigniter with PHP.
I'm using following form,


PHP


<?php
echo form_open('/register/create_new', $form_params);
?>

DOB: <input type="text" id="dob" name="reg[dob]">
<input type="submit" value="Create Account" />
</form>



here, #dob is in dd-mm-yyyy format.


#dob


dd-mm-yyyy



my validation code is,


array(
'field' => 'reg[dob]',
'label' => 'DOB',
'rules' => 'required'
)



How can i set the rules for correct date validation?


rules





If possible - consider using separate dropdown menus for day month year . Less errors for your users, especially with the month and day mixups that can happen.
– cartalot
Jan 16 '13 at 16:26






@cartalot but, im using jquery datepicker
– KarSho
Jan 17 '13 at 5:08





stackoverflow.com/questions/12878863/…
– Sushant Pimple
Aug 9 '17 at 13:58




9 Answers
9



you can do it with regex


regex


$this->form_validation->set_rules('reg[dob]', 'Date of birth', 'regex_match[(0[1-9]|1[0-9]|2[0-9]|3(0|1))-(0[1-9]|1[0-2])-d{4}]');





It's impossible to implement reliable date validation with regular expressions. Yours is actually quite good but, for instance, it claims that 29-02-2000 is not valid.
– Álvaro González
Aug 20 '13 at 8:10



29-02-2000





@ÁlvaroG.Vicario i think its also possible with 'regex'
– Abin M Devasia
Aug 20 '13 at 8:21





Yeah, right, if you have the patience you can probably hard-code all the exceptions (including missing days due to transition to Gregorian calendar) but you know what I mean: regular expressions are not the best tool.
– Álvaro González
Aug 20 '13 at 8:25





@ÁlvaroG.Vicario stackoverflow.com/questions/8647893/…
– Abin M Devasia
Aug 27 '13 at 9:11



You can take use of CodeIgniters callback functions by creating a callback_date_valid() function that check if the date is valid.



And to check if it is valid, you could use PHP's checkdate function


array(
'field' => 'reg[dob]',
'label' => 'DOB',
'rules' => 'required|date_valid'
)

function callback_date_valid($date){
$day = (int) substr($date, 0, 2);
$month = (int) substr($date, 3, 2);
$year = (int) substr($date, 6, 4);
return checkdate($month, $day, $year);
}





Using proper date functions is the way to go. Nice answer.
– Álvaro González
Aug 20 '13 at 8:11





I think this is the way to go too. One thing, the name of the function has to be without "callback". So the right way would be> function date_valid($date){
– Limon
Jan 28 '14 at 17:30



I have a pretty clean solution for this.
You can extend codeigniters form validation library.



Do this by putting a MY_Form_validation.php file in your application/libraries folder. This file should look like this:






class MY_Form_validation extends CI_Form_validation {

public function __construct($rules = array())
{
parent::__construct($rules);
}


public function valid_date($date)
{
$d = DateTime::createFromFormat('Y-m-d', $date);
return $d && $d->format('Y-m-d') === $date;
}
}



To add the error message, you go to your application/language/ folder and open the form_validation_lang.php file. Add an entry to the $lang array at the end of the file, like so:


$lang['form_validation_valid_date'] = 'The field {field} is not a valid date';



Note that the key here must be the same as the function name (valid_date).



Then in your controller you use this as any other form validation function like for example 'required'


$this->form_validation->set_rules('date','Date','trim|required|valid_date');





This is a very elegant solution, and I would like to recommend an additional change to allow better customisation. Adding a parameter for the date format: function valid_date($date, $format = 'Y-m-d') and referencing it in the function. You can pass this parameter in the validation rules like: 'trim|required|valid_date[d-m-y]' Then the lang file can use {param} to specify the expected format on error.
– CYMA
Apr 21 '17 at 0:19






stackoverflow.com/questions/12878863/…
– Sushant Pimple
Aug 9 '17 at 13:57





plus one for nice standard way.....need to add format parameter aswell.
– Imran Qamer
Mar 15 at 7:49




I know this is old, but I just encountered the same issue. I like the answer Winks provided, but found that the code did not work. I modified it to this:


public function your_form_handler($date)
{
// ....
$this->form_validation->set_rules('date', 'Date', 'required|callback_date_valid');
// ....
}

/**
* Validate dd/mm/yyyy
*/
public function date_valid($date)
{
$parts = explode("/", $date);
if (count($parts) == 3) {
if (checkdate($parts[1], $parts[0], $parts[2]))
{
return TRUE;
}
}
$this->form_validation->set_message('date_valid', 'The Date field must be mm/dd/yyyy');
return false;
}





I found itz useful. But this also validates 21/07/1yyy. ie, one digit year also validated.
– Dayz
Apr 25 '17 at 6:41



There is no builtin date validation in Codeigniter form_validation Library, but you can use its callback to call a function and validate the date using PHP's own capabilities.


form_validation



With DateTime you can make the shortest date&time validator for all formats.


function validateDate($date, $format = 'Y-m-d H:i:s')
{
$d = DateTime::createFromFormat($format, $date);
return $d && $d->format($format) == $date;
}

var_dump(validateDate('2012-02-28 12:12:12')); # true
var_dump(validateDate('2012-02-30 12:12:12')); # false
var_dump(validateDate('2012-02-28', 'Y-m-d')); # true
var_dump(validateDate('28/02/2012', 'd/m/Y')); # true
var_dump(validateDate('30/02/2012', 'd/m/Y')); # false
var_dump(validateDate('14:50', 'H:i')); # true
var_dump(validateDate('14:77', 'H:i')); # false
var_dump(validateDate(14, 'H')); # true
var_dump(validateDate('14', 'H')); # true

var_dump(validateDate('2012-02-28T12:12:12+02:00', 'Y-m-dTH:i:sP')); # true
# or
var_dump(validateDate('2012-02-28T12:12:12+02:00', DateTime::ATOM)); # true

var_dump(validateDate('Tue, 28 Feb 2012 12:12:12 +0200', 'D, d M Y H:i:s O')); # true
# or
var_dump(validateDate('Tue, 28 Feb 2012 12:12:12 +0200', DateTime::RSS)); # true
var_dump(validateDate('Tue, 27 Feb 2012 12:12:12 +0200', DateTime::RSS)); # false



function was copied from this answer or php.net



I like the answer tmsimont provided, but found that the code did not work if non numeric values enterd. Modified code is given below:


/**
* Validate dd/mm/yyyy
*/
public function date_valid(){
$date=$this->input->post('dob');
$parts = explode("/", $date);
if (count($parts) == 3) {
if (is_numeric($parts[2])) {
if (is_numeric($parts[0])) {
if (is_numeric($parts[1])) {
if (checkdate($parts[1], $parts[0], $parts[2])){
return TRUE;
}
}
}
}
}

$this->form_validation->set_message('date_valid', 'The Date field must be mm/dd/yyyy');
return false;
}



The actual Regex for Codeigniter Date validation :


$this->form_validation->set_rules('reg[dob]','Date of birth',array('regex_match[/^((0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)dd)$/]'));



I am using same expression for format dd-mm-yyyy and dd/mm/yyyy



No Warnings and errors :-)



I've written this custom validator for ci3 - validates the d/m/Y H:i format - you can easily change that.


$this->form_validation->set_rules("start_date", "Start Date", 'trim|callback__check_date_valid');


public function _check_date_valid($date){

$this->form_validation->set_message('_check_date_valid', "Please enter a valid date");
$d = DateTime::createFromFormat('d/m/Y H:i', $date);

if($d && $d->format('d/m/Y H:i') === $date || $date == ''){
return true;
}else{

return false;
}

}





Unless you're good with regex - this is safer and allows you to explicitly set the php date format to validate against.
– Smith
Jun 29 at 10:52



Using Regex is probably the best way. I use this Regex that I found here for the format YYYY-MM-DD: http://www.regular-expressions.info/dates.html



The actual Regex is:


^(19|20)dd[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])$



It has a nice explanation on how each section works so that you can modify it for different date formats.



Then you can use the code suggested by @Abin: (make sure you enclose it in some kind of delimiter)


$this->form_validation->set_rules('reg[dob]', 'Date of birth', 'regex_match[/^(19|20)dd[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])$/]');





Error is: Warning: preg_match(): Unknown modifier '.'
– Priyabrata Atha
May 9 '17 at 8:18






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

paramiko-expect timeout is happening after executing the command

paramiko-expect timeout is happening after executing the command Can someone help me why timeout is happening after executing the command .I am trying to SSH to a machine and execute a command.I want to store the result of the executed command . I have referred paramiko-timeout but i didn't get my expected result. import traceback try: import paramiko except ImportError: raise Exception("Please install paramiko , pip install paramiko") import pexpect from paramiko_expect import SSHClientInteraction def main(): HOSTNAME = "minion5.net" USERNAME = "root" PASSWORD = "help@432" PROMPT = "root@*:~$s+" try: client = paramiko.SSHClient() client.load_system_host_keys() client.set_missing_host_key_policy(paramiko.AutoAddPolicy()) client.connect(hostname=HOSTNAME, username=USERNAME, password=PASSWORD) with SSHClientInteraction(client, timeout=20, display=True) as interact:
Read more

how to run turtle graphics in Colaboratory

how to run turtle graphics in Colaboratory Given that we can do other types of drawing/visualization in Colaboratory, I would think running turtle graphics would be pretty simple (but not so simple I've figured it out!) I can import the turtle library, but I get the following error when any draw command occurs: TclError: no display name and no $DISPLAY environment variable Thanks in advance. 1 Answer 1 I think P5.js is your best bet. I test it in this notebook. https://colab.research.google.com/drive/1TqF6RObllyslad3KrO4SiAuegRjuJDCF By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more

Export result set on Dbeaver to CSV

Export result set on Dbeaver to CSV Normally I use Dbeaver for windows and always export my result set like this: run my query --> select the result --> export the result set --> select export to clipboard --> done This step by step puts my result set in my clipboard and I can paste it wherever I want to work with it. The problem is that now I am using dbeaver for mac and this guide is not working. I can go on until the moment that I select my result set like in the image below: exporting data set But once I go further in the process, in the last step I get: no query Note that in "source" it was suppose to show the query that originated the result set, but instead it says just "select. As a result it does't select my result or anything (besides being "successful"). Normally my query would show up there automatically and I couldn't find any option that corrects this problem in the menus. Please help me! Thanks. Aft
Read more