Run PHP code once

Question

I want the code to run only once, because every time I refresh it re-enter the sqlite database. Without running from a button. code:

if(!file_exists($dir.$base)) {  
$base_hndl  =   new SQLite3($dir.$base);
$requete = "CREATE TABLE 'contact' (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
nom TEXT NULL,
prenom TEXT NULL,
categorie TEXT NULL
)";             
$result = $base_hndl->exec($requete);} else {
$row = 0;
$delemiter = ";" ;

$data = array();

    if (($handle = fopen("contacts.csv", "r")) !== FALSE) 
    {
        while (($data = fgetcsv($handle, 2000, $delemiter)) !== FALSE)
        { 
            $num = count($data);
            $row++;
            $base_hndl  =   new SQLite3($dir.$base);
            $query_value = "";
            $query = "INSERT INTO contact (nom,prenom,categorie) VALUES ( ";

            for ($c = 0; $c < $num; $c++) 
            {

                if($data[$c] == "")
                { 
                    $query_value .= "\"0\"";
                }
                else
                {
                    //$query .= "'" . $data[$c] . "'";
                    $query_value .= "\"$data[$c]\"";
                }
                if ($c+1 < $num) 
                {
                   $query_value .= ",";
                }
            }
            $query_value .= ")\n";

            $result = $base_hndl->exec($query.$query_value);    
        }
        fclose($handle);
    }

}

Answer 1

Just before the insertion code check if it was done POST, ie if it was through Submit:

if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'POST')
{
    //código de inserção após clicar no botão
}

Answer 2

I don’t understand, if you want the code to run only once, then make sure the page runs only once too

@Edit
Make a select and then if to check if the record already exists, if it already exists insert, if it does not exist insert insert.

if($registro > 0){
// não faz nada
}else{
//aqui vai o código se inserção
}

Answer 3

Make a SELECT before INSERT to know if there is already the record that is being inserted every page update.