/*
* Created on 2010-4-25
*
* To change the template for this generated file go
* Window-Preferences-PHPeclips tutorial e-PHP-Code Templates
*/
$ Conn = mysql_connect ('localhost', 'root ','');
Mysql_select_db ('member', $ conn );
$ SQL = "select * from user_list ";
$ Query = mysql_query ($ SQL );
While ($ row = mysql_fetch_array ($ query ))
{
?>
<Table width = 500 border = "0" align = "center" cellpadding = "5" cellspacing = "1" bgcolor = "# add3ef">
<Tr bgcolor = "# eff3ff">
<Td> id: <? = $ Row [uid]?> User: <? = $ Row [username]?> </Td>
</Tr>
<Tr bgColor = "# ffffff">
<Td> Password: <? = $ Row [password]?> </Td>
</Tr>
<A href = "del. php? Id = <? = $ Row [uid]?> "> Delete </a>
<? }?>
</Table>
Database structure, copy this code to phpmyadmin to run
SET SQL _MODE = "NO_AUTO_VALUE_ON_ZERO ";
--
-- Database: 'member'
--
----------------------------------------------------------
--
-- Table structure 'user _ list'
--
Create table 'user _ list '(
'Uid' int (11) not null auto_increment,
'M _ id' varchar (5) not null,
'Username' varchar (25) not null,
'Password' varchar (64) not null,
Primary key ('uid ')
) ENGINE = MyISAM default charset = gb2312 AUTO_INCREMENT = 11;
--
-- Export the table data 'user _ list'
--
Insert into 'user _ list' ('uid', 'M _ id', 'username', 'password') VALUES
(9, '1', 'admin', '75cf565ad38d0f837c43363e402b1a00 '),
(10, '2', 'admin2', '75cf565ad38d0f837c43363e402b1a00 ');