PHP adodb_connect函数代码示例

function limit_view_all_bids(&$selectionSQL, &$sort, &$showing, $max_view_per_page = MAX_PAPER, $err_message = "")
{
    //Establish connection with database
    $db = adodb_connect(&$err_message);
    //Check the sorting by Title
    switch ($sort) {
        case 3:
            $selectionSQL .= " ORDER BY Title ASC";
            break;
        case 4:
            $selectionSQL .= " ORDER BY Title DESC";
            break;
        case 5:
            $selectionSQL .= " ORDER BY PaperID ASC";
            break;
        case 6:
            $selectionSQL .= " ORDER BY PaperID DESC";
            break;
        default:
            $selectionSQL .= " ORDER BY PaperID";
            break;
    }
    //Limit the records to the maximun papers per page
    $selectionSQL .= " LIMIT " . $showing . "," . MAX_PAPER;
    $selectionResult = $db->Execute($selectionSQL);
    if (!$selectionResult) {
        $err_message .= " Unable to query database. <br>\n";
        return NULL;
    }
    return $selectionResult;
}

function get_chair_usernames()
{
    //Establish connection with database
    $db = adodb_connect();
    if (!$db) {
        echo "Could not connect to database server - please try later.";
        exit;
    }
    $sql = "SELECT * FROM " . $GLOBALS["DB_PREFIX"] . "Member AS M, ";
    $sql .= $GLOBALS["DB_PREFIX"] . "Registration as R ";
    $sql .= "WHERE M.RegisterID = R.RegisterID ";
    //$sql .= "WHERE PrivilegeTypeID > 1 ";
    $sql .= "ORDER BY M.PrivilegeTypeID DESC, R.LastName ASC";
    $result = $db->Execute($sql);
    $users = array();
    while ($user = $result->FetchNextObj()) {
        $users[] = $user;
    }
    return $users;
}

$php_root_path = "..";
$privilege_root_path = "/admin";
require_once "includes/include_all_fns.inc";
session_start();
global $valid_user;
extract($_GET, EXTR_REFS);
$err_message = " Unable to process your request due to the following problems: <br>\n";
if (!check_valid_user(&$err_message)) {
    //This user is not login
    do_html_header("View File Failed", &$err_message);
    $err_message .= " Sorry, You must login to view this file. <br>\n";
    $err_message .= "<br><br> Go to <a href='{$php_root_path}/index.php'>Login</a> page.";
    do_html_footer(&$err_message);
    exit;
}
$db = adodb_connect(&$err_message);
if (!$db) {
    do_html_header("View File Failed", &$err_message);
    $err_message .= " Could not connect to database server - please try later.<br>\n";
    $err_message .= "<br><br> Try <a href='view_file.php?fileid=" . $_GET["fileid"] . "'>again</a>?";
    do_html_footer(&$err_message);
    exit;
}
$sql = "SELECT File,FileName,FileSize,FileType FROM " . $GLOBALS["DB_PREFIX"] . "File F , " . $GLOBALS["DB_PREFIX"] . "Paper P";
$sql .= " WHERE F.FileID=" . $_GET["fileid"] . " AND F.PaperID=P.PaperID";
$result = $db->Execute($sql);
$rows = $result->RecordCount();
if (!$result) {
    do_html_header("View File Failed", &$err_message);
    $err_message .= " Could not connect to File database.<br>\n";
    $err_message .= "<br><br> Try <a href='view_file.php?fileid=" . $_GET["fileid"] . "'>again</a>?";

<?php

$php_root_path = "..";
$privilege_root_path = "/admin";
require_once "includes/include_all_fns.inc";
session_start();
if (!($db = adodb_connect())) {
    do_html_header("Create Attendee Registration Form &#151; Error");
    do_html_footer("Error connecting to database.");
    exit;
}
require_once "includes/rego_form_functions.php";
// page used for creating form as well as displaying help
if ($_GET['help'] == "viscond") {
    // display help
    do_html_header("Help: Visibility Conditions");
    ?>
	<p>An advanced feature of the registration form is the ability to set <em>Visibility
		Conditions</em>. They allow you to specify that a particular group or field
		will only be displayed or enabled after another condition has been satisfied.</p>
	<p>Each group or field has two visibility properties &#0150; <em>visible</em> and <em>enabled</em> 
		&#0150; each with two options &#0150; <em>true</em> or <em>false</em>. There
		is only one event &#0150; <em>when</em> &#0150; which is triggered when the
		specified field changes (either the text changes or a different option is
		selected).</p>
	<p>Groups and fields are specified using the numbers that appear beside the
		fields in blue. For example, [3:5] represents group 3, field 5. If the
		field is a checkbox group, radio group, drop-down menu or selectable
		list, you can reference the field's options numerically by counting the
		number of options starting at 1. However, if the first option of a drop-down
		menu is <em>--- (select) ---</em>, this does not count as an option and the

<?php

$php_root_path = "..";
$privilege_root_path = "/admin";
require_once "includes/include_all_fns.inc";
session_start();
// extract ( $_SESSION , EXTR_REFS ) ;
$err_message = " Unable to process your request due to the following problems: <br>\n";
do_html_header("View All Users");
//Establish connection with database
$db = adodb_connect();
if (!$db) {
    echo "Could not connect to database server - please try later.";
    exit;
}
$memberSQL = "SELECT * FROM " . $GLOBALS["DB_PREFIX"] . "Member M," . $GLOBALS["DB_PREFIX"] . "PrivilegeType P," . $GLOBALS["DB_PREFIX"] . "Registration R";
$memberSQL .= " WHERE M.RegisterID <> 0";
$memberSQL .= "\tAND M.PrivilegeTypeID = P.PrivilegeTypeID";
$memberSQL .= "\tAND M.RegisterID = R.RegisterID";
$memberSQL .= "\tAND P.PrivilegeTypeName = 'Reviewer'";
//Check the sorting by Title
switch ($HTTP_GET_VARS["sort"]) {
    case 1:
        $memberSQL .= " ORDER BY M.MemberName ASC";
        $sortStr = "UserName - Ascending";
        break;
    case 2:
        $memberSQL .= " ORDER BY M.MemberName DESC";
        $sortStr = "UserName - Descending";
        break;
    case 3:

function validatePDF_callback($file_data, $valid, $magic, $fileID)
{
    $file_size = strlen($file_data);
    global $DEBUG;
    if ($DEBUG) {
        informAdmin("DEBUG validatePDF_callback.php: called validatePDF_callback( <binary>, {$valid}, {$magic}, {$fileID} )");
    }
    // sanitize all parameters
    $fileID = intval($fileID);
    $magic = intval($magic);
    if ($valid) {
        $valid = 1;
    } else {
        $valid = 0;
    }
    // put result into database
    $err_message = "validatePDF_callback(): ";
    $db = adodb_connect();
    // FIXME: fix declaration of adodb_connect() to include the reference (&) symbol!
    if ($db) {
        $file_data = $db->qstr($file_data);
        // escape binary
        $sql = "UPDATE " . $GLOBALS["DB_PREFIX"] . "File_report SET File={$file_data}, FileSize={$file_size}, DateTime=NOW(), Valid={$valid} WHERE FileID = {$fileID} AND Magic = {$magic}";
        if (!$db->Execute($sql)) {
            informAdmin("{$err_message} executing SQL query:\n" . $db->MetaErrorMsg($db->MetaError()));
        }
    } else {
        informAdmin("{$err_message} \$db is invalid\n" . $db->MetaErrorMsg($db->MetaError()));
    }
}

 /**
  * Get a handle to the ADODB database object. You can then use this
  * to perform all kinds of database operations.
  *
  * @link http://phplens.com/lens/adodb/docs-adodb.htm
  * @final
  * @return ADOConnection a handle to the ADODB database object
  */
 function &GetDb()
 {
     global $DONT_LOAD_DB;
     /* Check to see if we have a valid instance.
      * If not, build the connection */
     if (!isset($this->db) && !isset($DONT_LOAD_DB)) {
         $this->db =& adodb_connect();
     }
     $db =& $this->db;
     return $db;
 }

 /**
  * Get a handle to the ADODB database object. You can then use this
  * to perform all kinds of database operations.
  *
  * @link http://phplens.com/lens/adodb/docs-adodb.htm
  * @final
  * @return ADOConnection a handle to the ADODB database object
  */
 public function &GetDb()
 {
     global $DONT_LOAD_DB;
     /* Check to see if we have a valid instance.
      * If not, build the connection */
     if (!isset($this->db) && (!isset($DONT_LOAD_DB) || $DONT_LOAD_DB == 'force')) {
         $this->db = adodb_connect();
     }
     return $this->db;
 }

function redisplay(&$paperid_array, &$process, &$dbprefix, $err_message = "")
{
    //Establish connection with database
    $db = adodb_connect(&$err_message);
    //global $_SESSION ;
    $i = 0;
    $array = array();
    reset($paperid_array);
    foreach ($paperid_array as $some => $paperID) {
        //Get the paper information
        if (($paperInfo = get_paper_info($paperID, &$err_message)) === false) {
            do_html_header("Update Paper Bids Failed", &$err_message);
            $err_message .= " Cannot retrieve information from database. <br>\n";
            $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
            do_html_footer(&$err_message);
            exit;
        }
        $array[$i]["paperid"] = $paperInfo->PaperID;
        $array[$i]["papertitle"] = stripslashes($paperInfo->Title);
        //Get the lastest file of the paper
        if (($FileIDData = get_latestFile($paperID, &$err_message)) === false) {
            do_html_header("Update Paper Bids Failed", &$err_message);
            $err_message .= " Could not execute \"get_latestFile\" in \"update_biddings.php\". <br>\n";
            $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
            do_html_footer(&$err_message);
            exit;
        }
        $array[$i]["fileid"] = $FileIDData->FileID;
        if ($catcomsep = getSelectedCategoryCommaSeparated($paperInfo->PaperID, &$err_message) || numCategories(&$err_message) == 0) {
            $array[$i]["cat"] = $catcomsep;
        } else {
            do_html_header("Update Paper Bids Failed", &$err_message);
            $err_message .= " Could not execute \"getSelectedCategoryCommaSeparated\" in \"update_biddings.php\". <br>\n";
            $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
            do_html_footer(&$err_message);
            exit;
        }
        if ($authors = retrieve_authors($paperInfo->PaperID, &$err_message)) {
            $array[$i]["author"] = $authors;
        } else {
            do_html_header("Update Paper Bids Failed", &$err_message);
            $err_message .= " Could not execute \"retrieve_authors\" in \"update_biddings.php\". <br>\n";
            $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
            do_html_footer(&$err_message);
            exit;
        }
        if ($process === "update") {
            $preferenceSQL = " SELECT PreferenceID FROM " . $GLOBALS["DB_PREFIX"] . "Selection ";
            $preferenceSQL .= " WHERE PaperID = " . $paperInfo->PaperID;
            $preferenceSQL .= " AND Membername = '" . $_SESSION["valid_user"] . "'";
            $preferenceResult = $db->Execute($preferenceSQL);
            if (!$preferenceResult) {
                do_html_header("Update Paper Bids Failed", &$err_message);
                $err_message .= " Could not query \"Selection\" table in database by \"redisplay()\" of \"update_biddings.php\". <br>\n";
                $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
                do_html_footer(&$err_message);
                exit;
            }
            $userPreference = $preferenceResult->FetchNextObj();
            $array[$i]["bidid"] = $userPreference->PreferenceID;
        }
        if ($bidtable = Generate_Preference_Radio_Input_Table($paperInfo->PaperID, $array[$i]["bidid"], &$err_message)) {
            $array[$i]["bid"] = $bidtable;
        } else {
            do_html_header("Update Paper Bids Failed", &$err_message);
            $err_message .= " Could not execute \"retrieve_authors\" in \"update_biddings.php\". <br>\n";
            $err_message .= "<br><br> Try <a href='" . $_SERVER["PHP_SELF"] . "?" . $_SERVER["QUERY_STRING"] . "'>again</a>?";
            do_html_footer(&$err_message);
            exit;
        }
        $i++;
    }
    //End of for loop
    return $array;
}

function GetSelectedLevelList(&$paperID, $err_message = "")
{
    //Establish connection with database
    $db = adodb_connect(&$err_message);
    $sql = "SELECT LevelID FROM " . $GLOBALS["DB_PREFIX"] . "PaperLevel ";
    $sql .= " WHERE PaperID = {$paperID} ";
    $result = $db->Execute($sql);
    $levelList = array();
    if (!$result) {
        $err_message .= " Could not get records from the PaperLevel Table <br>\n ";
        // Exception has occurred
        return false;
    } else {
        while ($record = $result->FetchNextObj()) {
            $levelList[] = $record->LevelID;
        }
    }
    return $levelList;
}