downloads Database Table

Table: downloads

Tool: Downloads
Associated Objects: Downloads, Download

Fields

ispublic BIT(1) NOT NULL DEFAULT 0 v5

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(255) NOT NULL v5

description TEXT NOT NULL v5

dorder INT UNSIGNED NOT NULL v5

url VARCHAR(100) NOT NULL v5

added INT UNSIGNED NOT NULL v5

downloads SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

member INT UNSIGNED NOT NULL DEFAULT 1 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 downloads");
while ($resRow = $results->fetch_assoc())
{
 $ispublic = $resRow["ispublic"];  //
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $dorder = $resRow["dorder"];  //
 $url = $resRow["url"];  //
 $added = $resRow["added"];  //
 $downloads = $resRow["downloads"];  //
 $member = $resRow["member"];  //
}

Other Downloads Tables

downloads

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us