How to create Member List In PHP

**Spiral** · #1 (**permalink**) 06-30-2007, 11:14 AM

In this tutorials.We teach you "how to create member list in PHP with mysql

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 :

Code:

<? 
INSERT INTO `user` VALUES (1, 'admin', '12345', ' [Only Registered users can see links . Click Here To Register...]'); 
INSERT INTO `user` VALUES (2, 'jacky', '1234578910', ' [Only Registered users can see links . Click Here To Register...]'); 
INSERT INTO `user` VALUES (3, 'mizuki', 'abcd', ' [Only Registered users can see links . Click Here To Register...]'); 
?>

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode


<<< The Web Hosting >>>