Insert a form with while

Question

ola i have this form that multiplies according to the app registration for the user,

.

see the result graphically,

how do I enter into the database where I can have a user with up to 7 distinct record or more? I am currently doing half q manual but with records q was not to be inserted

session_start();
if (!isset($_SESSION['login']) || $_SESSION['nivel_acesso_id'] != '2') { //verifica se existe um usuario logado.
    
}
$conn = new mysqli("localhost", "root", "", "teste"); 

$brf1 = $_POST['brf1'];
$brf2 = $_POST['brf2'];
$brf3 = $_POST['brf3'];
$brf4 = $_POST['brf4'];
$brf5 = $_POST['brf5'];
$brf6 = $_POST['brf6'];
$brf7 = $_POST['brf7'];

$app1 = '1';
$app2 = '2';
$app3 = '3';
$app4 = '4';
$app5 = '5';
$app6 = '6';
$app7 = '7';
$iduser = $_SESSION['id'];



// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$sql = "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf1', '$app1');";
$sql .= "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf2', '$app2');";
$sql .= "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf3', '$app3')";
$sql .= "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf4', '$app4')";
$sql .= "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf5', '$app5')";
$sql .= "INSERT INTO events (id_nome, brfinal, aplicativo)
VALUES ('$iduser', '$brf6', '$app6')";

if ($conn->multi_query($sql) === TRUE) {
    echo "<script>alert('Preencha todos os campos para logar-s333e.'); history.back();</script>";
    header("Location: calendar.php");
} else {
    echo "<script>alert('Preencha todos os campos para logar-s111e.'); history.back();</script>" . $conn->error;
}

$conn->close();

?> 

Answer 1

Good morning man, what you can do is the following. First on your FORM you will put at the end of each name of inputs a [] so that it becomes a kind of array when you send the data to PHP. With this, you no longer need to identify the ID of each line as you are doing. On the part of PHP, it is very simple what you will do, basically you will run a INSERT within a foreach or a for where you will pass by parameter the amount of idVoce had in FORM as many times as it will have to run the INSERT in the Bank. It will look like this:

Your input’s where I just copied the DIV with the ones inside, just change the name of these in your HTML:

    <div class="com-sm-4">
        <input type="text" name="app[]">
    </div>

    <div class="col-sm-4">
        <input type="text" name="brinicial[]">
    </div>

    <div class="form-group">
        <input type="text" name="count[]">
        <input type="text" name="brf[]">
    </div>

    <div class="form-group">
        <input type="checkbox" name="naojogou[]">
    </div>

Your script in PHP:

<?php
$id = $connect->insert_id; 
$qtd_insert = sizeof($_POST['app']);

for($i = 0; $i <$qtd_insert; $i++) {
    $app = $_POST['app'][$i];
    $count = $_POST['count'][$i];
    $brf = $_POST['brf'][$i];
    $checkbox = isset($_POST['naojogou'][$i]);

    $query = "INSERT INTO events(id_nome, brfinal, aplicativo) VALUES ('$id', '$brf', '$app')";
    if(!$connect->query($query) === true) {
        die("Erro na inserção dos dados: " . $query . "<br>" . $connect->error)
    }
}
?>

However, since I didn’t have your HTML, I was a little confused about which fields you are inserting in the BD, if not these that I put in the query, just replace them with the other variables there. In the case of the checkbox, you can check whether a checkbox is checked by isset, it makes a kind of check where if the checkbox is marked, it exists, otherwise it does not exist, and with that it can take or not the value of the same.

Answer 2

Guys I managed to solve the problem after a while analyzing here a thank you so much for everything you’ve done for me.

the way I was able to solve was by changing the input of the app form taking out the disabled that does not pass value and putting the readonly that blocks the same way and passes values the other was changing the $Row['idnome'] who passed only the name and not the id the rest was what Leo went through as example.

label for="inputEmail3" class="col-sm-2 control-label">Aplicativo</label>
                      <div class="col-sm-4">
                      <?php echo $row['idnome'];?>
                          <input type="hidden" class="form-control" name="app[]" id="app"  value="<?php echo $row['idapp'];?>" readonly>

                      </div>

and php was like this

include_once("conexao.php");

$qtd_insert = count($_POST['brf']);


for($i = 0; $i <$qtd_insert; $i++) {
    $app = $_POST['app'][$i];
    $brf = $_POST['brf'][$i];
    
    

   $query = "INSERT INTO events(id_nome, brfinal, aplicativo) VALUES ('".$_SESSION['id']."', '$brf', '$app')";
    if(!$conn->query($query) === true) {
     die("<script>alert('Erro na inserção dos dados!!!');</script>: " . $query . "<br>" . $conn->error);
     
    }

Answer 3

You need to understand the operation of receiving data from the forms by PHP, when it comes to forms with repeated information as is your case, you have another option to facilitate the processing of this data that would look like this:

while($row=mysqli_fetch_assoc($result)){
    <input type="text" name="nome_do_input_1[]">
    <input type="text" name="nome_do_input_2[]">
}

Note: Note that this is an example of how you can do by adding your code and values as you wish, as long as the name of the <input> is accompanied by [], for so the PHP will understand that this input is a array.

In the PHP you will receive a array thus:

array (size=3)
  'nome_do_input_1' => 
    array (size=2)
      0 => string 'input 1' (length=7)
      1 => string 'input 1 de novo' (length=15)
  'nome_do_input_2' => 
    array (size=2)
      0 => string 'input 2' (length=7)
      1 => string 'input 2 de novo' (length=15)

So just treat the data as arrays that are using repeat loops to make the input treatments, remembering that each numerical key of the arrays are respectively of each app, example: every key 0 is of the first app, all-key 1 is from the second, etc.