$aValues["first_answer_correct"] = isset($aValues["first_answer_correct"]) ? 1 : 0;
$aValues["second_answer_correct"] = isset($aValues["second_answer_correct"]) ? 1 : 0;
$aValues["second_answer"] = str_replace("\"", "\"", str_replace("'", "\\'", htmlentities($aValues["second_answer"])));
$aValues["second_answer"] = str_replace("\"", "\"", str_replace("'", "\\'", htmlentities($aValues["second_answer"])));
$sInsertFirstAnswer = "INSERT INTO wds_answer (ans_answer, ans_correct, ans_created_by, ans_updated_by, ans_created_at, ans_updated_at, ans_active) VALUES ('{$aValues["first_answer"]}', {$aValues["first_answer_correct"]}, 1, 1, now(), now(), 1)";
$cmdInsertFirstAnswers = $db->command($sInsertFirstAnswer, true);
$iFirstAnswerID = $db->GetInsertedID();
$sInsertSecondAnswer = "INSERT INTO wds_answer (ans_answer, ans_correct, ans_created_by, ans_updated_by, ans_created_at, ans_updated_at, ans_active) VALUES ('{$aValues["second_answer"]}', {$aValues["second_answer_correct"]}, 1, 1, now(), now(), 1)";
$cmdInsertSecondAnswers = $db->command($sInsertSecondAnswer, true);
$iSecondAnswerID = $db->GetInsertedID();
$sInsertQuestion = "INSERT INTO wds_questions (qes_question, qes_created_by, qes_updated_by, qes_created_at, qes_updated_at, qes_active) VALUES ('{$aValues["question"]}', 1, 1, now(), now(), 1)";
$cmdInsert = $db->command($sInsertQuestion, true);
$iQuestionID = $db->GetInsertedID();
$sInsertAnsQues = "INSERT INTO wds_answers_question (anqe_first_answer_id, anqe_second_answerd_id, anqe_question_id, anqe_created_by, anqe_updated_by, anqe_created_at, anqe_updated_at, anqe_active) VALUES ({$iFirstAnswerID[0]}, {$iSecondAnswerID[0]}, {$iQuestionID[0]}, 1, 1, now(), now(), 1)";
$cmdInsertAnsQues = $db->command($sInsertAnsQues, true);
$iSetAnswerQuestionID = $db->GetInsertedID();
$sSelectTrivia .= " AND trivia.anqe_id = {$iSetAnswerQuestionID[0]}";
$cmdSavedTrivia = $db->command($sSelectTrivia);
if ($db->NumRowsAffected() > 0) {
$aData["success"] = "Trivia {$aValues["question"]} created successfully";
$aData["records"] = $db->fetch_array($cmdSavedTrivia);
} else {
array_push($aData["message_list"], "Trivia was unable to be inserted. This is the error: " . $db->GetError());
}
}
} else {
$sSelectTrivia .= isset($aValues["random"]) ? " ORDER BY RAND() LIMIT 10" : "";
$cmdGetTrivias = $db->command($sSelectTrivia);
$aData["records"] = $db->fetch_array($cmdGetTrivias);
}
echo json_encode($aData);
<?php
error_reporting(E_STRICT);
include_once "cls_connection.php";
$db = new ConnectMySql();
$aValues = json_decode(file_get_contents("php://input"), true);
$sUsername = $aValues["username"];
$sPassword = md5("WhatdidyousayUser " . $aValues["password"]);
$aData = array();
$aData["message_list"] = array();
if ($sUsername !== "") {
$sSelect = "select * from wds_users u where u.user_username = '******' and u.user_password = '******'";
$cmd = $db->command($sSelect);
if ($db->NumRowsAffected() > 0) {
$aData = $db->fetch_array($cmd);
} else {
array_push($aData["message_list"], "Username {$sUsername} credentials are incorrect or it was not found on DB.");
}
} else {
array_push($aData["message_list"], "Please fill form so we can sign you in.");
}
echo json_encode($aData);
