Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 = $this->db->query("SELECT `username`, `password` FROM `user` WHERE `id` = $this->id");
- $row = $this->db->fetch($result);
- if($result)
- {
- $this->username = $result->username;
- $this->password = $result->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, 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement