calendars Database Table

Table: calendars

Tool: Calendar
Associated Objects: Calendars, Calendar

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

contact INT UNSIGNED NOT NULL v5

title VARCHAR(50) NOT NULL v5

description TEXT NOT NULL v5

begin INT UNSIGNED NOT NULL v5

recur TINYINT NOT NULL DEFAULT 0 v5

end 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 calendars");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $contact = $resRow["contact"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $begin = $resRow["begin"];  //
 $recur = $resRow["recur"];  //
 $end = $resRow["end"];  //
}

Other Calendar Tables

calendars calendarschedule

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us