Re: [PHP-DB] MySQL Connect Problem

[Greg K]

Where you have your variable set to password just put  that means there
is no password other whys your saying your password is password
Jeff Oien [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I tried your code and got this:

 Warning: Can't connect to MySQL server on 'localhost'

 Also tried ip address of my machine. So at least maybe that narrows
 down the problem.
 Jeff Oien

  Hi Jeff,
  I am using Windows, but am a beginner.  Here is some code I use maybe it
  will help
 
  I use this in my navigation pages:
 
  ? include (db_details.php); ?
 
  ?
 
  mysql_pconnect($host,$user,$password)
  or die(Unable to connect to SQL server);
  mysql_select_db($dbasename) or die(Unable to select database);
  ?
 
  and here is db_details.php
 
  ?
  $host=host.name.com;
  $user=user_id;
  $password=password;
  $dbasename=database_name;
  ?
  By using the include it means if I go LIVE with a site I only have to
change
  one file db_details.php
  The reason I don't do it all in one is that it didn't like . in IP
  addresses for some reason ( I think it thought it was the beginning of a
  string)
  On my windows machine my db_details would look like this
  ?
  $host=localhost;
  $user=;
  $password=;
  $dbasename=database_name;
  ?
  You shouldn't need a password.
  I hope this helps
  All the Best
  Lisa
 
  -Original Message-
  From: Jeff Oien [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, May 17, 2001 2:16 PM
  To: PHP-DB
  Subject: RE: [PHP-DB] MySQL Connect Problem
 
 
  I'm on Windows 2000.
  Jeff
 
   Jeff,
  
   If you are on unix/linux use the command id to see who you are.
   You can only use jeff in your connect string if jeff is a user in your
  mysql
   database.
  
   If you are root when you are running mysql then you should probably
set a
   password for root in the database.
  
   Wayne
  
  
   On Thu, 17 May 2001 13:20, Jeff Oien wrote:
  Here is sample code:
  ?
  $connection = @mysql_connect(localhost, jeff, *)
  or die(Couldn't connect.);
  if ($connection) {
  $msg = success!;
  }
  ?
 
  This is on my machine only used by me. I also tried connecting
to
  IP address and 127.0.0.1 and it still won't work. Thanks.
  Jeff Oien

 Are your the 'root' rather than 'jeff'?  Did you alter the grants
and
 apply the password? If not do you need  a password for connection?

 Tim Morris
   
To be honest I don't know if I am root. I know I don't need a
password
to connect via the command line. I just type 'mysql'. I do have
username
and password specified in the .ini file which I believe I set when I
  first
installed it. What can I do from here?
Jeff Oien
  
   --
   Wayne Bastow - DBA - Central Coast Health Phone: 61 2 43203231
   Email: wbastowATccahsDOThealthDOTnswDOTgovDOTau
  
   Linux, the choice of a GNU generation Kernel 2.2.16-22 on a i686
  
   Running Windows on a Pentium is like having a brand new Porsche but
only
   be able to drive backwards with the handbrake on. (Unknown source)
  
   ==
   This message is intended for the addressee named and may contain
   confidential information. If you are not the intended recipient,
please
   delete it and notify the sender. Views expressed in this message are
   those of the individual sender, and are not necessarily the views of
   the NSW Department of Health.
   ==
  
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  To contact the list administrators, e-mail: [EMAIL PROTECTED]
 

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] function login problem

[Greg K]

I am creating a function called login, I have a main file called index.php
.. which has my login form , it calls a login.php file, and in that
login.php there is file include statement which calls config.php and that is
where the function lie. This is my function , now if i don't set this as a
function and just put it my login.php it works fine. But when I name the
function in put it in my config.php no matter what I do all ways giving me
the error You have entered an invalid username or password. I dont know if
this has to do with passing of variables.. or what is going on but if
something can please help me I would appreciate it ..

Thank You

  function login() {
$query=Select uname from members where pass='$pass'and uname='$username';
$result=mysql_query($query) or die(You are not authorized to be here.);
$array= @mysql_fetch_array($result);
$uname = $array[0];
if($uname==)
{
echo You have entered an invalid username or password;
}
else

{
echo You are logged in;
$remote_address = getenv(REMOTE_ADDR);
echo Your IP address is $remote_address.;
}
}



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] mail system

[Greg K]

I was wondering if anyone had any ideas on how I can setup a email system ,
internal using php and mysql only .. No Imap Server, or POP. Can someone
please guide me in the right direction ,, this is email sysetm would be only
for registered members. I am setting up a dating site.. Any help would be
appreciated

Thank You



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]