slideshows Database Table

Table: slideshows

Tool: Slideshow
Associated Objects: Slideshow, Slideshows

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

speedtype TINYINT UNSIGNED NOT NULL v5

speedmilli SMALLINT UNSIGNED NOT NULL v5

effect TINYINT UNSIGNED NOT NULL v5

width SMALLINT UNSIGNED NOT NULL v5

height SMALLINT UNSIGNED NOT NULL v5

title VARCHAR(255) NOT NULL v5

speedinterval SMALLINT UNSIGNED NOT NULL DEFAULT 5000 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 slideshows");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $speedtype = $resRow["speedtype"];  //
 $speedmilli = $resRow["speedmilli"];  //
 $effect = $resRow["effect"];  //
 $width = $resRow["width"];  //
 $height = $resRow["height"];  //
 $title = $resRow["title"];  //
 $speedinterval = $resRow["speedinterval"];  //
}

Table: slideshows

Fields

Example PHP Usage

Other Slideshow Tables