PHP Classes

File: upload/plugins/bulletinboard/api_libs/bb_get_list_message_ads.php

Recommend this page to a friend!
  Classes of James Brows   PHP Bulletin Board   upload/plugins/bulletinboard/api_libs/bb_get_list_message_ads.php   Download  
File: upload/plugins/bulletinboard/api_libs/bb_get_list_message_ads.php
Role: Example script
Content typex: text/plain
Description: Example script
Class: PHP Bulletin Board
Manage and post messages in multi-user forums
Author: By
Last change:
Date: 3 years ago
Size: 964 bytes
 

Contents

Class file image Download
<?php

function bb_get_list_message_ads()
{
    //Ki?m tra Cookie, n?u ko ??ng nh?p thì tr? v? false
    $cookie_username=isset(Configs::$_['user_data']['user_id'])?Configs::$_['user_data']['user_id']:'';

    try {
        isValidAccessAPI();
    } catch (\Exception $e) {
        echo responseData($e->getMessage(),'yes');return false;
    }

    $limit=addslashes(getPost('limit','50'));
    $page_no=addslashes(getPost('page_no','1'));

    if((int)$page_no > 0)
    {
        $page_no=(int)$page_no-1;
    }
    if((int)$page_no<=0)
    {
        $page_no=0;
    }

    $offset=(int)$page_no*30;
   
    $queryStr='';

    $queryStr.="select a.*,b.subject as title,b.username as author ";
    $queryStr.=" from bb_message_ads_data as a join bb_message_data as b ON a.message_id=b.message_id ";
    $queryStr.=" order by a.ent_dt desc limit ".$offset.",".$limit;

    $db=new Database();
    $result=$db->query($queryStr);

    return $result;
}