|
|
Posted by Rik on 02/17/07 17:03
On Sat, 17 Feb 2007 14:13:22 +0100, phyburn <phyburn@gmail.com> wrote:
> It seems there is something wrong with my script for the reason that
> it always returns, UserName NOT found . I know it connects to the db
> fine because I don't get a error. So just been trying to figure out
> what's wrong. I am using PEAR btw.
>
> Pastebin: http://pastebin.ca/360410
>
>
> <?PHP
>
> require 'DB.php';
>
>
> $db =3D DB::connect('mysql://lol:lol@localhost/user');
>
> if (DB::isError($db)) {die('ERROR{1}: ' . $db-
>> getMessage()); }else{print "We connected";}
>
> $user =3D $_POST['user'];
> $password =3D md5($_POST['password']);
> $password2 =3D md5($_POST['password2']);
>
> $sql =3D check();
>
>
>
> function check()
> {
> global $db;
> global $user;
>
>
> $rows =3D $db->getAll('SELECT user_name FROM user');
> if (DB::isError($db)) {die('ERROR{2}: ' . $db->getMessage());}
Untested, I seldomly use PEAR::DB:
$stmt =3D $db->prepare('SELECT user_name, password FROM user WHERE user_=
name =
=3D ?');
$result =3D $db->execute($stmt,$user);
if($result->numRows()!=3D1) die('Username not found or multiple users wi=
th =
the same name.');
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|