Php mysql date in table

First, you'll have to set the "locale information", to specify which language you want to use. Keep in mind, that even though you set that language, it needs to be installed on the server you're running on. It most likely is, but you'll notice if the setlocale has no effect (default is English).

The second thing you'll need to know, is that date() isn't affected by this, you'll have to use strftime() instead, which has a slightly different formatting, which you'll find on the documentation.

An example of using French dates with these two functions:

setlocale(LC_ALL, 'fr_FR'); 
echo strftime("%B %e %Y", strtotime($var['date_operation']));

Reference and documentation:

• http://php.net/manual/en/function.setlocale.php
• http://php.net/manual/en/function.strftime.php

The modern and rock-solid approach is the intl (from "Internationalization") extension, which offers e.g. the IntlDateFormatter class:

$date = new DateTime('2016-06-14');
$fmt = new IntlDateFormatter('fr_FR', IntlDateFormatter::LONG, IntlDateFormatter::NONE, 'Europe/Paris', IntlDateFormatter::GREGORIAN);
var_dump($fmt->format($date));

string(12) "14 juin 2016"

If you think it's overkill for your project, you can use the legacy strftime() function but you need to change current locale:

$date = strtotime('2016-06-14');
var_dump(setlocale(LC_TIME, 'fr_FR', 'fr')); // Need to try values until you get true
var_dump(strftime('%B %e %Y', $date));

You need to have French locale data installed. In my experience, this works better on Unix-like systems than on Windows.