<?php
if (isset($_GET['term'])) {
    include "../../db.php";
    include "../../php_conexion.php";
    $return_arr = array();
    /* If connection to database, run sql statement. */
    if ($conexion) {

        $fetch = mysqli_query($conexion, "SELECT * FROM mecanico where nombre_mecanico like '%" . mysqli_real_escape_string($conexion, ($_GET['term'])) . "%' LIMIT 0 ,50");

        /* Retrieve and store in array the results of the query.*/
        while ($row = mysqli_fetch_array($fetch)) {
            $id_mecanico                  = $row['id_mecanico'];
            $row_array['value']          = $row['nombre_mecanico'];
            $row_array['id_mecanico']     = $id_mecanico;
            $row_array['nombre_mecanico'] = $row['nombre_mecanico'];
            //$row_array['fiscal_cliente'] = $row['fiscal_cliente'];
            //$row_array['email_cliente']  = $row['email_cliente'];
            array_push($return_arr, $row_array);
        }
    }

    /* Free connection resources. */
    mysqli_close($conexion);

    /* Toss back results as json encoded array. */
    echo json_encode($return_arr);
}
