我正在尝试为我的网站运行脚本,我得到了一个没有错误的白色屏幕,我已经尝试使用运行该脚本
error_reporting(E_ALL);
ini_set('display_errors',TRUE);
但我仍然没有错误,我不能访问php.ini,因为我使用的是godaddy。
//Get ITID from URL
$iITID = $_GET["ITID"];
$oteaminfo = mysql_query("
SELECT .Players.FirstName, Players.LastName, Players.Position, Players.Height, Players.Weight, .Players.DOB, Countries.Nation, NHLTeams.Team, ; ; ; InternationalTeam.InternationalTeam, InternationalLeagues.InternationLeague, CNGHLTeams.CNGHLRights
From Players
Inner Join InternationalTeam
On Players.ITID=InternationalTeam.ITID
Inner Join InternationalLeagues
On Players.ILID=InternationalLeagues.ILID
Inner Join Countries
On Players.NationID=Countries.NationID
Inner Join NHLTeams
On Players.TeamsID=NHLTeams.TeamID
Inner Join CNGHLTeams
On Players.CNGHLID=CNGHLTeams.CNGHLID
WHERE InternationalTeam.InternationalTeam=$iITID
ORDER BY Players.LastName;
") or die(mysql_error());
while($row = mysql_fetch_array($oteaminfo))
{
Print "Player Name: ".$row['FirstName']." ".$row['LastName']."<br>";
Print "Position: ".$row['Position']."<br>";
Print "Height: ".$row['Height']."<br>";
Print "Weight: ".$row['Weight']."<br>";
Print "Birthdate: ".$row['DOB']."<br>";
Print "Nationality: ".$row['NationID']."<br>";
Print "NHL Rights: ".$row['Team']."<br>";
Print "CNGHL Team: ".$row['CNGHLRights']."<br>";
}
?>
脚本缺少Players.Weight, .Players.DOB, Countries.Nation, NHLTeams.Team, InternationalTeam.InternationalTeam, InternationalLeagues.InternationLeague, CNGHLTeams.CNGHLRights
因为它不允许我缩进它以显示为脚本。我试着查找这个问题,但在我的情况下,似乎找不到任何能帮助我的东西。任何帮助都将不胜感激。
我认为这是SQL 的开始
SELECT .Players.FirstName, Players.LastName, Players.Position
搞砸了。更正后的SQL应该像一样
SELECT Players.FirstName, Players.LastName, Players.Position
而且,当您试图在页面上打印结果时,最好使用echo
而不是print
。并且,print
应该是print
而不是Print
。PHP区分大小写。
此外,根据PHP手册,不推荐使用mysql_
命令。最好使用mysqli_
命令或PDO。
尝试ini_set('display_errors','On');基本上,自从PHP的最新版本以来,您可以定义每个级别的错误可见性,但这一行应该可以做到
如果有帮助,请告诉我,如果没有帮助,我可能会使用PDO和try-catch块重写您的代码,这样您将能够引发异常,并且通常您的代码将更加安全。
http://php.net/manual/en/book.pdo.php