Difficulty updating data with angular and php

Question

Good afternoon

I’m trying to update the database and I can’t. If I use mysqli, the following warning appears on the console: "http://localhost:8888/systems/systems_web/Vigilantescomunitarios/admin/php/updateUsuario.php 500 (Internal Server Error)"

If I use mysql and PDO connection, nothing happens, nor notice on the console appears.

My js file:

app.controller("AtualizarUsuarioController", function ($scope, $window, $http, $location) {

$scope.usuario = {
    'id': $window.localStorage.getItem('idUsuarios'),
    'nome': $window.localStorage.getItem('nome'),
    'email': $window.localStorage.getItem('email')
}

//$location.path('/atualizarUsuario' + $scope.usuario.id);
$scope.atualizarUsuario = function (usuario) {
    $http.post("admin/php/atualizarUsuario.php", usuario).then(function (data){
        $location.path("#/usuarios");
    });
};
});

php:

<?php
header("Access-Control-Allow-Origin: *");

include_once ("conPDO.php");
$pdo = conectar();

$postdata = file_get_contents("php://input");
$data = json_decode($postdata);
$id = $data->id;
$nome = $data->nome;
$email = $data->email;
$senha = $data->senha;

$senha = sha1($senha);

$usuarioAtual=$pdo->prepare("UPDATE usuarios SET nome=:nome, email=:email, senha=:senha WHERE id=:id");
$usuarioAtual->bindValue(":nome", $nome);
$usuarioAtual->bindValue(":email", $email);
$usuarioAtual->bindValue(":senha", $senha);
$usuarioAtual->bindValue(":id", $id);
$usuarioAtual->execute();

And my folder structure.

Console return after print_r and console.log

Answer 1

Your problem may be in the method used in $http, in your case you are using PUT. In the past I had problems using it also because there are settings and (some cases) server limitations that prevent the PUT be called.

Use POST, out some particularities - which will not imply in your case- you will have no problem and may be able to solve.

$http.post([url], [data], [config]);

Note: Do not use print screen of your code, use the same code.

---

Edited:

Another important point would be to use print_r (in php) and console.log (at Angular) to better debug what is happening and where the problem is.

//No AngularJs
$scope.atualizarUsuario = function (usuario) {
    $http.post("admin/php/atualizarUsuario.php", usuario).then(function (data){
        console.log(data); //'data' pois é o valor definido dentro do `function` do `then`
        $location.path("#/usuarios");
    });
};

//E no PHP
$usuarioAtual->execute();
print_r($usuarioAtual);

This way you have a better view of what is happening.