zipkda.blogg.se

When you need a web app that heavily relies on a database.

PHPMaker without writing a single line of code. In our case we need to create two tables: CREATE TABLE books ( book_idint(8) primary key auto_increment, titlevarchar(50) not null, authorvarchar(50) not null, covervarchar(100) ) CREATE TABLE users ( user_idint(8) primary key auto_increment, usernamevarchar(20) not null, passwordvarchar(20) not null, user_levelint(2) default 0, loanedint(8) references books(id) ) Open phpMyAdmin and write out your MySQL statements. You must create a database with your tables first. Staffs will be able to add/edit/remove books as well as register/deregister members. Members will be able to search the library catalogue and list books by categories. We’ll be making a simple web application for a library. The menu, for example, is on the left by default which you cannot change through PHPMaker, but you can manually edit the generated code and position the menu to the top. Things which we can do with PHPMaker is only limited by our understanding of the generated code.

Instead of reinventing the wheel, we’ll rely on PHPMaker to do the hard work for us. Coding a database driven website is more difficult than it sounds.

PHPMaker generates clean code and is useful when you need a web app that heavily relies on a database. You can make a pretty complex web application with PHPMaker without writing a single line of code.