Insertion de base en php

Bonjour
je fais l'insertion de base mais rien d'affichage ?
alors comment je dois faire

1 réponse

  1. Contributeur
    bonjour, il manque peut-être une virgule?
    1. nom voici mon code
      <?php
      if (isset ($_POST['valider'])){
      $servername = "localhost";
      $username = "root";
      $password = "";
      $dbname = "pizza";

      // Create connection
      $conn = new mysqli($servername, $username, $password, $dbname);
      // Check connection
      if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
      }

      $pizzaparis=$_POST['pizzaparis'];
      $monfichier =fopen($pizzaparis, 'r');
      $lignes = file($pizzaparis);
      $nb_ligne =count($lignes);
      $i=0;
      foreach ($lignes as $lineContent)
      {
      $lineContent=str_replace("- ","",$lineContent);
      $lineContent=str_replace("[","",$lineContent);
      $lineContent=str_replace("]","",$lineContent);
      $lineContent=str_replace('"','',$lineContent);
      $lineContent=str_replace("(","",$lineContent);
      $lineContent=str_replace(";","",$lineContent);
      $lineContent=str_replace(")","",$lineContent);

      echo"<br>",$lineContent."<br>";
      $pieces = explode(" ", $lineContent);
      for ($i=0; $i<count($pieces) ; $i++)
      {
      echo " pieces ".$i." = ".$pieces[$i]."<br>";
      }
      $a=$pieces[0];
      $b=$pieces[1];
      $c=$pieces[2];
      $d=$pieces[3]." ".$pieces[4];
      $e=$pieces[5]." ".$pieces[6];
      $f=$pieces[7]." ".$pieces[8];
      $g=$pieces[9];
      $h=$pieces[10]." ".$pieces[11]." ".$pieces[12]." ".$pieces[13]." ".$pieces[14]." ".$pieces[15]." ".$pieces[16]." ".$pieces[17];
      $k=$pieces[18]." ".$pieces[19]." ".$pieces[20]." ".$pieces[21];

      echo $a,$b,$c,$d,$e,$f,$g,$h,$k;

      }

      $sql= "INSERT INTO pizza1(url,adresse,date,cod1,lien1,cod2,lien2,lien3,lien4) VALUES ('".$a."','".$b."','".$c."','".$d."','".$e."','".$f."','".$g."','".$h."','".$k."')";

      if ($conn->query($sql)=== true)
      {
      $stat = "New record created successfully";
      //echo "New record created successfully";
      }
      else
      {
      $stat = "Error: " . $sql . "<br>" . $conn->error;
      //echo "Error: " . $sql . "<br>" . $conn->error;
      }

      echo $stat;

      fclose($monfichier);
      $conn->close();
      }
      ?>
    2. Contributeur
      @aicha zitouniet quel est le soucis?
      <?php 
      if (isset ($_POST['valider'])){ 
      $servername = "localhost"; 
      $username = "root"; 
      $password = ""; 
      $dbname = "pizza"; 
      
      // Create connection 
      $conn = new mysqli($servername, $username, $password, $dbname); 
      // Check connection 
      if ($conn->connect_error) { 
      die("Connection failed: " . $conn->connect_error); 
      } 
      
      $pizzaparis=$_POST['pizzaparis']; 
      $monfichier =fopen($pizzaparis, 'r'); 
      $lignes = file($pizzaparis); 
      $nb_ligne =count($lignes); 
      $i=0; 
      foreach ($lignes as $lineContent) 
      { 
      $lineContent=str_replace("- ","",$lineContent); 
      $lineContent=str_replace("[","",$lineContent); 
      $lineContent=str_replace("]","",$lineContent); 
      $lineContent=str_replace('"','',$lineContent); 
      $lineContent=str_replace("(","",$lineContent); 
      $lineContent=str_replace(";","",$lineContent); 
      $lineContent=str_replace(")","",$lineContent); 
      
      echo"<br>",$lineContent."<br>"; 
      $pieces = explode(" ", $lineContent); 
      for ($i=0; $i<count($pieces) ; $i++) 
      { 
      echo " pieces ".$i." = ".$pieces[$i]."<br>"; 
      } 
      $a=$pieces[0]; 
      $b=$pieces[1]; 
      $c=$pieces[2];	
      $d=$pieces[3]." ".$pieces[4]; 
      $e=$pieces[5]." ".$pieces[6]; 
      $f=$pieces[7]." ".$pieces[8]; 
      $g=$pieces[9];	
      $h=$pieces[10]." ".$pieces[11]." ".$pieces[12]." ".$pieces[13]." ".$pieces[14]." ".$pieces[15]." ".$pieces[16]." ".$pieces[17]; 
      $k=$pieces[18]." ".$pieces[19]." ".$pieces[20]." ".$pieces[21]; 
      
      echo $a,$b,$c,$d,$e,$f,$g,$h,$k;	
      
      } 
      
      $sql= "INSERT INTO pizza1(url,adresse,date,cod1,lien1,cod2,lien2,lien3,lien4) VALUES ('".$a."','".$b."','".$c."','".$d."','".$e."','".$f."','".$g."','".$h."','".$k."')"; 
      
      if ($conn->query($sql)=== true) 
      { 
      $stat = "New record created successfully"; 
      //echo "New record created successfully"; 
      } 
      else 
      { 
      $stat = "Error: " . $sql . "<br>" . $conn->error; 
      //echo "Error: " . $sql . "<br>" . $conn->error; 
      } 
      
      echo $stat; 
      
      fclose($monfichier); 
      $conn->close(); 
      }	
      ?>