public function insert() { if (!is_null($this->id)) { trigger_error("User::insert(): Attempt to insert a user object that already has its ID property set to {$this->id}.", E_USER_ERROR); } $conn = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD); $sql = "INSERT INTO " . TABLENAME_REQUESTS . " ( type, sentById, sentToId, status ) VALUES ( :type, :sentById, :sentToId, :status)"; $st = $conn->prepare($sql); $st->bindValue(":type", $this->type, PDO::PARAM_STR); $st->bindValue(":sentById", $this->sentById, PDO::PARAM_INT); $st->bindValue(":sentToId", $this->sentToId, PDO::PARAM_INT); $st->bindValue(":status", $this->status, PDO::PARAM_STR); // print_r( $st ); $result = $st->execute(); $this->id = $conn->lastInsertId(); $conn = null; if (!$result) { self::$errorMessage = "User::insert: Insertion Failed, PDO::errorInfo(): " . $st->errorCode() . ": " . $st->errorInfo()[2]; self::$errorCode = $st->errorCode(); //echo $errorMessage; return false; } else { self::$successMessage = "User::insert: User successfully inserted with id " . $this->id; return true; } }