appointmentrequests Database Table

Table: appointmentrequests

Tool: Appointments
Associated Objects: AppointmentRequests, AppointmentRequest

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

visitor INT UNSIGNED NOT NULL v5

begin INT UNSIGNED NOT NULL v5

end INT UNSIGNED NOT NULL v5

status TINYINT 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 appointmentrequests");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $added = $resRow["added"];  //
 $visitor = $resRow["visitor"];  //
 $begin = $resRow["begin"];  //
 $end = $resRow["end"];  //
 $status = $resRow["status"];  //
}

Other Appointments Tables

appointmentrequests

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us