blogentries Database Table

Table: blogentries

Tool: Blog
Associated Objects: BlogEntry, BlogEntries

Fields

id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT v5

added INT UNSIGNED NOT NULL DEFAULT 0 v5

title VARCHAR(100) NOT NULL v5

description VARCHAR(255) NOT NULL v5

body TEXT NOT NULL v5

blog MEDIUMINT UNSIGNED NOT NULL DEFAULT 1 v5

active BIT(1) NOT NULL DEFAULT 0 v5

directory VARCHAR(42) 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 blogentries");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $body = $resRow["body"];  //
 $blog = $resRow["blog"];  //
 $active = $resRow["active"];  //
 $directory = $resRow["directory"];  //
}

Other Blog Tables

blogcomments blogentries blogs blogtemplates blogvar blogvardata

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us