showcases Database Table

Table: showcases

Tool: Member Showcase
Associated Objects: Showcase, Showcases

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(50) NOT NULL v5

shortdescr TEXT NOT NULL v5

longdescr TEXT NOT NULL v5

type TINYINT UNSIGNED NOT NULL v5

sorder TINYINT UNSIGNED NOT NULL v5

member 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 showcases");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $shortdescr = $resRow["shortdescr"];  //
 $longdescr = $resRow["longdescr"];  //
 $type = $resRow["type"];  //
 $sorder = $resRow["sorder"];  //
 $member = $resRow["member"];  //
}

Other Member Showcase Tables

showcases

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us