SHOW:
|
|
- or go back to the newest paste.
| 1 | <!--- | |
| 2 | awalannya sudah salah sebenarnya.. tetapi saya juga salah kl memperbaiki seperti ini | |
| 3 | at least jalan.. tp ini bukan solusi ya.. | |
| 4 | ---> | |
| 5 | connect.php | |
| 6 | <?php | |
| 7 | ||
| 8 | class database | |
| 9 | {
| |
| 10 | var $host; | |
| 11 | var $user; | |
| 12 | var $password; | |
| 13 | var $db_name; | |
| 14 | var $mysqli; | |
| 15 | ||
| 16 | public function __construct($new_host, $new_user, $new_password, $new_db_name) | |
| 17 | {
| |
| 18 | $this->host = $new_host; | |
| 19 | - | $this->mysqli = new mysqli($host, $user, $password, $db_name); |
| 19 | + | |
| 20 | $this->password = $new_password; | |
| 21 | $this->db_name = $new_db_name; | |
| 22 | ||
| 23 | $mysqli = new mysqli($host, $user, $password, $db_name); | |
| 24 | if($mysqli->connect_error) | |
| 25 | {
| |
| 26 | die("Terjadi kesalahan");
| |
| 27 | exit; | |
| 28 | }else{
| |
| 29 | return $mysqli; | |
| 30 | ||
| 31 | } | |
| 32 | } | |
| 33 | } | |
| 34 | ||
| 35 | ?> | |
| 36 | ||
| 37 | instantiate.php | |
| 38 | <?php | |
| 39 | function instantiate() | |
| 40 | {
| |
| 41 | $database = new database('localhost', 'root', '', 'tickit');
| |
| 42 | } | |
| 43 | ?> | |
| 44 | ||
| 45 | user.php | |
| 46 | <?php | |
| 47 | require 'functions/instantiate.php'; | |
| 48 | ||
| 49 | class user | |
| 50 | {
| |
| 51 | var $username; | |
| 52 | private $password; | |
| 53 | var $email; | |
| 54 | var $firstname; | |
| 55 | var $lasname; | |
| 56 | var $address; | |
| 57 | var $town; | |
| 58 | var $country; | |
| 59 | var $postcode; | |
| 60 | ||
| 61 | private $repeat_password; | |
| 62 | ||
| 63 | private $query; | |
| 64 | ||
| 65 | ||
| 66 | function register($new_username, $new_password, $new_repeat_password, $new_email, $new_firstname, $new_lastname, $new_address, $new_town, $new_country, $new_postcode) | |
| 67 | {
| |
| 68 | $this->username = $new_username; | |
| 69 | $this->password = $new_password; | |
| 70 | $this->repeat_password = $new_repeat_password; | |
| 71 | $this->email = $new_email; | |
| 72 | $this->firstname = $new_firstname; | |
| 73 | $this->lasname = $new_lastname; | |
| 74 | $this->address = $new_address; | |
| 75 | $this->town = $new_town; | |
| 76 | $this->country = $new_country; | |
| 77 | $this->postcode = $new_postcode; | |
| 78 | ||
| 79 | $database = new database('localhost', 'root', '', 'tickit');
| |
| 80 | $selectUser = $database->prepare("SELECT username FROM user WHERE username=?");
| |
| 81 | $selectUser->bind_param('s', $this->username);
| |
| 82 | $selectUser->execute(); | |
| 83 | $selectUser->store_result(); | |
| 84 | ||
| 85 | if(!$selectUser->num_rows) | |
| 86 | {
| |
| 87 | if($this->password === $this->repeat_password) | |
| 88 | {
| |
| 89 | $inputUser = $mysqli->prepare("INSERT INTO user VALUES(?,?,?,?,?,?,?,?,?)");
| |
| 90 | $inputUser->bind_param('sssssssss', $this->username, $this->password, $this->email, $this->firstname, $this->lastname, $this->address, $this->town, $this->country, $this->postcode);
| |
| 91 | if($inputUser->execute()) | |
| 92 | {
| |
| 93 | header("location:login.php");
| |
| 94 | } | |
| 95 | else | |
| 96 | {
| |
| 97 | "Ada kesalahan saat mendaftar."; | |
| 98 | } | |
| 99 | } | |
| 100 | else | |
| 101 | {
| |
| 102 | echo "Password tidak sama."; | |
| 103 | } | |
| 104 | } | |
| 105 | else | |
| 106 | {
| |
| 107 | echo "Username tersebut sudah dipakai."; | |
| 108 | } | |
| 109 | } | |
| 110 | } | |
| 111 | ||
| 112 | ?> |
