$query_data = jsonDataToQueryString($_POST);
$query = "INSERT INTO category ({$query_data['fields']}) VALUES({$query_data['values']})";
if (mysql_query($query)) {
$id = mysql_insert_id();
$message = "Data has been saved";
$idUpdatesql = "UPDATE category SET id = '{$id}' WHERE tbid = " . $id . "";
mysql_query($idUpdatesql);
$result["success"] = 1;
} else {
$result["success"] = 0;
$message = substr(mysql_error(), 0, -9);
}
} else {
// updating category fields
$id = $_POST['tbid'];
unset($_POST['tbid']);
$query_data = jsonEditQuery($_POST);
$sql = "UPDATE category SET {$query_data} WHERE tbid = " . $id . "";
// exit;
if (mysql_query($sql)) {
$result["success"] = 1;
$message = "Data has been updated";
} else {
$result["success"] = 0;
$message = substr(mysql_error(), 0, -9);
}
}
//exit;
$result["message"] = $message;
echo json_encode($result);
}
if ($action_check[1] == $val) {
$permissions[$val][$v] = true;
}
}
}
$permission_string = json_encode($permissions);
$fileds_data['permissions'] = $permission_string;
} else {
$fileds_data['permissions'] = "[]";
}
//insert
if (isset($_POST['id'])) {
//edit block;
$edit_id = $_POST['id'];
unset($fileds_data['id']);
$edit_query = jsonEditQuery($fileds_data);
$sql = "UPDATE users SET {$edit_query} WHERE id ={$edit_id}";
if (mysql_query($sql)) {
$return_data = array('status' => true, 'message' => "This user has been updated successfully.");
} else {
$return_data = array('status' => false, 'message' => "Please Try again.");
}
echo json_encode($return_data);
} else {
//add block
$post_data = jsonDataToQueryString($fileds_data);
$query = "insert into users ({$post_data['fields']}) values ({$post_data['values']})";
//echo $query;
if (mysql_query($query)) {
$return_data = array('status' => true, 'message' => "This user has been added successfully.");
echo json_encode($return_data);
