ecshop mysql 操作_ECshop 里对数据库操作

最新推荐文章于 2021-02-08 07:09:37 发布

小马逛吃

最新推荐文章于 2021-02-08 07:09:37 发布

阅读量196

点赞数

文章标签： ecshop mysql 操作

本文链接：https://blog.csdn.net/weixin_31976851/article/details/113383522

版权

//修改

$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);