<?php
    session_start();
    $usuarioSession = $_SESSION['USUARIO'];
    $grupo = $_SESSION['GRUPO'];
    $contacto = $_SESSION['CONTACTO'];
    $awa_session_id = $_SESSION['AWA_SESION_ID'];
    include('../includes/conex.php');
    include('../includes/eat.php');
    if(!isset($usuarioSession) or $awa_session_id != $awa_id)
    {
      eatCookies();
      header('Location:../index.php');
    }
    if(isset($_COOKIE['usuario']) AND $_COOKIE['usuario'] != $staticUsu )
    {
      eatCookies();
      header('Loction:../index.php');
    }
    if(isset($_COOKIE['idioma']))
    {
      include('../lg/LG_' . $_COOKIE['idioma'] . '.php');
    }
    else
    {
      include('../lg/LG_SP.php');
    }
    $marca = htmlspecialchars(mysqli_real_escape_string($con,$_POST['marca']));
    if(empty($marca))
    {
        echo '<option value="">' . $elige_el_modelo_lg . '</option>';
    }
    else
    {
        $sql = "SELECT * FROM VEHICULOS_MODELOS WHERE MARCA = ? ORDER BY DESCRIPCION ASC";
        $stmt = $con->prepare($sql);
        $stmt->bind_param('i',$marca);
        $stmt->execute();
        $res = $stmt->get_result();
        if($res->num_rows)
        {
            echo '<option value="">' . $elige_el_modelo_lg . '</option>';
            echo '<option value="0" data-eurotax="">' . $nuevo_modelo_lg . '</option>';
            while($fila = $res->fetch_array()) 
            {
                echo '<option value="' . $fila['CODIGO'] . '" data-eurotax="' . $fila['EUROTAX'] . '">' . $fila['DESCRIPCION'] . '</option>';
            }
            
        }
        else
        {
            echo '<option value="">' . $elige_el_modelo_lg . '</option>';
        }
    }
    
?>

