帝國cms 會員註冊問題

我從小程序上獲取到相應的openid與userinfo 但是想要插入卻無法請問一下
有使用過cms的大神我該如何導入數據庫？？把會員資料存入數據庫裡啊？
我已經試過n種方式了求解拜託

require_once 'wxBizDataCrypt.php';

$appid = '';
$appSecret = '';
$Code = $_GET['Code'];
$url = 'https://api.weixin.qq.com/sns/jscode2session?appid='.$appid.'&secret='.$appSecret.'&js_code='.$Code.'&grant_type=authorization_code';
$apiData = file_get_contents($url);
$rawData =$_GET['rawData'];
$signature =$_GET['signature'];
$encryptedData = $_GET['encryptedData'];
$iv = $_GET['iv'];

if(!isset($apiData['errcode'])){
$sessionkey = json_decode($apiData)->session_key;
$signature2 = sha1($rawData.$sessionkey);
if($signature2 != $signature){
return false;
}
$userInfo = new WXBizDataCrypt($appid, $sessionkey);
$errCode = $userInfo->decryptData($encryptedData, $iv, $data);
if($errCode == 0){
$openId = json_decode($data)->openId;
$avatarUrl = json_decode($data)->avatarUrl;
$gender = json_decode($data)->gender;
$city = json_decode($data)->city;
$nickName = json_decode($data)->nickName;
$country = json_decode($data)->country;
$province = json_decode($data)->province;
}
print_r($data."\n");
}
require('../class/connect.php'); //引入数据库配置文件和公共函数文件
require('../class/db_sql.php'); //引入数据库操作文件
$link=db_connect(); //连接MYSQL
$empire=new mysqlquery(); //声明数据库操作类

$sql=$empire->query("select openid from {$dbtbpre}enewsmember where openId = $openId limit 1");

var_dump($sql);
後面一直有問題所以刪了....
我是先查詢沒有為false 然後insert到數據庫但是add跟主表都無法存每次都是null

你连接了数据库没？同数据库创建一个连接写insert语句

图片说明
在这里配置

代码下载：http://www.diybloghome.com/tempgin/269.html

 <?php
if(!defined('InEmpireCMS'))
{
    exit();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>用户注册</title>
<script id="jquery_183" type="text/javascript" class="library" src="/images/login/js/jquery-1.8.3.min.js"></script>
</head>
<body>
<div id="top"><h1>用户注册</h1></div>
<div class="form-bak">
<form name="userinfoform" method="post" action="../doaction.php" onsubmit="adaptValue();"><input type=hidden name=enews value=register>
<input name="groupid" type="hidden" id="groupid" value="<?=$groupid?>">
        <input name="tobind" type="hidden" id="tobind" value="<?=$tobind?>">
<div class="left">
<div class="line" id="line_name">
<div class="info">
<strong>用户名</strong>
<span class="tips">只能由数字、文字或下划线组成<br />最多30个字符</span>
</div>
<div class="input">
<input type="text" name="username" id="name" onblur="v_name();" onkeyup="v_name();" />
<div class="none">
<span></span>
</div>
</div>
</div>
<div class="line" id="line_password">
<div class="info">
<strong>密码</strong>
<span class="tips">6至30个字符</span>
</div>
<div class="input">
<input type="password" name="password" id="password" onblur="v_password();" onkeyup="v_password();" />
<div class="none">
<span></span>
</div>
</div>
</div>
<div class="line" id="line_repeat">
<div class="info">
<strong>确认密码</strong>
<span class="tips">再次输入密码</span>
</div>
<div class="input">
<input type="password" name="repassword" id="repeat" onblur="v_repeat();" onkeyup="v_repeat();" />
<div class="none">
<span></span>
</div>
</div>
</div>
<div class="line" id="line_account">
<div class="info">
<strong>邮箱</strong>
<span class="tips">常用的邮箱账号</span>
</div>
<div class="input">
<input type="text" name="email" id="account" onblur="v_account();" onkeyup="v_account();"/>
<div class="none">
<span></span>
</div>
</div>
</div>
</div>
<div class="right">
<input type="submit" id="submit" name="Submit" value="完成注册" disabled="disabled"/>
<div class="readagreement-wrap" onclick="onReadAgreementClick();">
<input type="checkbox" name="agree" id="agree" onchange="v_submitbutton();" />
同意《<a id="readagreement" href="#agreement" onclick="showAgreement();" title="查看用户使用协议">用户使用协议</a>》
</div>
<div>已经拥有账号，<a href="/e/member/login/">直接登录</a></div>
<div><a href="/e/memberconnect/?apptype=qq" target="_blank"><img src="/e/memberconnect/qq/images/qqlogin.gif" border="0"></a></div>
</div>
</form>
</div>
<div id="agreement" class="agreement" style="display:none;">
<h1>用户使用协议</h1>
<iframe src=""></iframe>
<input type="button" value="同意" onclick="agree();"/>
<a href="#" class="backtotop" >返回顶部</a>
</div>
</body>
</html>
<style>* { font-family:"微软雅黑","黑体","宋体"; color:#333;}
a {color:#069;}
body {margin:0; padding:0; background:#f3f3f3;}
.form-bak {width:800px; height:400px; margin:40px auto; background:#eee; border-radius:10px; box-shadow:0 2px 8px #999;}
.left {float:left; width:500px; height:400px;}
.line {width:100%; height:80px; margin:16px 0 0 0;}
.info {float:left; height:100%; width:200px;}
.info strong, .info span {display:block; text-align:right;}
.info strong {font-size:24px; line-height:36px; margin-top:10px; color:#333; }
.info span {font-size:12px; line-height:24px; color:#666; font-family:"微软雅黑","宋体"; }
.input input {background:none; border:none; outline:none; font-size:18px; line-height:40px; height:40px; width:240px; padding:9px 0 9px 9px; border-radius:10px;}
.input {float:right; width:278px; height:58px; background:#f6f6f6; border:1px solid #999; border-radius:10px; box-shadow:inset 0 2px 5px #999; margin:10px 0; position:relative; }
.error,.corect {height:20px; width:20px; position:absolute; top:19px; right:9px; background:url("/images/login/js/ICON_20.svg") no-repeat 0 -20px;}
.error span {display:block; position:absolute; top:30px; right:20px; background:#fcc; border:1px solid #f33; font-size:12px; line-height:16px; color:#600; padding:6px 10px 4px 10px; border-radius:5px; opacity:.8; white-space:nowrap; overflow:hidden;}
.corect {background-position:0 0;}
.corect span{display:none;}
.none {display:none;}

.right {float:right; width:260px; height:360px; margin:20px 0 0 0; border-left:1px solid #ccc;}
input[type=submit] {background:none; border:none; outline:none; margin:0; padding:0; cursor:pointer;
font-size:40px; height:200px; width:200px; background:#369; margin:20px 30px 0 30px; color:#eee;}
input[type=submit]:disabled {background:#999; cursor:no-drop;}
.right div { margin:0 30px; width:200px; height:30px; line-height:30px; text-align:center;}
.readagreement-wrap {margin:20px 30px!important; outline:1px solid #f99;}

#top h1 {font-size:30px; line-height:40px; padding:10px; text-align:center;}
.agreement,#top {width:800px; margin:20px auto; background:#eee; border-radius:10px; box-shadow:0 2px 8px #999; text-align:center;}
.agreement h1 {display:block; font-size:24px; line-height:30px; padding:20px 20px 10px 20px; margin:0; color:#333; text-align:center;}
.agreement iframe { width:760px; min-height:400px; margin:0 20px 20px 20px; border:none; outline:none;}
.agreement .backtotop {display:block; line-height:20px; padding:10px; text-align:center;}</style>
<script>function enableSubmit(bool){
if(bool)$("#submit").removeAttr("disabled");
else $("#submit").attr("disabled","disabled");
}
function v_submitbutton(){
if($("#agree").attr("checked")!="checked") {
enableSubmit(false);
$(".readagreement-wrap").css("outline","1px solid #f99");
return;
}else{$(".readagreement-wrap").css("outline","1px solid #9f9");}
for(f in flags) if(!flags[f]) {enableSubmit(false); return;}
enableSubmit(true);
}
function showAgreement(){
$("#readagreement").removeAttr("onclick");
$("#agreement").show();
$("#agreement iframe").attr("src","/xieyi.htm");
}
function agree(){
$("#agreement").hide();
$("#readagreement").attr("onclick","showAgreement();");
if($("#agree").attr("checked")!="checked") $("#agree").trigger("click");
}
function onReadAgreementClick(){
return;
if($("#agree").attr("checked")){
$("#agree").removeAttr("checked");
}else{
$("#agree").attr("checked","checked");
}
v_submitbutton();
}
var flags = [false,false,false,false];
//邮箱验证，网上找到的正则
var RegEmail = /^([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+\.[a-zA-Z]{2,3}$/;
function lineState(name,state,msg){
if(state=="none"){$("#line_"+name+" .input div").attr("class","none"); return;}
if(state=="corect"){$("#line_"+name+" .input div").attr("class","corect");return;}
$("#line_"+name+" .input span").text(msg);$("#line_"+name+" .input div").attr("class","error");
}
function v_account(){
var account = $("#account").val();
if(!RegEmail.test(account)) {lineState("account","error","邮箱格式不正确"); flags[0]=false;enableSubmit(false);}
else{lineState("account","corect","");flags[0] = true;}
v_submitbutton();
}
function v_name(){
var name = $("#name").val();
if(name.length==0) {lineState("name","error","不得为空"); flags[1]=false;}
else{
if(name.length>30) {lineState("name","error","必须少于30个字符"); flags[1]=false;}
else{lineState("name","corect",""); flags[1] = true;}
}
v_submitbutton();
}
function v_password(){
var password = $("#password").val();
if(password.length<6) {lineState("password","error","必须多于或等于6个字符"); flags[2]=false;}
else{
if(password.length>30){lineState("password","error","必须少于或等于30个字符"); flags[2]=false;}
else{
lineState("password","corect","");
flags[2] = true;
}
}
v_repeat();
v_submitbutton();
}
function v_repeat(){
if(!flags[2]) {lineState("repeat","none",""); return;}
if($("#password").val()!=$("#repeat").val()) {lineState("repeat","error","密码不一致"); flags[3]=false;}
else{
lineState("repeat","corect","");
flags[3] = true;
}
v_submitbutton();
}

function adaptValue(){
return true;
}</script>

你是哪里报错没看到你插入数据库只看到你访问微信的远程连接

你把这一句的sql语句打印出来看看
$sql=$empire->query("select openid from {$dbtbpre}enewsmember where openId = $openId limit 1");

你说你存不进去却不把存入的代码发出来出错的环节有很多啊你的数据处理有问题 sql执行有没有报错你使用的还是封装好的sql类那这个类有没有问题调用方式有没有问题这个都有影响啊