ppicasso772 Posted July 17, 2015 Share Posted July 17, 2015 (edited) <?php class Database{ private $host = DB_HOST; private $user = DB_USER; private $pass = DB_PASS; private $dbname = DB_NAME; private $dbh; private $error; private $stmt; public function __construct(){ // Set DSN $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname; // Set options $options = array( PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ); // Create a new PDO instanace try{ $this->dbh = new PDO($dsn, $this->user, $this->pass, $options); } // Catch any errors catch(PDOException $e){ $this->error = $e->getMessage(); } } } public function query($query){ $this->stmt = $this->dbh->prepare($query); } public function bind($param, $value, $type = null){ if (is_null($type)) { switch (true) { case is_int($value): $type = PDO::PARAM_INT; break; case is_bool($value): $type = PDO::PARAM_BOOL; break; case is_null($value): $type = PDO::PARAM_NULL; break; default: $type = PDO::PARAM_STR; } } $this->stmt->bindValue ( $param, $value, $type); } public function execute(){ return $this->stmt->execute(); } public function resultset(){ $this->execute(); return $this->stmt->fetchAll(PDO::FETCH_OBJ); } public function single(){ $this->execute(); return $this->stmt->fetch(PDO::FETCH_OBJ); } public function rowCount(){ return $this->stmt->rowCount(); } public function lastInsertId(){ return $this->dbh->lastInsertId(); } public function beginTransaction(){ return $this->dbh->beginTransaction(); } public function endTransaction(){ return $this->dbh->commit(); } public function cancelTransaction(){ return $this->dbh->rollBack(); } what is problem here i could not fix it .line 32 with red color Edited July 17, 2015 by Ch0cu3r Added code tags Quote Link to comment Share on other sites More sharing options...
requinix Posted July 17, 2015 Share Posted July 17, 2015 Count your {s and }s and see which ones match up with which ones. Proper indentation will also make it much easier to read. Quote Link to comment Share on other sites More sharing options...
ppicasso772 Posted July 17, 2015 Author Share Posted July 17, 2015 would u send me ur mail. ? i will send project Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted July 17, 2015 Share Posted July 17, 2015 The problem is caused because you have two many } for closing your constructor. This is results in the class definition closing prematurely and so this is why you are getting the error. public function __construct(){ // Set DSN $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname; ... code omitted .. catch(PDOException $e){ $this->error = $e->getMessage(); } } } // <--- remove this line Quote Link to comment Share on other sites More sharing options...
ppicasso772 Posted July 17, 2015 Author Share Posted July 17, 2015 thx soooo much . it s ok now Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.