[SOLVED] User System?

[adamlacombe]

Does anyone know how to make a basic login user system with mysql?

I know how to do most of it but not sure on the login process.

[adamlacombe]

I have searched google for days for a user system tutorial but all i get are advanced scripts with lost password, sign up, members page, and profile page features. All im looking for is something that will let me login with mysql, I can make all the other features.

If anyone knows of a tutorial that will help me or can write one up that would be great!

Thanks!

[Maq]

If anyone knows of a tutorial that will help me or can write one up that would be great!

 

Hate to burst your bubble princess, but I don't think anyone is going to write a tutorial just for you.  I'm sure you can find basic tutorials on how to create a login script.  This is a very common request.  I would recommend doing a search on phpfreaks for some similar threads as well.

 

I have searched google for days for a user system tutorial but all i get are advanced scripts with lost password, sign up, members page, and profile page features.

 

Just ignore the extra features you don't want.

[adamlacombe]

well i have found a basic one i want to use but i dont know how to pull the info of the logged in user.

i have tried:

$_SESSION['username']

but that does not wanna work.

I run into this problem a lot with the other script i have found too.

the link to the tut is: http://dev.thatspoppycock.com/index.php/Creating_a_Simple_PHP_and_MySQL-Based_Login_System

[pgrevents]

silly question but is session_start(); at the top of all your pages?

[adamlacombe]

yeah its right at the top of the page.

[pgrevents]

are you setting your session is $_SESSION['sessionname'] = $stuffvar

 

have you tried printing your session to see if it is infact working but its your other code that isnt?

[adamlacombe]

ok, got it working!

I hate to be such a pain but any idea why this:

<?php 
session_start();
include "db_connect.php"; //mysql db connection here

print "<link rel='stylesheet' href='style.css' type='text/css'>";

print "<table class='maintable'>";

print "<tr class='headline'><td>From</td><td>Author</td><td>Message</td></tr>";

$getmail="SELECT * from PM where to='$_SESSION['username']'";

$getmail2=mysql_query($getmail) or die("Could not get mail");

while($getmail3=mysql_fetch_array($getmail2))

{

  print "<tr class='mainrow'><td>$getmail3[from]</a></td><td>$getmail3[msg]</a></td></tr>";

}

print "</table>";



?>

 

does not work?

 

it has something to do with the:

$getmail="SELECT * from PM where to='$_SESSION['username']'";

[Maq]

Change that to:

 

$getmail="SELECT * from PM where to='{$_SESSION['username']}'";

 

It thought that the single quote in the query was ending the comparative value, when adding curly brackets it escapes the quotes and allows for variables such as arrays.

[adamlacombe]

hmm...

I changed it to what you posted and got the error "could not get mail".

 

[Maq]

Change that line to:

 

$getmail2=mysql_query($getmail) or die(mysql_error());

[adamlacombe]

ok now i get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to='test'' at line 1

[Maq]

OK, 'to' is a reserved word - Reserved Words.  The way around this is to use back ticks which will escape the reserved word and give the meaning literally.

 

This should work:

 

$getmail="SELECT * from PM where `to`='{$_SESSION['username']}'";

[adamlacombe]

ok got it!

Thank you! 

[Maq]

ok got it!

Thank you! 

 

YW, please mark solved.