31.05.2012, 22:43
Hello guys. I started to make a PHP+MySQL Website, and made a registering system together with the help of a tutorial.
All works perfectly when simple, but when i try to makeup the design, it gives me errors. Not sure if the error comes from MySQL or PHP, but shoul be easy to solve to someone that actualy knows these languages good.
So let's take it to the point.
This works perfectly:
And this gives me this error:
http://i50.tinypic.com/2day7ah.png
And if i put the right user name and password:
http://i46.tinypic.com/acewt1.png
Thanks. It's the same with ALL other pages.. If i let them likke original, all works, if i change them to look better, this happens.
All works perfectly when simple, but when i try to makeup the design, it gives me errors. Not sure if the error comes from MySQL or PHP, but shoul be easy to solve to someone that actualy knows these languages good.
So let's take it to the point.
This works perfectly:
Код:
<?php
include("conf.inc.php"); // Includes the db and form info.
session_start(); // Starts the session.
if (!isset($_POST['submit'])) { // The form has not been submitted.
echo "<form action=\"login.php\" method=\"POST\">";
echo "<table>";
echo "<tr>";
echo "<td colspan=\"2\">Login:</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Username:</td><td width=\"50%\"><input name=\"username\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Password:</td><td width=\"50%\"><input name=\"password\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"2\"><input type=\"submit\" name=\"submit\" value=\"submit\"</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
} else {
$username = form($_POST['username']);
$password = md5($_POST['password']); // Encrypts the password.
$q = mysql_query("SELECT * FROM `users` WHERE username = '$username' AND password = '$password'") or die (mysql_error()); // mySQL query
$r = mysql_num_rows($q); // Checks to see if anything is in the db.
if ($r == 1) { // There is something in the db. The username/password match up.
$_SESSION['logged'] = 1; // Sets the session.
header("Location: site.php"); // Goes to main page.
exit(); // Stops the rest of the script.
} else { // Invalid username/password.
header("Location: login.php"); // Goes back to login page.
}
}
mysql_close($db_connect); // Closes the connection.
?>
http://i50.tinypic.com/2day7ah.png
And if i put the right user name and password:
http://i46.tinypic.com/acewt1.png
Код:
<BODY BGCOLOR = "#A0A0A0">
<div align="center">
<img src="http://images.cooltext.com/2643376.png" width="209" height="109" alt="Login" />
<br /></a>
<table border="5">
<tr>
<th>
<?php
include("conf.inc.php"); // Includes the db and form info.
session_start(); // Starts the session.
if (!isset($_POST['submit'])) { // The form has not been submitted.
echo "<form action=\"login.php\" method=\"POST\">";
echo "<table>";
echo "<tr>";
echo "<td colspan=\"2\">Login:</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Username:</td><td width=\"50%\"><input name=\"username\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Password:</td><td width=\"50%\"><input name=\"password\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"2\"><input type=\"submit\" name=\"submit\" value=\"submit\"</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
} else {
$username = form($_POST['username']);
$password = md5($_POST['password']); // Encrypts the password.
$q = mysql_query("SELECT * FROM `users` WHERE username = '$username' AND password = '$password'") or die (mysql_error()); // mySQL query
$r = mysql_num_rows($q); // Checks to see if anything is in the db.
if ($r == 1) { // There is something in the db. The username/password match up.
$_SESSION['logged'] = 1; // Sets the session.
header("Location: site.php"); // Goes to main page.
exit(); // Stops the rest of the script.
} else { // Invalid username/password.
header("Location: login.php"); // Goes back to login page.
}
}
mysql_close($db_connect); // Closes the connection.
?>