<?php

$id = 10;
try
{
    $db = new PDO("mysql:host=localhost;dbname=test", "root", "");
    
    $sql = 'SELECT `JAction` , `JDate` , `JHeure` , `JInfo` 
             FROM `journaltest` 
             WHERE `JAction` like "Description :%"  
             ORDER BY `journaltest`.`JDate` ASC';
             
    $statement = $db->prepare($sql);
    $statement->execute(array(":JAction");
    
    if($rows = $statement->fetchAll())
    {
        foreach($rows as $row)
        {
            echo "field: ".$row["field"]."<br />";
        }
    }
    
    $db = NULL;
}
catch (PDOException $exception)
{
    die("Erreur : " . $exception->getMessage() . "<br/>");
}

?>

<?php
/*$JAction = 'JAction';
$JInfo = 'JInfo';
$JDate = 'JDate';
$JHeure = 'JHeure';*/
$sqldb = new PDO("mysql:host=localhost;dbname=test","root","") or die ("impossible d'ouvrir bdd !"); 
$stm = $sqldb->prepare('SELECT `JAction` , `JDate` , `JHeure` , `JInfo` 
             FROM `journaltest`');
$stm -> execute (array($JAction,$JDate,$JHeure,$JInfo));


?>