T4VN is an online PHP Help community that provides PHP Tutorials, PHP Examples, PHP Scripts, PHP Support
    HOME  |  HOSTING COUPON  |  TEMPLATE  |  PHP SCRIPTS  |  LINK TO US  |  LINK  |  REGISTER | CONTACT
::: Member Login :::
 Username
 Password
 
Forgot your password ?
::: PHP Tutotal :::
  PHP Basic (7)
  PHP Advanced (4)
  PHP Database (2)
  Coding Step By Step (8)
  PHP and AJAX (0)
::: PHP Example :::
  Arrays (1)
  Code Highlighters (3)
  Database Functions (12)
  Date & Time (5)
  E-Mail (6)
  Forms (5)
  Guestbooks (1)
  Logging (2)
  Miscellaneous (10)
  Password Generators (3)
  Randomizers (3)
  String Manipulation (10)
  User Authentication (6)
::: Search On T4VN :::
::: T4VN Statistics :::
  PHP Scripts : 35
  PHP Example : 67
  PHP Tutorials : 21
  PHP News : 91
  Total Coupon : 36
  Other Tutorials :
  Member : 168
  Visitor Online : 2
  Today Visit: 227
  Total Visitor : 88077
  Most Online : 25
::: Sponsored Links :::

PR 4 For This Webpage
Home Today :

How to create Member List In PHP


In this tutorials.We 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 Tutorials :

<?
CREATE TABLE 
`user` (
  `
user_idint(10unsigned NOT NULL auto_increment,
  `
usernamevarchar(150NOT NULL default '',
  `
passwordvarchar(150NOT NULL default '',
  `
emailvarchar(255NOT NULL default '',
  
PRIMARY KEY (`user_id`)
)  ;
?>



Step 2 : As I have some data,example :

PHP Tutorials :

<?
INSERT INTO 
`userVALUES (1'admin''12345''admin@a.com');
INSERT INTO `userVALUES (2'jacky''1234578910''jacky@y.com');
INSERT INTO `userVALUES (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 Tutorials :

<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

Author : T4VN Team




Other Tutorials
Poll System
Create Simple News System
Simple Upload Page
Create Simple ShoutBox
Sending Simple Text Emails
Simple Hit Counter

::: Resources :::
  Links Directory
  Programming 2 3
  Webmaster 2 3
  Web Design 2 3
  Web Hosting 2 3
  Other Links 2 3
  Asian ShowBiz News
  Teach Seo For You
::: New Templates :::




::: Other Tutorials :::
 Program Design

  Powered By T4VN.NET - Version 2.0 - CopyRight © T4VN.NET 2005-2007