<style> @font-face { font-family: 'hacen'; src: url('css/TheSans-Plain.eot?#iefix') format('embedded-opentype'), url('css/TheSans-Plain.otf') format('opentype'), url('css/TheSans-Plain.woff') format('woff'), url('css/TheSans-Plain.ttf') format('truetype'), url('css/TheSans-Plain.svg#TheSans-Plain') format('svg'); font-weight: normal; font-style: normal; } #transfer_reason,#typ,#page_an{width:700px; height:30px; margin-top:10px;} .btn{ border:1px solid #515151; width:100px; height:35px; color:#FFFFFF; background-color:#da141b;font-size:18px;} .btn:hover { background-color:#ED4248; cursor:pointer;border:1px solid #222222; } </style> <?php require'menu.php'; //require"../sqlconnect.php"; //-----------------------------------------------------------------------------------// //Creation du formulaire d'insertion //-----------------------------------------------------------------------------------// echo' <div id="page-wrapper"><div class="col-lg-12"> <h1 class="page-header">Articles</h1> </div> <meta charset="utf-8" />'; echo ' <!doctype html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1256" /> <title>Ajout des Articles</title> <link href="cssstyle.css" rel="stylesheet" type="text/css"> <script src="css/tinymce.min.js"></script> <script type="text/javascript"> tinymce.init({ selector: "#input", menubar:false, toolbar:"undo redo" /*toolbar:"undo redo,styleselect,alignright", style_formats:[ {title:"paragraphe", format:"p"}]*/ }); </script> </head> <body> <center> <table> <form method="post" action="" enctype="multipart/form-data"> <form method="post" action="" enctype="multipart/form-data"> <tr><th><label>Titre : </label></th><td><input type="text" name="titre" placeholder="titre d\'article" id="typ" ></td></tr> <tr><th><label>Auteur : </label></th><td><input type="text" name="auteur" placeholder="auteur d\'article" id="typ" ></td></tr> <tr><th><label>Ville : </label></th><td><input type="text" name="ville" placeholder="Ville" id="typ" ></td></tr> <tr ><th style="margin-top:5px;">Type de l\'article:</th> <td><select name="typearticle" style="margin-top:5px; margin-bottom:5px;" id="typ"> <option>---------------------------------------------------------- TYPE ARTICLE ----------------------------------------------------------</option> <option>??????</option> <option>????????</option> <option>??????</option> <option>????????</option> <option>?????? ? ????</option> <option>?????</option> </select></td></tr> <tr><th><label>Texte : </label></th><td><textarea id="input" name="input" style="width:100%;"></textarea></td></tr> <tr><th><label style="margin-top:-15px;">Image d\'article : </label></th><td><input type="file" id="typ" name="image" style="margin-top:15px;"><br><br/></td></tr> <tr><td colspan="2"><center><input type="submit" name="ajout" value="Valider" class="btn"></center></td></tr> </form> </table></center> '; //Connexion à la BDD //-----------------------------------------------------------------------------------// try{ // $db = new PDO('mysql:host=localhost;dbname=sadatv', 'root', '',array (PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); require"../../../sqlconnect.php"; }catch (PDOException $e) { printf("%s:%d %s (%d) [%s]\n", $e->getFile(), $e->getLine(), $e->getMessage(), $e->getCode(), get_class($e)); var_dump(debug_backtrace()); } //-----------------------------------------------------------------------------------// //Traitement //-----------------------------------------------------------------------------------// //Recuperation propre des variables $titre = !empty($_POST['titre'])?$_POST['titre']:''; $auteur = !empty($_POST['auteur'])?$_POST['auteur']:''; $ville = !empty($_POST['ville'])?$_POST['ville']:''; $typearticle = !empty($_POST['typearticle'])?$_POST['typearticle']:''; $texte = !empty($_POST['input'])?$_POST['input']:''; $image_name = !empty($_FILES['image']['name'])?$_FILES['image']['name']:NULL; $image_type = !empty($_FILES['image']['type'])?$_FILES['image']['type']:''; $image_size = !empty($_FILES['image']['size'])?$_FILES['image']['size']:''; $image_tmp_name= !empty($_FILES['image']['tmp_name'])?$_FILES['image']['tmp_name']:NULL; if(isset($_POST['ajout'])){ if($image_name && $image_tmp_name){ if(move_uploaded_file($image_tmp_name, "imagearticle/$image_name")){ $date = new Datetime('now', new DateTimeZone('Africa/Casablanca')); //Preparation de la requete : if($typearticle=='??????') { $choix="rapo_Politique"; } if($typearticle=='????????') { $choix="rapo_so"; } if($typearticle=='??????') { $choix="rapo_sport"; } if($typearticle=='????????') { $choix="rapo_eco"; } if($typearticle=='?????? ? ????') { $choix="rapo_fan"; } if($typearticle=='?????') { $choix="rapo_environnement"; } $sql = 'INSERT INTO article (id,titre,auteur,type_article,texte,img,loca,dateedit,ville) VALUES(:id,:titre,:auteur,:type_article,:texte,:img,"'.$choix.'","'.$date->format('Y-m-d H:i:s').'",:ville)'; $params=array(":id"=>"",":titre"=>$titre,":auteur"=>$auteur,":type_article"=>$typearticle,":texte"=>$texte,":img"=>$image_name,":ville"=>$ville); //execution de la requête try{ $prepare = $db->prepare($sql); $prepare->execute($params); $new_id = $db->lastInsertId(); } catch(Exception $e){ echo "<pre><br>".$e->getMessage()."<br>"; var_dump(debug_backtrace()); echo "</pre>"; } // Si l'insertion a fonctionné.. un id a été créé..et donc : if(isset($new_id)){ echo'<script>alert("l\'ajout fait avec succés ")</script>'; } }else{ echo'<script>alert("Erreur ! \n >> l\'upload a échoué ! ")</script>'; } }else{ //Erreur ! $_FILES est vide echo "Erreur ! Aucun fichier !"; print_r($_FILES); } } echo'</body> </html>'; <code php>
</code>
Afficher la suite