I am currenty working on my first attempt at getting my site up and running, I have manged to make a simple login and user accoutn creation processes, but this has got me thinking about the other fetures i wanted to add int he future and how to implement them.
I want user's to be be able to create a list of of things they want to do, With item title and then item discription.
So I was thinkg that my mysql table would basically need the following headers,
author(bascically their user name ), title, discription, Date_created, last_updated
Is this is enuth? It's my first time at makeing a DB and before I set up the user login's I would not have even thought about adding the date created or updated.
Is there another peace of information that might come in handy in the futrure? or something for datebase mangement, in the future ideally user's will be able to ad things to their list's as time goes on and edit them.
Aslo ideally I would like to set up, well for want of better word nice url's, so that when user want to share their list rather than using a link that has a lot php and does some sort of database Search that they could just type in, URL/users/username and be presented with there list, so that they can easily share it with any one.
Also in the futre, well as soon as i get this next bit working I am going to want to be adding a system, for commenets (on indavdual list items) with that in mind (just thinking of this now) would it be an idea to ad in some sort of record id, to which to tie the comment system in to?
First off thanks to any one who takes the time to read all that, sorry its so long but thought it was better to ask all in one go so you could see what direction I want to go in, rather than me find things out one at a time only to find out i am going in the wrong direction.
Is php the solution?
Moderator: General Moderators
PHP will do all that you have written, but you should read through the mysql manual, and do a search on the internet for database designing.
The table you proposed would be better with a Unique Task Id (created with an auto_increment column), which will provide a unique way to find each task. This will aslo allow you to attach comments to each task, which you should keep in a separate table, with key task_id.
As for other information you might need... How about "Task Status"? This can be a flag field that allows the user to see whether their task is New, Started, Finished, Deleted etc. How about adding a "Due Date" to each Task, so that the user can say "This task needs to be completed by..."?
There are probably a few other features you can add, but I'd concentrate on getting the basics working first before you start adding "Nice to have" features.
The table you proposed would be better with a Unique Task Id (created with an auto_increment column), which will provide a unique way to find each task. This will aslo allow you to attach comments to each task, which you should keep in a separate table, with key task_id.
As for other information you might need... How about "Task Status"? This can be a flag field that allows the user to see whether their task is New, Started, Finished, Deleted etc. How about adding a "Due Date" to each Task, so that the user can say "This task needs to be completed by..."?
There are probably a few other features you can add, but I'd concentrate on getting the basics working first before you start adding "Nice to have" features.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
The MySQL Manual: http://dev.mysql.com
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Between 4.1 and 5.1? A fair bit has changed.
Changes for the 4.1 branch: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
Changes for the 5.0 branch: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
Changes for the 5.1 branch: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html
General overview of the features for each: 4.1, 5.0, 5.1
It's a simple search on their site to find this stuff.. You're on your own now.
Changes for the 4.1 branch: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
Changes for the 5.0 branch: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
Changes for the 5.1 branch: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html
General overview of the features for each: 4.1, 5.0, 5.1
It's a simple search on their site to find this stuff.. You're on your own now.