[RESOLVED] want to diaplsy either user logged in or admin is logging into site

[preet_harman83]

can anyone tell mewhere im wrong i wana get if user login it should display user logged in and if admin login it should disaply admin logged in ...but its displaying nothing who so ever logged in.need r suggestion
database is as follows
uid | username | password | name | type
--------+----------+----------+-------------------+-------
on | man | preet |t singh | user
onto | nio | gdic | onio | admin

<?php
$username = $POST["username"];
$password = $POST["password"];
$connection = pg_connect("dbname=test user=ev host=localhost ") or die("Cannot connect
to server");
$result = pg_query($connection, "select type from ontestusers where username='$username' and password='$password' ") or die("Cannot execute the query");

$no_rows = pg_num_rows( $result ); // if only one row correct username and pwd
if($no_rows == 1)
{ //testing purpose
//echo "In IF NO OF ROWS ".$result['type'];
//echo "In IF NO OF ROWS ".$no_rows;
if ($result['type'] == 'user' )
{
//echo $result['type'];
echo "User";
}
elseif($result['type'] == 'admin' )
{
// echo $result['type'];
echo "ADMIN";
}
}
else
{
echo "Username and pwd wrong...";
}
?>

[preet_harman83]

this is the solution friends...submitting it for ur help..thanks to jayant who helped me in this
<?php

$username = $POST['username'];
$password = $POST['password'];

          $connection = pg_connect("dbname=test user=ev host=localhost") or die("Can't connect to database server.");
          //echo $connection;

          $query = pg_query("SELECT type FROM sers WHERE username='$username' AND password='$password'") or die('Cannot execute the query.');

          $no_rows = pg_num_rows($query);
          //echo $no_rows;
            if ( $no_rows == 1 )
            {
                 $result = pg_fetch_assoc($query);// instead of returning it as $result[0], $result[1]
                 //,it does it as $result['type']

                    if ( $result['type'] == 'user' )
                    {
                       echo ( 'User' );
                    }
                    else if ( $result['type'] == 'admin' )
                    {
                       echo ( 'Admin' );
                    }
                    else
                    {
                        echo ( 'Invalid user type.' );
                    }
            }

         else
            {
                    echo ( 'Username or password was wrong.' );
            }
   ?>

[Rodney_H_]

Preet:

My PostgreSQL skills are a little-bit-rusty, hah! But perhaps this might help:

<?php
// make sure form is filled out
if(isset($_POST["username"]) && isset($_POST["password"]))
{
	$username = $_POST["username"];
	$password = $_POST["password"];
}
else {
	echo 'go back and enter a username AND password.';
	exit;
}

// connect to a database
$conn = pg_connect("dbname=test user=ev host=localhost");

if(!conn)
{
	echo 'Could not connect';
	exit;
}

// create query statement
$query = "SELECT type FROM ontestusers";
$query .= " WHERE username='" . $username . "'";
$query .= " AND password='" . $password . "'";

// execute query
$result = pg_query($conn, $query);
if(!$result)
{
	echo 'Cannot execute the query';
	exit;
}

// check for rows
$rows = pg_num_rows($result);

// if no results:
if($rows == 0)
{
	echo 'Username and pwd wrong...';
	exit;
}
// else there was a match:
else
{
	if($rows['type'] == 'user')
	{
		echo 'Usertype: ' . $rows['type'];
	}
	else
	{
		echo 'Usertype: ' . $rows['type'];
	}
}
?>

[preet_harman83]

thanks rodney...even urs code worked i just need to modify this $result = pg_fetch_assoc($query);
thanks for such an invaluable help..
hope to seek ur help in future too
regards
harman

[Rodney_H_]

Thanks, Harman. I am glad.

[Rodney_H_]

Thanks, Harman. I am glad that you have your script working.

To mark your thread Resolved:

1) go to the top and look for: Thread Tools.

2) Click it.

3) Click: "Mark This Thread Resolved"

All there is to it. 😉