script which after login write USER for user and ADMN for admin

[preet_harman83]

can u help me to make it disaply..USER if user login which is having type 0 and ADMN id admn login whose type is 1 in onlinetestusers table
select * from onlinetestusers;
uid | username | password | name | type
--------+----------+----------+-------------------+------
on1001 | harman | preet | harmanpreet singh | 0
on1002 | antonio | magdic | antonio | 1

0 is user
i is admn

<?php

$username = $POST["username"];
$password = $POST["password"];
$connection = pg_connect("dbname=harmantest user=damdev host=localhost ");
echo $connection;
if (!$connection)
{
print("Connection Failed ");
exit;
}

$result = pg_query($connection, "select * from onlinetestusers where username='$username' and password='$password' ");
echo $result;
while($row = pg_fetch_row ($result))
{
$username = $row['username'];
$password = $row['password'];
}
if ($username == $result['username'] && $password == $result['password'])
{
print "The entered username and password were correct!";
}
else
{
print "The entered username and password were wrong!";
}
?>

[msk_1980]

You can do something like:

if ( $row['type'] == 0 )
echo "USER";
else
echo "ADMIN";

I dont know if there is an easy way to do it.

[preet_harman83]

if ($username == $result['username'] && $password == $result['password'])
{
if ( $row['type'] == 0 )
{
echo "USER";
}
else
{
echo "ADMIN";
}
tried this but itsdisaplyinh only user either i enter user or admn

msk_1980 wrote:

You can do something like:

if ( $row['type'] == 0 )
echo "USER";
else
echo "ADMIN";

I dont know if there is an easy way to do it.

[msk_1980]

what type of data is type i.e char or int. you might need to change if accordingly. if not try to echo $row['type'] and see whats the output.

[preet_harman83]

type is integer
can u give me ypur yahoo messenger id so tht we can disucss its urgent if u dnt hve any problem