Insertion de base en php

aicha zitouni -  
yg_be Messages postés 23437 Date d'inscription   Statut Contributeur Dernière intervention   -
Bonjour
je fais l'insertion de base mais rien d'affichage ?
alors comment je dois faire

1 réponse

  1. yg_be Messages postés 23437 Date d'inscription   Statut Contributeur Dernière intervention   Ambassadeur 1 588
     
    bonjour, il manque peut-être une virgule?
    0
    1. aicha zitouni
       
      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();
      }
      ?>
      0
      1. yg_be Messages postés 23437 Date d'inscription   Statut Contributeur Dernière intervention   1 588 > aicha zitouni
         
        et 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(); 
        }	
        ?>
        0