videos Database Table

Table: videos

Tool: Video Library
Associated Objects: Video, Videos

Fields

approved BIT(1) DEFAULT 0 NOT NULL v5

added INT UNSIGNED NOT NULL v5

member INT UNSIGNED NOT NULL v5

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(50) NOT NULL v5

rating TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

url VARCHAR(255) NOT NULL v5

seconds SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

priority TINYINT UNSIGNED NOT NULL DEFAULT 0 v5.06

ispublic BIT(1) NOT NULL v5.06

details VARCHAR(255) NOT NULL v5.06

title2 VARCHAR(50) NOT NULL v5.06

directory VARCHAR(255) NOT NULL v5.06

seokeywords VARCHAR(255) NOT NULL v5.06

seodescription VARCHAR(25) NOT NULL v5.06

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 videos");
while ($resRow = $results->fetch_assoc())
{
 $approved = $resRow["approved"];  //
 $added = $resRow["added"];  //
 $member = $resRow["member"];  //
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $rating = $resRow["rating"];  //
 $url = $resRow["url"];  //
 $seconds = $resRow["seconds"];  //
 $priority = $resRow["priority"];  //
 $ispublic = $resRow["ispublic"];  //
 $details = $resRow["details"];  //
 $title2 = $resRow["title2"];  //
 $directory = $resRow["directory"];  //
 $seokeywords = $resRow["seokeywords"];  //
 $seodescription = $resRow["seodescription"];  //
}

Table: videos

Fields

Example PHP Usage

Other Video Library Tables