simple database + login script, help!!

[jasonpclaire]

Hi all. I am completely new to PHP and MySQL and this forum, so I hope someone can help. I have just installed xampp (completely out of the box as it were) and am having problems with a simple script. The script is below

<?php

        ini_set('display_errors', 1);
        $connx = mysql_connect("localhost", "root");
       
        if($connx)
        {
	    echo ("connected to database");	
        }
        else
       {
            die("DB connection failed: " . mysql_error());
        } 
?>

I have also created a DB called 'test' with a table called 'members' containing
(int)id=1,
(varchar)username="jpc",
(varchar)password="1234"

My question is how do I

(1) specify the database name so that the database test is chosen?
(2) specify the table members?
(3) cycle through records (I know SQL and a loop will be needed)

I am trying to create a login script that checks the DB and table and finds a match.

I tried to use connect statement out of various tutorial such as
$connx = mysql_connect("localhost", "jpc", "1234"); I can see the logic behind this statement but this give me the following error/warning when parsed

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'jpc'@'localhost' (using password: YES) in C:\xampp\htdocs\checklogin.php on line 13
DB connection failed: Access denied for user 'jpc'@'localhost' (using password: YES)

ANY and I mean ANY enlightenment you guys can give me would be great.

P.S. Do I need to change anything in xampp (I am using xampp 1.7.2 if this helps and I haven't messed around with anything it is just as installed)

Many thanks for your time and effort in advance
JPC

[Stefano Mtangoo]

Hi,
Here are simple procedure to make it happen
1. Connect to server

$host = "localhost";
$username = "root";
$password = "mypass";
$mydb = "testdb";
$connx = mysql_connect($host, $username, $password) or die("Cannot connect to server <br />".mysql_error());

2. select dabase (Like commandline USE)

mysql_select_db("$mydb") or die("Cannot select databaese $mydb <br />".mysql_error())

3. Query from whatever table you want from selected database

$query = "SELECT * FROM testTable ";
mysql_query($query) or die("Error:<br />".mysql_error())

Hope it helps :)

[jasonpclaire]

Wow, that was quick, will try it and let you know how I get on

many thanks for the reply

[Stefano Mtangoo]

If you hit any wall, I will be happy to lend support!

[jasonpclaire]

Thanks so much, I now am able to connect to my database. I have 4 records and can find each one. I still need to tinker but I think I'm getting there. Wow, thanks for the help and this great forum

I have also included my script here for anyone to use

<?php
$host = "localhost";
$username = "root";
$password = "";
$mydb = "test";
$tbl_name="members"; // Table name
$connx = mysql_connect($host, $username, $password) or die("Cannot connect to server <br />".mysql_error());


if($connx)
{
echo("connected to database");
}


if(!$connx)
{
echo("no connection found");
}


mysql_select_db("$mydb") or die("Cannot select databaese $mydb <br />".mysql_error());


//  $query = "SELECT * FROM members ";
//      mysql_query($query) or die("Error:<br />".mysql_error());


// hard coded to test initially
//  $myusername = "jpc";
//  $mypassword = "1234";


// these are passed from a main_login script, 2 boxes for username and password...comment out is using the hard code above


$myusername=$_POST;
$mypassword=$_POST;


// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);


// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row


if($count==1)
{
$_SESSION = true;
exit;
}
else
{
echo "Wrong Username or Password";
}
?>

I hope it helps others

[jasonpclaire]

Thanks, can I ask one more question.....

OK I think I'm nearly there with the login script and I came across the following code. I can see the logic in this part but when I have the following code in the script I get the following error

if($count==1)
{
session_register($myusername);
session_register($mypassword);
header("location:login_success.php");
//$_SESSION = true;    // this was the original script
//exit;                                         // this was the original script
}

Obviously 'login_success.php' is the next part I have to tackle...back burner for now....

ERRORs/WARNINGs


Warning: session_register() [function.session-register]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\checklogin.php:10) in C:\xampp\htdocs\checklogin.php  on line 42


Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\checklogin.php:10) in C:\xampp\htdocs\checklogin.php on line 44

These only happen when I introduce the above code in script otherwise I get nothing but a message saying that I have connected to the database (which is what I expect)

Once again thanks for your time, energy and advice in advance
JPC

[Stefano Mtangoo]

Your post is "simple...."
Make that simple one work and make it complex slowly

[jasonpclaire]

Your post is "simple...."
Make that simple one work and make it complex slowly

Hmmmm, I know what you mean, am trying to do that. Does this mean that the code above is not needed?

[Stefano Mtangoo]

What exactly do you want to do? Once we know the answer then we'll be able to suggest/help

[jasonpclaire]

What exactly do you want to do? Once we know the answer then we'll be able to suggest/help

Hi thanks for the reply. I want to proceed to the next php script making sure that the user is logged in. I think that the 'session_register's' and the 'header' statement has something to do with it but I get those errors

As far as I know these are legal statements and can't tell why I get the errors

Any insights?

if($count==1)
{
session_register($myusername);
session_register($mypassword);
header("location:login_success.php");
//$_SESSION = true; // this was the original script
//exit; // this was the original script
}

Thanks again for your time in advance
JPC

[Stefano Mtangoo]

want to tes if user is logged in right?
if yes then at very top of page add these line (before anything else)

session_start();
if($_SESSION['logged'] ){
    echo "You are logged in";
}
else{
//redirect to login page
header("Location:login.php");
}

and on your above code remember to remove exit after

$_SESSION['logged'] = true;

and add this

header("Location:members.php");

to redirect to members area.

Confused, just cry out and someone will answer ;)

[Stefano Mtangoo]

and both members.php and login.php should be in one place for above code to work without modification. Use code tags to make your code readable

[furqan219]

nice login script

[jasonwtanner]

Thanks for the code Jason! I've been trying to figure out how to do a login script as well and every time I've tried it, it's never recognized either the echo or if statements. I used your code and received a message, which is better than getting a message of nothing. Any help from anyone would be much appreciated.

Here is the message:
".mysql_error()); if($connx) { echo("connected to database"); } if(!$connx) { echo("no connection found"); } mysql_select_db("$mydb") or die("Cannot select databaese $mydb
".mysql_error()); // $query = "SELECT * FROM members "; // mysql_query($query) or die("Error:
".mysql_error()); // hard coded to test initially // $myusername = "jpc"; // $mypassword = "1234"; // these are passed from a main_login script, 2 boxes for username and password...comment out is using the hard code above $myusername=$_POST; $mypassword=$_POST; // To protect MySQL injection $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1) { $_SESSION = true; exit; } else { echo "Wrong Username or Password"; } ?>

[Stefano Mtangoo]

would you repost the code, this time wrapping into code-tags?