Convert PHP data to save to Mysql database

Question

I need to receive a date using the datapicker as dd/mm/yyyy and switch to database format (mysql).

have the access methods (Getter and Setter) in them applied this date function and strstring to convert:

function setDatavenc($datavenc) {
    $this->datavenc = date('d/m/Y', strtotime($datavenc));
}

.

function getDatavenc() {
    return date('d/m/Y', strtotime($this->datavenc));
}

But when saving in the bank saved 0000-00-00 And when making the query returns: 01/01/1970.

I’ve searched a lot including some form here in stackoverflow and none worked.

Answer 1

The PHP date function works as follows:

string date ( string $format [, int $timestamp ] )

The format you can insert the way you need, using is TABLE , from the PHP documentation page. In your case how you need the format 0000-00-00 the code would look like this:

function setDatavenc($datavenc) {
    $this->datavenc = date('Y-m-d', strtotime($datavenc));
}