Hi,

I'm preparing to write a fairly lengthy tutorial on PHP and MySQL. I haven't started writing yet and am in still in the planning stages, but I think I'll cover installation, a basic introduction, including history, an introduction to basic operators and statements, and then some more advance topics.

I'm trying to decide what examples I can use to show these things. Wheteve we build in the tutorial shouldn't be so simple that it's of no practical use, but should start out easily.

Right now, I'm thinking about a Content Management System- that example could show show how to retreive, add, and delete data to/from a MySQL database, and I think I'd be able to include the basic operators and several important functions. I might also be able to include several other things that seem important (like FormMail, perhaps I could include a form to allow users to email articles the the admin).

If anybody has any ideas for examples that they've seen and found helpful or that they'd like to see, please let me know. The example should be of practical use, and should demonstrate enough of PHP to allow readers to understand more than has been completed by the time they finish.

Thanks for your help!

    CMS is a good example of an application, but nobody sees it, so you don't get the "look what I did" ego boost of showing it off to friends on a web site.

    Another application to consider would be a Web Log (or blog). They are fairly simple, and the end product is something the novice can use daily. Here'a a pretty complete implementation in php:

    http://www.phpbb.com/

    On the other hand, you can start with something very small (and unfortunately, unless you like Perl, cryptic) like Blosxom:

    http://www.raelity.org/apps/blosxom/

    Plenty of opportunities to introduce things like database independence, templates (or even skins), etc.

      Write a Reply...