PHP initialise_db Examples

Example #1

File: sqlprocesstoarray.php Project: prodigyworks/Service-Call

 function __construct()
 {
     //Include database connection details
     require_once 'system-db.php';
     start_db();
     initialise_db();
 }

Example #2

File: crud.php Project: prodigyworks/schokolat

 function __construct()
 {
     require_once 'system-db.php';
     start_db();
     initialise_db();
     if (isset($_GET['from'])) {
         $this->fromrow = $_GET['from'];
     }
     if (isset($_GET['to'])) {
         $this->torow = $_GET['to'];
     }
     if (isset($_GET['direction'])) {
         $this->sortdirection = $_GET['direction'];
     }
     if (isset($_GET['sort'])) {
         $this->sortby = $_GET['sort'];
     }
     $this->pagesize = $this->torow - $this->fromrow;
 }

Example #3

File: pdfreport.php Project: prodigyworks/FA

 function __construct($orientation, $metric, $size)
 {
     parent::__construct($orientation, $metric, $size);
     require_once 'system-db.php';
     start_db();
     initialise_db();
     $this->B = 0;
     $this->I = 0;
     $this->U = 0;
     $this->HREF = '';
     $this->fontlist = array('arial', 'times', 'courier', 'helvetica', 'symbol');
     $this->issetfont = false;
     $this->issetcolor = false;
 }

Example #4

File: addquotationdocument.php Project: prodigyworks/Coast-Guard

<?php

//Include database connection details
require_once 'system-db.php';
start_db();
initialise_db();
$quotationid = $_GET['id'];
$memberid = getLoggedOnMemberID();
$qry = "SELECT A.id FROM {$_SESSION['DB_PREFIX']}documents A " . "WHERE A.sessionid = '" . session_id() . "' " . "AND A.id NOT IN (SELECT documentid FROM {$_SESSION['DB_PREFIX']}quotationdocs WHERE documentid = A.id) " . "ORDER BY A.id";
$result = mysql_query($qry);
if (!$result) {
    logError($qry . " = " . mysql_error());
}
while ($member = mysql_fetch_assoc($result)) {
    $qry = "INSERT INTO {$_SESSION['DB_PREFIX']}quotationdocs " . "(quoteid, documentid, createddate, metacreateddate, metacreateduserid, metamodifieddate, metamodifieduserid) " . "VALUES " . "({$quotationid}, " . $member['id'] . ", NOW(), NOW(), {$memberid}, NOW(), {$memberid})";
    $itemresult = mysql_query($qry);
    if (!$itemresult) {
        logError($qry . " = " . mysql_error());
    }
}
$qry = "UPDATE {$_SESSION['DB_PREFIX']}documents " . "SET sessionid = NULL, metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE sessionid = '" . session_id() . "'";
$result = mysql_query($qry);
if (!$result) {
    logError($qry . " = " . mysql_error());
}
if (isset($_GET['refer'])) {
    header("location: " . base64_decode($_GET['refer']));
} else {
    header("location: " . $_SERVER['HTTP_REFERER']);
}

Example #5

File: system-db.php Project: prodigyworks/schokolat

function authenticate()
{
    start_db();
    initialise_db();
    if (!isAuthenticated()) {
        header("location: system-login.php?callback=" . base64_encode($_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING']));
        exit;
    }
}

Example #6

File: system-config.php Project: prodigyworks/Service-Call

 public static function initialiseDB()
 {
     initialise_db();
     if (!isset($_SESSION['ROLES'])) {
         $_SESSION['ROLES'] = array();
         $_SESSION['ROLES'][0] = "PUBLIC";
         $_SESSION['ROLES'][1] = "UNAUTHENTICATED";
     }
 }