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); }
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']; $_SESSION['PREGO_ADMIN']['STAFF_ID'] = $row['login_id']; $_SESSION['PREGO_ADMIN']['STAFF_PWD'] = $row['login_pwd'];