PHP start_db函数代码示例

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

 function __construct($orientation, $metric, $size, $datefrom)
 {
     $dynamicY = 0;
     $this->dateFrom = $datefrom;
     start_db();
     parent::__construct($orientation, $metric, $size);
     $this->SetAutoPageBreak(true, 30);
     $this->AddPage();
     try {
         $startdate = convertStringToDate($this->dateFrom);
         $sql = "SELECT A.name, C.amount,\n\t\t\t\t\t    (\n\t\t\t\t\t   \t\tSELECT SUM(B.amount) * D.retailprice\n\t\t\t\t\t   \t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t   \t\tINNER JOIN {$_SESSION['DB_PREFIX']}product D\n\t\t\t\t\t   \t\tON D.id = B.productid \n\t\t\t\t\t   \t\tWHERE B.eventid = A.id \n\t\t\t\t\t   \t\tAND B.eventdate = '{$startdate}' \n\t\t\t\t\t   \t\tAND B.type = 'S'\n\t\t\t\t\t    ) AS sold\n\t\t\t\t\t    FROM {$_SESSION['DB_PREFIX']}event A \n\t\t\t\t\t    LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}eventforecast C\n\t\t\t\t\t    ON C.eventid = A.id\n\t\t\t\t\t    AND C.forecastdate = '{$startdate}' \n\t\t\t\t\t\tORDER BY A.name";
         $result = mysql_query($sql);
         if ($result) {
             while ($member = mysql_fetch_assoc($result)) {
                 $sold = $member['sold'] != "" ? $member['sold'] : 0;
                 $line = array("Event" => $member['name'], "Takings" => "£ " . number_format($sold, 2), "Expected" => "£ " . number_format($member['amount'], 2));
                 $this->addLine($this->GetY(), $line, 6.2);
             }
         } else {
             logError($sql . " - " . mysql_error());
         }
     } catch (Exception $e) {
         logError($e->getMessage());
     }
 }

 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;
 }

<?php

//Include database connection details
require_once 'system-db.php';
start_db();
logout();
header("location: system-login.php");

 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;
 }

 function __construct($orientation, $metric, $size, $id)
 {
     $dynamicY = 0;
     start_db();
     parent::__construct($orientation, $metric, $size);
     try {
         $sql = "SELECT \n\t\t\t\t\t\t A.*, \n\t\t\t\t\t\t DATE_FORMAT(A.matchdate, '%d/%m/%Y') AS matchdate,\n\t\t\t\t\t\t B.name AS refereename, C.name AS submittedteamname, D.name AS oppositionname, \n\t\t\t\t\t\t E.name AS agegroupname, E.age\n\t\t\t\t\t\t FROM  {$_SESSION['DB_PREFIX']}matchdetails A\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}referee B\n\t\t\t\t\t\t ON B.id = A.refereeid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}team C\n\t\t\t\t\t\t ON C.id = A.teamid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}team D\n\t\t\t\t\t\t ON D.id = A.oppositionid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}teamagegroup E\n\t\t\t\t\t\t ON E.id = A.agegroupid\n\t\t\t\t\t\t WHERE A.id = {$id}";
         $result = mysql_query($sql);
         if ($result) {
             while ($this->headermember = mysql_fetch_assoc($result)) {
                 $dynamicY = $this->newPage() + 2;
                 $sql = "SELECT A.*, B.firstname, B.lastname, B.registrationnumber\n\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}matchplayerdetails A \n\t\t\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}player B \n\t\t\t\t\t\t\t\tON B.id = A.playerid\n\t\t\t\t\t\t\t\tWHERE A.matchid = {$id} \n\t\t\t\t\t\t\t\tORDER BY B.firstname, B.lastname";
                 $itemresult = mysql_query($sql);
                 $index = 1;
                 if ($itemresult) {
                     while ($itemmember = mysql_fetch_assoc($itemresult)) {
                         $this->addText(15, $dynamicY, $index++, 10, 4, '');
                         $this->addText(25, $dynamicY, $itemmember['firstname'] . " " . $itemmember['lastname'], 10, 4, '');
                         $dynamicY = $this->addText(110, $dynamicY, $itemmember['registrationnumber'], 10, 4, '');
                     }
                 } else {
                     logError($qry . " - " . mysql_error());
                 }
                 $dynamicY = 153 + $this->margin;
                 $dynamicY = $this->addText(15, $dynamicY, "CLUB / MANAGERS REPORT (Including the FA Respect Codes of Conduct)", 10, 4, 'B') + 2;
                 if ($this->headermember['age'] < 12) {
                     $this->addText(15, $dynamicY, "Referee", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratereferee']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Opponent players", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['rateplayers']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Opponent Management", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratemanagement']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Opponent Spectators", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratespectators']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Pitch Size", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratepitchsize']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Pitch Condition", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratepitchcondition']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Goal Size", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['rategoalsize']), 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Changing Rooms", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratechangingrooms']), 10, 4, '') + 1;
                 } else {
                     $this->addText(15, $dynamicY, "Did the pitch have the required barriers, cones and markings", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->headermember['requiredbarriers'] == 1 ? "Yes" : "No", 10, 4, '') + 1;
                     $this->addText(15, $dynamicY, "Was the pitch size/condition, goals and changing rooms adequate", 10, 4, '');
                     $dynamicY = $this->addText(150, $dynamicY, $this->headermember['pitchsize'] == 1 ? "Yes" : "No", 10, 4, '') + 1;
                 }
                 $this->addText(15, $dynamicY, "Did your opponent players, management and spectators comply with the Codes", 10, 4, '');
                 $dynamicY = $this->addText(150, $dynamicY, $this->headermember['complycodes'] == 1 ? "Yes" : "No", 10, 4, '') + 1;
                 $this->addText(15, $dynamicY, "Did you check your opponent players ID cards", 10, 4, '');
                 $dynamicY = $this->addText(150, $dynamicY, $this->headermember['opponentids'] == 1 ? "Yes" : "No", 10, 4, '') + 1;
                 $this->Line(15, $dynamicY, 195, $dynamicY);
                 $dynamicY = $this->addText(15, $dynamicY + 2, "REFEREE SECTION", 10, 4, 'B') + 3;
                 $this->addText(15, $dynamicY, "Referee", 10, 4, 'B');
                 $this->addText(45, $dynamicY, $this->headermember['referee'], 10, 4, '');
                 if ($this->headermember['refereescore'] > 0) {
                     $this->addText(105, $dynamicY, "Appointed by League", 10, 4, 'B');
                     $dynamicY = $this->addText(145, $dynamicY, $this->headermember['refappointedbyleague'] == "Y" ? "Yes" : "No", 10, 4, '') + 3;
                     $this->addText(15, $dynamicY, "Marks out of 100", 10, 4, 'B');
                     $dynamicY = $this->addText(45, $dynamicY, $this->headermember['refereescore'], 10, 4, '') + 3;
                     $this->addText(15, $dynamicY, "Remarks", 10, 4, 'B');
                     $dynamicY = $this->addText(45, $dynamicY, $this->headermember['refereeremarks'], 10, 4, '', 150) + 2;
                 } else {
                     $dynamicY = $this->addText(145, $dynamicY, " ", 10, 4, '');
                 }
                 $this->Line(15, $dynamicY, 195, $dynamicY);
                 $dynamicY = $this->addText(15, $dynamicY + 3, "SIGNED", 10, 4, 'B') + 2;
                 $this->DynamicImage($this->headermember['imageid'], 15, $dynamicY);
             }
         } else {
             logError($sql . " - " . mysql_error());
         }
     } catch (Exception $e) {
         logError($e->getMessage());
     }
     $this->AliasNbPages();
 }

 function __construct($orientation, $metric, $size, $id)
 {
     $dynamicY = 0;
     start_db();
     parent::__construct($orientation, $metric, $size);
     try {
         $sql = "SELECT A.*, DATE_FORMAT(A.invoicedate, '%d/%m/%Y') AS invoicedate,\n\t\t\t\t\t\tD.name AS customername, D.accountnumber, D.invoiceaddress1, D.invoiceaddress2, D.invoiceaddress3, \n\t\t\t\t\t\tD.invoicecity, D.invoicepostcode, B.deliveryaddress1, B.deliveryaddress2, \n\t\t\t\t\t\tB.deliveryaddress3, B.deliverycity, B.deliverypostcode, D.firstname, B.lastname,\n\t\t\t\t\t\tE.fullname AS takenbyname\n\t\t\t\t\t    FROM  {$_SESSION['DB_PREFIX']}invoice A\n\t\t\t\t\t    INNER JOIN  {$_SESSION['DB_PREFIX']}customerclientsite B\n\t\t\t\t\t    ON B.id = A.siteid\n\t\t\t\t\t    INNER JOIN  {$_SESSION['DB_PREFIX']}customerclient C\n\t\t\t\t\t    ON C.id = B.clientid\n\t\t\t\t\t    INNER JOIN  {$_SESSION['DB_PREFIX']}customer D\n\t\t\t\t\t    ON D.id = C.customerid\n\t\t\t\t\t    LEFT OUTER JOIN  {$_SESSION['DB_PREFIX']}members E\n\t\t\t\t\t    ON E.member_id = A.takenbyid\n\t\t\t\t\t    WHERE A.id = {$id}\n\t\t\t\t\t    ORDER BY A.id DESC";
         $result = mysql_query($sql);
         if ($result) {
             while ($this->headermember = mysql_fetch_assoc($result)) {
                 $shipping = $this->headermember['deliverycharge'];
                 $discount = $this->headermember['discount'];
                 $total = 0;
                 $dynamicY = $this->newPage() + 7;
                 $sql = "SELECT A.*, B.productcode, B.description\n\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}invoiceitem A \n\t\t\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}product B \n\t\t\t\t\t\t\t\tON B.id = A.productid \n\t\t\t\t\t\t\t\tWHERE A.invoiceid = {$id} \n\t\t\t\t\t\t\t\tORDER BY A.sequence";
                 $itemresult = mysql_query($sql);
                 if ($itemresult) {
                     while ($itemmember = mysql_fetch_assoc($itemresult)) {
                         $line = array("Quantity" => $itemmember['quantity'], "Code" => $itemmember['productcode'], "Description" => $itemmember['description'], "Price Each" => number_format($itemmember['priceeach'], 2), "Line Total" => number_format($itemmember['priceeach'] * $itemmember['quantity'], 2));
                         $size = $this->addLine($dynamicY, $line);
                         $dynamicY += $size + 1;
                         if ($dynamicY > 225) {
                             $dynamicY = $this->newPage();
                             $dynamicY = 102;
                         }
                         $total = $total + $itemmember['priceeach'] * $itemmember['quantity'];
                         $totalvat += $itemmember['vat'];
                     }
                 } else {
                     logError($qry . " - " . mysql_error());
                 }
                 $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Goods Net:", "Line Total" => number_format($total, 2));
                 $size = $this->addLine(236, $line);
                 $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Delivery:", "Line Total" => number_format($shipping, 2));
                 $size = $this->addLine(242, $line);
                 $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Invoice Net:", "Line Total" => number_format($shipping + $total, 2));
                 $size = $this->addLine(248, $line);
                 $totalvat += $shipping * (getSiteConfigData()->vatrate / 100);
                 $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "VAT:", "Line Total" => number_format($totalvat, 2));
                 $size = $this->addLine(254, $line);
                 $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Total:", "Line Total" => number_format($totalvat + $shipping + $total - $discount, 2));
                 $size = $this->addLine(260, $line);
                 $this->addText(162, 265, "Pounds Sterling", 6, 3);
             }
         } else {
             logError($sql . " - " . mysql_error());
         }
     } catch (Exception $e) {
         logError($e->getMessage());
     }
     $this->AliasNbPages();
 }

function logout()
{
    start_db();
    if (isAuthenticated()) {
        $qry = "UPDATE {$_SESSION['DB_PREFIX']}loginaudit SET " . "timeoff = NOW(), metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE id = " . $_SESSION['SESS_LOGIN_AUDIT'] . "";
        $result = mysql_query($qry);
    }
    session_unset();
    $_SESSION['ROLES'][] = 'PUBLIC';
}

 public static function initialise()
 {
     //Start session
     start_db();
     $_SESSION['pagename'] = substr($_SERVER["PHP_SELF"], strripos($_SERVER["PHP_SELF"], "/") + 1);
     if ($_SESSION['pagename'] == "dynamicpage.php") {
         $_SESSION['pagename'] .= "?page=" . $_GET['page'];
     }
     BreadCrumbManager::initialise();
     self::initialiseDB();
     self::initialisePageData();
     BreadCrumbManager::calculate();
 }

 function __construct($orientation, $metric, $size, $id)
 {
     global $member;
     global $top;
     parent::__construct($orientation, $metric, $size);
     $this->SetAutoPageBreak(true, 0);
     //Include database connection details
     start_db();
     $margin = 7;
     $sql = "SELECT A.*, " . "DATE_FORMAT(A.creditdate, '%d/%m/%Y') AS creditdate, " . "DATE_FORMAT(A.paymentdate, '%d/%m/%Y') AS paymentdate, " . "DATE_FORMAT(A.createddate, '%d/%m/%Y') AS createddate, " . "DATE_FORMAT(B.datedelivered, '%d/%m/%Y') AS datedelivered, " . "A.deladdress, A.toaddress, B.plaintiff, B.casenumber, B.transcripttype, B.j33number, B.depositamount, " . "D.name AS courtname, D.vatapplicable, D.address, D.fax AS courtfax, D.cellphone AS courtmobile, " . "D.email AS courtemail, D.telephone AS courttelephone, D.contact AS courtcontact, " . "E.name AS provincename, F.name AS terms, G.firstname, G.lastname, G.mobile, G.landline, G.email, G.fax, " . "I.name AS clientcourtname, " . "O.privatebankingdetails, O.bankingdetails, " . "O.address AS officeaddress, O.email AS officeemail, O.telephone, O.contact, O.fax AS officefax, O.name AS officename  " . "FROM {$_SESSION['DB_PREFIX']}invoices A " . "INNER JOIN {$_SESSION['DB_PREFIX']}cases B " . "ON B.id = A.caseid " . "INNER JOIN {$_SESSION['DB_PREFIX']}courts D " . "ON D.id = B.courtid " . "INNER JOIN {$_SESSION['DB_PREFIX']}province E " . "ON E.id = D.provinceid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}caseterms F " . "ON F.id = A.termsid " . "INNER JOIN {$_SESSION['DB_PREFIX']}members G " . "ON G.member_id = A.contactid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}courts I " . "ON I.id = B.clientcourtid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}offices J " . "ON J.id = A.officeid " . "INNER JOIN {$_SESSION['DB_PREFIX']}offices O " . "ON O.id = A.officeid " . "WHERE A.caseid = {$id} " . "ORDER BY B.id";
     $result = mysql_query($sql);
     if ($result) {
         $total = 0;
         $subtotal = 0;
         $shipping = 0;
         $totalvat = 0;
         $depositamount = 0;
         $vatapplicable = "N";
         while ($member = mysql_fetch_assoc($result)) {
             $this->newPage();
             $first = false;
             $y = $top;
             $vatapplicable = $member['vatapplicable'];
             $invoiceid = $member['id'];
             //					$description = $this->stripHTML($member['description']);
             $description = $member['description'];
             if ($member['depositamount'] != null) {
                 $depositamount = $member['depositamount'];
             }
             $sql = "SELECT C.id, C.description, C.qty, C.vat, C.vatrate, C.total, C.unitprice, " . "H.name AS templatename " . "FROM {$_SESSION['DB_PREFIX']}invoiceitems C " . "INNER JOIN {$_SESSION['DB_PREFIX']}invoiceitemtemplates H " . "ON H.id = C.templateid " . "WHERE C.invoiceid = {$invoiceid} " . "ORDER BY C.id";
             $itemresult = mysql_query($sql);
             if ($itemresult) {
                 while ($itemmember = mysql_fetch_assoc($itemresult)) {
                     $line = array("Quantity" => number_format($itemmember['qty'], 0), "Description" => $itemmember['templatename'], "Unit Price" => "R " . number_format($itemmember['unitprice'], 2), "Total" => "R " . number_format($itemmember['total'], 2));
                     $size = $this->addLine($y, $line);
                     $y += $size;
                     if ($y > 235) {
                         $this->newPage();
                         $y = $top;
                     }
                     $subtotal += $itemmember['total'] - $member['vat'];
                     $shipping = $itemmember['shippinghandling'];
                     $totalvat += $itemmember['vat'];
                     $total += $itemmember['total'];
                 }
                 $y += 4;
                 if ($y > 175) {
                     $this->newPage();
                     $y = $top;
                 }
                 $line = array("Quantity" => " ", "Description" => $description, "Unit Price" => " ", "Total" => " ");
                 $size = $this->addLine($y, $line);
                 $y += $size;
                 if ($y > 235) {
                     $this->newPage();
                     $y = $top;
                 }
             } else {
                 logError($sql . " - " . mysql_error());
             }
         }
     } else {
         logError($sql . " - " . mysql_error());
     }
     if ($vatapplicable == "Y") {
         $this->Line(121, 240, 200, 240);
         $this->Line(121, 245, 200, 245);
         $this->Line(121, 250, 200, 250);
     }
     $this->Line(121, 255, 200, 255);
     if ($vatapplicable == "Y") {
         $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "VAT (" . number_format(getSiteConfigData()->vatrate, 0) . "%)", "Total" => "R " . number_format($totalvat, 2));
         $size = $this->addLine(242, $line);
         $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL", "Total" => "R " . number_format($total, 2));
         $size = $this->addLine(247, $line);
         $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "DEPOSIT", "Total" => "R " . number_format($depositamount, 2));
         $size = $this->addLine(252, $line);
         $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL DUE", "Total" => "R " . number_format($total - $depositamount, 2));
         $size = $this->addLine(258, $line, 0, 'B');
     } else {
         $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL", "Total" => "R " . number_format($total, 2));
         $size = $this->addLine(258, $line, 0, 'B');
     }
 }