videocomments Database Table

Table: videocomments

Tool: Video Library
Associated Objects: VideoComment, VideoComments

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

added INT UNSIGNED NOT NULL v5

visit INT UNSIGNED NOT NULL v5

video INT UNSIGNED NOT NULL v5

body 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 videocomments");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $visit = $resRow["visit"];  //
 $video = $resRow["video"];  //
 $body = $resRow["body"];  //
}

Table: videocomments

Fields

Example PHP Usage

Other Video Library Tables