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); }
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"; } } }
<?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');
} // 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(); $auth = $row['sorts']; $_SESSION['PREGO_ADMIN']['STAFF_SEQ'] = $row['id'];