Delete members
Posted: Sun Jul 10, 2005 8:39 am
hi there. i now have my members area set up on my site but am wanting to make am easy admin page where i can delete members without having to go into the database to delete them. I have the following script (mainly from php.net) to display all of the users in the table.
How can i modifly it to beable to delete members???
Thanks
Eric#
include('http://eric.madashatters.com/header.inc')
?>
<?php
$link = mysql_connect('localhost', 'madashat_eric', '********')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('madashat_users') or die('Could not select database');
$query = 'SELECT * FROM users';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "e;<table>\n<div class='white'>"e;;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "e;\t<tr>\n"e;;
foreach ($line as $col_value) {
echo "e;\t\t<td><div class='white'>$col_value</td>\n"e;;
}
echo "e;\t</tr>\n"e;;
}
echo "e;</table>\n"e;;
mysql_free_result($result);
mysql_close($link);
?>
<?
include('http://eric.madashatters.com/footer.inc')
?>
mp;quote;;
mysql_free_result($result);
mysql_close($link);
?>
<?
include('http://eric.madashatters.com/footer.inc')
?>
How can i modifly it to beable to delete members???
Thanks
Eric#
Code: Select all
<?
include('http://eric.madashatters.com/header.inc')
?>
<?php
$link = mysql_connect('localhost', 'madashat_eric', '********')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('madashat_users') or die('Could not select database');
$query = 'SELECT * FROM users';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "<table>\n<div class='white'>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td><div class='white'>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
mysql_close($link);
?>
<?
include('http://eric.madashatters.com/footer.inc')
?>?>
<?php
$link = mysql_connect('localhost', 'madashat_eric', '********')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('madashat_users') or die('Could not select database');
$query = 'SELECT * FROM users';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "e;<table>\n<div class='white'>"e;;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "e;\t<tr>\n"e;;
foreach ($line as $col_value) {
echo "e;\t\t<td><div class='white'>$col_value</td>\n"e;;
}
echo "e;\t</tr>\n"e;;
}
echo "e;</table>\n"e;;
mysql_free_result($result);
mysql_close($link);
?>
<?
include('http://eric.madashatters.com/footer.inc')
?>
mp;quote;;
mysql_free_result($result);
mysql_close($link);
?>
<?
include('http://eric.madashatters.com/footer.inc')
?>