Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

ERROR MESSAGE OVERLOAD

I am getting 5 seperate error messages when I execute my login page in Internet explorer. I am completly flumuxed by this. I've attached the code as well as all 5 error messages. Sorry for making so much work!

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php:4) in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 13

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php:4) in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 13

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 22

Warning: include(loginhtml) [function.include]: failed to open stream: No such file or directory in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 24

Warning: include() [function.include]: Failed opening 'loginhtml' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 24

<?php
$dbhost = "localhost";
$dbname = "users";
$dbuser = "root";
$dbpass = "pass";
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
 
session_start();
 
$username = $_POST[username];
$password = md5($_POST[password]);
 
$query = "SELECT * FROM users where username= $'username' and password= $'password'";
 
$result = mysql_query($query);
 
if (mysql_num_rows($result) != 1) {
$error = 'Bad Login';
    include login.html;
 
} else {
    $_SESSION[username] = '$username';
    include welcome.php;
}
 
?>

Open in new window

0
rafique12
Asked:
rafique12
  • 2
1 Solution
 
NerdsOfTechCommented:
Multiple Syntax errors: including:
* Misplaced quote errors
* Concatenation errors

Hope this revision helps you out.
<?php
$dbhost = "localhost";
$dbname = "users";
$dbuser = "root";
$dbpass = "pass";
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
 
session_start();
 
$username = $_POST["username"];
$password = md5($_POST["password"]);
 
$query = 'SELECT * FROM users where username= ' . $username . ' and password= ' . '$password';
 
$result = mysql_query($query);
 
if (mysql_num_rows($result) != 1) {
$error = 'Bad Login';
    include login.html;
 
} else {
    $_SESSION["username"] = $username;
    include welcome.php;
}
 
?>

Open in new window

0
 
NerdsOfTechCommented:
Correction on SQL Statement
<?php
$dbhost = "localhost";
$dbname = "users";
$dbuser = "root";
$dbpass = "pass";
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
 
session_start();
 
$username = $_POST["username"];
$password = md5($_POST["password"]);
 
$query = 'SELECT * FROM users where username= ' . $username . ' and password= ' . $password;
 
$result = mysql_query($query);
 
if (mysql_num_rows($result) != 1) {
$error = 'Bad Login';
    include login.html;
 
} else {
    $_SESSION["username"] = $username;
    include welcome.php;
}
 
?>

Open in new window

0
 
rafique12Author Commented:
That seems to have worked. Thanks guys!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now