forumposts Database Table

Table: forumposts

Tool: Forum
Associated Objects: ForumPosts, ForumPost

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

forumthread INT UNSIGNED NOT NULL v5

postertype TINYINT UNSIGNED NOT NULL v5

posterid INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

title VARCHAR(50) NOT NULL v5

post TEXT 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 forumposts");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $forumthread = $resRow["forumthread"];  //
 $postertype = $resRow["postertype"];  //
 $posterid = $resRow["posterid"];  //
 $added = $resRow["added"];  //
 $title = $resRow["title"];  //
 $post = $resRow["post"];  //
}

Other Forum Tables

forumauth forumpostlikes forumposts forums forumthreads

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us