Register / Login

**psycopatchet69** · Oct 5th, 2005, 04:44 PM

Ok, So I am just learning PhP, and I havent learned too much, but Im getting the basic Idea of it. I tend to work better when I have examples to look at.. Can someone help me out with some example code for a working user registration and Login page? I cant find any...Anywhere.

**ninjanutz** · Oct 5th, 2005, 06:12 PM

http://vbforums.com/showthread.php?t=358870

**lintz** · Oct 5th, 2005, 06:17 PM

Here is a basic login script. HTH

PHP Code:


<?php

$username = $_POST['username'];

$email = $_POST['email'];



if (!isset($_POST['submit'])) { // if form hasn't been submitted to itself then show form



?>

<html>

<head>

<title>Lintz's Test Login</title>

</head>



<body><center>

<b><font size="6">Please enter your username and email address to login</font></b> 

<p>

<form method="POST" action="<?php echo $PHP_SELF;?>">

<table border="1" style="border-collapse: collapse" bordercolor="#111111" width="580">

<tr>

<td width="580">

<table border="0" cellpadding="1" width="100%">

<td width="35%"><font face="Verdana" size="2"><b>Your Name:</b></font></td>

<td width="65%"><input type="text" name="username" size="65"></td>

</tr>

<tr>

<td width="35%"><font face="Verdana" size="2"><b>Email Address:</b></font></td>

<td width="65%"><input type="text" name="email" size="65"></td>

</tr>

<tr>

<td colspan="2" align="center"><br>

<input type="submit" value="Login" name="submit" style="font-family: Verdana; font-size: 10pt; font-weight: bold"></td>

</tr>

</table>

</td>

</tr>

</table>

</form>



<?

} 



else {



/*This is where you need to check the details the user has entered to make sure

they match what is in your database*/



if ($username == "UserName In Yr Database") {

//This shows the user who has submitted the detials, what details have been submitted.

echo "Thank you for logging in<p>";

echo "Your username is $username and your email address is $email.";

}



else {

echo "Login failed. Please check your details and try again";

}



}

?>

**ninjanutz** · Oct 5th, 2005, 07:08 PM

mine uses MySQL his doesnt...ur choice on wat u prefer

**lintz** · Oct 5th, 2005, 07:12 PM

Ninja, I was a little lazy

as I put a comment in saying to check the username entered is in his database.

**ninjanutz** · Oct 5th, 2005, 07:22 PM

o lol missed that part

**psycopatchet69** · Oct 5th, 2005, 07:24 PM

Wow, Thank you alot...Yeah, I would like to Use Sql, Ill take a look at the examples you guys gave me in a minute....Is there one for registering you could show me an example of too?

**lintz** · Oct 5th, 2005, 07:27 PM

Ninja's example does that as well

**psycopatchet69** · Oct 5th, 2005, 07:33 PM

Yes, I saw that, And thanks once again. I have one more thing I could use a little basic help on, Its alot easier to understand things with asking + examples then looking on all the sites I've been to. I just need some basics on Databases, Indexes, Auto Increments, and all that good junk...Surprisingly, I dont get it.

**ninjanutz** · Oct 5th, 2005, 07:57 PM

php.net and mysql.com have good things and remember...google is ur friend

**ninjanutz** · Oct 5th, 2005, 07:59 PM

indexes like array indexes? and auto increments like

<?php
if (x < 10)
{
x++;
}
echo "x";
?>

???? databases i dont really no but other ppl do

**psycopatchet69** · Oct 5th, 2005, 08:28 PM

Yes, ive been using google, but the tutorials and anything I find are too general, They dont have specifics on how to actually read from the DB and stuff, but Im sure i can find it if i spend some more time on it...

By indexes and Auto-Increments, I meant in the Database/Table itself....Like im going to be making a text-based RPG, And Its obviously going to use alot of tables....For now i think im going to be making one table, with all the info it in, And i need to know how to read/write from it so that i can look up the user's name and get their gold/army size....all that junk just from looking up their name.

**lintz** · Oct 5th, 2005, 08:44 PM

Try this.

PHP Code:


$sql = "SELECT * from YourTable WHERE userID = '1'"; //Tell database what to get     

$result   = mysql_query($sql) or die("Error getting user info<br>".mysql_error()); // Pulls what we want from the database 



//Now loop through all records from query



while ($UserDetails = mysql_fetch_row($result)) {



echo "$UserDetails[0]<br>"; //field one from table

echo "$UserDetails[1]<br>"; //field two from table

echo "$UserDetails[2]<br>"; //field three from table



}

**Pc_Madness** · Oct 5th, 2005, 08:46 PM

Originally Posted by psycopatchet69

Yes, ive been using google, but the tutorials and anything I find are too general, They dont have specifics on how to actually read from the DB and stuff, but Im sure i can find it if i spend some more time on it...

By indexes and Auto-Increments, I meant in the Database/Table itself....Like im going to be making a text-based RPG, And Its obviously going to use alot of tables....For now i think im going to be making one table, with all the info it in, And i need to know how to read/write from it so that i can look up the user's name and get their gold/army size....all that junk just from looking up their name.

Post what your table will look like and we'll try and give you a general idea on how to structure it. Generally the smaller the tables the better as it can take a long time to search through a really large table.

**psycopatchet69** · Oct 5th, 2005, 08:49 PM

Now can you please explain what that does? lol

More specific - I have a table named Info, and in the table there are 3 field, Name, Gold, Army....Now, How do I Tell it to take name = Psycopatchet, and return me the gold and army size? And also, How to locate those values for maniplulation.

**psycopatchet69** · Oct 5th, 2005, 08:57 PM

Ok, as an addon to my question(s), This may sound stupid..But in the "mysql_query($query,$link)" statement, I put a link to my database, right?

**lintz** · Oct 5th, 2005, 09:08 PM

A mod from my previous example.

PHP Code:


$sql = "SELECT * from Info WHERE Name = 'Psycopatchet'"; //Tell database what to get      

$result   = mysql_query($sql) or die("Error getting user info<br>".mysql_error()); // Pulls what we want from the database 



//Now loop through all records from query 



while ($UserDetails = mysql_fetch_row($result)) { 



echo "Name = $UserDetails[0]<br>"; //field one from table 

echo "Gold = $UserDetails[1]<br>"; //field two from table 

echo "Army = $UserDetails[2]<br>"; //field three from table 



}

**Pc_Madness** · Oct 5th, 2005, 09:34 PM

Originally Posted by psycopatchet69

Now can you please explain what that does? lol

More specific - I have a table named Info, and in the table there are 3 field, Name, Gold, Army....Now, How do I Tell it to take name = Psycopatchet, and return me the gold and army size? And also, How to locate those values for maniplulation.

User Table
User ID = Auto increment
Name = String
Any other person details

Info Table (you could probably think up a better name than that

)
User ID
Gold = Integer
Army = Integer?

So your query will end up looking something like,
SELECT GOLD, ARMY FROM INFO,USER WHERE USER.UID = INFO.USERID AND USER.NAME = "Some Fellars Name"

**lintz** · Oct 5th, 2005, 09:46 PM

"Some Fellars Name", only us Aussies would use a phrase like that

**PlaGuE** · Oct 7th, 2005, 10:55 AM

http://phpfreaks.com have sum good tuts.... I learnt pagination from them.

Thread: Register / Login

Thread Tools

Display

Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Re: Register / Login

Posting Permissions