update sql, avec php/ajax

Bonjour a vous,

Voici mon code, et je cherche a faire la mise a jour automatique de ma table sql en ajax, mais j'y arrive pas,
voici le code de ma page :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
                <table>
                    <?  while ($row = mysqli_fetch_assoc($result)) { ?>
                    <tr>
                        <td><?php echo $row['model_oem']; ?></td>
                        <td><?php echo "WV-" . $row['model_horizontal']; ?></td>
                        <td><?php echo $row['quantity']; ?></td>
                        <td><?php echo "<input type=\"text\" id=" . $row['model_oem'] . " name=\"product_qts\" value=\"0\">"; ?></td>
                        <td><?php echo "<input type=\"hidden\" id=" . $row['product_id'] . " name=\"product_id\" value=". $row['product_id'] . ">"; ?></td>
                        <script>
                            $(document).ready(function(){
                                $("#<?php echo $row['model_oem']?>").on('change', function postinput(){
                                    var product_qts = $('#<?php echo $row['model_oem']?>');
                                    var product_id = $('<?php echo $row['product_id']?>');
                                    $.ajax({
                                        url: 'editqts.php',
                                        data: { product_id: <?php echo $row['product_id']?>, product_qts: product_qts },
                                        type: 'post'
                                    }).done(function(responseData) {
                                        console.log('Done: ', responseData);
                                    }).fail(function() {
                                        console.log('Failed');
                                    });
                                });
                            });
                        </script>
                    </tr>
                    <?php } ?>
                </table>

et voici le code de mon fichier editqts.php :

Code:

1
2
3
4
5
6
7
$product_id = $_POST['product_id'];
$product_qts = $_POST['product_qts'];
 
if (isset($_POST['product_qts'])) {
    $sql_qts_update = "UPDATE oc_product SET quantity = '$product_qts' WHERE product_id = '$product_id' ";
    $conn->query($sql_qts_update);
}

je suis pas super avec le ajax encore.
Merci pour votre aide

<table> <?php while ( $row = mysqli_fetch_assoc($result) ): ?> <tr> <td><?= $row['model_oem'] ?></td> <td>WV-<?= $row['model_horizontal'] ?></td> <td><?= $row['quantity'] ?></td> <td> <input type="text" id="<?= $row['model_oem'] ?>" name="product_qts" value="0" /> <input type="hidden" id="<?= $row['product_id'] ?>" name="product_id" value="<?= $row['product_id'] ?>" /> </td> </tr> <?php endWhile; ?> </table> <script> $(document).ready(function() { $("td input[type='text']").change(function() { $.ajax({ url: 'editqts.php', data: { product_id: $(this).next().val(), product_qts: $(this).val() }, type: 'post' }).done(function (responseData) { console.log('Done: ', responseData); }).fail(function () { console.log('Failed'); }); }); }); </script>