<?php
// Inclusione del file di connessione al database
include 'conn/con-db.php';

// Verifica se il form è stato inviato con il valore "register"
if (isset($_POST['var_insert_cookie']) && $_POST['var_insert_cookie'] == "register") {

    $var_editConnection = $var_condb_STRING;
    $var_editTable = "register_cookie";
    $var_editRedirectUrl = "/login/livello.asp";
    $var_fieldsStr = "visitor_ip|value|visitor_cookie|value";
    $var_columnsStr = "visitor_ip|',none,''|visitor_cookie|',none,''";

    // Crea gli array var_fields e var_columns
    $var_fields = explode("|", $var_fieldsStr);
    $var_columns = explode("|", $var_columnsStr);

    // Imposta i valori del form
    for ($i = 0; $i < count($var_fields); $i += 2) {
        $var_fields[$i + 1] = isset($_POST[$var_fields[$i]]) ? $_POST[$var_fields[$i]] : '';
    }

    // Crea la query SQL di inserimento
    $var_tableValues = "";
    $var_dbValues = "";
    for ($i = 0; $i < count($var_fields); $i += 2) {
        $FormVal = $var_fields[$i + 1];
        $var_typeArray = explode(",", $var_columns[$i + 1]);
        $Delim = $var_typeArray[0];
        if ($Delim == "none") {
            $Delim = "";
        }
        $AltVal = $var_typeArray[1];
        if ($AltVal == "none") {
            $AltVal = "";
        }
        $EmptyVal = $var_typeArray[2];
        if ($EmptyVal == "none") {
            $EmptyVal = "";
        }
        if ($FormVal == "") {
            $FormVal = $EmptyVal;
        } else {
            if ($AltVal != "") {
                $FormVal = $AltVal;
            } elseif ($Delim == "'") {  // escape quotes
                $FormVal = "'" . str_replace("'", "''", $FormVal) . "'";
            } else {
                $FormVal = $Delim . $FormVal . $Delim;
            }
        }
        if ($i != 0) {
            $var_tableValues .= ",";
            $var_dbValues .= ",";
        }
        $var_tableValues .= $var_columns[$i];
        $var_dbValues .= $FormVal;
    }
    $var_editQuery = "INSERT INTO " . $var_editTable . " (" . $var_tableValues . ") VALUES (" . $var_dbValues . ")";

    // Esegui l'inserimento
    $conn = new mysqli($var_condb_HOST, $var_condb_USER, $var_condb_PASS, $var_condb_DB);

    if ($conn->connect_error) {
        die("Connessione fallita: " . $conn->connect_error);
    }

    if ($conn->query($var_editQuery) === TRUE) {
        echo "insert";
    } else {
        echo "Errore: " . $conn->error;
    }

    $conn->close();
}
?>