I have this problem where i cant get any response from the .php that ajax is sending data to. its supposed to run a insert on mysql, i tried putting the query manually to see if it works and it does.
Here's the function that sends ajax
function Continue(SLAatendida) {
var url = window.location.pathname;
var id = url.substring(url.lastIndexOf('/')+ 1);
console.log(SLAatendida);
console.log(id);
$.ajax({
type: 'POST',
url: 'ws.php',
data: {
'id': id,
'sla_atendida': SLAatendida
},
success: function(msg){
console.log(msg);
}
});
And the php file thats supposed to run the query (ws.php)
<?php
session_start();
header('Access-Control-Allow-Origin: *');
header('Content-type: text/html; charset=UTF-8');
include('debug.php');
include('../antest/dbconnect.php');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$debug_to_console("ws");
$id = $_POST["id"];
$SLAatendida = $_POST["sla_atendida"];
$sql_upd_sla = "INSERT INTO sla (id, sla_atendida) VALUES ('$id','$SLAatendida')";
$data = $conn->query($sql_upd_sla);
if($conn->query($sql_upd_sla))
{
echo "Registro efetuado com sucesso";
} else {
echo "Houve um erro";
die();
}
?>
Both console.log returns the right values from the var.