PHP get_ip_area Examples

Example #1

File: OrdersAction.class.php Project: anshidai/bagsloves

 public function excel()
 {
     Vendor('Excel.php-excel');
     $map['id'] = array('in', $_REQUEST['id']);
     $orders = $this->dao->where($map)->select();
     $xls = array();
     $xls[0][0] = "编号";
     $xls[0][1] = "金额";
     $xls[0][2] = "运输方式";
     $xls[0][3] = "运费";
     $xls[0][4] = "手续费";
     $xls[0][5] = "保险金";
     $xls[0][6] = "付款方式";
     $xls[0][7] = "购买时间";
     $xls[0][8] = "附加留言";
     $xls[0][9] = "IP地址";
     $xls[0][10] = "邮箱";
     $xls[0][11] = "姓";
     $xls[0][12] = "名";
     $xls[0][13] = "地址";
     $xls[0][14] = "电话";
     $xls[0][15] = "邮编";
     $xls[0][16] = "城市";
     $xls[0][17] = "省份";
     $xls[0][18] = "国家";
     $xls[0][19] = "订单状态";
     $xls[0][20] = "快递方式";
     $xls[0][21] = "重量";
     $i = 1;
     foreach ($orders as $o) {
         $xls[$i][0] = $o['sn'];
         $xls[$i][1] = $o['orders_total'];
         $xls[$i][2] = $o['shipping_method'];
         $xls[$i][3] = $o['shippingmoney'];
         $xls[$i][4] = $o['paymoney'];
         $xls[$i][5] = $o['insurance'];
         $xls[$i][6] = $o['payment_module_code'];
         $xls[$i][7] = toDate($o['dateline']);
         $xls[$i][8] = $o['BuyNote'];
         $xls[$i][9] = $o['ip_address'] . "(" . get_ip_area($o['ip_address']) . ")";
         $xls[$i][10] = $o['delivery_email'];
         $xls[$i][11] = $o['delivery_firstname'];
         $xls[$i][12] = $o['delivery_lastname'];
         $xls[$i][13] = $o['delivery_address'];
         $xls[$i][14] = $o['delivery_telephone'];
         $xls[$i][15] = $o['delivery_zip'];
         $xls[$i][16] = $o['delivery_city'];
         $xls[$i][17] = $o['delivery_state'];
         $xls[$i][18] = $o['delivery_country'];
         $xls[$i][19] = L('orders_status_' . $o['orders_status']);
         $xls[$i][20] = $o['shipping_method'];
         $xls[$i][21] = $o['total_weight'];
         $i++;
     }
     $xls_obj = new Excel_XML('UTF-8', false, 'SOP订单列表');
     $xls_obj->addArray($xls);
     $xls_obj->generateXML("SOP");
 }

Example #2

File: personal_user.php Project: source-hunter/74cms

    $db->query("UPDATE " . table('members') . " SET qq_openid = ''  WHERE uid='{$_SESSION[uid]}' LIMIT 1");
    exit('解除腾讯QQ绑定成功！');
} elseif ($act == 'del_sina_binding') {
    $db->query("UPDATE " . table('members') . " SET sina_access_token = ''  WHERE uid='{$_SESSION[uid]}' LIMIT 1");
    exit('解除新浪微博绑定成功！');
} elseif ($act == 'del_taobao_binding') {
    $db->query("UPDATE " . table('members') . " SET taobao_access_token = ''  WHERE uid='{$_SESSION[uid]}' LIMIT 1");
    exit('解除淘宝账号绑定成功！');
} elseif ($act == 'login_log') {
    require_once QISHI_ROOT_PATH . 'include/fun_user.php';
    require_once QISHI_ROOT_PATH . 'include/page.class.php';
    $uid = intval($_SESSION['uid']);
    $smarty->assign('total', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1'"));
    $wheresql = " WHERE log_uid='{$_SESSION['uid']}' AND log_type='1001' ";
    $perpage = 15;
    $total_sql = "SELECT COUNT(*) AS num FROM " . table('members_log') . $wheresql;
    $total_val = $db->get_total($total_sql);
    $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET));
    $currenpage = $page->nowindex;
    $offset = ($currenpage - 1) * $perpage;
    $smarty->assign('loginlog', get_user_loginlog($offset, $perpage, $wheresql));
    $smarty->assign('page', $page->show(3));
    $smarty->assign('title', '会员登录日志 - 企业会员中心 - ' . $_CFG['site_name']);
    $smarty->display('member_personal/personal_user_loginlog.htm');
} elseif ($act == 'demo') {
    require_once QISHI_ROOT_PATH . 'include/fun_user.php';
    echo '<pre>';
    print_r(get_ip_area('113.25.9.112'));
    echo '</pre>';
}
unset($smarty);