Effortless E-Commerce with PHP and MySQL

11: Site Administration

The last requirement of the Coffee site is the ability to administer it. As a book has limited pages, there’s not enough room to discuss and develop every administrative feature, but this chapter will walk through the most important and complex ones.

The site administration pertains to three categories of information:

• Products

• Sales

• Orders

For each of these, the chapter will present one or more scripts to view and manipulate the respective data, such as adding new products, defining sales, increasing inventory, viewing orders, and so on.

The administrative pages will use neither the MVC approach nor the stored procedures that the public side does. Instead of using stored procedures, the chapter will use prepared ...