Is php the solution?
Posted: Tue Aug 22, 2006 8:42 am
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.
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.