ECshop 里对数据库操作
//修改
$sql = "UPDATE ".$GLOBALS[‘ecs‘]->table(‘users‘)." SET "."real_name = ‘$real_name‘ ," ."identity = ‘$identity‘, " ."email = ‘$email‘, " ."mobile = $mobile, " ."open_bank = ‘$open_bank‘ ,
" ."bank_user = ‘$bank_user‘ ," ."bank_account = ‘$bank_account‘ ," ."bank_branch = ‘$bank_branch‘ " ."WHERE " . "user_id=" . $user_id;
$GLOBALS[‘db‘]->query($sql);
//查询
$sql = ‘SELECT user_name,real_name,identity,email,mobile,pay_points,open_bank,bank_user,bank_account,bank_branch FROM ‘ . $ecs->table(‘users‘) ."WHERE " . "user_id=" . $user_id;
$infos = $db->getAll($sql);
//添加
$sql = ‘INSERT INTO ‘. $ecs->table(‘reg_extend_info‘) . " (`user_id`, `reg_field_id`, `content`) VALUES (‘$user_id‘, ‘$val[id]‘, ‘$temp_field_content‘)";
$db->query($sql);
//删除
$sql = "DELETE FROM " .$ecs->table(‘feedback‘). " WHERE msg_id = ‘$id‘ OR parent_id = ‘$id‘";
$db->query($sql);
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
