bannerads Database Table

Table: bannerads

Tool: Banner Ads

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

type TINYINT UNSIGNED NOT NULL v5

url VARCHAR(255) v5

content VARCHAR(255) v5

lastview INT UNSIGNED NOT NULL DEFAULT 0 v5

approved BIT(1) DEFAULT 0 NOT NULL v5

active BIT(1) DEFAULT 1 NOT NULL v5

views INT UNSIGNED NOT NULL DEFAULT 0 v5

clicks INT UNSIGNED NOT NULL DEFAULT 0 v5

added 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 bannerads");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $type = $resRow["type"];  //
 $url = $resRow["url"];  //
 $content = $resRow["content"];  //
 $lastview = $resRow["lastview"];  //
 $approved = $resRow["approved"];  //
 $active = $resRow["active"];  //
 $views = $resRow["views"];  //
 $clicks = $resRow["clicks"];  //
 $added = $resRow["added"];  //
}

Other Banner Ads Tables

banneradcredits bannerads banneradstats

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us