<?php require_once('database.php'); ?>

<?php

class User extends Database{

    public $user;

    public function validate_login($username, $password){

        $this->query("SELECT username, password FROM users WHERE username='". $username ."' AND password='". $password . "'");

        if(mysql_num_rows($result) == 1) {

            return TRUE;
        }
            return FALSE;
    }

    public function insert($tablename, $username, $password, $email_address){

        $result = $this->query("INSERT INTO $tablename(username, password, email_address) VALUES('$username','$password','$email_address')");
        if($result){

            return TRUE;

        } else {

            return FALSE;

        }

    }

    public function getID($id){

        $res = $this->query("SELECT * FROM users WHERE id='". $id ."'");

        $row = mysql_fetch_row($res);

        return $row;
    }
}

$me = new User();



//$me->insert('users', 'abc', 'acb','abc');
echo '<pre>';

print_r($me->getID(4));