Save up to 80 % on our C# e-learning courses. Only this week!
Get up to 50 % extra points for free! More info

Lesson 11 - Enhancing the wrapper and editor

In the previous lesson, The flash-message mechanism, we added a flash message mechanism to the system, which displays messages to users. In today's tutorial, we'll start working on the administration section. Since it's a rather complicated thing, it will take up several lessons. On the bright side, you'll get a solid and simple CMS with everything one should contain. It will undoubtedly serve you as the base for any website you could want/need to build.

Improving the database wrapper

Earlier, we made a Db class that wraps the PDO driver and lets us work with the database in an object-oriented way from anywhere in the application. We promised that this class would serve as a so-called CRUD. Meaning that it provides methods that facilitate creating, reading, updating and deleting data in the database. Theoretically, we could use the wrapper as it is now even to execute INSERT and UPDATE clauses. However, it'd be rather uncomfortable to do so. Therefore, we'll add some more useful methods for inserting and updating rows.


...End of the preview...

Premium article

Premium article is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.

Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)

Article description

Requested article covers this content:

In this tutorial, we'll extend the database wrapper with INSERT and UPDATE methods, and start working on the article editor for our object-oriented CMS.

Limited offer: Learn all knowledge and save money

Buy articles and tests separately one by one 40 points
Buy all currently available articles in the section including all features for an exclusive price 34 points
Currently, you have 0 points
By buying this exclusive package, you'll have access to all 13 articles in this course including exercise submitting while saving $0.54. This offer is limited for the first articles only with an additional exclusive 15% discount.
You gain 34 points for adding an article to the site, or for $3.60 $3.06

Warning, by buying just this article you'll lose the limited 15% discount for the package of all the articles.

To access the article, you need 10 points
Currently, you have 0 points
You gain 10 points for adding an article to the site, or for $0.90

Before buying this article, you have to buy the previous one

Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.

This article is licensed: Premium, by buying this article, you agree with the terms of use.

You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.

You can get points immediately using:

Credit card SMS Wire transfer
Credit card SMS Wire transfer
Article has been written for you by David Capka
The author is a programmer, who likes web technologies and being the lead/chief article writer at He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.
Unicorn university The author learned IT at the Unicorn University - a prestigious college providing education on IT and economics.
Activities (9)