<?php
    include 'config_fns.php';

    $connect = new MySql();
    $connect->connect($db_host, $db_username, $db_password, $db_name);

    class MySql
    {
        var  $host;
        var  $user;
        var  $password;
        var  $database;
        public  $db_handle;

        public function connect($db_host, $db_user, $db_password, $db_database)
        {
            $this->host = $db_host;
            $this->user = $db_user;
            $this->password = $db_password;
            $this->database = $db_database;

            $this->db_handle = mysql_connect($this->host, $this->user, $this->password)or die('could not connect to db');
            mysql_select_db($this->database)or die('could not select db');
        }

        public function query($sql)
        {
            return mysql_query($sql, $this->db_handle) or die (mysql_error());
        }

        public function fetch($result)
        {
            return mysql_fetch_assoc($result, $this->db_handle) or die (mysql_error());
        }

    }

    class User
    {
        public $db;
        public $id;
        public $username;
        public $password;

        public function __construct($db, $id = 0)
        {
            $this->db = $db;
            $this->id = $id;

            if($this->$id !== 0)
            {
                $result = mysql_query("SELECT `username`, `password` FROM `user` WHERE `id` = $this->id");
                $row = mysql_fetch_assoc($result);


                    if($row)
                    {

                        $this->username = $row['username'];
                        $this->password = $row['password'];
                    }

                return $row;




                echo mysql_error();
            }
        }

        public function setUsername($name)
        {
            $this->username = $name;
            return $this;
        }

        public function setPassword($password)
        {
            $this->password = $password;
            return $this;
        }

        public function getUsername()
        {
            return $this->username;
        }

        public function getPassword()
        {
            return $this->password;
        }

        public function save()
        {
            if($this->id == 0)
            {
                $id = $this->db->query("INSERT INTO `user` (username, password) VALUES ('{$this->username}', '{$this->password}')");
                $this->id = $this -> id = mysql_insert_id ( );
            }else{
                $this->db->query("UPDATE `user` SET `username` = '{$this->username}', `password` = '{$this->password}' WHERE `id` = '{$this->id}'");
            }
            return $this->id;
        }
    }

    $user = new User($connect, 1);
    echo $user->getUsername() . '<br/>';
    echo $user->getPassword();


    $user = new User($connect, 1);
    $user->setUsername($_POST['username']);
    $user->setPassword($_POST['password']);
    $id = $user->save();


    //echo "<br/> New user {$user->getUsername()} created with a password of {$user->getPassword()} and an id of $id";

?>

<form method="POST" target="self">
    <input type="text" name="username" value="Username" onclick="this.value = ''" /><br/>
    <input type="text" name="password" value="Password" onclick="this.value = ''" /><br/>
    <input type="submit" name="submit" />
</form>