♫ SHOW DB CONTENTS:

To show the database contents:



<?php

$dbname="databasename";

$dbc=mysql_connect("localhost","root","") or die("cannt connect database");

$dbs=mysql_select_db($dbname,$dbc) or die("cannt select database");

$sql="select * from tablename";

$result=mysql_query($sql) or die("error in query".$mysql_error());


while($row=mysql_fetch_array($result))

{

echo "Database Contents: ";

echo "username: ".$row[username];

echo "password: ".$row[password];

}

?>