• Registered: 2005-03-07
  • Posts: 362

Topic: PHP/MySql Support/Ideas/Help Needed Please

I am creating a website for a musician who would like an organic/nature feel to the website. He sent me some photos of fish he wanted on the site and I decided to create something a little more dynamic for him.

http://www.izzy.34sp.com/fish.swf

On the frontpage of the site I want that animated fishtank (made in SwishMax). I want to create a PHP script/database that records how often the fish are fed. I want visitors of the site to have the option of 'feeding the fish'. If the fish aren't fed at least once every 6 hours they will die  :cry: I would like a real-time clock that also displays 'when the fish were last fed' and 'time remaining to feed fish again'.... when someone feeds them it resets the timer to say 6 hours before fish die etc...

Is this possible? Am I right in thinking that it has to be done in PHP/mysql? If someone could donate a little time to me on this project I would be very greatful, please spout forth your ideas big_smile

Thank you,
Will
admin@new-york-dolls.com

Punbb mods & styles

downliner's Website

  • Registered: 2005-09-12
  • Posts: 1

Re: PHP/MySql Support/Ideas/Help Needed Please

This is a different variation of the virtual pet theme.

This is pretty straight forward, but an excellent project to learn PHP and database development - mySQL would be my choice of databases because there are lots of howto articles to help you.

I suggest that you start with PHP sites such as the following and begin reviewing articles and code:
http://www.findingfacts.com/L3/L3_2_29_46.php
You probably won't find the exact code segment that you need, but eventually you will cobble together enough code snipits to do the job. On the way you will have learned to use PHP because it's a very easy language to learn. Next I would look at pages such as this on MySQL and learn databases:
http://www.findingfacts.com/L3/L3_54_55_59.php