无法通过PHP脚本连接到GoDaddy mysqli数据库

问题描述：

一直在尝试多年，但只是无法让我的php脚本连接到我的GoDaddy服务器上的mysqli数据库。我检查过无数次的用户名，密码，数据库名称。这是脚本。感谢您的任何建议。无法通过PHP脚本连接到GoDaddy mysqli数据库

$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);

没有错误和输出，它不可能进行调试。 – Manikiran

if if（$ con> connect_error）{ die（'Connect Error：'。$ mysqli-> connect_error）; }发送到您的代码并向我们报告实际的错误消息。 – jeff

而且，只是为了挑选：它是一个MySQL数据库，而不是mysqli。 Mysqli是您在PHP中使用的数据库连接处理程序。 – junkfoodjunkie

答

你可以试试这个：（即使它不工作，就会ATLEAST显示错误，你所面临的）

<?php 
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); 
error_reporting(E_ALL); 
$con = new mysqli("localhost","username","password","Villa1234"); 
if ($con->connect_error) { 
    die("Connection failed: " . $con->connect_error); 
} 
$sql = "SELECT * FROM Prospects WHERE email = '$loginEmail'"; 
$result=$con->query($sql); 
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数据库

相关推荐