Ajax update only on selected line

Question

I have a Datatable here and I’m using a plugin so that the user can edit the table data, got in parts(haha), the problem is that my call is not identifying what the user enters, and when I manually set the cell value it changes in all rows of that column in db, I imagine I need to identify the row ID the user is editing but I don’t know how to do.

Below my Ajax Call:

    $.ajax({
        url: "include/edita.php",
        type: "POST",
        data: { 'coletadora': 'Definição Manual'},                   
        success: function(data){
            alert(data);                                    
        }
    });

It is also relevant the content of my edita.php (ignore the defamed php, was long away from php and need this system running before transitioning to PDO), I know I need a WHERE to limit the update to this particular ID that we will discover:

    <?php
$host= 'localhost';
$bd= 'minhadb';
$userbd = 'meuusr';
$senhabd= 'meupw';



//Conectando com banco MySQL
$conexao = mysql_connect($host,$userbd,$senhabd);
if (!$conexao)
    die ("Erro de conexão com localhost, o seguinte erro ocorreu -> ".mysql_error());
//Conectando com a tabela do banco de dados
$banco = mysql_select_db($bd,$conexao);
if (!$banco)
    die ("Erro de conexão com banco de dados, o seguinte erro ocorreu -> ".mysql_error());
$coletadora   = $_POST["coletadora"];
$sql = "UPDATE minhadb SET coletadora = '$coletadora'";

mysql_query($sql,$conexao);
?>

Thanks in advance for the help!

Answer 1

It is why you have not informed, through the key Primary or other unique value, which line should be changed in the database.

An output for this can be the inclusion of the changed line id in the request.

For example: (Taking into account that you use jQuery)

<td data-id="1" data-coluna="coletadora">VALOR DA CÉLULA</td>

When your user submits the changes, you should include both the column and the new value and the "identifier" of that row, which in this example would be the id.

Ex:

$.ajax({
        url: "include/edita.php",
        type: "POST",
        data: { 
                $('tdQueOUserAlterou').data('coluna') : 
                $('tdQueOUserAlterou').text(),
                'id' : $('tdQueOUserAlterou').data('id')
        },                   
        success: function(data){
            alert(data);                                    
        }
    });

Then the SQL query could be changed to:

$id = $_POST['id'];
$sql = "UPDATE minhadb SET coletadora = '$coletadora' WHERE 'id'='$id'";

This WHERE tag is what defines which line to change. You want to set the collector equal to such a value ONLY where the id is equal to that entered. Remembering that it can be any single field in your table and not only id.