Guest User

Sql connect

a guest
Dec 20th, 2015
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. class User {
  2. protected $sqlConnection = NULL;
  3.  
  4. function __construct() {
  5. GLOBAL $db;
  6. $this->sqlConnection=$db;
  7. }
  8.  
  9. public function AddUser() {
  10. $sql=$this->sqlConnection;
  11. $fieldValue = "test";
  12. $queryInsert = "INSERT INTO users (nick) VALUES ( :nickname )";
  13. $stmt = $sql->prepare($queryInsert);
  14. $stmt->bindParam(":nickname", $fieldValue, PDO::PARAM_STR);
  15.  
  16. try {
  17. $stmt->execute();
  18. }
  19. catch(PDOExecption $e) {
  20. $sql->rollback();
  21. print "Error!: " . $e->getMessage() . "</br>";
  22. }
  23. }
  24.  
  25. }
  26.  
  27. try {
  28. $db = new PDO('mysql:host=localhost;dbname=adatbazisnev;charset=utf8', 'root', 'admin');
  29. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  30. $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  31. } catch(PDOException $ex) {
  32. echo "An Error occured!";
  33. }
  34.  
  35. $objUser = new User;
  36. $objUser->AddUser();
Advertisement
Add Comment
Please, Sign In to add comment