How to send information from a dynamic form?

Question

I have to make a form in which I will have this table, only instead of being static it will be dynamic, one can enter 1 familiar, 2 ,3 ,4, 10, whatever she wants. That’s what I’m using it for JQUERY, And every time someone clicks on an add button they add a new row to the table, this part I know how to do. My doubt is as follows, how then I send all the information to the database, told me that I would have to store in a array, only that I array s in PHP I’m not very good.

MY EXAMPLE

html part

<form method="post" id="formulario" action="dados.php">  
        
                <div id="telefone">  
            <p><label>Nome</label><input type="text" class="fone" name="agregado[]" size="15" /><span class="adicionar">Adicionar registo</span></p>  
            <p><label>telefone</label><input type="text" class="fone" name="agregado[]" size="15" /></p>  
       </div>  
            <p><input type="submit" value="Enviar" id="btEnviar" name="btEnviar" />  
     </form> 

PART DATA.PHP

$ligacao = mysqli_connect("localhost", "root", "", "teste");
                        if (mysqli_connect_errno()) {
                            echo "Erro na liga??o MySQL: " . mysqli_connect_error();
                        }

$result = count($_POST["agregado"]);
$agregado=$_POST["agregado"];
var_dump($agregado);

for($i=0; $i<$result; $i++){
    $sql="insert into teste (nome) values ('$agregado[i]', '$agregado[i]')";//DUVIDA
    echo $sql;
}

All right, I’ll get to this part var_dump($agregado) where the exit is something like this

array(2) { [0]=> string(4) "pessoa" [1]=> string(3) "123" } 

This is the way out in case you enter 1 person, if you put 2 the way out will be:

array(4) { [0]=> string(4) "pessoa" [1]=> string(3) "123" [2]=> string(5) "pessoa_2" [3]=> string(3) "234" }

and so on and so forth

How do I insert each position of the array into its proper place?

I do the go-around to go through all array positions but then can’t get it to enter the correct position..

Answer 1

Well, if you can do the jQuery part, that’s a start. From jQuery you can send the values to PHP through POST in various ways, JSON, array, csv, or other.

Imagining a csv, to facilitate the example, imagine that we have a field that brings text, in which the delimiter of the various lines is a ";" and that the delimiter of the fields is a ","

// variavel POSTed por jQuery
$csv = "nome1,parentesco1,idade1,contacto1;nome2,parentesco2,idade2,contacto2"

If the form field is called 'items', you must access it using $_POST['items']. Then:

$items = explode(";", $csv);

foreach ($items as $item) {
$colunas = explode(",", $item);
// Inserir aqui na base de dados, usando $coluna[0], $coluna[1], ..., $coluna[N]
}

Note that this code was made out of my head, is not tested.