function getArticle($idArticle) { global $bdd; $bdd = getBdd(); $article = $bdd->query('SELECT art_id, art_title, art_content,DATE_FORMAT(art_date,"%d/%m/%Y") as date, DATE_FORMAT(art_date,"%H:%i") as heure, use_login FROM article JOIN user ON art_use_id = use_id where art_id =' . $idArticle); return $article; }
function addComment($login, $article, $comment) { global $bdd; $bdd = getBdd(); $comments = $bdd->prepare(' INSERT INTO commentary (com_content, com_use_id, com_art_id) SELECT "' . $comment . '", use_id, ' . $article . ' FROM user WHERE use_login = "******")'); $comments->execute(); }
<!-- PARTIE DONNEES --> <?php // Conexion a la BD require_once 'CANDIbdd.inc'; $bdd = getBdd(); // Ecriture de la requete SQL dans la variable $requete $requetetech = "SELECT TCH_codeTechnologie, TCH_libelleTechnologie FROM candi_technologie ORDER BY TCH_codeTechnologie"; // Préparation de la requete SQL $prep = $bdd->prepare($requetetech); // Exécution de la requete $prep->execute(); // Récuperation du tableau resultat requete (contenant toutes les lignes) $rstechnologie = $prep->fetchAll(); // Ecriture de la requete SQL dans la variable $requetedetail $requeteEtat = "SELECT ET_CDT_codeEtat, ET_CDT_libelleEtat FROM CANDI_ETAT_CANDIDATURE ORDER BY ET_CDT_codeEtat"; // Préparation de la requete SQL $prep = $bdd->prepare($requeteEtat); // Exécution de la requete $prep->execute(); // Récuperation du tableau resultat requete (contenant toutes les lignes) $rsetat = $prep->fetchAll(); // Ecriture de la requete SQL dans la variable $requetestatut $requeteStatut = "SELECT STA_codeStatut, STA_libelleStatut FROM sta_statut ORDER BY sta_codestatut"; // Préparation de la requete SQL $prep = $bdd->prepare($requeteStatut); // Exécution de la requete $prep->execute(); // Récuperation du tableau resultat requete (contenant toutes les lignes) $rsstatut = $prep->fetchAll(); // Ecriture de la requete SQL dans la variable $requetedetail $requeteSuivit = "SELECT SVT_codeSuivit, SVT_libelleSuivit FROM CANDI_SUIVIT ORDER BY SVT_codeSuivit";
function getPicturePicture($idArticle) { global $bdd; $bdd = getBdd(); $article = $bdd->query('SELECT * FROM picture where pic_art_id =' . $idArticle . ' and pic_type = "picture"'); return $article; }