douan8473 2015-05-11 17:51 采纳率: 100%
浏览 86
已采纳

可捕获的致命错误:类mysqli的对象无法转换为字符串

I was trying to create a Registration form for my project but unfortunately i got this error while i could not find any error in the code!Please help me to get ride from this Issue !

my code

<?php

// this file is connected with regform.php
    $firstname= $_POST['firstname'];
    $lastname =$_POST['lastname'];
    $email =$_POST['email'];
    $password =$_POST['password'];
    $confirmpassword =$_POST['confirmpassword'];
    $address =$_POST['address'];
    $balance =$_POST['balance'];
    $password_hash = md5($password);

$bookConn = mysqli_connect("localhost", "root","", "bookstore") OR die("wrong execution");

    $queryS = "SELECT Email FROM customer";
    $resultSQ = mysqli_query($bookConn , $queryS);
    $flag=0;

while($row=mysqli_fetch_array($resultSQ))
{
    if($email == $row['Email'])
    {
        $flag=1;
    }
}

    if($flag==0)
    {
            if($password == $confirmpassword)

        {
            $query = "INSERT INTO  user (firstName , LastName ,Email , Password , Address , Balance )values('".$firstname."', '".$lastname."' ,'".$email."' , '".$password_hash."', '".$address."' , '".$balance."')";
            $result = mysqli_query($bookConn , $query) OR die($bookConn);

             if ($result)
                {
                    echo "successfuly Registered";
                }

            else {
                    echo "something went wrong!";
                 }
        }

        else{
            echo "Passowrd does not match!";
            }
    }

else{

        echo "Email is already existed in the Database!";

    }
mysqli_close($dbc);
?>
  • 写回答

1条回答 默认 最新

  • duanjun7801 2015-05-11 18:15
    关注

    There are two error seems in your code:-

    1. mysqli_close($dbc). You never created $dbc in your code. It must be mysqli_close($bookConn).

    2. You need to modified your last mysqli_query like this:-

      $result = mysqli_query($bookConn , $query) OR die(mysqli_error($bookConn));

    Note:- I hope by doing these changes you will get rid of your proble. Thanks.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 应用简单的Python代码完成一个学生成绩管理系统
  • ¥15 用matlab求微分方程初值问题
  • ¥15 vscode下编写第三方库opencv与pcl代码时没有代码提示
  • ¥15 能够跑通不报错,如何解决?(标签-matlab)
  • ¥15 MOS在RDS较大,频率高时开关波形异常
  • ¥15 SCENIC分析报错求解答
  • ¥15 ceph初始化mon不成功 下图不报错 这个是什么元
  • ¥15 数学建模数学建模少ai
  • ¥35 这个等效电路图是什么意思?(答疑)(有没有不是chat的,我就是在chat搜不到才来问的,chat还开了VIP)(可以追加酬金)
  • ¥200 基于同花顺supermind的量化策略脚本编辑