PHP database::error方法代码示例

function create_usage_graph($from_date, $end_date)
{
    //create an instance of class database here
    $con = new database();
    //set up query string
    $query_members = "SELECT * FROM people_online WHERE people_online.member = 'y' \r\n\t\t\t\t\t  AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'";
    $query_visitors = "SELECT * FROM people_online WHERE people_online.member = 'n' \r\n\t\t\t\t\t  AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'";
    $rs_members = $con->query($query_members) or die($con->error());
    $rs_visitors = $con->query($query_visitors) or die($con->error());
    // COMMENT : must use OOP style ( use the $con object uve created  ) not a procedural one...-mh
    $data_member = mysql_fetch_assoc($rs_members);
    // this is wrong...
    $data_visitors = mysql_fetch_assoc($rs_visitors);
    $data_member = $con->getnumrows($rs_members);
    $data_visitors = $con->getnumrows($rs_visitors);
    $data = $data_member + $data_visitors;
    if ($data == 0) {
        echo '<script>alert("Sorry, no usage results found.");window.close();</script>';
        exit;
    }
    //echo 'm='.$data_member;
    //echo 'v='.$data_visitors;
    $arr_label = array("Members", "Visitors");
    //$arr_data = array($data_member['MEMBERS'], $data_visitors['VISITORS']);
    $arr_data = array($data_member, $data_visitors);
    //start displaying the graph
    $from_date = explode('-', $from_date);
    $from_date = strdate($from_date[1], '', '') . ' ' . $from_date[2] . ',' . $from_date[0];
    $end_date = explode('-', $end_date);
    $end_date = strdate($end_date[1], '', '') . ' ' . $end_date[2] . ',' . $end_date[0];
    $graph = new graph_creator(320, 600, "People Online As of {$from_date} to {$end_date}", $arr_label, $arr_data, $center_value = 0.45);
    $graph->create_pie_graph();
}

 /**
  * Layout Page Logic
  * @return 
  * @param $db Object
  */
 function __construct(database $db, user $user)
 {
     $this->db =& $db;
     $this->user =& $user;
     $this->sub_page = Kit::GetParam('sp', _GET, _WORD, 'view');
     $this->layoutid = Kit::GetParam('layoutid', _REQUEST, _INT);
     // If we have modify selected then we need to get some info
     if ($this->layoutid != '') {
         // get the permissions
         Debug::LogEntry('audit', 'Loading permissions for layoutid ' . $this->layoutid);
         $this->auth = $user->LayoutAuth($this->layoutid, true);
         if (!$this->auth->edit) {
             trigger_error(__("You do not have permissions to edit this layout"), E_USER_ERROR);
         }
         $this->sub_page = "edit";
         $sql = " SELECT layout, description, userid, retired, xml FROM layout ";
         $sql .= sprintf(" WHERE layoutID = %d ", $this->layoutid);
         if (!($results = $db->query($sql))) {
             trigger_error($db->error());
             trigger_error(__("Cannot retrieve the Information relating to this layout. The layout may be corrupt."), E_USER_ERROR);
         }
         if ($db->num_rows($results) == 0) {
             $this->has_permissions = false;
         }
         while ($aRow = $db->get_row($results)) {
             $this->layout = Kit::ValidateParam($aRow[0], _STRING);
             $this->description = Kit::ValidateParam($aRow[1], _STRING);
             $this->retired = Kit::ValidateParam($aRow[3], _INT);
             $this->xml = $aRow[4];
         }
     }
 }

    function __construct(database $db, user $user)
    {
        $this->db =& $db;
        $this->user =& $user;
        $usertype = Kit::GetParam('usertype', _SESSION, _INT, 0);
        $this->groupid = Kit::GetParam('groupid', _REQUEST, _INT, 0);
        // Do we have a user group selected?
        if ($this->groupid != 0) {
            // If so then we will need to get some information about it
            $SQL = <<<END
\t\t\tSELECT \tgroup.GroupID,
\t\t\t\t\tgroup.Group
\t\t\tFROM `group`
\t\t\tWHERE groupID = %d
END;
            $SQL = sprintf($SQL, $this->groupid);
            if (!($results = $db->query($SQL))) {
                trigger_error($db->error());
                trigger_error(__("Can not get Group information."), E_USER_ERROR);
            }
            $aRow = $db->get_assoc_row($results);
            $this->group = $aRow['Group'];
        }
        // Include the group data classes
        include_once 'lib/data/usergroup.data.class.php';
    }

function save_segment($segmentTitle, $segmentTopic, $segmentAnchor, $segmentSchedule, $segmentContent, $segmentDate)
{
    #$segmentTitle		the title of the segment
    #$segmentTopic		the topic being tockled on the segment
    #$segmentAnchor 		the anchorman of the segment
    #$segmentSchedule 	the schedule of the segment on air
    #$segmentContent 	the content of the segment
    #$segmentDate 		the date when the segment was written
    $query = "INSERT INTO news_segments VALUES('', '{$segmentTitle}', '{$segmentTopic}', '{$segmentContent}', '{$segmentAnchor}', '{$segmentSchedule}', '{$segmentDate}')";
    $db = new database();
    if (!$db->query($query)) {
        echo $db->error();
        exit;
    }
}

<?php

include 'coreclass.php';
$response = $_POST['response'];
//the user response
$topic_id = $_POST['topic_id'];
//the topic
$response_date = date('Y-m-d');
//the date when the user responded
//these codes are for debugging purpose only
echo '<br>Date Today: ' . $response_date;
echo '<br>Topic ID: ' . $topic_id;
echo '<br>User Response: ' . $response;
//define query string here
$query = "INSERT INTO poll_data VALUES('', '{$topic_id}', '{$response}', '{$response_date}')";
//instantiate new object of class database
$con = new database();
if (!$con->query($query)) {
    echo $con->error();
} else {
    //this line is just temporary
    echo '<br><a href="display_poll.php">Back To Main</a>';
}

/**
 * Get current active quota
 */
function getActiveQuota()
{
    $sql = "select * from quota where isdefault=1 ";
    $db = new database();
    if (!($result = $db->query($sql))) {
        die('Error:' . $db->error());
    }
    $quota = array();
    if ($quota[] = $db->fetcharray()) {
    }
    return $quota[0]->quota;
}

 } else {
     $emailAlerts = FALSE;
 }
 if ($alwaysAlert == "On") {
     $alwaysAlert = TRUE;
 } else {
     $alwaysAlert = FALSE;
 }
 // The time in the past that the last connection must be later than globally.
 $globalTimeout = time() - 60 * Kit::ValidateParam(Config::GetSetting("MAINTENANCE_ALERT_TOUT"), _INT);
 $msgTo = Kit::ValidateParam(Config::GetSetting("mail_to"), _PASSWORD);
 $msgFrom = Kit::ValidateParam(Config::GetSetting("mail_from"), _PASSWORD);
 // Get a list of all licensed displays
 $SQL = "SELECT `displayid`, `lastaccessed`, `email_alert`, `alert_timeout`, `display`, `loggedin` FROM `display` WHERE licensed = 1";
 if (!($result = $db->query($SQL))) {
     trigger_error($db->error());
     trigger_error(__('Unable to access displays'), E_USER_ERROR);
 }
 // Loop over the licensed displays
 while ($row = $db->get_row($result)) {
     $displayid = Kit::ValidateParam($row[0], _INT);
     $lastAccessed = Kit::ValidateParam($row[1], _INT);
     $email_alert = Kit::ValidateParam($row[2], _INT);
     $alert_timeout = Kit::ValidateParam($row[3], _INT);
     $display_name = Kit::ValidateParam($row[4], _STRING);
     $loggedin = Kit::ValidateParam($row[5], _INT);
     $final_timeout = $globalTimeout;
     $last_seen = date("Y-m-d H:i:s", $lastAccessed);
     if ($alert_timeout != 0) {
         $final_timeout = time() - 60 * $alert_timeout;
     }

}
if (!file_exists("settings.php")) {
    // Xibo has not been configured. Just quit since we can't
    // raise a SOAP error because we don't know where
    // nuSOAP is yet.
    die("Not configured. Visit " . Kit::GetURL() . " to configure.");
}
if (file_exists("upgrade.php")) {
    // An upgrade is in progress. Just quit since the server
    // won't be in a servicable state
    die("An upgrade is pending. Visit " . Kit::GetURL() . ".");
}
//parse and init the settings.xml
Config::Load();
//create a DB
$db = new database();
if (!$db->connect_db($dbhost, $dbuser, $dbpass)) {
    trigger_error($db->error(), E_USER_ERROR);
}
if (!$db->select_db($dbname)) {
    trigger_error($db->error(), E_USER_ERROR);
}
// Error Handling (our error handler requires a DB connection
set_error_handler(array(new Debug(), "ErrorHandler"));
date_default_timezone_set(Config::GetSetting('defaultTimezone'));
// Work out the location of this service
$serviceLocation = Kit::GetXiboRoot();
// OAuth
require_once 'lib/oauth.inc.php';
// Setup the translations for gettext
TranslationEngine::InitLocale();

//
// Check to see if we've passed that point, and if so look at what was posted
// to include those classes.
if (Kit::GetParam("includes", _POST, _BOOL)) {
    for ($i = $_POST['upgradeFrom'] + 1; $i <= $_POST['upgradeTo']; $i++) {
        if (file_exists('install/database/' . $i . '.php')) {
            include_once 'install/database/' . $i . '.php';
        }
    }
}
session_start();
Config::Load();
// create a database class instance
$db = new database();
if (!$db->connect_db($dbhost, $dbuser, $dbpass)) {
    reportError(0, __("Unable to connect to the MySQL database using the settings stored in settings.php.") . "<br /><br />" . __("MySQL Error:") . "<br />" . $db->error());
}
if (!$db->select_db($dbname)) {
    reportError(0, __("Unable to select the MySQL database using the settings stored in settings.php.") . "<br /><br />" . __("MySQL Error:") . "<br />" . $db->error());
}
// Initialise the Translations
set_error_handler(array(new Debug(), "ErrorHandler"));
TranslationEngine::InitLocale($db);
include 'install/header_upgrade.inc';
if (!isset($_SESSION['step'])) {
    $_SESSION['step'] = 0;
}
if (Kit::GetParam('skipstep', _POST, _INT) == 1) {
    // Cheat the $_SESSION['step'] variable if required
    // Used if there are environment warnings and we want to retest.
    $_SESSION['step'] = 1;

    function __construct(database $db, user $user)
    {
        $this->db =& $db;
        $this->user =& $user;
        include_once 'lib/data/display.data.class.php';
        $this->sub_page = Kit::GetParam('sp', _GET, _WORD, 'view');
        $this->ajax = Kit::GetParam('ajax', _REQUEST, _WORD, 'false');
        $displayid = Kit::GetParam('displayid', _REQUEST, _INT, 0);
        // validate displays so we get a realistic view of the table
        $this->validateDisplays();
        if (isset($_GET['modify']) || $displayid != 0) {
            $this->sub_page = 'edit';
            if (!$this->has_permissions && $this->ajax == 'true') {
                trigger_error(__("You do not have permissions to edit this display"), E_USER_ERROR);
            }
            $SQL = <<<SQL
                SELECT display.displayid,
                    display.display,
                    display.defaultlayoutid,
                    display.license,
                    display.licensed,
                    display.inc_schedule,
                    display.isAuditing,
                    display.email_alert,
                    display.alert_timeout,
                    display.MediaInventoryStatus,
                    display.MediaInventoryXml,
                    display.MacAddress,
                    display.WakeOnLan,
                    display.WakeOnLanTime,
                    display.BroadCastAddress,
                    display.SecureOn,
                    display.Cidr,
                    display.ClientAddress,
                    X(display.GeoLocation) AS Latitude,
                    Y(display.GeoLocation) AS Longitude
             FROM display
            WHERE display.displayid = %d
SQL;
            $SQL = sprintf($SQL, $displayid);
            Debug::LogEntry('audit', $SQL);
            if (!($results = $db->query($SQL))) {
                trigger_error($db->error());
                trigger_error(__("Can not get the display information for display") . '[$this->displayid]', E_USER_ERROR);
            }
            while ($row = $db->get_row($results)) {
                $this->displayid = Kit::ValidateParam($row[0], _INT);
                $this->display = Kit::ValidateParam($row[1], _STRING);
                $this->layoutid = Kit::ValidateParam($row[2], _INT);
                $this->license = Kit::ValidateParam($row[3], _STRING);
                $this->licensed = Kit::ValidateParam($row[4], _INT);
                $this->inc_schedule = Kit::ValidateParam($row[5], _INT);
                $this->auditing = Kit::ValidateParam($row[6], _INT);
                $this->email_alert = Kit::ValidateParam($row[7], _INT);
                $this->alert_timeout = Kit::ValidateParam($row[8], _INT);
                $this->mediaInventoryStatus = Kit::ValidateParam($row[9], _INT);
                $this->mediaInventoryXml = Kit::ValidateParam($row[10], _HTMLSTRING);
                $this->macAddress = Kit::ValidateParam($row[11], _STRING);
                $this->wakeOnLan = Kit::ValidateParam($row[12], _INT);
                $this->wakeOnLanTime = Kit::ValidateParam($row[13], _STRING);
                $this->broadCastAddress = Kit::ValidateParam($row[14], _STRING);
                $this->secureOn = Kit::ValidateParam($row[15], _STRING);
                $this->cidr = Kit::ValidateParam($row[16], _INT);
                $this->clientIpAddress = Kit::ValidateParam($row[17], _STRING);
                $this->latitude = Kit::ValidateParam($row[18], _DOUBLE);
                $this->longitude = Kit::ValidateParam($row[19], _DOUBLE);
                // Make cidr null if its a 0
                $this->cidr = $this->cidr == 0 ? '' : $this->cidr;
            }
        }
        return true;
    }

$dateline = $_POST['dateline'];
$article_title = $_POST['title'];
$article_body = $_POST['editor_content'];
//print_r ($_POST);
$userID = $_SESSION['userID'];
//$created = date("F d, Y h:i:s A");
$created = time();
$query = " insert into articles ( stageID, created, dateline, title, article_body) ";
$query .= " values( '{$stageID}', {$created}, '{$dateline}', '{$article_title}', '{$article_body}' )";
print $query;
$db = new database();
$result = $db->query($query);
if ($result) {
    // ok ..
} else {
    print $db->error();
}
//	cge nash, a2 kuhaon ang id sa bag-o nga na-insert nga record ha..
//	TODO: must use the accessor methods here, but not
//	directly accessing the variable..ex. $db->getInsertID()
$insertID = $db->insertID;
if ($insertID) {
    // now lets insert the article with corresponding author
    $query = " insert into article_author ( articleID , userID ) ";
    $query .= " values( '{$insertID}' , '{$userID}') ";
    $result = $db->query($query);
    $query = " insert into article_category ( articleID , categoryID ) ";
    $query .= " values( '{$insertID}' , '{$categoryID}' ) ";
    $result = $db->query($query);
}
if ($result) {

#the actual content.
$con = new database();
#echo "<br>Name: ".$source_name;
#echo "<br>Email: ".$emailAddress;
#echo "<br>Contact: ".$contactNumber;
#echo "<br>Report: ".$report;
#echo "<br>Date: ".$reportDate;
if ($name = "" || ($report = "")) {
    #this the name field or the report field is empty, prompt the
    #user and redirect back to the form...
    header('Location: ' . $_SERVER['HTTP_REFERRER']);
} else {
    #define the query
    $query = "INSERT INTO external_source VALUES('', '{$source_name}', '{$emailAddress}', '{$contactNumber}', '{$reportDate}', '{$report}')";
    if (!$con->query($query)) {
        $con->error();
    }
    $_SESSION['message'] = "Thank you for the information you have given to us. <br>";
    #header('Location: external_source_form_f.php');
}
#################################################################################################################################
/*
 * Get the default stylesheets
 */
include 'admin/template.configuration.php';
$stylesheet = ' themes/' . $default_template_name . '/' . $default_template_stylesheet;
// Generate the page now
$tpl = new template_parser('themes/templates/submit_external_source_tpl.php');
$tags = array('{DATELINE}' => niceDate($headline[0]->dateline), '{ARTICLEID}' => $headline[0]->articleID, '{HEADLINE}' => $headline[0]->title, '{AUTHOR}' => 'By ' . getArticle_authors_info($headline[0]->articleID, 'fullname') . ' / BR</p>', '{ARTICLE_BODY}' => makeAShortIntro(strip_tags($headline[0]->article_body)), '{PHOTO}' => $photo, '{VIEW_ARTICLE_URL}' => $my_profile[0]->homeaddress, '{OTHER_HEADLINES}' => $other_headlines, '{OTHER_TOPSTORIES}' => $other_topstories, '{QUOTE_OF_THE_DAY}' => $quote, '{SUBSECTIONS}' => $subsections, '{MESSAGE}' => $message, '{PAGE_GENERATED}' => '&nbsp;' . $pagegenerated, '{SPONSORED_LINKS}' => $sponsoredlinks, '{SUBSECTIONS}' => $subsections, '{CATEGORY}' => $categorylist, '{FOOTER}' => 'themes/templates/footer.tpl.php', '{STYLESHEET}' => $stylesheet);
$tpl->parse_template($tags);
print $tpl->display();

<?php

require_once "debugger.php";
require_once "database.php";
$db = new database();
$con = $db->connect("localhost", "root", "revive", "mysql");
mysqli_set_charset($con, "utf8");
$result = $db->query("SELECT * FROM user");
if ($result) {
    while ($row = mysqli_fetch_array($result)) {
        echo $row['Host'] . " - " . $row['User'] . "\n";
    }
} else {
    echo $db->error();
}
$con2 = $db->getConnection();
print_r($con2);

/**
 * This function will send a query to the table user_stage then, retrieve the
 * stages that the user has been assign..
 * return the recordset in array()  
 */
function query_data($userID)
{
    // get this user stages of this user...
    $sql = "select * from user_stage us\r\n\t\twhere us.userID = " . intval($userID) . " order by us.stageID ASC ";
    // sort the STAGES accordingly..
    $db = new database();
    if (!($result = $db->query($sql))) {
        die('Error:' . $db->error());
    }
    $user_stages = array();
    while ($row = $db->fetcharray()) {
        $user_stages[] = $row;
    }
    $db->freeresult();
    // simply free the result..
    print 'USERNAME=' . $_SESSION['username'];
    // ok pepol,, lets chek his user stages..
    $sql = " select * from ";
    // if the user has been assign with SOME workflows...
    $state = 0;
    foreach ($user_stages as $field => $user_stage) {
        if ($user_stage->stageID) {
            switch ($user_stage->stageID) {
                case 1:
                    // if the user is on writing stage, retrieve his articles
                    $sql .= " articles a ,";
                    $sql .= " article_author aa ";
                    $state = 1;
                    // we assume that there was another stages been assign..
                    break;
                case 2:
                    // the user is assign on editing stage..
                    $editing_stage = 1;
                    break;
                case 3:
                    // ..proofreading stage..
                    $proofreading_stage = 1;
                    break;
                case 4:
                    // ..publishinng stage..
                    $publishing_stage = 1;
                    break;
            }
        }
    }
    // if this user has been assign with these stages..editing, proofreading ..etc...
    if ($editing_stage == 1 || $proofreading_stage == 1 || $publishing_stage == 1) {
        if (count($user_stages) > 1) {
            // this user is assign with SOME WORKFLOWS..
            if ($state) {
                //
                $sql .= " ,article_versions av ";
            } else {
                // simply, first call of the article versions..
                $sql .= " article_versions av ";
            }
        } else {
            // this user has been set with one workflows..
            $sql .= "  article_versions av ";
        }
    }
    $sql .= " where ";
    // WHERE CLAUSE HERE..very important!!!!
    $state = 0;
    if (count($user_stages) > 1) {
        // this user has been assign with SOME WORKFLOWS
        foreach ($user_stages as $field => $user_stage) {
            if ($user_stage->stageID) {
                switch ($user_stage->stageID) {
                    case 1:
                        // writer
                        $sql .= " a.stageID = 1 ";
                        $sql .= " and aa.userID = {$userID} ";
                        $state = 1;
                        break;
                    case 2:
                        // editor
                        // PROBLEM : concatenation of and..ex. editor+chef
                        if ($state) {
                            $sql .= " and av.stageID = 2 ";
                        } else {
                            $sql .= " av.stageID = 2 ";
                        }
                        break;
                    case 3:
                        // editor n chief
                        if ($state) {
                            $sql .= " and av.stageID = 3 ";
                        } else {
                            $sql .= " av.stageID = 3 ";
                        }
                        //$sql .= " and av.modified_by = $userID ";
                        break;
                    case 4:
                        // publisher
//.........这里部分代码省略.........

}
// UPGRADE TO VERSION 3.1.1
// ************************
$result = 0;
if ($module_version < $new_module_version) {
    // Title: Upgrading to
    echo '<h3>SITEMAP - Upgrading to version ' . $new_module_version . ':</h3>';
    // Get ITEMS table to see what needs to be created or modified
    $itemstable = $database->query("SELECT * FROM `" . $dbtable . "`");
    $items = $itemstable->fetchRow();
    echo "<BR><B>Trying to rename database field '<i>loop</i>' to '<i>sitemaploop</i>'...</B><BR>";
    if (!array_key_exists('sitemaploop', $items)) {
        if ($database->query("ALTER TABLE `" . $dbtable . "` CHANGE `loop` `sitemaploop` TEXT NOT NULL")) {
            echo '<span class="good">Database field <i>loop</i> renamed to <i>sitemaploop</i> successfully</span><br />';
        } else {
            echo '<span class="bad">' . $database->error() . '</span><br />';
            $result = 1;
        }
    } else {
        echo '<span class="ok">Database field <i>sitemaploop</i> already exists, update not needed.</span><br />';
    }
    echo "<BR><B>Trying to add database field '<i>show_hidden</i>'...</B><BR>";
    if (!array_key_exists('show_hidden', $items)) {
        if ($database->query("ALTER TABLE `" . $dbtable . "` ADD `show_hidden` INT NOT NULL")) {
            echo '<span class="good">Database field <i>show_hidden</i> added successfully</span><br />';
        } else {
            echo '<span class="bad">' . $database->error() . '</span><br />';
            $result = 1;
        }
    } else {
        echo '<span class="ok">Database field <i>show_hidden</i> already exists, update not needed.</span><br />';