Hello,

Can you please send me the files again? I just formatted and installed
Windows XP Pro and I thought exporting my email would also export the
attachments but I guess not. Thanks!

Thanks,
Stephen

-----Original Message-----
From: Debbie Dyer [mailto:[EMAIL PROTECTED]] 
Sent: None
To: Stephen Craton
Subject: Re: [PHP] Member's Area Script

Stephen
 
I didn't have time to go through all the code so I have sent you an
example of a logn/logout/test page.
 
Notice that when logging in the password is checked using the PASSWORD
function - you must insert passwords using PASSWORD or MD5 or some kind
of encryption - storing unencrypted passwords is bad.
 
It will easy to insert your pics/text around this skeleton.
 
Any questions let me know.
 
Debbie

----- Original Message ----- 
From: Stephen Craton 
To: 'debbie_dyer' 
Sent: Monday, September 30, 2002 12:53 PM
Subject: RE: [PHP] Member's Area Script

Here are the files. The 278 B file is the connections file and needs to
go into a folder called Connections.

Thanks,
Stephen
http://www.melchior.us
http://php.melchior.us

:: -----Original Message-----
:: From: debbie_dyer [mailto:[EMAIL PROTECTED]] 
:: Sent: Monday, September 30, 2002 1:55 AM
:: To: Stephen Craton
:: Subject: Re: [PHP] Member's Area Script
:: 
:: 
:: Stephen
:: 
:: Send me back the script/s as an attachment and I will see if 
:: I can see what the problem is.
:: 
:: Debbie
:: 
:: ----- Original Message -----
:: From: "Stephen Craton" <[EMAIL PROTECTED]>
:: To: "'debbie_dyer'" <[EMAIL PROTECTED]>; 
:: <[EMAIL PROTECTED]>
:: Sent: Monday, September 30, 2002 2:22 AM
:: Subject: RE: [PHP] Member's Area Script
:: 
:: 
:: > I'm having the error again this time on my webserver. I 
:: have it set as 
:: > a global variable but it's not working. It can be found at 
:: > http://mom.melchior.us. Type in test for the username and 
:: password. 
:: > Why???
:: >
:: > Thanks,
:: > Stephen
:: > http://www.melchior.us
:: > http://php.melchior.us
:: >
:: > :: -----Original Message-----
:: > :: From: debbie_dyer [mailto:[EMAIL PROTECTED]]
:: > :: Sent: Saturday, September 28, 2002 6:03 PM
:: > :: To: [EMAIL PROTECTED]
:: > :: Subject: Re: [PHP] Member's Area Script
:: > ::
:: > ::
:: > ::
:: > ::   $conn = $main; <- that line is the problem - you cant use
:: > :: global vars inside functions without declaring them as global
:: > ::
:: > :: ----- Original Message -----
:: > :: From: "Stephen Craton" <[EMAIL PROTECTED]>
:: > :: To: <[EMAIL PROTECTED]>
:: > :: Sent: Saturday, September 28, 2002 11:49 PM
:: > :: Subject: [PHP] Member's Area Script
:: > ::
:: > ::
:: > :: > Hello again,
:: > :: >
:: > :: > I'm trying to write a script that has a member's area in
:: > :: it. So far
:: > :: > I've been able to successfully validate only one username
:: > :: and only one
:: > :: > password but now I'm going big and trying to compare it
:: > :: with a table
:: > :: > in my MySQL database. Everything goes nice and smooth
:: > :: until I actually
:: > :: > try and enter in my username and password. I type it 
:: in, copy and
:: > :: > paste, whaetever and it tells me the error I wanted it to say 
:: > "The
:: > :: > username and password is not a good combo." I've copied
:: > :: and pasted the
:: > :: > username and password from the database directly yet it
:: > :: still gives me
:: > :: > this error. Here's my code for the login() function that
:: > :: logs the user
:: > :: > in:
:: > :: >
:: > :: > function login($username, $password)
:: > :: > {
:: > :: >   $conn = $main;
:: > :: >   if (!$conn)
:: > :: >     return 0;
:: > :: >
:: > :: >   $result = mysql_query("select * from user
:: > :: >                          where username='$username'
:: > :: >                          and passwd = '$password'");
:: > :: >   if (!$result)
:: > :: >      return 0;
:: > :: >
:: > :: >   if (mysql_num_rows($result)>0)
:: > :: >      return 1;
:: > :: >   else
:: > :: >      return 0;
:: > :: > }
:: > :: >
:: > :: > Here's the code for the part that calls the login() function:
:: > :: >
:: > :: > if(login($user, $pass))
:: > :: > {
:: > :: > $valid_user = $user;
:: > :: > session_register("valid_user");
:: > :: > }
:: > :: > else
:: > :: > {
:: > :: > echo "<font face='Arial, Helvetica, sans-serif'
:: > :: > size='3'><center><b>You supplied an invalid username 
:: and password
:: > :: > combo. Try again please.</b></center>"; exit;
:: > :: > }
:: > :: >
:: > :: > And here's the part that connects to the database:
:: > :: >
:: > :: > <?php
:: > :: > # FileName="Connection_php_mysql.htm"
:: > :: > # Type="MYSQL"
:: > :: > # HTTP="true"
:: > :: > $hostname_main = "localhost";
:: > :: > $database_main = "mom";
:: > :: > $username_main = "root";
:: > :: > $password_main = "";
:: > :: > $main = mysql_pconnect($hostname_main, $username_main,
:: > :: $password_main)
:: > :: > or die(mysql_error()); ?>
:: > :: >
:: > :: > Does anyone see why it's doing this to me? Please help!!
:: > :: >
:: > :: > Thanks,
:: > :: > Stephen
:: > :: > http://www.melchior.us
:: > :: > http://php.melchior.us
:: > :: >
:: > :: >
:: > :: >
:: > :: > --
:: > :: > PHP General Mailing List (http://www.php.net/)
:: > :: > To unsubscribe, visit: http://www.php.net/unsub.php
:: > :: >
:: > ::
:: > ::
:: > :: --
:: > :: PHP General Mailing List (http://www.php.net/)
:: > :: To unsubscribe, visit: http://www.php.net/unsub.php
:: > ::
:: > ::
:: >
:: >
:: >
:: > --
:: > PHP General Mailing List (http://www.php.net/)
:: > To unsubscribe, visit: http://www.php.net/unsub.php
:: >
:: 
:: 
:: 




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to