slidebanners Database Table

Table: slidebanners

Tool: Banner Creator
Associated Objects: SlideBanners, SlideBanner

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL DEFAULT 1 v5

title VARCHAR(50) NOT NULL v5

description TEXT NOT NULL v5

url VARCHAR(255) NOT NULL v5

width SMALLINT UNSIGNED NOT NULL v5

height SMALLINT UNSIGNED NOT NULL v5

slidebannerstyle 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 slidebanners");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $url = $resRow["url"];  //
 $width = $resRow["width"];  //
 $height = $resRow["height"];  //
 $slidebannerstyle = $resRow["slidebannerstyle"];  //
}

Other Banner Creator Tables

bannercreatorfields bannercreators slidebanners slidebannerstyles

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us