PHP dbFetchRow函数代码示例

/**
 * Observium
 *
 *   This file is part of Observium.
 *
 * @package    observium
 * @subpackage functions
 * @author     Adam Armstrong <adama@memetic.org>
 * @copyright  (C) 2006-2014 Adam Armstrong
 *
 */
function get_entity_by_id_cache($type, $id)
{
    global $cache;
    if ($type !== 'port') {
        list($entity_table, $entity_id_field, $entity_name_field) = entity_type_translate($type);
    }
    if (is_array($cache[$type][$id])) {
        return $cache[$type][$id];
    } else {
        switch ($type) {
            case "port":
                $entity = get_port_by_id($id);
                break;
            default:
                $entity = dbFetchRow("SELECT * FROM `" . $entity_table . "` WHERE `" . $entity_id_field . "` = ?", array($id));
                if (function_exists('humanize_' . $type)) {
                    $do = 'humanize_' . $type;
                    $do($entity);
                }
                break;
        }
        if (is_array($entity)) {
            entity_rewrite($type, $entity);
            $cache[$type][$id] = $entity;
            return $entity;
        }
    }
    return FALSE;
}

function get_entity_by_id_cache($entity_type, $entity_id)
{
    global $cache;
    $translate = entity_type_translate_array($entity_type);
    if (is_array($cache[$entity_type][$entity_id])) {
        return $cache[$entity_type][$entity_id];
    } else {
        switch ($entity_type) {
            case "port":
                $entity = get_port_by_id($entity_id);
                break;
            default:
                $entity = dbFetchRow("SELECT * FROM `" . $translate['table'] . "` WHERE `" . $translate['id_field'] . "` = ?", array($entity_id));
                if (function_exists('humanize_' . $entity_type)) {
                    $do = 'humanize_' . $entity_type;
                    $do($entity);
                } elseif (isset($translate['humanize_function']) && function_exists('humanize_' . $translate['humanize_function'])) {
                    $do = 'humanize_' . $translate['humanize_function'];
                    $do($entity);
                }
                break;
        }
        if (is_array($entity)) {
            entity_rewrite($entity_type, $entity);
            $cache[$entity_type][$entity_id] = $entity;
            return $entity;
        }
    }
    return FALSE;
}

/**
 * Fetch all info about a Proxmox VM
 * @param integer $vmid Proxmox VM ID
 * @param string $c Clustername
 * @return array An array with all info of this VM on this cluster, including ports
 */
function proxmox_vm_info($vmid, $c)
{
    $vm = dbFetchRow("SELECT pm.*, d.hostname AS host, d.device_id FROM proxmox pm, devices d WHERE pm.device_id = d.device_id AND pm.vmid = ? AND pm.cluster = ?", array($vmid, $c));
    $appid = dbFetchRow("SELECT app_id FROM applications WHERE device_id = ? AND app_type = ?", array($vm['device_id'], 'proxmox'));
    $vm['ports'] = dbFetchRows("SELECT * FROM proxmox_ports WHERE vm_id = ?", array($vm['id']));
    $vm['app_id'] = $appid['app_id'];
    return $vm;
}

/**
 * Observium
 *
 *   This file is part of Observium.
 *
 * @package        observium
 * @subpackage     functions
 * @copyright  (C) 2006-2013 Adam Armstrong, (C) 2013-2016 Observium Limited
 *
 */
function get_customoid_by_id($oid_id)
{
    if (is_numeric($oid_id)) {
        $oid = dbFetchRow('SELECT * FROM `oids` WHERE `oid_id` = ?', array($oid_id));
    }
    if (count($oid)) {
        return $oid;
    } else {
        return FALSE;
    }
}

/**
 * Check if a Proxmox VM exists
 * @param integer $i VM ID
 * @param string  $c Clustername
 * @param array   $pmxcache Reference to the Proxmox VM Cache
 * @return boolean true if the VM exists, false if it doesn't
 */
function proxmox_vm_exists($i, $c, &$pmxcache)
{
    if (isset($pmxcache[$c][$i]) && $pmxcache[$c][$i] > 0) {
        return true;
    }
    if ($row = dbFetchRow("SELECT id FROM proxmox WHERE vmid = ? AND cluster = ?", array($i, $c))) {
        $pmxcache[$c][$i] = (int) $row['id'];
        return true;
    }
    return false;
}

function get_alert_test_by_id($alert_test_id)
{
    if (is_numeric($alert_test_id)) {
        $alert_test = dbFetchRow('SELECT * FROM `alert_tests` WHERE `alert_test_id` = ?', array($alert_test_id));
    }
    if (is_array($alert_test) && count($alert_test)) {
        return $alert_test;
    } else {
        return FALSE;
    }
}

function get_port_stats_by_port_hostname()
{
    // This will return port stats based on a devices hostname and ifName
    global $config;
    $app = \Slim\Slim::getInstance();
    $router = $app->router()->getCurrentRoute()->getParams();
    $ifName = urldecode($router['ifname']);
    $stats = dbFetchRow("SELECT * FROM `ports` WHERE `ifName`=?", array($ifName));
    $output = array("status" => "ok", "port" => $stats);
    $app->response->headers->set('Content-Type', 'application/json');
    echo _json_encode($output);
}

function super_query($q, $m = false)
{
    $q = query($q);
    global $qNum;
    $qNum++;
    if (!$m) {
        return dbFetchRow($q);
    }
    $r = array();
    while ($e = dbFetchRow($q)) {
        $r[] = $e;
    }
    return $r;
}

function getOrderAmount($orderId)
{
    $orderAmount = 0;
    $sql = "SELECT SUM(pd_price * od_qty)\r\n\t        FROM tbl_order_item oi, tbl_product p \r\n\t\t    WHERE oi.pd_id = p.pd_id and oi.od_id = {$orderId}\r\n\t\t\t\r\n\t\t\tUNION\r\n\t\t\t\r\n\t\t\tSELECT od_shipping_cost \r\n\t\t\tFROM tbl_order\r\n\t\t\tWHERE od_id = {$orderId}";
    $result = dbQuery($sql);
    if (dbNumRows($result) == 2) {
        $row = dbFetchRow($result);
        $totalPurchase = $row[0];
        $row = dbFetchRow($result);
        $shippingCost = $row[0];
        $orderAmount = $totalPurchase + $shippingCost;
    }
    return $orderAmount;
}

/**
 * Check username against CAS authentication backend. User needs to exist in MySQL to be able to log in.
 *
 * @param string $username User name to check
 * @param string $password User password to check
 * @return int Authentication success (0 = fail, 1 = success) FIXME bool
 */
function cas_authenticate($username, $password)
{
    $row = dbFetchRow("SELECT `username`, `password` FROM `users` WHERE `username`= ?", array($username));
    if ($row['username'] && $row['username'] == $username) {
        if ($username == phpCAS::getUser()) {
            return 1;
        }
        dbInsert(array('user' => $_SESSION['username'], 'address' => $_SERVER["REMOTE_ADDR"], 'result' => 'CAS: username does not match CAS user'), 'authlog');
    } else {
        dbInsert(array('user' => $_SESSION['username'], 'address' => $_SERVER["REMOTE_ADDR"], 'result' => 'CAS: NOT found in DB'), 'authlog');
    }
    //session_logout();
    return 0;
}

function get_port_stats_by_port_hostname()
{
    // This will return port stats based on a devices hostname and ifName
    global $config;
    $app = \Slim\Slim::getInstance();
    $router = $app->router()->getCurrentRoute()->getParams();
    $hostname = $router['hostname'];
    $device_id = ctype_digit($hostname) ? $hostname : getidbyname($hostname);
    $ifName = urldecode($router['ifname']);
    $stats = dbFetchRow('SELECT * FROM `ports` WHERE `device_id`=? AND `ifName`=?', array($device_id, $ifName));
    $output = array('status' => 'ok', 'port' => $stats);
    $app->response->headers->set('Content-Type', 'application/json');
    echo _json_encode($output);
}

function authenticate($username, $password)
{
    global $config;
    if (isset($_SERVER['REMOTE_USER'])) {
        $_SESSION['username'] = mres($_SERVER['REMOTE_USER']);
        $row = @dbFetchRow("SELECT username FROM `users` WHERE `username`=?", array($_SESSION['username']));
        if (isset($row['username']) && $row['username'] == $_SESSION['username']) {
            return 1;
        } else {
            $_SESSION['username'] = $config['http_auth_guest'];
            return 1;
        }
    }
    return 0;
}

/**
 * Check user permission to access the bill
 *
 * @return boolean
 * @param  bill_id
 *
*/
function api_bill_permitted($bill_id)
{
    global $vars;
    $res = false;
    if ($vars['user']['level'] >= 10) {
        $res = true;
    } else {
        api_show_debug("Checking permission for bill", $bill_id);
        $row = dbFetchRow("SELECT * FROM `entity_permissions` WHERE `entity_type` = 'bill' AND `user_id` = ? AND `entity_id`= ? LIMIT 1", array($vars['user']['id'], $bill_id));
        if (is_array($row)) {
            $res = true;
        }
    }
    api_show_debug("Returned bill permitted", $res);
    return $res;
}

 public function getComponentType($TYPE = null)
 {
     if (is_null($TYPE)) {
         $SQL = "SELECT DISTINCT `type` as `name` FROM `component` ORDER BY `name`";
         $row = dbFetchRow($SQL, array());
     } else {
         $SQL = "SELECT DISTINCT `type` as `name` FROM `component` WHERE `type` = ? ORDER BY `name`";
         $row = dbFetchRow($SQL, array($TYPE));
     }
     if (!isset($row)) {
         // We didn't find any component types
         return false;
     } else {
         // We found some..
         return $row;
     }
 }

function mysql_query($query, $multi = false){
	global $inited_mysql, $mysql_iid;

	if(!$inited_mysql){
		new_db_decl();
		dbQuery("SET NAMES 'utf8'");
		$inited_mysql = true;
	}

	$db = dbQuery($query);

	$mysql_iid = dbInsertedId();

	if($multi){
		$data = array();
		while ($row = dbFetchRow($db)) $data[] = $row;
		return $data;
	}else return dbFetchRow($db);
}