I have a login script working great .. I have been trying to make a admin form that will allow admin to:
show all users paginated with link to edit/delete users .. mostly to update user levels or delete unwanted members
maybe an option to delete inactive users by way of drop down menu with say 7, 14, 30, 100, 365 days.
data base table is layed out like:
Code: Select all
CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
user_name varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
) TYPE=MyISAM COMMENT='Membership Information';Code: Select all
<?
$dbhost = 'localhost';
$dbuser = '###';
$dbpasswd = '###';
$database = '###';
$connection = mysql_pconnect("$dbhost","$dbuser","$dbpasswd")
or die ("Couldn't connect to server.");
$db = mysql_select_db("$database", $connection)
or die("Couldn't select database.");
?>Cheers