会員登録すると、上記エラーが帰ってきます。
Notice: Trying to get property of non-object in 23行目
if($result->num_rows == 0)
宜しくお願いいたします。
<?php session_start(); require_once("db.php"); //If user clicked register button if(isset($_POST)) { //Escape Special Characters In String First $companyname = mysqli_real_escape_string($conn, $_POST['companyname']); $headoffice = mysqli_real_escape_string($conn, $_POST['headoffice']); $phone = mysqli_real_escape_string($conn, $_POST['phone']); $website = mysqli_real_escape_string($conn, $_POST['website']); $companytype = mysqli_real_escape_string($conn, $_POST['companytype']); $email = mysqli_real_escape_string($conn, $_POST['email']); $password = mysqli_real_escape_string($conn, $_POST['password']); //Encrypt Password $password = base64_encode(strrev(md5($password))); $sql = "SELECT email FROM comapany WHERE email='$email'"; $result = $conn->query($sql); ※エラーNotice: Trying to get property of non-object in ↓ if($result->num_rows == 0) { $sql = "INSERT INTO company(companyname, headoffice, phone, website, companytype, email, password) VALUES ('$companyname', '$headoffice', '$phone', '$website', '$companytype','$email', '$password')"; if($conn->query($sql)==TRUE) { $_SESSION['registerCompleted'] = true; header("Location: company-login.php"); exit(); } else { echo "Error" .$sql . "<br>" . $conn->error; } } else { $_SESSION['registerError'] = true; header("Location: company-register.php"); exit(); } $conn->close(); } else { $_SESSION['registerError'] = true; header("location: company-register.php"); exit(); }ソースコードは ``` バッククォート3つで囲んで、読みやすくしてから投稿してください
回答2件
あなたの回答
tips
プレビュー