PHP getTabMember Examples

Example #1

File: member.inc.php Project: qcstw-dev/qcsasia

function displayListMember($selectedPage, $rechercheSQL, $nbCompteParPage, $action, $idUser, $sort)
{
    $tabMember = getTabMember($selectedPage, $rechercheSQL, $nbCompteParPage, $sort);
    $i = 0;
    foreach ($tabMember as $member) {
        if ($i % 2 == 0) {
            $htmlData = $htmlData . '<tr class="odd">' . "\n";
        } else {
            $htmlData = $htmlData . '<tr class="even">' . "\n";
        }
        $htmlData = $htmlData . '<td><input class="checkbox" name = "tabIdMember[]" type = "checkbox" value = "' . $member['id'] . '"/></td>' . "\n";
        $htmlData = $htmlData . '<td><a target "_BLANK" href = "index.php?page=view-member&idMember=' . $member['id'] . '">' . $member['id'] . '</a></td>' . "\n";
        $htmlData = $htmlData . '<td>' . $member['company_name'] . '</td>' . "\n";
        $htmlData = $htmlData . '<td>' . $member['type'] . '</td>' . "\n";
        $htmlData = $htmlData . '<td><a href = "mailto:' . $member['email'] . '">' . $member['email'] . '</a></td>' . "\n";
        $htmlData = $htmlData . '<td>' . $member['country'] . '</td>' . "\n";
        $htmlData = $htmlData . '<td>' . $member['country_ip'] . '</td>' . "\n";
        $status = $member['status'];
        if ($status == '0') {
            $status = "Pending";
        }
        if ($status == '1') {
            $status = "Email verified";
        }
        if ($status == '2') {
            $status = "Member";
        }
        if ($status == '99') {
            $status = "Deleted";
        }
        $htmlData = $htmlData . '<td>' . $status . '</td>' . "\n";
        if (time() - $member['last_hit'] < 10) {
            $htmlData = $htmlData . '<td><img width = "30" height = "30" src = "http://www.qcsasia.com/wp-content/uploads/2014/07/point-vert.jpg" /></td>' . "\n";
        } else {
            $htmlData = $htmlData . '<td></td>' . "\n";
        }
        $htmlData = $htmlData . '</tr>' . "\n";
        $i++;
    }
    return $htmlData;
}

Example #2

File: exportXLS.php Project: qcstw-dev/qcsasia

<?php

$baseURL = "../";
require_once "checkSession.php";
require_once "../include/utils.inc.php";
require_once "../include/member.inc.php";
require_once "../include/lib/phpexcel/PHPExcel.php";
require_once "../include/lib/phpexcel/PHPExcel/Writer/Excel2007.php";
////////////////////////////////////////////////////////////////////
$tabMember = getTabMember("", $_SESSION['sqlQuery'], -1, $_REQUEST['sort']);
$rand = rand(0, 10000);
$filename = "list-members-" . $login . "-" . $rand . ".xls";
$filepath = "../xls/" . $filename;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setTitle('QCS');
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
// STYLE TITRE
////////////////////////////////////////////////////////////
$styleTitre = new PHPExcel_Style();
$styleTitre->applyFromArray(array('font' => array('name' => 'Arial', 'bold' => true, 'size' => '12', 'color' => array('rgb' => 'FFFFFF')), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'DF0101')), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER)));
$objPHPExcel->getActiveSheet()->setSharedStyle($styleTitre, "A1:U1");
// TAILE DES COLONNES ///////////////////////////////////////////////
$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(30);