Exemple #1
0
<?php

require_once "../include/includes.php";
setContentType("text", "plain");
session_start();
$db = new SqlManager($fpConfig);
$postData = $_POST;
if (!$postData) {
    $postData = getJsonPostData();
}
//$postData = array("action" => "login", "username" => "amy", "password" => "koKoBird" );
debugVar("postData");
$action = $postData ? @$postData["action"] : reqParam("action");
debugVar("action");
$response = array();
// POST: {action: login, username:, password: md5}, return user if successful or null if login fail
// POST: {action: register, username, email, password: md5, first_name, last_name}, return user if successful or null if login already exists.
// POST: {action: sendResetEmail, email}, return success or error if user not found
// POST: {action: resetPassword, email, key, password}, return success or error if user not found or invalid key or empty password
// GET/POST  {}		return current session["user"];
// GET/POST  {action: logout} unset session["user"], return empty or null user object;
// response: {success: true, user: {}, message: }
//compare MD5 password in db with MD5 password submitted
function validatePassword($dbUser, $postData)
{
    if (!$dbUser || !isset($postData["password"])) {
        return false;
    }
    return $dbUser["password"] == $postData["password"];
}
switch ($action) {
Exemple #2
0
<?php

require_once "../include/includes.php";
setContentType("text", "plain");
session_start();
$db = new SqlManager($fpConfig);
$postJson = getJsonPostData();
$action = reqParam("action");
if (!$action) {
    $action = @$postJson["action"];
}
$username = fpCurrentUsername();
$response = array();
switch ($action) {
    case "saveForm":
        //save form: insert,update,delete user_answers for this user
        $user_answers = $postJson["formData"];
        $result = saveAnswers($db, $username, $user_answers);
        $response = array("answers" => count($user_answers), "result" => $result);
        break;
    case "form_questions":
    default:
        $response["questions"] = getFormQuestions($db, $_REQUEST);
        if ($username) {
            $response["user_answers"] = $db->selectWhere(array("table" => "user_answer", "username" => $username));
        }
}
$db->disconnect();
$response["queries"] = $db->getLog();
$response["time"] = getTimer(true);
echo jsValue($response);
Exemple #3
0
<?php

require_once "../include/includes.php";
setContentType("text", "plain");
session_start();
//get query parameters from request
//query database: upload, user and user_answer tables
//return list of uploads with image urls.
$params = getJsonPostData();
debugVar("params");
if (!$params) {
    $params = $_REQUEST;
}
$username = fpCurrentUsername();
$db = new SqlManager($fpConfig);
if ($db->offline) {
    echo file_get_contents("query.json");
    return;
}
$questions = getFormQuestions($db);
$questions = arrayIndexBy($questions, "id");
//debugVar("questions", true);
$portraitType = arrayExtract($params, "portrait");
//convert age to year_born
ageToYearBorn($db, $params);
$order = arrayExtract($params, "order");
$groupBy = arrayExtract($params, "group");
$interval = arrayExtract($params, "interval");
if (!$groupBy) {
    $results = demographicPortrait($db, $params, $portraitType);
    //$users = arrayDistinct($results, "username");