schedules Database Table

Table: schedules

Tool: Schedule
Associated Objects: Schedules, Schedule

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

training BIT(1) NOT NULL DEFAULT 0 v5

begin INT UNSIGNED NOT NULL v5

end INT UNSIGNED NOT NULL v5

type TINYINT UNSIGNED NOT NULL DEFAULT 1 v5

typeid INT UNSIGNED 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 schedules");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $training = $resRow["training"];  //
 $begin = $resRow["begin"];  //
 $end = $resRow["end"];  //
 $type = $resRow["type"];  //
 $typeid = $resRow["typeid"];  //
}

Other Schedule Tables

schedules scheduletemplates

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us