setupdesign Database Table

Table: setupdesign

Tool: Design Management

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v2

designtype TINYINT v2.1

member INT UNSIGNED DEFAULT 0 v5

design INT UNSIGNED v5

writescript TINYINT DEFAULT 0 v2.1

hosting TINYINT DEFAULT 0 v2.1

video TINYINT DEFAULT 0 v2.1

background TINYINT DEFAULT 0 v2.1

matchingthankyou TINYINT DEFAULT 0 v2.1

matchingbanners TINYINT DEFAULT 0 v2.1

SEO TINYINT DEFAULT 0 v2.1

complete TINYINT DEFAULT 0 v2.1

added INT UNSIGNED DEFAULT 0 v2.1

hdetails TEXT v2.1

hfilename VARCHAR(255) v2.1

hautoresponder VARCHAR(255) v2.1

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 setupdesign");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $designtype = $resRow["designtype"];  //
 $member = $resRow["member"];  //
 $design = $resRow["design"];  //
 $writescript = $resRow["writescript"];  //
 $hosting = $resRow["hosting"];  //
 $video = $resRow["video"];  //
 $background = $resRow["background"];  //
 $matchingthankyou = $resRow["matchingthankyou"];  //
 $matchingbanners = $resRow["matchingbanners"];  //
 $SEO = $resRow["SEO"];  //
 $complete = $resRow["complete"];  //
 $added = $resRow["added"];  //
 $hdetails = $resRow["hdetails"];  //
 $hfilename = $resRow["hfilename"];  //
 $hautoresponder = $resRow["hautoresponder"];  //
}

Other Design Management Tables

designnotes designphotos designrevisions designs designtemplates designtypes setupdesign

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us