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...
ict.social 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 :)
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.
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.
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|