echo "<input type="text" name="N[]" value=".'$i'.">";
$N = !empty($_POST['N']) ? $_POST['N']: NULL; if(!empty($N)){ $sqlValues = array(); foreach($N as $val ){ $sqlValues[] = "('$val')" } $sql = "INSERT INTO table (N) VALUES "; $sql .= join(",",$sqlValues); if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } }
<form method="post" action="essay.php">
<?php
$mysqli = new mysqli('localhost', 'root', '', 'location');
$i=1;
for($i=1;$i<=60;$i++){
echo '
<input type="text" name="a[]" value="'.$i.'"><br />'; // affichage
}
?>
<input type="submit" name="valide" value="valide"></form>
<?php
$mysqli = new mysqli('localhost', 'root', '', 'location');
$a= !empty($_POST['a']) ? $_POST['a'] : NULL;
if (!empty($a)){
$sqlvalues = array();
foreach($a as $val) {
$sqlvalues[] = "('$a')";
}
$sql = "INSERT INTO aa (a) VALUES ";
$sql .= join(",",$sqlvalues);
if(mysqli_query($mysqli, $sql)){
echo '<script language="javascript">';
echo 'alert("Votre Compte Bien Crée");';
echo 'window.location="login.php";';
echo '</script>';
} else {
echo '<script language="javascript">';
echo 'alert("Erreur de Création");';
echo 'window.location="creation.php";';
echo '</script>';
}}
?>
foreach($a as $val) { $sqlvalues[] = "('$val')"; }
31 oct. 2018 à 09:55
31 oct. 2018 à 09:57