Ajax error when placing on server

Question

Good afternoon guys, I’m having a hard time, when I’m using my code in my local bank, it works normally... When I play on the server, it gives the following error: Datatables Warning: table id=dt_client - Ajax error. For more information about this error, Please see http://datatables.net/tn/7

I already did and I re-did everything, I entered the error link, and I followed the step by step. and gets here

Remember that in my local bank it works, and when I open it by the server, it gives this error right away, without any procedure.. What can I do to fix it? I’ll be very grateful if you help me. Some information is already in the comments, but on Leandro’s recommendation, I will post them here.

Useful information that can help: I imported the local bank EXACTLY EQUAL to the server. Before I just tried to SHOW the data, and it appeared normal, after I implemented the function to add/edit the tables it showed the mentioned error.

According to the error, it happens in the list.php which has the following code `

include ("conexion.php");

$query = "SELECT * FROM usuario WHERE estado = 1 ORDER BY idusuario desc;";
$resultado = mysqli_query($conexion, $query);

if( !$resultado ){ 
    die("Error");
}else{ 
    $array["data"] = []; //devuelve un arreglo vacío por si no hay registros en la base de datos.
    while( $data = sqlsrv_fetch_array ($resultado)){ 
        $arreglo["data"][] = array_map("utf8_encode", $data);

    }
    echo json_encode($arreglo);
}

mysqli_free_result($resultado);
mysqli_close($conexion);`

And that’s my "conexion.php"

<?php
$server = "localhost";
$user = "*****";
$password = "****";
$bd = "*****";

$conexion = mysqli_connect($server, $user, $password, $bd);
if (!$conexion){ 
    die('Error de Conexión: ' . mysqli_connect_errno());    
}   
?>

I’m almost sure it’s something on the server, because there are already some code working, what I realized is that they are only "mysql" and what I put now, is "mysqli". I don’t know if it could be something like...

Remembering that in localhost I can add/remove/edit normally, the database works 100%, when I play pro server by winscp, ( same name of the database, files, folders, users, etc) it does not load nor the information.

If necessary, I can pass the entire compressed code, as it has some dependency folders, like js,css etc... ( that also includes on the server). So we can test if it is a REALLY error on the server, or in the code itself. ** Moreover, the server is hosted on a local machine, which is accessed by the IP, I type the ip 177.xxx.xxx.xx / folder when I’m off the network, but my files are hosted on it, so the database is the same localhost.. I don’t know if I was clear or could explain what I wanted...

Answer 1

As I imagined, the problem was the server that did not run my codes for some reason, I made an internal server, I made it public and it worked, ( I don’t know how to close the topic xD)

Solved