Prevent double insert at same time

Hi , today i check if there are some record inserted at same time in  a db's table and i have 21 record duplicated 8 on 2022, 12 on 2023 and 1 on 2024 .I   reduce this effect by adding a js working when i push submit button (disabling button and showing a gif)  at half of 2024 but i have  a duplicate on december 2024 . 

How can I completely avoid this problem?

Use redirect() after sending the form: https://codeigniter.com/user_guide/outgo...l#redirect

Use redirect() after sending the form: https://codeigniter.com/user_guide/outgo...l#redirect

Always i redirect after submit , this is an example :

Code:

$db = \Config\Database::connect();

$db->transStart()

//my code to insert

$db->transComplete();

if($db->transStatus()!==false) {

    session()->setFlashdata('gestisciRecordOK', 'MESSAGE OK');

    return redirect()->to('/CONTROLLER/METHOD/');


}else{

    session()->setFlashdata('gestisciRecordBad', 'MESSAGE BAD');

    return redirect()->to('/CONTROLLER/METHOD/');
}

But this is not the solution...

1. What do you mean by duplicated records?
2. Are you sending a form?
3. Are you using JS to send form data?

1 same data at same seconds
2 yes with post
3 only to form submit()

Please show me how you're handling the submission process in JS.

using a js client side verification isn't efficient nor secure.

to prevent the form being submited twice with same data one way is to use CI4 CSRF security

set Config/Security.php $regenerate = true
put a CSRF token in your form
set a CSRF filter on your POST route or check CSRF token in your controller on POST

https://codeigniter.com/user_guide/libra...urity.html

you may also set the db column(s) as unique so if one user try to submit dupplicate data with a valid CSRF the db will not accept them

1 same data at same seconds
2 yes with post
3 only to form submit()

You posted the same answer as 4 hours ago. Please show me your actual JS code that handles form submission.

You posted the same answer as 4 hours ago. Please show me your actual JS code that handles form submission.

sorry i make a mistake :

button to submit

Code:

        <div class='text-right mt-4'>
        <span>note: * campi obbligatori</span><br>
        <a href='<?= base_url() ?>' class='btn btn-danger'>Annulla</a>
        <button class='btn btn-info' id='bottone_invio_form' type='button' onclick=''>INSERISCI</button>
        <span id="gif_animata">  <i class="fas fa-spinner fa-spin"></i></span>
        </div>

script

Code:

        $("#bottone_invio_form").click(function() {

            var scegli_materiali = $("#scegli-materiali").val();

            var quantita = $("#id_class_quantita").val();

            if(scegli_materiali == ""  ){

                alert('Scegli un codice!!!!');

            }else if(quantita ==''){
               
                alert('Inserisci una quantità');


            }else{

                $("#bottone_invio_form").hide();

                $("#gif_animata").show();

                $("#myform").submit();

            }

         

        });