What sample application should I make?

[Tino]

I'll just post it here as well in hopes of getting more responses

So I am in the process of re-recording the MySQL videos for phpacademy, and I have run into some problems! Actually just one.

When I first started doing this, I had some application in mind. Being myself though, I forgot what it was and I just can't seem to think of what it was anymore.

So, my question to you people is, what do you think would be a good sample application to do?

[jacek]

I'll just post it here as well in hopes of getting more responses

Because of all the extra members ?

I will reply here though.

But what does this application need to include ? the obvious one is a blog or a CMS type ting.

[Tino]

I don't know how many people there are here that aren't on phpacademy

It needs to include.. Anything with a database really. Something with JOINs, probably, and maybe something that makes use of some functions like SUM and IF to demonstrate how to use those. It doesn't matter too much, really.

[EcazS]

Something with JOINs

Posts table, comments table

[jacek]

It needs to include.. Anything with a database really. Something with JOINs, probably, and maybe something that makes use of some functions like SUM and IF to demonstrate how to use those. It doesn't matter too much, really.

Depending on how you do it, the simple blog can use all of those.

I don't know how many people there are here that aren't on phpacademy

I think none

[Tino]

Considering more and more people seem to be suggesting a blog (not just here, also elsewhere), a blog it will be

[Temor]

I don't know how many people there are here that aren't on phpacademy

I think none

I actually made my phpacademy account after this one.

[jacek]

I actually made my phpacademy account after this one.

Considering more and more people seem to be suggesting a blog (not just here, also elsewhere), a blog it will be

The blog is a nice example, and it contains most of the complicated database things, although it is a bit boring in the sense that its the first thing anyone thinks to make. but if you add something cool it will be great

Will be interesting to see what you come up with

[Tino]

Sometimes when I'm bored I go and make a blog just for the sake of doing something

Yes, it's been done to death, so I will need to add some unique little twist to it. Well, maybe not unique, but something that doesn't get done all the time.

Ideas?

[jacek]

Yes, it's been done to death, so I will need to add some unique little twist to it. Well, maybe not unique, but something that doesn't get done all the time.

Ideas?

You can't plan a twist and not know what it will be !

Erm, I guess just go for a more complete system, most of the tutorials are just on the basics of it (including mine). Like you could have an account system, with permissions for various things.

Or you could use HTML5 AJAX jQuery CSS3 forms instead of normal ones, all those buzz words would get the views rolling in !

[EcazS]

Comment avatars?

If you have field where you can enter a URL to your website you can check if it's an image and set it has their comment avatar if it's not then have a default avatar

[Tino]

Personally I was thinking about categorising blog posts.

Of course I'll take a look at everything and see what I'm going to do. Every suggestion sounds interesting though