compare

[Anon]

I'm sort of new to php, and I need help improving my code.
I'm trying to create a program that will determine if the data already exist in the postgresql database, and i cant make it to work. I have a field "usrname" in my table

$query=pg_exec($connect,"SELECT * from dialup where usrname='$usrnme');
//"$usrnme" is the variable from a html form//

$result=pg_result($query,0,urname);
if($result==$usrnme){

echo "data already exists";

[Anon]

I'm not real familiar with the pgsql commands having never worked with them, but I imagine they're pretty similiar.

For one, you could do a:
SELECT COUNT(*) FROM dialup WHERE username='$usrnme'

and if the result is > 0 , you have an existing user by that name

You could also do use your existing query and and use the pg_numrows function like this:

if ($pg_numrows($query) > 0){
echo "you have an existing user";
} else {
echo "everything looks good";
}

There's probably some other ways to do it too...

[Anon]

What would you expect, when you have the
thing spelled three different ways:

usrname
usrnme
urname

This may not be the only problem here, but until you
fix it...

[Anon]

Yes, it would be wise if him to authenticate a user against a password as well.

[Anon]

There's no need to use SELECT *, use SELECT usrname.

If you have made that field unique, you could also just try to insert the new name, and check for errors.

That may be an ugly method, since there may be other reasons for errors, but I beleve it's the fastes. I like speed.