Get Users from users table : Authentication « HTML « PHP






Get Users from users table

 
<html><head><title>Get Users</title></head>
<body>

<?php

$conn=@mysql_connect("localhost", "userName", "password") or die("Could not connect");

$rs = @mysql_select_db("my_database", $conn) or die("Could not select database");
 
$sql="select * from users";
 
$rs=mysql_query($sql,$conn) or die("Could not execute query");

$list = "<table>";
$list.="<tr><th>First Name</th>";
$list.="<th>Last Name</th>";
$list.="<th>User Name</th>";
$list.="<th>Password</th></tr>";

while($row= mysql_fetch_array($rs) )
{
   $list .= "<tr>";
   $list .= "<td>".$row["first_name"]."</td>";
   $list .= "<td>".$row["last_name"]."</td>";
   $list .= "<td>".$row["user_name"]."</td>";
   $list .= "<td>".$row["password"]."</td>";
   $list .= "</tr>";
}
$list .= "</table>";
echo($list);

?>
</body></html>
  
  








Related examples in the same category

1.Authentication Over HTTP
2.Basic authentication prompt
3.Checking the values returned from the authentication prompt
4.Enforcing Basic authentication
5.HTTP Authentication example
6.HTTP Authentication example forcing a new name/password
7.Hardcoding the username and password into a script
8.If user logged in
9.Only One Username and Password Is Valid
10.Usernames and Passwords Are Checked Against Data in a Database
11.Usernames and Passwords Are Checked Against Data in a File
12.Using HTTP authentication with a PHP script
13.Use database to store user name and password
14.The Username and Password Are Retrieved for Both Apache and IIS
15.Simple credentials checking:
16.User management with database