I am having a hell of a time trying to figure out why my syntax is not working.
It states that I have a syntax error on line 33, with an unexpected “}”. How do I fix that?
Here is the code:
<?php class DB { private static $_instance = null; private $_pdo, $_query, $_error = false, $_results, $_counts = 0; private function _constuct() { try { $this->_pdo = new PDO('mysql:host=' .Config::get('mysql/host') .';dbname=' . Config::get('mysql/db'), Config::get('mysql/username'), Config::get('mysql/password')); } catch(PDOException $e) { die($e->getMessage()); } } public static function getInstance(){ if(!isset(self::$_instance)) { self::$_instance = new DB(); } return self::$_instance; } public function query($sql, $params = array()){ $this->_error = false; if($this->_query =$this_pdo->prepare($sql)) { $x = 1; if(count($params)) { foreach($params as $param) { $this->_query->bindValue($x, $param); $x++ [size=18pt][b] }[/b][/size] } if($this->_query->execute()) { $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ); $this->count = $this->_query->rowCount(); } else { $this->_error = true; } } return $this; } public function action($action, $table, $where = array()) { if(count($where) === 3) { $operators = array('=', '>', '<', '>=', '<='); $field = $where[0]; $operator = $where[1]; $value = $where[2]; if(in_array($operator, $operators)) { $sql = "{$action} FROM {$table} WHERE {$field} {$operator} ?"; if($this->query($sql, array($value))->error()) { return $this; } } } return false; } public function get($table, $where) { return $this->action('SELECT *', $table, $where); } public function delete($table, $where) { return $this->action('DELETE', $table, $where); } public function insert($table, $fields = array()) { if(count($fields)) { $keys = array($fields); $values = null; $x = 1; $sql = "INSERT INTO users (`" . implode('`,`', $keys) . "`)"; echo $sql; } return false; } public function results(){ return $this->_error; } public function first() { return $this->results()[0]; } public function error() { return $this->_error; } public function count() { return $this->_count; } } I have bolded it and made it red. Any help please?!