simple database + login script, help!!

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 :)

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

many thanks for the reply

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

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

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

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

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?

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

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

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 ;)

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

nice login script

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"; } ?>

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