Php Timeline

coco1985

Hi,

I want to make a timeline using php and mySQL. Here is what I want: I want it based on completed tasks. There will be 12 tasks and each task will be a notch on the timeline filled in. Once all 12 tasks are completed, the timeline will be full all the way across.

Does anyone have any idea how to go about creating this? I know I need to create a table in myphpadmin with each tasks as a new row. After that I am stuck.

If anyone could help, that would be awesome!

Thanks!

sfullman

ok generally on this forum we want more specific questions with enough to duplicate the problem. this is too broad.

Having said that, you would need a table with at least the following fields

CompletionDate
Timeline_ID //parent timeline id since I assume these will be groups of 12
Description
Completed //boolean 1|0 - maybe you don't need this I don't know

you'd also need some type of table called timelines

ID
User_ID //the foreign key of the user on that timeline
DateStarted //maybe you need that
DateCompleted //this might be needed to be filled in

You need to do some studying about relational database structure - if you're not familiar with this and you launch right into your project, you'll pay for it in the end. Spend a few hours learning relational db concepts esp. primary to foreign key relationships

Samuel

coco1985

Relational database structure - - got it! I will look it up. Thanks!

coco1985

sfullman;10956351 wrote:
ok generally on this forum we want more specific questions with enough to duplicate the problem. this is too broad.

Having said that, you would need a table with at least the following fields

CompletionDate
Timeline_ID //parent timeline id since I assume these will be groups of 12
Description
Completed //boolean 1|0 - maybe you don't need this I don't know

you'd also need some type of table called timelines

ID
User_ID //the foreign key of the user on that timeline
DateStarted //maybe you need that
DateCompleted //this might be needed to be filled in

You need to do some studying about relational database structure - if you're not familiar with this and you launch right into your project, you'll pay for it in the end. Spend a few hours learning relational db concepts esp. primary to foreign key relationships

Samuel

Hey I just noticed you are in central texas, me too!! I'm in Waco. 🙂