1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| <?php
session_start();
include("./includes/levels.php");
include("./includes/DBconnect.php");
if(isset($_POST['title']) && isset($_POST['content']) && isset($_POST['auteur']) && ($_POST['publication']) )
{
try
{
function uk_date_to_mysql_date($date){
$date_year=substr($date,6,4);
$date_month=substr($date,3,2);
$date_day=substr($date,0,2);
$date=date("Y-m-d", mktime(0,0,0,$date_month,$date_day,$date_year));
return $date;
}
$newDate=uk_date_to_mysql_date($_POST['publication']);
// INSERT ARTICLE
$db->exec('INSERT INTO articles(title_art, content_art, date_art, poster_art, speaker_art)
VALUES('.$_POST['title'].',
'.$_POST['content'].',
'.$newDate.',
'.$_SESSION['sessionPseudo'].',
'.$_POST['auteur'].');');
echo 'L\'article été ajouté !';
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
}
else
{
echo 'Erreur!';
}
?> |
Partager