Formatting date from dd-mm-yyyy to yyyy-mm-dd in php

Asked Jul 11 '14 at 09:40

Active Jul 11 '14 at 10:06

Viewed 46 times

Below is my function for inserting records to my database through HTML form. However I want my date to be typed in dd-mm-yyyy format and then be saved to my database as default yyyy-mm-dd format. I tried with strtotime and DateTime::createFromFormat(as you can see these are commented out lines) but nothing works for me.Can I get your help with it?

//---------------------------------------------------------------------
    public function addRecord(){
//---------------------------------------------------------------------
    $this->postVariablesToClassVariables() ;

    //$this->ldate= DateTime::createFromFormat('d/m/Y', $this->ldate)->format('Y-m-d');
    //$this->ldate = date('Y-m-d', strtotime($this->ldate));

    if($this->lno && $this->ldate && $this->version && $this->company &&){

    $ins = mysql_query ("INSERT INTO `mlicenses_table`(`lno`,`ldate`,`version`,`company`)
    VALUES  ('".$_POST['lno']."','".$_POST['ldate']."','".$_POST['version']."', '".$_POST['company']."')");

    $this->resetClassVariables();
    return $this->errorMessages= "New records added to database" ;

    }
    else {

    $this->errorMessages="Enter all fields required " ;
    return;
    }
    }

edited Jul 11 '14 at 10:06

Rakesh Sharma

13,680
5
37
44

asked Jul 11 '14 at 09:40

user2815059

1

`$output = implode("-",array_reverse(explode("-",$input)));` – Niet the Dark Absol Jul 11 '14 at 09:43
Also [obligatory xkcd reference](http://xkcd.com/327/) - start using [PDO](http://php.net/pdo) before it's too late! – Niet the Dark Absol Jul 11 '14 at 09:43
The second one, or `date("Y-m-d", strtotime("11-07-2014"));`, was already correct. Show your debugging output, and explain how it deviated. – mario Jul 11 '14 at 09:45
show what you getting in $this->ldate? – Rakesh Sharma Jul 11 '14 at 09:47
If I enter date in dd-mm-yyyy format database field shows 0000-00-00 – user2815059 Jul 11 '14 at 09:57
cause you need to send Y-m-d format – Rakesh Sharma Jul 11 '14 at 10:05

Formatting date from dd-mm-yyyy to yyyy-mm-dd in php

0 Answers0