chatmessages Database Table

Table: chatmessages

Tool: Chat
Associated Objects: ChatMessage, ChatMessages

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

added INT UNSIGNED NOT NULL v5

member INT UNSIGNED NOT NULL v5

contact INT UNSIGNED NOT NULL v5

message VARCHAR(255) NOT NULL v5

delivered INT UNSIGNED NOT NULL DEFAULT 0 v5

owner BIT(1) NOT NULL DEFAULT 0 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 chatmessages");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $member = $resRow["member"];  //
 $contact = $resRow["contact"];  //
 $message = $resRow["message"];  //
 $delivered = $resRow["delivered"];  //
 $owner = $resRow["owner"];  //
}

Other Chat Tables

chatmessages chatsettings

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us