How to create Member List In PHP & MYSQL ?

**t4vn.net** · 05-11-2007, 01:06 PM

In this tutorials.I teach you "how to create member list in PHP with mysql.This Source code has been writen form T4VN Team. so, if you want to develop it, please contact us. Thanks for your interested in this code.

Step 1 : Create database with information

PHP Code:


			
<? 
CREATE TABLE `user` ( 
  `user_id` int(10) unsigned NOT NULL auto_increment, 
  `username` varchar(150) NOT NULL default '', 
  `password` varchar(150) NOT NULL default '', 
  `email` varchar(255) NOT NULL default '', 
  PRIMARY KEY (`user_id`) 
)  ; 
?>

Step 2 : As I have some data,example :

PHP Code:


			
<? 
INSERT INTO `user` VALUES (1, 'admin', '12345', 'admin@a.com'); 
INSERT INTO `user` VALUES (2, 'jacky', '1234578910', 'jacky@y.com'); 
INSERT INTO `user` VALUES (3, 'mizuki', 'abcd', 'mi@a.com'); 
?>

Now,how to list all of member in this table ?.
Step 3: create listmember.php with code below

PHP Code:


			
<HTML> 
<HEAD> 
<meta http-equiv="Content-Language" content="en-us"> 
<TITLE>This is Example</TITLE></HEAD> 
<body> 
            <TABLE style="BORDER-COLLAPSE: collapse" borderColor=#77a7ad  
            cellSpacing=1 cellPadding=1 width="100%" bgColor=#ffffff border=1> 
        <tr> 
            <td width="37" align="center" ><font face="Tahoma" size="2"><b>STT</b></font></td> 
            <td align="center" ><font face="Tahoma" size="2"><b>Username</b></font></td> 
            <td align="center" ><font face="Tahoma" size="2"><b>Email</b></font></td> 
                    </tr> 
<? 
$ds="select * from user order by user_id "; 
$rs=mysql_query($ds,$connect); 
if(mysql_num_rows($rs)!= "") 
{ 
    $stt=0; 
    while($row=mysql_fetch_array($rs)) 
    { 
        $stt++; 
?> 
        <tr> 
            <td width="37" align="center"><font face="Tahoma" size="2"><?=$stt?></font></td> 
            <td align="center"><font face="Tahoma" size="2"><?=$row["dn_username"]?></font></td> 
            <td align="center"><font face="Tahoma" size="2"><?=$row["dn_email"]?></font></td> 


        </tr> 
        <? 
    } 

?> 
    </table> 
</body> 
</html>

Now,you're done

All information you can find here:
http://www.t4vn.net/tutorials/showtu...st-In-PHP.html

Good lucks with your practice.