PHP Class_DB Examples

Example #1

File: Class_M_OTHER.php Project: BGCX262/zuozhenshi-prego-svn-to-git

 public static function get_shops($ins_shop_cd)
 {
     $db = new Class_DB();
     $sql = "SELECT  a.shop_cd, a.shop_name  FROM M_SHOP a inner JOIN M_INS_SHOP_SHOP b on  a.shop_cd = b.shop_cd  where b.ins_shop_cd  = '{$ins_shop_cd}'";
     //echo $sql;
     $db->query($sql);
     $data = array();
     while ($row = $db->fetch()) {
         $data[] = $row["shop_name"];
     }
     return implode(",", $data);
 }

Example #2

File: index.php Project: rsroriz/fb_ipiranga_shop

function f_pesquisa_ajax()
{
    global $valor;
    $DB = new Class_DB();
    $DB->connect("FBipirangashop", "cont.senderdirect.com", "root", "rmc3284K");
    $DB->query("SELECT nome FROM respostas WHERE nome LIKE '{$valor}%'");
    if ($DB->affected_rows()) {
        while ($DB->next_record()) {
            echo $DB->f(0) . "\n";
        }
    }
}

Example #3

File: modifyInfo.php Project: BGCX262/zuozhenshi-prego-svn-to-git

<?php

require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
// 要修改的数据
$id = $_POST['id'];
$login_id = $_POST['login_id'];
$login_pwd = $_POST['login_pwd'];
$user_name = $_POST['user_name'];
$login_flgs = $_POST['login_flgs'];
$sorts = $_POST['sorts'];
session_start();
$u_time = date("Y-m-d H:i:s");
$c_time = date("Y-m-d H:i:s");
$c_user = $_SESSION['ADMIN_LOGIN']['ID'];
$u_user = $c_user;
if (empty($login_flgs)) {
    $login_flgs = 0;
}
$db = new Class_DB();
if ($_SESSION['dml'] == 1) {
    $sql = "update mp_acount set user_name = '{$user_name}',login_id = '{$login_id}',login_pwd = '{$login_pwd}',login_flgs = '{$login_flgs}',sorts = '{$sorts}',u_time='{$u_time}',u_user='******' where id = '{$id}'";
} else {
    $countsql = "select id from mp_acount";
    $db->query($countsql);
    $next = $db->num_rows() + 1;
    $sql = "insert into mp_acount values({$next},'{$login_id}','{$login_pwd}','{$user_name}','{$sorts}','{$login_flgs}','{$u_time}','{$u_user}','{$c_time}','{$c_user}')";
}
$db->query($sql);
header('Location: account_list.php');

Example #4

File: login.php Project: BGCX262/zuozhenshi-prego-svn-to-git

 if ($err_mes['login_id']) {
     $err_msg = $msg_bg . "IDは" . $err_mes['login_id'] . $msg_ed;
 }
 // login_pass err
 if ($err_mes['login_pass']) {
     $passmsg = $msg_bg . "パスワードは" . $err_mes['login_pass'] . $msg_ed;
     if ($err_msg) {
         $err_msg = $err_msg . $passmsg;
     } else {
         $err_msg = $passmsg;
     }
 }
 // login_id and login_pass ok
 if ($oerr->clear) {
     // get data by login_id and login_pwd
     $db = new Class_DB();
     $sql = sprintf("SELECT * FROM mp_account WHERE login_id = '%s' AND login_pwd = '%s' ", mysql_real_escape_string($id), mysql_real_escape_string(Class_PWD::do_encode($pass)));
     $db->query($sql);
     if ($db->num_rows()) {
         $row = $db->fetch();
         // ログイン不可
         if ($row['login_flgs'] == '1') {
             $err_msg = '<p class="caution">ログインできません。管理者にお問い合わせください。</p>';
             $err = true;
             $db->close();
             // ログイン可
         } else {
             // set auth and session
             session_name('PREGO_ADMIN');
             //session_cache_limiter(private_no_expire);
             session_start();