quizresponses Database Table

Table: quizresponses

Tool: Quiz
Associated Objects: QuizResponses, QuizResponse

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

added INT UNSIGNED NOT NULL v5

skipped BIT(1) NOT NULL DEFAULT 0 v5

timespent SMALLINT NOT NULL v5

answervalue TEXT NOT NULL v5

quiz INT UNSIGNED NOT NULL v5

iscorrect BIT(1) NOT NULL DEFAULT 0 v5

points TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

visitor INT UNSIGNED NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM quizresponses");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $skipped = $resRow["skipped"];  //
 $timespent = $resRow["timespent"];  //
 $answervalue = $resRow["answervalue"];  //
 $quiz = $resRow["quiz"];  //
 $iscorrect = $resRow["iscorrect"];  //
 $points = $resRow["points"];  //
 $visitor = $resRow["visitor"];  //
}

Other Quiz Tables

quizanswers quizque quizresponses quizzes

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us