Urgent Help

susi

hi
im having trouble with a project im doing! its a website! im a newbie to this so please bear with me...

when a person logs in as a new member! the information is sent to my database..

what i want to do is be able to display their information on a members page when they log in..

any ideas how 2 go about this??
any good tutorials or anything?
very stuck! 🙁

thanks in advance!

timbr8ks

I'm going to assume for the moment that people have to provide a username and password when they sign up. If not, they must be providing some unique identifier, such as email address.

Having said that, when they create a new account, you'll want to verify that the username is unique by looking at your database to determine if anyone already has it. If they do, you take them back to the first page with a message telling them that the username is not unique, try again. If it is unique, you insert a new record into your database with the new username and password (and first name, last name, email address, and whatever else you're collecting).

Immeidately thereafter, you search your database to get the user_id -- make sure every record in your database has an id -- for the person with that username.

Now that you know that, you can set a cookie (see the manual at php.net to learn how). It is best not to set the cookie with the actual ID. Rather, you should encrypt it or use some kind of multiplier on the user_id so that the cookie does not display the acutal user_id. (Someone could change their cookie to access someone else's records.)

With the cookie set, you can run a script at the top of every page looking for the cookie, and looking up the person's name based on the id in the cookie. If you're using a multiplier on the id #, you'll need to divide the cookie value by that same multiplier to get back to the user_id #.

I hope this helps.

susi

yeah.. its a username/password login.
im creating a football site which when a person registers.. they get 2 pick 11 players.. this goes to my database.

when i log in using user/pass it goes to the members area.

i want it to display the 11 players on that page for that member!
im using sessions

i have the following query in my members page

$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]";
$result = mysql_query($qstr);

but then how do i call it??
get the name of the player1 to appear on the members area!

thank you in advance

😕

Islefyord

I am doing something similar using the following code.


// Get Query
$result = mysql_query("SELECT * FROM main WHERE `Type` = 'Plate'",$db);
// All details from Main Table with Type of Plate
if ($myrow = mysql_fetch_array($result)) {

// Diplay results as a table
echo "<table border=1 cellspacing=0 bgcolor=#000000 BORDERCOLOR=#ffffff>\n";


//Table header
echo "<tr><td>Name</td><td>Race</td><td>Class</td><td>Lvl</td><td>Armour Type</td><td>Head</td><td>Chest</td><td>Arms</td><td>Wrist 1</td><td>Wrist 2</td><td>Hands</td><td>Legs</td><td>Feet</td></tr>\n";

do {
//Table Contents
   printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
		$myrow["Name"], $myrow["Race"], $myrow["Class"], $myrow["Level"], $myrow["Type"], $myrow["Head"], $myrow["Chest"], $myrow["Arms"], $myrow["Wrist1"], $myrow["Wrist2"], $myrow["Hands"], $myrow["legs"], $myrow["feet"]);

} while ($myrow = mysql_fetch_array($result)) ;
echo "</table>\n";
} else {

   echo "<p>Sorry, no results were found!";

}



?>

What it does is display all fields in the main table with a type of 'plate'. I guess you could rearrange this to give you all Player Names Where MemberID = 'x'

Hope this helps, if not would be interested to know how you do it.

susi

thanks for the help but it didn't work!
got errors!
any other suggestions????

🙁

Dean_Glass

Hi,

I'm also a newbie and am just starting out with PHP as well. I am creating a CVtool where users can logon and create/edit etc their CV's. This is my code that works.

<?php
#if valid entries from form - set variables to entered values
if ($_POST['username'] && $_POST['userpass']) {
 	$name = $_POST['username'];
 	$pass = $_POST['userpass'];
	$_SESSION['session'] = $name;

}
#creating input area
echo("<p><font size='4'>Enter login details:</font>");
echo("<form action='".$PHP_SELF."' method='post'>");
echo("User Name: <input type=\"text\" name=\"username\" size='8'>");
echo("Password: <input type=\"text\" name=\"userpass\" size='8'><br><br>");
echo("<input name=\"submit\" type=\"submit\" value=\"Enter\">");
echo("</form>");
echo("</p>");

# Ensuring that all fields have entries
if ($name and $pass)
{ 
	#Connect to MySQL
	$conn=@mysql_connect("localhost","****","*****")
							or die("Sorry no connection");

#Select the specified database
$rs = @mysql_select_db("cvtest", $conn)
		or die("Database not located");

#Create the query
$sql="select * from candidate where uname = '$name' and password = '$pass' ";

#execute the query
$rs = @mysql_query($sql,$conn)
		 or die(mysql_error());

#Get number of rows that match uname and pass
$num = mysql_numrows($rs);

#If matched, then log in authenticated
if($num !=0)
	{ echo ("Logged in as : ".$name." ");
		echo ("<p><a href=getdata.php>Edit Personal Details</a></p>");
		echo ("<p><a href=cvmain.php>View existing CVs</a></p>");
		echo ("<p><a href=cvmain.php>Create CV</a></p>");	
	}
else
	{ echo ("Log-in failed - Username or Password incorrect!");}
}
?>
<html>
<head>
<title>LOGIN AUTHENTICATION</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
</body>
</html>

Hope it helps.

susi

thanks for all the help so far but i have that working!

my problem is the displaying of information that is in the database for that particular member in the members page!

its in da database.. i just don't know how to properly call it and display it!!!

Islefyord

What errors did you get?

Looking at what I put, you have to declare username, password and db previous to my code. I personally have a db.inc file and then put include 'db.inc' in the header.

<?php include 'db.inc'

?>

<?php 

$db = mysql_connect("localhost", $username, $password);
mysql_select_db("tsm1",$db);

?>

The db.inc file looks like

<?php
   $hostName = "localhost";
   $databaseName = "tsm1";
   $username = "username";
   $password = "password";

   function clean($input, $maxlength)
   {
      $input = substr($input, 0, $maxlength);
      $input = EscapeShellCmd($input);
      return ($input);
   }
?>

reply with the errors you are getting and I'll try to work it out 🙂

susi

its ok!!!
i got it working finally!!! 🙂

it was basically....

include("connect2db.php");

Query execution

$result = mysql_query("SELECT * from members2 where username = '$SESSION_UNAME'");

Query detail specification

$row = mysql_fetch_array($result);

The player will be accessible as

echo $row['player1'];

thanks for everything though!!! 🙂