<?php
header('Access-Control-Allow-Origin: *');
header('Expires: Sun, 01 Jan 2014 00:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');


include 'jsonconn.php';
include 'func.library.php';


$user_id=$_POST['user_id'];
$name=$_POST['name'];



    
    $sql="update users set name='$name' where   id ='$user_id'"; 
     executeQuery($sql, $link); 


//end register

$sql="select * from users  WHERE id ='$user_id'"; 




try {
    $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $dbh->query($sql);
    $member = $stmt->fetchAll(PDO::FETCH_OBJ);
    $dbh = null;
    echo @$_GET['callback'] .'{"otp":'. json_encode($member) .'}';
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}


?>