lessonassignments Database Table

Table: lessonassignments

Tool: Study
Associated Objects: LessonAssignments, LessonAssignment

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

lesson INT UNSIGNED NOT NULL v5

contenttype TINYINT UNSIGNED NOT NULL v5

contentid INT UNSIGNED NOT NULL v5

dorder SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

forceorder BIT(1) NOT NULL DEFAULT 0 v5

scoreneeded INT UNSIGNED NOT NULL DEFAULT 0 v5

var1 VARCHAR(255) NOT NULL DEFAULT '0' v5

title VARCHAR(255) NOT NULL v5

description TEXT NOT NULL 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 lessonassignments");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $lesson = $resRow["lesson"];  //
 $contenttype = $resRow["contenttype"];  //
 $contentid = $resRow["contentid"];  //
 $dorder = $resRow["dorder"];  //
 $forceorder = $resRow["forceorder"];  //
 $scoreneeded = $resRow["scoreneeded"];  //
 $var1 = $resRow["var1"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
}

Other Study Tables

dictionary documentdict gameplay games gamevars lessonassignmentcomplete lessonassignmentresources lessonassignments lessonreset lessons mymath studyhistory vocabulary

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us