I have 2 PHP files, called:
- user_one.php -> returns a JSON with the info of One user (given by POST parameter)
- user_uptade.php -> modify all fieds of One user (given by POST parameter) and returns a JSON with the modified data.
Then I got 1 more file called, update_user.html where I want to:
- Call user_one.php
- take the JSON and put the info in the form of the update_user
- When User modifies his data, when he click accept button, user_update.php has to be called.
What I want to know is how can I fill this form calling the user_one.php given the $_POST['user'].
*The user_one.php has to return a "echo json" because this file is called ina mobile phone request*
user_one.php (where the json is coded and returned)
    <?php
/*
 * Following code will get single product details
 * A product is identified by product id (uid)
 */
// array for JSON response
$response = array();
// include db connect class
require_once __DIR__ . '../../db_connect.php';
// connecting to db
$db = new DB_CONNECT();
// check for post data
if (isset($_POST["user"])) {
    $uid = $_POST['user'];
    // get a product from products table
    $result = mysql_query("SELECT *FROM Usuarios WHERE Usuario = '$uid'");
    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
            $result = mysql_fetch_array($result);
            $users = array();
            $users["name"] = $result["Nombre"];
            $users["lastname"] = $result["Apellidos"];
            $users["user"] = $result["Usuario"];
            $users["password"] = $result["Contrasena"];
            $users["birthday"] = $result["Fnacimiento"];
            $users["direction"] = $result["Direccion"];
            $users["email"] = $result["Email"];
            $users["phone"] = $result["TelfFijo"];
            $users["mobile_phone"] = $result["TelfMov"];
            $users["user_type"] = $result["TipoUsuario"]; 
            // success
            $response["success"] = 1;
            // user node
            $response["user"] = array();
            // push single users into final response array
            array_push($response["user"], $users); 
            // echoing JSON response
            echo json_encode($response);
        } else {
            // no user found
            $response["success"] = 0;
            $response["message"] = "No user found";
            // echo no users JSON
            echo json_encode($response);
        }
    } else {
        // no user found
        $response["success"] = 0;
        $response["message"] = "No user found";
        // echo no users JSON
        echo json_encode($response);
    }
} else {
    // required field is missing
    $response["success"] = 0;
    $response["message"] = "Required field(s) is missing";
    // echoing JSON response
    echo json_encode($response);
}
?>
user_uptade.html (Where has to be filled the form with JSON obtained in user_one.php)
<html>
<body> 
<br>Agregue un nuevo Usuario:
<form method="post" action="user_update.php" >
Nombre:
<br>
<input type="Text" name="name" >
<br>
<br>
Apellidos:
<br>
<input type="Text" name="lastname" >
<br>
<br>
Usuario:
<br>
<input type="Text" name="user" >
<br>
<br>
Fecha nacimiento:
<br>
<input type="Text" name="bday" >
<br>
<br>
Direccion:
<br>
<input type="Text" name="direccion" >
<br>
<br>
TelFijo:
<br>
<input type="Text" name="tfijo" >
<br>
<br>
TelMov:
<br>
<input type="Text" name="tmov" >
<br>
<br>
Email:
<br>
<input type="Text" name="email" >
<br>
<br>
Password:<br>
<input type="password" name="password" ><br>
<input type="Submit" name="enviar" value="Agregar">
</form>
</body>
</html>
 
    