hi i need a php to do the following

Someone fills out a form, which will contain the following

Your Artist Name :
Your Track Name :
The Track Link :
and a checkbox agreeing that this information will be displayed on the website.

Then basically, i want it to connect to a mysql database, which will store all this information.

Then, i want a php page which will display all this information, for 30 days, once 30 days has exceeded, the data is deleted from the database.

Would this be hard? and how much would it cost me?

please feel free to msg me or email me. Thanx

That's easy
I would guess about 1-2 hours so I would charge around $80 (US-Dollar) for that at most.

Marian

http://www.programmingbids.com

Make sure you can run crons on your hosting service. you will need it if you want it to delete automatically.

$80 -$100 sounds about right.

Robert

Hi matt2kjones, please check your email. :)

Originally posted by GWDGuy
Make sure you can run crons on your hosting service. you will need it if you want it to delete automatically.

$80 -$100 sounds about right.

Robert

You don't NEED to run crons ;)

If you don't need a cron what is going to tell it when to delete? It needs that info from the server?? Maybe I am making it harder than it needs to be.. We run a bunch of crons.

I would be thankful for some insight :D

Assuming people will be visiting this page of information on a daily basis, just insert some logic in the page to detect how long the entries have been on the page. If it's past 30 days, wipe it away.

Oh I understand that. Fake cron type deal I was thining what if someone does not go on one of the days that needs to be deleted then they would not know to get removed.. I thought maybe there was another way... No problem :D

Thanks
Robert

You can set the mySQL timestamp ... it takes the form

yyyymmddhhmmss - Example: 20020713245959

Anyways ... you COULD use logic to find what 30 days ago was ...

For this, what I would do, is to get the current epoch time, then subtract 30 days worth of seconds ... then convert epock time into the mySQL timestamp format (this is not that hard to do).

The OTHER option, is to write a cron that does the above ... set an active field for each entry ... if it's older than 30 days, then set active to 0. I like this way, because you can re-activate old entries (I'm assuming they're paying to be up, so why not leave this option in) ...

The part you've described, which is a form, and a mySQL table ... it's a piece of cake ...

Interesting... Thanks for the info.. :D

Robert

wow, thanx for all the replies, pm's and emails guys

I have it sorted now thanx,

thanx for everyone replying, very greatfull

Just out of interest, how much did you pay for this script in the end?

$7,980.87