» Unlabelled » Dispalying Elements From Database using PHP

Dispalying Elements From Database using PHP

- on Tuesday, September 20, 2011 - No comments
<html>
<body>
<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("test",$conn) or die('Could not connect: ' . mysql_error());
$query="SELECT * FROM users";
$display=mysql_query($query);
?>
<table width="100%" border="1">
    <tr>
        <td>Username</td>
        <td>Password</td>
        <td>Email</td>
        <td>Gender</td>
        <td>Phone Number</td>
        <td>Url</td>
        <td>Address</td>
    </tr>

<?php
while($row=mysql_fetch_assoc($display)){
?>

    <tr>
        <td><?php echo $row['id']; ?></td>
        <td><?php echo $row['name']; ?></td>
        <td> <a href="mailto:<?php echo $row['email']; ?>">Send mail</a></td>
        <td><?php echo $row['gender']; ?></td>
        <td><?php echo $row['phno']; ?></td>
        <td><a href="<?php echo $row['url']; ?>"><?php echo $row['url']; ?></a> </td>
        <td><?php echo $row['address']; ?></td>
        <td><a href=sdbupdate.php?id=<?php echo $row['id'];?>>edit</a></td>
        <td><a href=sdbdelete.php?id=<?php echo $row['id'];?>>delete</a></td>
    </tr>
<?php
}
?>
</table>
</form>
</body>
</html>

Post a Comment

Analytics