个人账户', '退出'); } } else { if ($act == 'user-info') { header("Location: club_login.php?act=user-info"); exit(); } else { header("Location: club_login.php?act=product"); exit(); } } if ($act == 'update') { $id = mysql_escape_string(trim($_REQUEST['id'])); $sex = mysql_escape_string(trim($_REQUEST['sex'])); $birthday = mysql_escape_string(trim($_REQUEST['birthday'])); $province_id = mysql_escape_string(trim($_REQUEST['province'])); $city_id = mysql_escape_string(trim($_REQUEST['city'])); $address = mysql_escape_string(trim($_REQUEST['address'])); $zipcode = mysql_escape_string(trim($_REQUEST['zipcode'])); $mobile = mysql_escape_string(trim($_REQUEST['mobile'])); $email = mysql_escape_string(trim($_REQUEST['email'])); // $sql = " update oppo_bd.bd_product_registration set sex = '{$sex}', province = '{$province_id}', // city = '{$city_id}', address = '{$address}', zipcode = '{$zipcode}', mobile = '{$mobile}' where p_id = {$id}"; // $db->exec($sql); // $sql_u = "update oppo_bd.bd_club_user set e_mail = '{$email}', birthday = '{$birthday}' where u_id = {$_SESSION['u_id']}"; // $db->exec($sql_u); $sql = " update oppo_bd.bd_product_registration set sex = ?, province = ?, city =?, address =?, zipcode = ?, mobile =? where p_id =?"; $pdodb->safeExecute($sql, [$sex,$province_id,$city_id,$address,$zipcode,$mobile,$id]); $sql_u = "update oppo_bd.bd_club_user set e_mail =?, birthday =? where u_id =? "; $pdodb->safeExecute($sql_u,[$email, $birthday,$_SESSION['u_id']]); } elseif ($act == 'loginout') { session_destroy(); bdsetcookie('logging_status',0 ,0); alert_back('退出登录', 'index.php'); } if ($act != 'reset' && $act != 'loginout') { //$sql = " // select u.user_name,u.birthday, u.e_mail, pr.p_id, pr.name, pr.sex, pr.province, pr.city, pr.address, pr.zipcode, pr.mobile // from oppo_bd.bd_club_user u // left join oppo_bd.bd_product_registration pr on u.u_id = pr.u_id // where pr.u_id = '{$_SESSION['u_id']}' // order by pr.p_id desc limit 1 //"; //$info = $db->getRow($sql); $sql = " select u.user_name,u.birthday, u.e_mail, pr.p_id, pr.name, pr.sex, pr.province, pr.city, pr.address, pr.zipcode, pr.mobile from oppo_bd.bd_club_user u left join oppo_bd.bd_product_registration pr on u.u_id = pr.u_id where pr.u_id = ? order by pr.p_id desc limit 1 "; $info = $pdodb->safeQueryRow($sql,[$_SESSION['u_id']]); $info['birthday'] = date("Y-m-d", strtotime($info['birthday'])); $province_id = $info['province']; $city_id = $info['city']; //$product_sql_t = " // select machine_type, serial_number, is_real // from oppo_bd.bd_product_registration // where u_id = '{$_SESSION['u_id']}' and (is_real = '1' or (is_real = '0' and UNIX_TIMESTAMP(last_update_stamp) >= ".(time() - 7*3600*24).")) // order by p_id desc //"; //$product_list = $db->getAll($product_sql_t); $product_sql_t = " select machine_type, serial_number, is_real from oppo_bd.bd_product_registration where u_id = ? and (is_real = '1' or (is_real = '0' and UNIX_TIMESTAMP(last_update_stamp) >= ".(time() - 7*3600*24).")) order by p_id desc "; $product_list = $pdodb->safeQueryAll($product_sql_t,[$_SESSION['u_id']]); } $province_id = isset($province_id) ? $province_id : (isset($_REQUEST['province_id']) ? trim($_REQUEST['province_id']) : null); $city_id = isset($city_id) ? $city_id : (isset($_REQUEST['city_id']) ? trim($_REQUEST['city_id']) : null); $province_list = shipping_get_province_list(); foreach ($province_list as $k => $province){ if($k!= 3688 && $k!=3784){ unset($province_list[$k]); } } $city_list = isset($province_id) ? shipping_get_city_list($province_id) : array(); if ($act == 'reset') { print json_encode($city_list); exit(); } include Zandy_Template::outCache('product-user-info', $siteConf['tplDir'], $siteConf['cacheDir']);