Guest User

Untitled

a guest
Jun 25th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. class database
  2. {
  3. private $conn;
  4. private $db_name = 'profil_penduduk';
  5. private $db_user = 'root';
  6. private $db_pass = '';
  7. private $db_host = 'localhost';
  8.  
  9. public function connect()
  10. {
  11.  
  12. $this->conn = null;
  13. try
  14. {
  15. $this->conn = new PDO("mysql:host=$this->db_host;dbname=$this->db_name", $this->db_user, $this->db_pass);
  16. $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  17. }
  18. catch(PDOException $exception)
  19. {
  20. echo "Connection error: " . $exception->getMessage();
  21. }
  22.  
  23. return $this->conn;
  24. }
  25. }
  26.  
  27. class admin
  28. {
  29. private $conn;
  30.  
  31. function __construct()
  32. {
  33. # code...
  34. $database = new database();
  35. $db = $database->connect();
  36. $this->conn = $db;
  37. }
  38.  
  39. public function runQuery($sql)
  40. {
  41. # code...
  42. $stmt = $this->conn->prepare($sql);
  43. return $stmt;
  44. }
  45. }
  46.  
  47. $auth_admin = new admin();
  48.  
  49.  
  50. $admin_id = $_SESSION['admin_session'];
  51.  
  52. $stmt = $auth_admin->runQuery("SELECT * FROM admin WHERE admin_id=:admin_id");
  53. $stmt->execute(array(":admin_id"=>$admin_id));
  54.  
  55. $adminRow=$stmt->fetch(PDO::FETCH_ASSOC);
  56.  
  57. "SELECT * FROM admin WHERE admin_id=:admin_id"
Add Comment
Please, Sign In to add comment