Guest User

Untitled

a guest
Aug 6th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. class db {
  2. function openDB($db = '') {
  3. global $epConfig;
  4. if($db==''){$db=$epConfig['dbname'];}
  5. $_server = $epConfig['server'];
  6. $_dbname = $db;
  7. $_dbport = $epConfig['dbport'];
  8. $_dbuser = $epConfig['dbuser'];
  9. $_dbpass = $epConfig['dbpass'];
  10. $con = pg_connect("host=$_server port=$_dbport dbname=$_dbname user=$_dbuser password=$_dbpass");
  11. return $con;
  12. }
  13.  
  14. function closeDB($db) {
  15. $cls = pg_close($db);
  16. $log = debug_backtrace();
  17. if (!$cls) {
  18. $this->logMessage($log);
  19. }
  20. return $cls;
  21. }
  22. function exec_query($query) {
  23. $q = pg_query($query);
  24. $log = debug_backtrace();
  25. if (!$q)
  26. $this->logMessage($log);
  27. return $q;
  28. }
  29.  
  30. $db=new db();
  31. $connection=$db->openDB();
  32. $db->exec_query("...sql command...");
  33. $db->closeDB($connection);
  34.  
  35. pg_close(): supplied resource is not a valid PostgreSQL link resource
Add Comment
Please, Sign In to add comment