<?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($sql)
        {
            return mysql_fetch_assoc($this->query($sql), $this->db_handle);
        }

        public function row($sql)
        {

        }
    }

    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 = $this->db->query("SELECT `username`, `password` FROM `user` WHERE `id` ='{$this->id}'");

                    if($result)
                    {
                        $this->username = $result->username;
                        $this->password = $result->password;
                    }
            }
        }

        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, 31);
    $user->setUsername($_POST['username']);
    $user->setPassword($_POST['password']);
    $id = $user->save();
    */

    $user = new User($connect, 31);
    echo $user->getUsername();
    print_r($user);


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

    /*class User
    {
        public $username;
        public $password;

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

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

        public function query($sql)
        {
            $sql = "INSERT INTO `user` (`username`, `password`) VALUES ({$CreateUser['username']}, {$CreateUser['password']})";
        }
    }

    $newUser = new CreateUser();
    $newUser->setUsername($_POST['username']);
    $newUser->setPassword($_POST['password']);
    $connect->query("INSERT INTO `user` (`username`, `password`, created_at) VALUES ('$newUser->username', '$newUser->password', NOW())");
    //$connect->query("SELECT * FROM `users`");
    //$connect->fetch($MySql->query);
    echo mysql_error() . '<br/>';
    print_r($newUser);
    */
?>

<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>