php script shows blank page
I wrote a forum script in PHP. My web host has PHP and MySQL installed. All of the databases have been set up. I have uploaded it to http://lightbulbproductions.net/forum_home.php. However, it gives me a blank page. Here is the code (note: the MySQL username and password has been replaced with admin and pass in this block of code. The real username/password ARE on the script that is on the server.)
Code:
<html>
<head>
<script language="javascript" type="text/javascript">
window.onload = function()
{
var trs = document.getElementsByTagName("tr");
for (var i = 0; i < trs.length; i++)
{
var tr = document.getElementsByTagName("tr")[i];
if (i == (parseInt(trs.length) - 1))
{
tr.innerHTML += '<a name="Most_Recent"></a>';
}
}
}
</script>
<title></title>
</head>
<body>
<h1>Posts</h1>
<a href="#Most_Recent">Most Recent</a> <a href="#Quick_Reply">Quick Reply</a> <a href="forum_form.htm">Advanced Reply</a><br />
<?php
$con = mysql_connect("localhost","admin","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("forum", $con);
$result = mysql_query("SELECT * FROM posts");
echo "<table border='1'>
<tr>
<th>Username</th>
<th>Title</th>
<th>Post</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Username'] . "</td>";
echo "<td>" . $row['Title'] . "</td>";
echo "<td>" . $row['Post'] . "</td>";
echo "</tr>";
}
echo "<a name="Most_Recent"></a></table>";
mysql_close($con);
?>
<br /><button onclick="location.reload()">Reload Posts</button>
<br /><a name="Quick_Reply">Quick Reply:
<form action="" method="post">
Username: <input name="username" id="username" type="text" /><br />
Password: <input name="pass" id="pass" type="password" /><br />
Post title: <input name="title" id="title" type="text" /> Text: <textarea name="post" id="post"></textarea>
<input type="submit" value="Submit"/>
</form></a>
<a href="forum_form.htm">Advanced Reply</a>
<?php
$username = $_POST["username"];
$pass = $_POST["pass"];
$title = $_POST["title"];
$post = $_POST["post"];
$con2 = mysql_connect("localhost","admin","password");
if (!$con2)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("forum", $con2);
$result = mysql_query("SELECT * FROM users
WHERE username == $username");
while($row = mysql_fetch_array($result))
{
echo '<p>Trying ' . $row['username'] . '<img src="ajax-loader.gif" width="220" height="19">';
if (($row['username'] == $username) && ($row['password'] == $pass))
{
echo 'Login Succeeded! Posting<img src="wait.gif" alt="Animated Loading Symbol" name="posting" id="posting" width="32" height="32">';
sql();
echo 'Posted!';
break;
} else {
echo 'Login failed.'
}
echo 'Moving on...';
}
mysql_close($con2);
function sql() {
$con3 = @mysql_connect("localhost", "admin", "password");
if (!$con3) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
} else {
mysql_query("INSERT INTO forum (user, title, post)
VALUES ($username, $title, $post)");
}
mysql_close($con3);
}
?>
</body>
</html>
