Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8" />
- <title>Mon blog</title>
- <link href="style.css" rel="stylesheet" />
- <?php
- $host='localhost:8889';
- $user='root';
- $pass='root';
- $db = 'Ebay';
- $connect=mysqli_connect($host,$user,$pass);
- $db_select=mysqli_select_db($connect,$db);
- ?>
- </head>
- <body>
- <?php
- header("Location: index.php");
- if(isset($_POST['add'])){
- $mal_rempli=1;
- if(empty($_POST['titre'])){echo "Pas de titre <br>";$mal_rempli=0;}
- if(empty($_POST['prix'])){echo "Pas de prix <br>";$mal_rempli=0;}
- if(empty($_POST['nom'])){echo "Pas de nom <br>";$mal_rempli=0;}
- if(empty($_POST['codepostal'])){echo "Pas de code postal <br>";$mal_rempli=0;}
- if(empty($_POST['mail'])){echo "Pas de mail <br>";$mal_rempli=0;}
- if(empty($_POST['numero'])){echo "Pas de numero <br>";$mal_rempli=0;}
- if(empty($_POST['contenu'])){echo "Pas de contenu <br>";$mal_rempli=0;}
- if($mal_rempli==1){
- $titre=$_POST['titre'];
- $date=$_POST['date'];
- echo "La date :".$date;
- $prix=$_POST['prix'];
- $nom=$_POST['nom'];
- $codepostal=$_POST['codepostal'];
- $mail=$_POST['mail'];
- $numero=$_POST['numero'];
- $affnum=$_POST['affNum'];
- $contenu=$_POST['contenu'];
- if(!empty($_POST['image1'])){$image1=$_POST['image1'];}else{$image1='NULL';}
- if(!empty($_POST['image2'])){$image1=$_POST['image2'];}else{$image2='NULL';}
- if(!empty($_POST['image3'])){$image1=$_POST['image3'];}else{$image3='NULL';}
- $nb_id = count(mysqli_fetch_array(mysqli_query($connect,'SELECT id FROM Annonces'))) +1;
- $request = "INSERT INTO `Annonces` (`id`, `nom`, `titre`, `date`, `codepostal`, `contenu`, `numero`, `affnum`, `mail`, `image1`, `image2`, `image3`) VALUES ('".$nb_id."', '".$nom."', '".$titre."', '".$date."', '".$codepostal."', '".$contenu."', '".$numero."', '".$affnum."', '".$mail."', '".$image1."', ".$image2.", ".$image3.");";
- echo $request;
- if(mysqli_query($connect,$request)){
- //$message='Annonce ajouté !';
- //echo '<script type="text/javascript">window.alert("'.$message.'");</script>';
- // Plus tard, faire la redirection.
- }
- }else{
- $Refaire=0;
- }
- }elseif((!isset($_POST['add']))||($Refaire=0)){
- ?>
- <form method="post" action="./new.php">
- <pre>
- Titre → <input type="text" name="titre" size="20">
- Prix → <input type="number_format" name="prix" size="4">
- <input type="hidden" name="date" value="<?php echo date('d-m-Y');?>">
- Nom → <input type="text" name="nom" size="20">
- CP → <input type="number_format" name="codepostal" size="5">
- Email → <input type="email" name="mail">
- Numero → <input type="number_format" name="numero" size="10">
- <br>
- Afficher le numero :
- <input type=radio name="affNum" value="Oui" checked> Oui
- <input type=radio name="affNum" value="Non"> Non
- <br>
- Saisisez du texte →
- <textarea name="contenu" rows=10 cols=30></textarea>
- Image 1 → Lien : <input type="text" name="image1" size=30> <b>ou</b> Fichier :<input type="file" name=image1>
- Image 2 → Lien : <input type="text" name="image2" size=30> <b>ou</b> Fichier :<input type="file" name=image2>
- Image 3 → Lien : <input type="text" name="image3" size=30> <b>ou</b> Fichier :<input type="file" name=image3>
- <br>
- <input type="submit" name="add" value="Publier">
- </pre>
- </form>
- <?php
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement