Coding Forum

**Mankiy** · 04-01-2003, 08:58 PM

PHP Code:


			
<html>

<head>

<title>Login</title>

</head>



<body bgcolor="#FFFFFF" text="#000000">

<p><font face="Arial, Helvetica, sans-serif" size="5"><b>Login</b></font></p>



<form name="login" method="post" action="login.php"> 

Username: &nbsp; <input type="text" name="username" size="15" maxlength="15">

<br>

Password: &nbsp; <input type="password" name="password" size="15" maxlength="15">

<br><br>

          <input type="submit" name="Login" value="Login">

          <input type="reset" name="Clear" value="Clear">

</form>





<?php 

 // Connect to the database server 

include("config.php");



// Request the info of all the info

 $result = @mysql_query("SELECT username,password FROM members"); 

 if (!$result) { 

   echo("<p>Error getting information: " . mysql_error() . "</p>"); 

   exit(); 

 } 

?>







<?php

while ( $row = mysql_fetch_array($result)) {

  $dbusername = 'row["username"]';  

  $dbpassword = 'row["password"]';



  if (($username == $dbusername) && ($password == $dbpassword)){

//This is where it goes if the login is successful  

?>



  <script>

    window.location=http://members.lycos.co.uk/clanx/ex.php    

  </script>



<?php

} else {

//This is where it goes if the login fails

?>



  <script>

    window.location=http://members.lycos.co.uk/clanx/login.php    

  </script>



<?php

}

}

mysql_close(); 

?>

</body>

</html>

This doesnt seem to work for some reason

Will someone help me plz?

**shneak** · 04-02-2003, 08:58 AM

Here's the corrected code:

<?php
// Connect to the database server
include("config.php");

// Request the info of all the info
$result = @mysql_query("SELECT username,password FROM members");
if (!$result) {
echo("<p>Error getting information: " . mysql_error() . "</p>");
exit();
} else {

while ( $row = mysql_fetch_array($result)) {
$dbusername = $row[username];
$dbpassword = $row[password];

if (($HTTP_POST_VARS[username] == $dbusername) && ($HTTP_POST_VARS[password] == $dbpassword)){
header("Location: http://members.lycos.co.uk/clanx/ex.php");
} else {
header("Location: http://members.lycos.co.uk/clanx/login.php");
}

}
mysql_close();

?>

<html>
<head>
<title>Login</title>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<p><font face="Arial, Helvetica, sans-serif" size="5"><b>Login</b></font></p>

<form name="login" method="post" action="login.php">
Username:   <input type="text" name="username" size="15" maxlength="15">
<br>
Password:   <input type="password" name="password" size="15" maxlength="15">
<br><br>
<input type="submit" name="Login" value="Login">
<input type="reset" name="Clear" value="Clear">
</form>
</body>
</html>

**shneak** · 04-02-2003, 09:03 AM

Ooops... I mean HERE'S the corrected code

<?php
// Connect to the database server
include("config.php");

// Request the info of all the info
$result = @mysql_query("SELECT username,password FROM members");

if (!$result) {

echo("<p>Error getting information: " . mysql_error() . "</p>");

} else {

while ( $row = mysql_fetch_array($result)) {

$dbusername = $row[username];
$dbpassword = $row[password];

if (($HTTP_POST_VARS[username] == $dbusername) && ($HTTP_POST_VARS[password] == $dbpassword)){

header("Location: http://members.lycos.co.uk/clanx/ex.php");

} // endif

} // endwhile

} // endif

mysql_close();

?>

<html>
<head>
<title>Login</title>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<p><font face="Arial, Helvetica, sans-serif" size="5"><b>Login</b></font></p>

<form name="login" method="post" action="login.php">
Username: <input type="text" name="username" size="15" maxlength="15">
<br>
Password: <input type="password" name="password" size="15" maxlength="15">
<br><br>
<input type="submit" name="Login" value="Login">
<input type="reset" name="Clear" value="Clear">
</form>
</body>
</html>

**Mankiy** · 04-02-2003, 03:50 PM

but im not using HTTP access.......

Im using database authentication.......

**Mankiy** · 04-02-2003, 04:00 PM

wait, if its not HTTP access, whats the $HTTP_POST_VARS????

I havent gotten that far in PHP yet....

**david** · 04-02-2003, 05:44 PM

$HTTP_POST_VARS allows you to access the variables passed to the PHP script through the POST method of a form. You may have come across:
$variablename=$_POST['variable'];
or have just accessed variables using:
$variablename;
All of them work but the $HTTP_POST_VARS and $_POST are better programming style (and in later versions of PHP they are the only ones that work).

http://www.freewebmasterhelp.com/tutorials/php/6
has more info.

**Mankiy** · 04-02-2003, 06:56 PM

hmmm.......

still didnt work for me

Ah, Login scripts HATE me

**npr1211** · 08-30-2003, 05:45 AM

I am using login scripts! you probly need a new Database with this script! i can hook you up free!

E-mail me at brent@geeks2go.ca

and ill hook ya up in no time! and send me the Full script in a Zip file and ill fix it!

**stewis** · 08-30-2003, 06:44 AM

hi what kind of error you getting?

and change this line

PHP Code:


			
@mysql_query("SELECT username,password FROM members");

to

PHP Code:


			
mysql_query("SELECT username,password FROM members") or die (mysql_error());

tell me what error you get and maybe i can help more

btw i cant test your script atthe moment as i have just formated and i havnt installed my dev server yet, but i will when i get time later

**npr1211** · 08-31-2003, 07:54 PM

hey stewis u got any good login scripts? well loads of $#!T that i can use. i am pi$$ed about the one i am using.

**npr1211** · 08-31-2003, 07:55 PM

i am needing help installing Mysql if you know how i can use the help!

**npr1211** · 08-31-2003, 08:00 PM

i am going to download mysql soon so i need help when ever i can get it!

**npr1211** · 08-31-2003, 08:01 PM

anyone know where i can download the Full Mysql manual??? free!

**stewis** · 09-01-2003, 06:57 AM

umm http://www.mysql.com/downloads/downl...ip&pick=mirror - CHM manual

you may want to look at www.firepages.au.com for a full php/mysql/apache setup (only probs is its a little out of date php + apache)

Note: its not for production use just development

**stewis** · 07:16 AM

oh and as a reply Mankiys question try this code i havnt tested it but it should work:

PHP Code:


			
<?php

// Connect to the database server

include("config.php");



// Request the info of all the info

  $login = mysql_fetch_array(mysql_query("SELECT username,password FROM members LIMIT 1") or die(mysql_error()));

  $dbusername = $login["username"];

  $dbpassword = $login["password"];



if (($_POST["username"] == $dbusername) && ($_POST["password"] == $dbpassword))

{

    //This is where it goes if the login is successful

    header("location: http://members.lycos.co.uk/clanx/ex.php");

}

else

{

    //This is where it goes if the login fails

    ?>



    <html>

        <head>

            <title>

                Login

            </title>

        </head>



        <body bgcolor="#FFFFFF" text="#000000">

            <p>

                <font face="Arial, Helvetica, sans-serif" size="5">

                    <b>Login</b>

                </font>

            </p>

            <form name="login" method="post" action="login.php">

                Username: &nbsp; <input type="text" name="username" size="15" maxlength="15">

                <br>

                Password: &nbsp; <input type="password" name="password" size="15" maxlength="15">

                <br><br>

                <input type="submit" name="Login" value="Login">

                <input type="reset" name="Clear" value="Clear">

            </form>

        </body>

    </html>

    <?php

}

mysql_close();

?>