Advertisement
Guest User

Untitled

a guest
Feb 13th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. <?php
  2. class DBCON{
  3. /**
  4. *initialize all the components for database
  5. *
  6. *allow you to construct parallel database session using different dbms like mysql,pgsql etc.
  7. *
  8. *@param string $db_ini_dbms set your current database management system
  9. *@param string $db_ini_host set your host ex.127.0.0.1
  10. *@param string $db_ini_username set your username ex. root
  11. *@param string $db_ini_password set your password default empty
  12. *@param string $db_ini_dbname set your database name default empty
  13. *@param string $db_ini_port set your :port default empty
  14. *@return PDO
  15. */
  16.  
  17. function __construct($db_ini_dbms,$db_ini_host,$db_ini_username,$db_ini_password=NULL,$db_ini_dbname='',$db_ini_port=''){
  18. #pdo instance
  19. $this->pdo=null;
  20.  
  21. #check for different dbms and catch errors for all exceptions
  22. try{
  23.  
  24. switch ($db_ini_dbms) {
  25. case 'mysql':
  26. #mysql
  27. $this->pdo=new PDO($db_ini_dbms.':host='.$db_ini_host.((!empty($db_ini_port)) ? (';port=' . $db_ini_port) : '').';dbname='.$db_ini_dbname,$db_ini_username,$db_ini_password);
  28. break;
  29.  
  30. case 'mysqli':
  31. #mysqli
  32. mysqli_report(MYSQLI_REPORT_STRICT);
  33. $this->pdo=new mysqli($db_ini_host,$db_ini_username,$db_ini_password,$db_ini_dbname);
  34. break;
  35.  
  36. case 'pgsql':
  37. #postgress
  38. $this->pdo=new PDO($db_ini_dbms.':host='.$db_ini_host.((!empty($db_ini_port)) ? (';port=' . $db_ini_port) : '').';dbname='.$db_ini_dbname.';user='.$db_ini_username.';password='.$db_ini_password);
  39. break;
  40.  
  41. default:
  42. # code...
  43. break;
  44.  
  45. }
  46.  
  47. }catch(Exception $e){ echo "error has occured.Please try to refresh the page"; }
  48. return $this->pdo;
  49. }
  50. function __toString(){
  51. return 'status:connected';
  52. }
  53. }
  54. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement