surveys Database Table

Table: surveys

Tool: Survey
Associated Objects: Surveys, Survey

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(50) NOT NULL v5

token VARCHAR(255) NOT NULL v5

description VARCHAR(255) NOT NULL v5

redirecturl VARCHAR(255) NOT NULL v5

random BIT(1) NOT NULL DEFAULT 0 v5

questionshow TINYINT NOT NULL DEFAULT 0 v5

member INT UNSIGNED NOT NULL v5

contactgroup INT UNSIGNED NOT NULL DEFAULT 1 v5

body TEXT NOT NULL v5

head TEXT NOT NULL v5

results TEXT NOT NULL v5

useremail TEXT NOT NULL v5

subject VARCHAR(255) NOT NULL v5

adminnotify BIT(1) NOT NULL DEFAULT 1 v5

membernotify BIT(1) NOT NULL DEFAULT 1 v5

contactnotify BIT(1) NOT NULL DEFAULT 1 v5

addtlemail TEXT NOT NULL v5

addtlsubject VARCHAR(100) 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 surveys");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $token = $resRow["token"];  //
 $description = $resRow["description"];  //
 $redirecturl = $resRow["redirecturl"];  //
 $random = $resRow["random"];  //
 $questionshow = $resRow["questionshow"];  //
 $member = $resRow["member"];  //
 $contactgroup = $resRow["contactgroup"];  //
 $body = $resRow["body"];  //
 $head = $resRow["head"];  //
 $results = $resRow["results"];  //
 $useremail = $resRow["useremail"];  //
 $subject = $resRow["subject"];  //
 $adminnotify = $resRow["adminnotify"];  //
 $membernotify = $resRow["membernotify"];  //
 $contactnotify = $resRow["contactnotify"];  //
 $addtlemail = $resRow["addtlemail"];  //
 $addtlsubject = $resRow["addtlsubject"];  //
}

Other Survey Tables

surveyanswers surveyquestions surveyresults surveys surveyusers

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us