load PHP from JavaScript

0

I'm doing a game in JavaScript and the result, when we win or lose, I pass it to a database with PHP. It is limited to making an update +1 query in games and +1 in wins or losses, and depending on whether we win or lose is a PHP file or another.

I am trying to do it for AJAX but it does not load the script. Look to see if you can lend me a hand.

The AJAX part:


function ganar() {
var enviar = new XMLHttpRequest();
  var relleno = 123;
  var url = 'ganar.php?relleno=' + relleno;

  enviar.open('GET', url, true);
  enviar.send(null);
  alert("HAS PERDIDO");
  window.location.href = "../charmander/perfil.php";
}
/***********************************************************/

The PHP:

<?php

$nombre=$_SESSION['usuario'];


$base= new PDO('mysql:host=localhost;dbname=te_la_juegas','root','');

$base->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

$base->exec("SET CHARACTER SET UTF8");

$sql="UPDATE USUARIOS SET partidas = partidas + 1, partidas_ganas = partidas_ganas + 1
 where nombre like '$nombre' ";
$resultado=$base->prepare($sql);

//$resultado->bindValue(":nombre",$nombre);

$resultado->execute(array($nombre));

header('Location:http://localhost/TRABAJO_FINAL/registrado/charmander/perfil.php');
exit;

 ?>

    
asked by Diego 12.06.2017 в 01:20
source

0 answers