public static function create_table($name) { $query_string = "CREATE TABLE IF NOT EXISTS " . $name . "_users " . "(\n\t\t\t\t\t\t\t `first_name` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t `last_name` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t `email` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t `phone_number` varchar(13) NOT NULL,\n\t\t\t\t\t\t\t `score` int(11) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t `questions_attempted` int(11) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t `correct_ans` int(11) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t `wrong_ans` int(11) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t PRIMARY KEY (`email`),\n\t\t\t\t\t\t\t UNIQUE KEY `phone_number` (`phone_number`)\n\t\t\t\t\t\t\t)"; $db = new DB_CONNECT(); $result = $db->query_database($query_string); return $result; }
public static function create_table($name) { $query_string = "CREATE TABLE IF NOT EXISTS " . $name . "_questions" . "(\n\t\t\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t\t\t `question` text NOT NULL,\n\t\t\t\t\t\t\t `option1` text NOT NULL,\n\t\t\t\t\t\t\t `option2` text NOT NULL,\n\t\t\t\t\t\t\t `option3` text NOT NULL,\n\t\t\t\t\t\t\t `option4` text NOT NULL,\n\t\t\t\t\t\t\t `correct_ans` text NOT NULL,\n\t\t\t\t\t\t\t `marks` int(11) NOT NULL,\n\t\t\t\t\t\t\t `negative_marks` int(11) NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t\t\t)"; $db = new DB_CONNECT(); $result = $db->query_database($query_string); return $result; }
<?php require_once "../includes/db_connect.php"; require_once "../includes/functions.php"; require_once "../includes/session.php"; confirm_logged_in(); if (!is_null($_GET['question_id'])) { $test_name = urldecode($_GET['test_name']); $question_id = $_GET["question_id"]; $db = new DB_CONNECT(); $username = get_username(); //$test_name = $db->mysql_prep($_POST["test_name"]); $table_name = $test_name . "_questions"; $query = "DELETE FROM " . $table_name . " WHERE id='{$question_id}'"; $result = $db->query_database($query); if (is_null($result)) { // query failed echo "query failed"; } else { redirect_to('question_list.php?test_name={$test_name}'); } }
<?php require_once '../includes/db_connect.php'; require_once '../includes/functions.php'; require_once '../includes/session.php'; confirm_logged_in(); $db = new DB_CONNECT(); // get username from the session $username = get_username(); //select all test created by him from test table if (isset($_GET["message"])) { $message = "The Test has been deleted."; } $query = "SELECT test_name,start_time,end_time,event_date,duration FROM test WHERE username='******'"; $admin_tests = $db->query_database($query); if ($db->number_of_rows($admin_tests) > 0) { $i = 1; while ($row = $db->fetch_array($admin_tests)) { $table_data = array(); $table_data_array[$i] = array(); $table_data["test_name"] = $row["test_name"]; $table_data["start_time"] = $row["start_time"]; $table_data["end_time"] = $row["end_time"]; $table_data["event_date"] = $row["event_date"]; $table_data["duration"] = $row["duration"]; $table_data_array[$i] = $table_data; $i++; } $no_of_rows = $i - 1; $table_data_array["number_of_rows"] = $no_of_rows; $table_html = make_test_information_table();
if (is_null($result)) { // query failed echo "query failed"; } else { redirect_to("question_list.php?test_name=" . get_test_name()); } } else { echo "empty fields"; } } else { echo "Someting was not set"; } } else { $db = new DB_CONNECT(); $query = "SELECT * FROM test WHERE test_name='" . get_test_name() . "' AND username='******' "; $details = $db->query_database($query); if ($db->number_of_rows($details) > 0) { $i = 1; $row = $db->fetch_array($details); $table_data = array(); $table_data["test_name"] = $row["test_name"]; $table_data["start_time"] = $row["start_time"]; $table_data["end_time"] = $row["end_time"]; $table_data["event_date"] = $row["event_date"]; $table_data["duration"] = $row["duration"]; } } ?> <!DOCTYPE html> <html>
<?php require_once '../includes/db_connect.php'; require_once '../includes/functions.php'; require_once '../includes/session.php'; confirm_logged_in(); $db = new DB_CONNECT(); // get username from the session $username = get_username(); $test_name = urldecode($_GET['test_name']); //select all test created by him from test table $query = "SELECT * FROM " . $test_name . "_users"; $users_table = $db->query_database($query); if ($db->number_of_rows($users_table) > 0) { $i = 1; while ($row = $db->fetch_array($users_table)) { $table_data = array(); $table_data_array[$i] = array(); $table_data["first_name"] = $row["first_name"]; $table_data["last_name"] = $row["last_name"]; $table_data["email"] = $row["email"]; $table_data["phone_number"] = $row["phone_number"]; $table_data["score"] = $row["score"]; $table_data["questions_attempted"] = $row["questions_attempted"]; $table_data["correct_ans"] = $row["correct_ans"]; $table_data["wrong_ans"] = $row["wrong_ans"]; $table_data_array[$i] = $table_data; $i++; } $no_of_rows = $i - 1; $table_data_array["number_of_rows"] = $no_of_rows;
} if (isset($_POST["submit"])) { $db = new DB_CONNECT(); $keys = array("question", "option1", "option2", "option3", "option4", "radio", "marks", "negative_marks"); if (!array_diff($keys, array_keys($_POST)) && check_is_set($_POST)) { $question = $db->mysql_prep($_POST["question"]); $option1 = $db->mysql_prep($_POST["option1"]); $option2 = $db->mysql_prep($_POST["option2"]); $option3 = $db->mysql_prep($_POST["option3"]); $option4 = $db->mysql_prep($_POST["option4"]); $correct_ans = $db->mysql_prep($_POST["radio"]); $marks = $db->mysql_prep($_POST["marks"]); $negative_marks = $db->mysql_prep($_POST["negative_marks"]); $table_name = get_test_name() . "_questions"; $query = "Insert into " . $table_name . " (`question`, `option1`, `option2`, `option3`, `option4`, `correct_ans`, `marks`, `negative_marks`) \n VALUES('{$question}','{$option1}','{$option2}', '{$option3}', '{$option4}', '{$correct_ans}', '{$marks}', '{$negative_marks}')"; if (!is_null($db->query_database($query))) { redirect_to("add_question.php?message=true"); } else { echo "Question cannot be added"; } } else { $message = "Someting was not set"; } } ?> <!DOCTYPE html> <html> <head> <title>Add Question</title> <?php
<?php require_once "../includes/db_connect.php"; require_once "../includes/functions.php"; require_once "../includes/session.php"; confirm_logged_in(); if (!is_null($_GET['test_name'])) { $test_name = urldecode($_GET['test_name']); $db = new DB_CONNECT(); $username = get_username(); //$test_name = $db->mysql_prep($_POST["test_name"]); $query = "DELETE FROM test WHERE username='******' AND test_name='{$test_name}'"; $result = $db->query_database($query); if (is_null($result)) { // query failed echo "query failed"; } else { $user_table = $test_name . "_users"; $questions_table = $test_name . "_questions"; $query = "DROP TABLE {$user_table} "; $result = $db->query_database($query); $query2 = "DROP TABLE {$questions_table} "; $result2 = $db->query_database($query2); var_dump($query2); if (!is_null($result) && !is_null($result2)) { redirect_to('view_test.php?message=true'); } } }