PHP mydb::query方法代码示例

function get_my_answers($id)
{
    $db = new mydb();
    $query = "select q.id as q_id, q.content, c.choice, c.answer from crystal q, answer a, choices c where a.q_id = q.id and a.answer = c.id and a.m_id = \$1";
    $result = $db->query($query, array($id), "getans");
    return $result;
}

function update_log($m_id, $answer)
{
    $sex = getNewLogSex($m_id, $answer);
    $db = new mydb();
    $query = "insert into log (m_id, sex) values(\$1, \$2)";
    $result = $db->query($query, array($m_id, $sex), "setlog");
}

function get_questions_with_search($search)
{
    $db = new mydb();
    $query = "select c.id, c.date, c.content, m.login_name from crystal c, member m where c.m_id = m.id and c.content like \$1";
    $result = $db->query($query, array("%" . $search . "%"), "search");
    return $result;
}

function get_choices($id)
{
    $db = new mydb();
    $query = "select * from choices c where c.q_id = \$1";
    $result = $db->query($query, array($id), "choices");
    return $result;
}

function getNewLogSex($id, $n)
{
    $db = new mydb();
    $query = "select c.answer from answer a, choices c where a.m_id = \$1 and c.id = a.answer";
    $result = $db->query($query, array($id), "getNewLogSex");
    $num = pg_num_rows($result);
    $sum = 0;
    if ($num == 0) {
        return "1000";
    }
    for ($i = 0; $i < $num; $i++) {
        $row = pg_fetch_assoc($result, $i);
        $sum += intval($row['answer']);
    }
    $sum += $n;
    return $sum / ($num + 1);
}

//Fehlerinstanz
$api = php_sapi_name();
$err = new error($api);
include_once "dblib.php";
include_once "pepper.php";
include_once "erplib.php";
$erpdb = new mydb($ERPhost, $ERPdbname, $ERPuser, $ERPpass, $ERPport, 'pgsql', $err, $debug);
$shopdb = new mydb($SHOPhost, $SHOPdbname, $SHOPuser, $SHOPpass, $SHOPport, 'mysql', $err, $debug);
$sql = "SELECT * FROM custom_variable_configs WHERE name = 'pepperkunde'";
$rs = $erpdb->getOne($sql);
if (isset($rs['id'])) {
    $cvarid = $rs['id'];
} else {
    exit;
}
$sql = "SELECT k_ID,Kunden_NR FROM kunde WHERE Kunden_NR != '0'";
$kunden = $shopdb->getAll($sql);
$sqlkdnr = "SELECT id FROM customer WHERE customernumber = '%s' ";
$sqldel = "DELETE FROM custom_variables WHERE config_id={$cvarid} AND trans_id=";
$sqlins = "INSERT INTO custom_variables (config_id,trans_id,text_value) VALUES ({$cvarid},%d,'%s')";
$i = 0;
if ($kunden) {
    foreach ($kunden as $nr) {
        $rs = $erpdb->getOne(sprintf($sqlkdnr, $nr['kunden_nr']));
        if (isset($rs['id'])) {
            echo $nr['k_id'] . " -> " . $nr['kunden_nr'] . "\n";
            $rc = $erpdb->query($sqldel . $rs['id']);
            $rc = $erpdb->query(sprintf($sqlins, $rs['id'], $nr['kunden_nr']));
        }
    }
}

function getGraphData()
{
    $db = new mydb();
    $query = "select * from log where m_id = \$1";
    $result = $db->query($query, array($_SESSION['id']), "getGraphData");
    return $result;
}

$db = new mydb();
while ($dataset = fgets($fp, 1024)) {
    $data = explode(',', $dataset);
    preg_match("/^(\\d{4,})(\\d{2,})(\\d{2,})T(\\d{2,})(\\d{2,})(\\d{2,})\\..*/ism", $data[0], $ret);
    if (preg_match('/StartTime/i', $data[0])) {
        continue;
    }
    $day = $ret[1] . '-' . $ret[2] . '-' . $ret[3];
    $date = $day . ' ' . $ret[4] . ':' . $ret[5] . ':' . $ret[6];
    if ($count == 0) {
        $position = $date;
    }
    $watt = $data[2] * 6 * 1000;
    @($usage[$day][$ret[4]]['watt'] += $watt);
    #var_dump(round($watt));
    $db->query("INSERT INTO measure_watt ( sensor, data, time) values( {$argv['1']}, round( {$watt} ), '{$date}' )");
    $count++;
}
$db->query("INSERT INTO measure_positions ( position_time, position_description, position_sensor) values( '{$position}', 'google Power Meter import', '{$argv['1']}' )");
#var_dump($usage);exit;
foreach ($usage as $k => $v) {
    foreach ($v as $vk => $vv) {
        @($daily += $vv[watt]);
        $count_hourly++;
        @($w = number_format(round($vv[watt]), 0, ',', '.'));
        $db->query("INSERT INTO measure_watt_hourly( sensor, data, hour, time) values( '{$argv['1']}', '{$w}', '{$vk}', '{$k}' )");
    }
    $count_daily++;
    $daily = number_format(round($daily), 0, ',', '.');
    $db->query("INSERT INTO measure_watt_daily( sensor, data, time) values( '{$argv['1']}', '{$daily}', '{$k}' )");
}

<?php

session_start();
include "setting.php";
if (post_check()) {
    $login_name = $_POST['login_name'];
    $pwd = $_POST['pwd'];
} else {
    gotoindex();
}
$db = new mydb();
$query = "select * from member where login_name=\$1";
$result = $db->query($query, array($login_name));
if (pg_num_rows($result) == 1) {
    $row = pg_fetch_assoc($result, 0);
    if (password_verify($pwd, $row['pwd'])) {
        $_SESSION['login_name'] = $row['login_name'];
        $_SESSION['id'] = $row['id'];
        $_SESSION['ipaddress'] = $_SERVER['REMOTE_ADDR'];
        login_success();
    } else {
        login_failed();
    }
} else {
    login_failed();
}
function login_success()
{
    header("Location: top.php");
}
function post_check()

<?php

include_once dirname(__FILE__) . '/class_mydb.php';
$db = new mydb(array('hostname' => DB_HOST, 'username' => DB_USER, 'password' => DB_PASSWORD, 'database' => DB_NAME));
//get user by ID
$user_info = array();
if (FALSE === ($res = $db->query('SELECT uid, username, dob, mobile, address FROM register_user WHERE uid = ?', array((int) $uid)))) {
    error_log(__METHOD__ . " Failed to get user info with error = " . $db->error_msg);
} else {
    $user_info = $res->first_row('array');
    $res->free_result();
}
print_r($user_info);
//get users
$users = array();
if (FALSE === ($res = $db->query('SELECT uid, username, dob, mobile, address FROM register_user WHERE uid = ?', array((int) $uid)))) {
    error_log(__METHOD__ . " Failed to get user info with error = " . $db->error_msg);
} else {
    $users = $res->result('array');
    $res->free_result();
}
print_r($users);

<?php

//$shopnr = $_GET['Shop'];
$shopnr = '';
include_once "conf{$shopnr}.php";
include_once "error.php";
//Fehlerinstanz
$api = php_sapi_name();
$err = new error($api);
include_once "dblib.php";
include_once "pepper.php";
include_once "erplib.php";
$erpdb = new mydb($ERPhost, $ERPdbname, $ERPuser, $ERPpass, $ERPport, 'pgsql', $err, $debug);
$shopdb = new mydb($SHOPhost, $SHOPdbname, $SHOPuser, $SHOPpass, $SHOPport, 'mysql', $err, $debug);
$sql = "SELECT k_ID,Kunden_NR FROM kunde WHERE Kunden_NR != '0'";
$kunden = $shopdb->getAll($sql);
$sqlkdnr = "SELECT customernumber FROM customer WHERE id = ";
$sqlupd = "UPDATE kunde SET Kunden_NR = '%s' WHERE k_ID = %d";
if ($kunden) {
    foreach ($kunden as $nr) {
        $rs = $erpdb->getOne($sqlkdnr . $nr['kunden_nr']);
        if (isset($rs['customernumber'])) {
            echo $nr['k_id'] . " -> " . $rs['customernumber'] . "\n";
            $rc = $shopdb->query(sprintf($sqlupd, $rs['customernumber'], $nr['k_id']));
        }
    }
}

session_start();
include "setting.php";
if (!isset($_SESSION['id']) || !isset($_SESSION['ipaddress'])) {
    gotoindex();
}
check_login();
if (!post_check()) {
    exit(0);
}
include "header.php";
$pwd = $_POST['pwd'];
$newpwd = $_POST['newpwd'];
$login_name = $_SESSION['login_name'];
$db = new mydb();
$query = "select * from member where login_name=\$1";
$result = $db->query($query, array($login_name));
$row = pg_fetch_assoc($result, 0);
if (password_verify($pwd, $row['pwd'])) {
    // パスワードが正しい
    $ck = check_new_pwd($newpwd);
    if ($ck != '') {
        print $ck;
        include "footer.php";
        return;
    }
    $newpasswd = password_hash($newpwd, PASSWORD_DEFAULT);
    $sql1 = "UPDATE member SET pwd = \$1 WHERE login_name = \$2";
    $result1 = $db->query($sql1, array($newpasswd, $login_name), "get");
    print "パスワードを更新しました。";
} else {
    print "現在のパスワードが間違っています。";