Insertion de base en php
aicha zitouni
-
yg_be Messages postés 23437 Date d'inscription Statut Contributeur Dernière intervention -
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
je fais l'insertion de base mais rien d'affichage ?
alors comment je dois faire
1 réponse
-
yg_be Messages postés 23437 Date d'inscription Statut Contributeur Dernière intervention Ambassadeur 1 588
bonjour, il manque peut-être une virgule?-
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();
}
?>- 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(); } ?>
-