pushnotifications Database Table

Table: pushnotifications

Tool: Push Notifications

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

title VARCHAR(50) NOT NULL v5

message VARCHAR(255) NOT NULL v5

url VARCHAR(255) NOT NULL v5

tag VARCHAR(20) NOT NULL v5

icon VARCHAR(255) NOT NULL DEFAULT '' v5

added INT UNSIGNED 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 pushnotifications");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $title = $resRow["title"];  //
 $message = $resRow["message"];  //
 $url = $resRow["url"];  //
 $tag = $resRow["tag"];  //
 $icon = $resRow["icon"];  //
 $added = $resRow["added"];  //
}

Other Push Notifications Tables

pushnotificationkeys pushnotifications

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us