Web-Service/points.php at master · Media-tv/Web-Service · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?php
include "connection.php";


if(isset($_POST['id']))
{

					if(isset($_POST['points']))	{
					    $sql = "UPDATE `users` SET `points` = :points
					    								WHERE id =  '".$_POST["id"]."' ";

					    $statement = $conn->prepare($sql);
					    $statement->bindValue(':points', $_POST['points']);
					    $updated = $statement->execute();
					    if($updated){
					  		 $sth = $conn->prepare("SELECT * FROM users WHERE id =  '".$_POST["id"]."' " );
					              $sth->execute();
					              $result2 = $sth->fetch(PDO::FETCH_ASSOC);
					              echo json_encode($result2);
					    }
    }else {
    	 $sth = $conn->prepare("SELECT * FROM users WHERE id =  '".$_POST["id"]."' " );
              $sth->execute();
              $result2 = $sth->fetch(PDO::FETCH_ASSOC);
              echo json_encode($result2);
    }

}


?>