Page 1 of 1

What sample application should I make?

Posted: Fri May 13, 2011 1:39 pm
by 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?

Re: What sample application should I make?

Posted: Fri May 13, 2011 2:01 pm
by jacek
Tino wrote: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.

Re: What sample application should I make?

Posted: Fri May 13, 2011 5:26 pm
by 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.

Re: What sample application should I make?

Posted: Fri May 13, 2011 5:27 pm
by EcazS
Tino wrote:Something with JOINs


Posts table, comments table :lol:

Re: What sample application should I make?

Posted: Fri May 13, 2011 6:08 pm
by jacek
Tino wrote: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.

Tino wrote:I don't know how many people there are here that aren't on phpacademy ;)

I think none :lol:

Re: What sample application should I make?

Posted: Fri May 13, 2011 6:19 pm
by Tino
Considering more and more people seem to be suggesting a blog (not just here, also elsewhere), a blog it will be :)

Re: What sample application should I make?

Posted: Fri May 13, 2011 6:38 pm
by Temor
jacek wrote:
Tino wrote:I don't know how many people there are here that aren't on phpacademy ;)

I think none :lol:


I actually made my phpacademy account after this one.

Re: What sample application should I make?

Posted: Fri May 13, 2011 6:56 pm
by jacek
Temor wrote:I actually made my phpacademy account after this one.

:D

Tino wrote: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 :D

Will be interesting to see what you come up with :D

Re: What sample application should I make?

Posted: Fri May 13, 2011 7:04 pm
by Tino
Sometimes when I'm bored I go and make a blog just for the sake of doing something :lol:

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?

Re: What sample application should I make?

Posted: Fri May 13, 2011 7:28 pm
by jacek
Tino wrote: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.


Tino wrote: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 ! :lol:

Re: What sample application should I make?

Posted: Fri May 13, 2011 7:30 pm
by 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 :lol:

Re: What sample application should I make?

Posted: Fri May 13, 2011 8:58 pm
by 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 :)