无法通过 PHP 脚本连接到 GoDaddy mysqli 数据库 [英] Can't connect to GoDaddy mysqli database via PHP script

问题描述

尝试了很长时间，但无法让我的 php 脚本连接到我的 GoDaddy 服务器上的 mysqli 数据库.我已经无数次检查过用户名、密码、数据库名称.这是脚本.感谢您提供任何建议.

Been trying for ages but just can't get my php script to connect to a mysqli database on my GoDaddy server. I've checked the username, password, database name countless times. Here's the script. Grateful for any advice.

$con = mysqli_connect("localhost","username","password","Villa1234");
$sql = "SELECT * FROM Prospects WHERE email = '$loginEmail'";
if ($result = mysqli_query($con,$sql)) {
    $rows = mysqli_num_rows($result);
    if ($rows == 1) {
        $firstRow = mysqli_fetch_assoc($result);
        $status = $firstRow['status'];
        $access = $firstRow['access'];
        $pid = $firstRow['prospect_ID'];
        if ($status == "Pending") {
            $loginResult = "pending";
        } else if ($access == "locked") {
            $loginResult = "locked";    
        } else {
            $storedPassword = $firstRow['password'];
            if ($storedPassword === $password) {
                $loginResult = "success";
                $firstName = $firstRow['firstname'];
                $_SESSION['loginEmail'] = $loginEmail;
            } else {
                $loginResult = "incorrect password";
            };
        };
    } else if ($rows == 0) {
        $loginResult = "email not registered";
    };  
};
mysqli_free_result($result);
mysqli_close($con); 

推荐答案

你可以试试这个:(即使它不起作用，它至少会显示你面临的错误)

You could try this: (Even if it doesn't work, it will atleast display the error you are facing)

<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
error_reporting(E_ALL);
$con = new mysqli("localhost","username","password","Villa1234");

$sql = "SELECT * FROM Prospects WHERE email = ?";
$stmt = $con->prepare($sql);
$stmt->bid_param("s", $loginEmail);
$stmt->execute();
$result = $stmt->bind_result();
if($result->num_rows==1){
    while($firstRow=$result->fetch_assoc()){
        $status = $firstRow['status'];
        $access = $firstRow['access'];
        $pid = $firstRow['prospect_ID'];
        if ($status == "Pending") {
        $loginResult = "pending";
        }
        else if ($access == "locked") {
        $loginResult = "locked";    
        }
        else {
        $storedPassword = $firstRow['password'];
        if ($storedPassword === $password) {
            $loginResult = "success";
            $firstName = $firstRow['firstname'];
            $_SESSION['loginEmail'] = $loginEmail;
        } else {
            $loginResult = "incorrect password";
        }
        }
    }
}
else if ($rows == 0) {
    $loginResult = "email not registered";
}
?>

这篇关于无法通过 PHP 脚本连接到 GoDaddy mysqli 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！