Guest User

Untitled

a guest
Mar 23rd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. // Connecting to database
  2. public function connect() {
  3. require_once 'include/Config.php';
  4. // Connecting to mysql database
  5. $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
  6. $this-> conn->set_charset("utf8");
  7. // return database handler
  8. return $this->conn;
  9. }
  10.  
  11. $stmt->bind_param("ssssssssssssssss", $name, $father_name, $gender, $age, $dob, $cnic, $phone_no, $address, $email, $encrypted_password, $salt, $roll_no, $session, $section, $semester, $shift);
  12. $result = $stmt->execute();
  13. $stmt->close();
  14.  
  15. create table users(
  16. id int(11) primary key auto_increment,
  17. /** unique_id varchar(23) not null unique, **/
  18. name varchar(50) not null,
  19. fahter_name varchar(50) not null,
  20. gender varchar(7) not null,
  21. age varchar(3) not null,
  22. dob varchar(15) not null,
  23. cnic varchar(100) not null,
  24. phone_no varchar(100) not null unique,
  25. address varchar(50) not null,
  26. email varchar(100) not null unique,
  27. encrypted_password varchar(80) not null,
  28. salt varchar(10) not null,
  29. roll_no varchar(50) not null,
  30. session varchar(50) not null,
  31. section varchar(2) not null,
  32. semester varchar(2) not null,
  33. shift varchar(50) not null,
  34. created_at datetime,
  35. updated_at datetime
Add Comment
Please, Sign In to add comment