Okie dokey, can anyone help me with...

Virtue

I'm having some problems, which probably would be simple enough to solve if I wasn't such a n00b.

Basically, I have figured out how to create a membership system using PHP and MySQL, I only have and need one database table, the "User" table.

But here's what I want to do, but have no idea where to start...

On one of the pages on my website, I want to have a roster table containing 10 slots to be filled by current members of my database/site.
In each "Empty Slot" I want to have clickable text saying something like "Click here to Enroll", which - when clicked, the slot will be filled with that members name.
And also, I would like to have a "Remove" button, so that is a member fills the slot and wishes to be removed from it again, they can click a button and it will remove their name from the roster.

Sounds like a simple enough concept eh?
Well, me being new to PHP and MySQL, I need soeme help.

I understand that 96% of people here won't want to go into detail about it for me, but could somebody at least point me to a tutorial or something that explains the basics of doing this?

Any help would be very much appreciated.

Thank you for your patience and time taken to read my query.

Virtue.

lanjoky

first question I need is how do you want the people in the tabled ordered. Is there some field in your Database that will specify an order? Second, will there always only be a max of 10 users in the list?

kevinsequeira

this should get u started ..

<?
table : roster has roster_id|user_id
table : user has user_id|username|........
// roster.php
// $logged_in_user is the current user who has logged in
// set up db connections
if(isSet($_GET['func'])){
	if($_GET['func']=="add"){
	 // add the user to roster with user_id
	}
	if($_GET['func']=="remove"){
	 // remove the user from roster using user_id
	}	
}
$q = "select roster.user_id, user.username from roster, user ";
$q = " where roster.user_id = user.user_id";
$r = mysql_query($q);
$count = mysql_num_rows($r);
echo '<table>';
while ($row = mysql_fetch_array($r)){
	//using link
	echo '<tr><td>'.$row[1].'<a href=roster.php?user_id='.$row[0].'&func=remove&logged_in_user='.$logged_in_user.'>remove</a></td></tr>';	
}
$remainder = 10 - $count;
if($remainder > 1){
	for($i=0;$i<$remainder;$i++){
		echo '<tr><td><a href=roster.php?user_id='.$logged_in_user.'&func=add&logged_in_user='.$logged_in_user.'>click to add</a></td></tr>';
	}
}
echo '</table>';
?>

reg
kevin

Virtue

Yes, only 10 people.
What I want is for logged in users who are already members of my database to be able to add themselvs to the roster, which is in the form of a HTML table.

I'm not quite sure what you mean by -
"How do you want the people in the tabled ordered?"

Does it show that bad that I'm SO new to this? Hehe.

Virtue.

Virtue

Ahh, thanks Kevin.
I have gone through that code and pretty much understand it all.
But the only snag I have is that I don't know where to put it. I take it this PHP file needs to be used in conjunction with another php/html file?

Virtue.

lanjoky

Put that Code right where you want the table in the same php file where u have the code for that page and want to see that table

kevinsequeira

i fu want only logged in users to be able to remove themselves make this change to the code i posted above

while ($row = mysql_fetch_array($r)){
	echo '<tr><td>'.$row[1];
	if($logged_in_user==$row[0]){
		echo '<a href=roster.php?user_id='.$row[0].'&func=remove&logged_in_user='.$logged_in_user.'> remove from roster</a>'
	}
echo '</td></tr>';	
}

reg
kevin

kevinsequeira

well once the users logs in have a link on the page like this

echo '<a href=/roster.php?logged_in_user='.$logged_in_user.'>goto roster</a>';

reg
kevin

Virtue

So would something like this work?...

<?
session_start();

echo "Welcome ". $SESSION['first_name'] ." ". $SESSION['last_name'] ."!
If you wish to participate in this event, please add yourself to the roster!<br /><br />";

<?
table : roster has roster_id|user_id
table : user has user_id|username|........
// roster.php
// $logged_in_user is the current user who has logged in
// set up db connections
if(isSet($GET['func'])){
if($GET['func']=="add"){
// add the user to roster with user_id
}
if($_GET['func']=="remove"){
// remove the user from roster using user_id
}

}
$q = "select roster.user_id, user.username from roster, user ";
$q = " where roster.user_id = user.user_id";
$r = mysql_query($q);
$count = mysql_num_rows($r);
echo '<table>';
while ($row = mysql_fetch_array($r)){
//using link
echo '<tr><td>'.$row[1].'<a href=roster.php?user_id='.$row[0].'&func=remove&logged_in_user='.$logged_in_user.'>remove</a></td></tr>';

}
$remainder = 10 - $count;
if($remainder > 1){
for($i=0;$i<$remainder;$i++){
echo '<tr><td><a href=roster.php?user_id='.$logged_in_user.'&func=add&logged_in_user='.$logged_in_user.'>click to add</a></td></tr>';
}
}
echo '</table>';
?>

Or should I shoot myself with the PHP gun again?

Virtue.

kevinsequeira

well first of all comment these lines

table : roster has roster_id|user_id
table : user has user_id|username|........

so change it to

//table : roster has roster_id|user_id
//table : user has user_id|username|........

and u need to get the $logged_in_user, u probablt need to have a session variable like

$logged_in_user = $_SESSION['id']

// im asuming ure using a column called id

reg
kevin

Virtue

Ok, I got that pretty much down.
I get a few errors when I try to test it, but that's probably because I go straight to that page from my localhost directory.
Itwould probably be okay if I created a test membership account and tested it with that, but I'm still ironing out some of the membership issues. Hehe.

Virtue.

Virtue

Here's a thought.
Would the same thing work without the login thing?

Maybe if I just had the user start a session when they got to the site and when they click on the roster, their session name is added to it?

Virtue.

kevinsequeira

well u would have to start the session when a user visits a page, but how would you know the user id then ??

reg
kevin