public function addemail(){
$email_name=$_POST['name'];
$email_email=$_POST['email']; $con=mysqli_connect("localhost","root","root","bottlelover")
or die('connect error'); mysqli_set_charset($con,"utf8"); $sql="SELECT * FROM email_list WHERE email_email = $email_email";
$result=mysqli_query($con,$sql)
or die('query1 error'); if($row=mysqli_fetch_array($result)){
$this->assign("res",'邮箱已被使用,用户添加失败');
mysqli_close($con);
$this->display("Bottleloveradd");
}
else {
$sql="INSERT INTO email_list(email_name,email_email) VALUES ('$email_name','$email_email')";
$result=mysqli_query($con,$sql)
or die('query2 error');
$this->assign("res",'新用户添加成功');
mysqli_close($con);
$this->display("Bottleloveradd");
}
}--------------------------------------------以上是代码--------------------------------------------------------我的本意是添加新用户之前要检查邮箱是不是已经被使用,
$sql="SELECT * FROM email_list WHERE email_email = $email_email";
$result=mysqli_query($con,$sql)
or die('query1 error');
这段代码提示query1 error错误,其他运行正常;为什么,明显没有错啊,表名没错,列名没错,变量名都没错.....
$email_name=$_POST['name'];
$email_email=$_POST['email']; $con=mysqli_connect("localhost","root","root","bottlelover")
or die('connect error'); mysqli_set_charset($con,"utf8"); $sql="SELECT * FROM email_list WHERE email_email = $email_email";
$result=mysqli_query($con,$sql)
or die('query1 error'); if($row=mysqli_fetch_array($result)){
$this->assign("res",'邮箱已被使用,用户添加失败');
mysqli_close($con);
$this->display("Bottleloveradd");
}
else {
$sql="INSERT INTO email_list(email_name,email_email) VALUES ('$email_name','$email_email')";
$result=mysqli_query($con,$sql)
or die('query2 error');
$this->assign("res",'新用户添加成功');
mysqli_close($con);
$this->display("Bottleloveradd");
}
}--------------------------------------------以上是代码--------------------------------------------------------我的本意是添加新用户之前要检查邮箱是不是已经被使用,
$sql="SELECT * FROM email_list WHERE email_email = $email_email";
$result=mysqli_query($con,$sql)
or die('query1 error');
这段代码提示query1 error错误,其他运行正常;为什么,明显没有错啊,表名没错,列名没错,变量名都没错.....
解决方案 »
- 求助!SQL语句没反应!!!
- Programmer and co-founder needed(PHP)-北京
- 请问大家一个问题哈,<a href="a.rar">下载</a>
- 面试PHP程序员什么一般要问什么比较好啊?
- 一条SQL语句如何求环比!这个月简历数减去上个月的(如图)
- 奇怪,最近也碰到session问题了:session为什么不能传递?
- 求助关于eval函数的一个小问题。
- 哪位大哥用过fsockopen函数
- 问一个传递变量值的问题
- 关于视频直播(websocket+php)
- 客户端怎么通过页面操作数据库?
- sprintf('%04b', $forumlink['type']);这句话是什么意思?
3Q , 我已经改正过来了,但是遇到了另一个问题,
if($row=mysqli_fetch_array($result)){
$this->assign("res",'邮箱已被使用,用户添加失败');
mysqli_close($con);
$this->display("Bottleloveradd");
}这段代码为什么一运行就提示localhost断开连接?
if($row=mysqli_fetch_array($result)){
$this->assign("res",'邮箱已被使用,用户添加失败');
mysqli_close($con);
$this->display("Bottleloveradd");
}这段代码为什么一运行就提示localhost断开连接?
3Q , 我已经改正过来了,但是遇到了另一个问题,
if($row=mysqli_fetch_array($result)){
$this->assign("res",'邮箱已被使用,用户添加失败');
mysqli_close($con);
$this->display("Bottleloveradd");
}这段代码为什么一运行就提示localhost断开连接?