help with activation script php

[BottyZ]

Hi all,

I have a members area, where users sign up using register.php, which then emails us to activate them. We will then log into our admin panel to activate any users not yet activated. Each user will only be allowed specific access to certain areas of the site i.e. if they own 2 products out of four they can only access support pages relating to those products. The access levels will be set when we activate the user. (have i lost you yet? )

I have the majority of scripts working, the only bit i'm stumped with is the activation. Ideally, i'd like to retrieve all users with the field activated=0 (so not activated) into a table, which i can do and have got set up. Then....

This is where i get lost: i want to make a form for each user retrieved into the table above, with checkboxes for each area i want to allow them to, all within the same table and once submitted will activate each user at a time.

Any ideas on the script? I can supply what i have now if needed?

Thanks!!

BottyZ Reviewed by BottyZ on 3rd Feb 2010. help with activation script php Hi all, I have a members area, where users sign up using register.php, which then emails us to activate them. We will then log into our admin panel to activate any users not yet activated. Each user will only be allowed specific access to certain areas of the site i.e. if they own 2 products out of four they can only access support pages relating to those products. The access levels will be set when we activate the user. (have i lost you yet? ;)) I have the majority of scripts working, Rating: 5

[NucleA]

<?php

if(isset($_POST['users_approval'])){

//code to process the form posted.

$users_approval = $_POST['users_approval'];
$num = count($users_approval);

for( $counter=1; $counter<=$num; $counter +=1){

//make user approve..I will code this later.. i gotta go..

}


}

else{

//connect to DB

//Display all accounts who are not activated

$query="Mysql command to get users which is not activated";

$result=mysql_query($query);

$row=mysql_fetch_array($result);

echo "<form  method='POST' action='' >";

while($row['activated']==0){

echo "<input type='checkbox' name='users_approval[]' value=' " .$row['userid']. " ' />" .$row['username']. "<br/>";

}

echo "<input type='submit'  value='Activate' /></form>";


}


?>