在ecshop中用户信息添加字段的思路分析及方法.doc

在ecshop中用户信息添加字段的思路分析及方法http:/0535/post/60.html一、数据库结构修改1、用phpMyAdmin打开mysql数据库2、选择表“ecs_users ”3】添加你想要加的字段二、修改模板文件1、修改themes/你所选模板目录下/user_passport.dwt文件 $lang.other_mobile_phone $lang.other_wangw 修改themes/你所选模板目录下/user_transaction.dwt文件 $lang.other_mobile_phone： $lang.other_wangw： 三修改php文件1.修改根目录下的user.php/* 修改个人资料的处理 */elseif ($action = act_edit_profile) include_once(ROOT_PATH . includes/lib_transaction.php); $birthday = trim($_POSTbirthdayYear) .-. trim($_POSTbirthdayMonth) .-. trim($_POSTbirthdayDay); $email = trim($_POSTemail); $msn = trim($_POSTothermsn); $qq = trim($_POSTotherqq); $mobile_phone = trim($_POSTothermobile_phone); $office_phone = $_POSTotheroffice_phone; $home_phone = $_POSTotherhome_phone;$wangw = $_POSTotherwangw; if (!empty($office_phone) & !preg_match( /d|_|-|s+$/, $office_phone ) ) show_message($_LANGpassport_jsoffice_phone_invalid); if (!empty($home_phone) & !preg_match( /d|_|-|s+$/, $home_phone) ) show_message($_LANGpassport_jshome_phone_invalid); if (!is_email($email) show_message($_LANGmsg_email_format); if (!empty($msn) & !is_email($msn) show_message($_LANGpassport_jsmsn_invalid); if (!empty($qq) & !preg_match(/d+$/, $qq) show_message($_LANGpassport_jsqq_invalid); if (!empty($mobile_phone) & !preg_match(/d+$/, $mobile_phone) show_message($_LANGpassport_jsmobile_phone_invalid); if (!empty($wangw) & !preg_match(/d+$/, $wangw) show_message($_LANGpassport_jswangw_invalid); $profile = array(3、修改upload/js/user.js文件处理注册用户*/function register() var frm = document.formsformUser; var username = Utils.trim(frm.elementsusername.value); var email = frm.elementsemail.value; var password = Utils.trim(frm.elementspassword.value); var confirm_password = Utils.trim(frm.elementsconfirm_password.value); var checked_agreement = frm.elementsagreement.checked; var msn = frm.elementsothermsn ? Utils.trim(frm.elementsothermsn.value) : ; var qq = frm.elementsotherqq ? Utils.trim(frm.elementsotherqq.value) : ; var home_phone = frm.elementsotherhome_phone ? Utils.trim(frm.elementsotherhome_phone.value) : ; var office_phone = frm.elementsotheroffice_phone ? Utils.trim(frm.elementsotheroffice_phone.value) : ; var mobile_phone = frm.elementsothermobile_phone ? Utils.trim(frm.elementsothermobile_phone.value) : ; var wangw = frm.elementsotherwangw ? Utils.trim(frm.elementsotherwangw.value) : ; var msg = ; / 检查输入 var msg = ; if (username.length = 0) msg += username_empty + n; else if (username.match(/s*$|c:concon$|%,*st&/) msg += username_invalid + n; else if (username.length 3) /msg += username_shorter + n; if (email.length = 0) msg += email_empty + n; else if ( ! (Utils.isEmail(email) msg += email_invalid + n; if (password.length = 0) msg += password_empty + n; else if (password.length 0 & (!Utils.isEmail(msn) msg += msn_invalid + n; if (qq.length 0 & (!Utils.isNumber(qq) msg += qq_invalid + n; if (office_phone.length0) var reg = /d|-|s+$/; if (!reg.test(office_phone) msg += office_phone_invalid + n; if (home_phone.length0) var reg = /d|-|s+$/; if (!reg.test(home_phone) msg += home_phone_invalid + n; if (mobile_phone.length0) var reg = /d|-|s+$/; if (!reg.test(mobile_phone) msg += mobile_phone_invalid + n; if (wangw.length0) var reg = /d|-|s+$/; if (!reg.test(wangw) msg += wangw_invalid + n; if (msg.length 0) 4、修改includes/lib_passport.php /* 过滤非法的键值 */ $other_key_array = array(msn, qq, office_phone, home_phone, mobile_phone,wangw); foreach ($profileother as $key = $val) /* 会员帐号信息 */ $info = array(); $infos = array(); $sql = SELECT user_name, birthday, sex, question, answer, rank_points, pay_points,user_money, user_rank, . msn, qq, office_phone, home_phone, mobile_phone,wangw . FROM .$GLOBALSecs-table(users) . WHERE user_id = $user_id;$infoquestion = isset($infosquestion) ? htmlspecialchars($infosquestion) : ; $infouser_money = price_format($infouser_money, false); $infopay_points = $infopay_points . $GLOBALS_CFGintegral_name; $infobonus