<?php
function datosCoche($bd, $id_car){
    $sql =  "   SELECT MA.DESCRIPCION AS MARCA, MO.DESCRIPCION AS MODELO, V.COMBUSTIBLE, V.CAJACAMBIOS, V.CARROCERIA, V.KM, V.ANO_FAB
                FROM VEHICULOS V
                INNER JOIN VEHICULOS_MARCAS MA ON V.MARCA = MA.CODIGO
                INNER JOIN VEHICULOS_MODELOS MO ON MO.CODIGO = V.MODELO
                WHERE V.CODIGO = ?";
    $base = $bd->prepare($sql);
    $id_car = mysqli_real_escape_string($bd, $id_car);
    $base->bind_param('i', $id_car);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
function curlPost($url,$data,$headers) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL,$url);
    curl_setopt($ch, CURLOPT_POST, TRUE);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 0);
    $response = curl_exec ($ch);
    if (curl_errno($ch)) {
        echo 'Error:' . curl_error($ch);
    }
    curl_close ($ch);
    return json_decode($response);
}
function curlGetData($url, $header) {

    $curl = curl_init();
    curl_setopt_array($curl, array(
        CURLOPT_URL => $url,
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_ENCODING => "",
        CURLOPT_MAXREDIRS => 10,
        CURLOPT_TIMEOUT => 0,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        CURLOPT_CUSTOMREQUEST => "GET",
        CURLOPT_HTTPHEADER => $header,
    ));
    $response = curl_exec($curl);
    curl_close($curl);
    return $response;
}
function limpiar($String){
    $String = str_replace(array('á','à','â','ã','ª','ä'),"a",$String);
    $String = str_replace(array('Á','À','Â','Ã','Ä'),"A",$String);
    $String = str_replace(array('Í','Ì','Î','Ï'),"I",$String);
    $String = str_replace(array('í','ì','î','ï'),"i",$String);
    $String = str_replace(array('é','è','ê','ë'),"e",$String);
    $String = str_replace(array('É','È','Ê','Ë'),"E",$String);
    $String = str_replace(array('ó','ò','ô','õ','ö','º'),"o",$String);
    $String = str_replace(array('Ó','Ò','Ô','Õ','Ö'),"O",$String);
    $String = str_replace(array('ú','ù','û','ü'),"u",$String);
    $String = str_replace(array('Ú','Ù','Û','Ü'),"U",$String);
    $String = str_replace(array('[','^','´','`','¨','~',']', "'"),"",$String);
    $String = str_replace("ç","c",$String);
    $String = str_replace("Ç","C",$String);
    $String = str_replace("ñ","n",$String);
    $String = str_replace("Ñ","N",$String);
    $String = str_replace("Ý","Y",$String);
    $String = str_replace("ý","y",$String);
     
    $String = str_replace("&aacute;","a",$String);
    $String = str_replace("&Aacute;","A",$String);
    $String = str_replace("&eacute;","e",$String);
    $String = str_replace("&Eacute;","E",$String);
    $String = str_replace("&iacute;","i",$String);
    $String = str_replace("&Iacute;","I",$String);
    $String = str_replace("&oacute;","o",$String);
    $String = str_replace("&Oacute;","O",$String);
    $String = str_replace("&uacute;","u",$String);
    $String = str_replace("&Uacute;","U",$String);

    $String = str_replace("/","-",$String);
    //$String = str_replace(" ","_",$String);
    $String = strtolower($String);
    return $String;
}
function multipleexplode ($delimiters,$string) {
    $phase = str_replace($delimiters, $delimiters[0], $string);
    $processed = explode($delimiters[0], $phase);
    return  $processed;
}
function verificaCodigoLiterales($bd, $codigo_lit, $tipo_lit){
    $sql =  "   SELECT L.DESCRIPCION_SP AS DESCRIPCION
                FROM VEHICULOS_LITERALES L
                WHERE L.CODIGO = ? AND L.TIPO = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $codigo_lit = mysqli_real_escape_string($bd, $codigo_lit);
    $tipo_lit = mysqli_real_escape_string($bd, $tipo_lit);
    $base->bind_param('is', $codigo_lit, $tipo_lit);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["DESCRIPCION"];
}
?>