<?php
require_once "praveen.php";
$respjson = array("status" => "unprocessed", error => 1);
$keys = array("userid", "password", "repassword");
$prn = new praveen();
$password = $prn->safePost("password");
$repassword = $prn->safePost("repassword");
if ($prn->checkPOST($keys)) {
if (strcmp($password, $repassword) == 0) {
$con = $prn->getConnection();
if ($con) {
$userid = $prn->safePost("userid");
$sql = "select password from registered_users where id='{$userid}' limit 1";
if ($result = $prn->query($sql)) {
$usercount = $result->num_rows;
if ($usercount == 1) {
$sql = "update hawabaaz.registered_users set password='******' where id='{$userid}'";
$prn->query($sql);
$respjson[error] = 0;
$respjson['status'] = "success";
} else {
$respjson["status"] = "Authentication Failure";
$respjson[error] = 5;
}
} else {
$respjson["status"] = "SQL querry error";
$respjson["SqlError"] = $conn->error;
$respjson[error] = 4;
}
} else {
<?php
require_once "praveen.php";
$keys = array("userId", "orders");
$app = new praveen();
$conn = $app->getConnection();
$app->checkPOST($keys);
$userId = $app->escapedPost($keys[0]);
$json = $app->escapedPost($keys[1]);
$sql = "insert into orders(user) value ({$userId})";
$result = $app->query($sql);
$orderId = $conn->insert_id;
if ($orders = json_decode($json, true)) {
$sql = "";
foreach ($orders as $order) {
$sql .= "insert into ordered_items(order_id, item_id, item_count) VALUES ({$orderId},{$order['0']},{$order['1']});";
}
$app->multiQuery($sql);
$resp[error] = 0;
if (debug) {
$resp[status] = "success";
}
} else {
$resp[error] = 6;
if (debug) {
$resp['status'] = "Json decode error";
$resp['json'] = $json;
$resp[line] = __LINE__;
}
}
echo json_encode($resp);