i'm making a little "to-do" list type thing using PHP which i plan to put in my startup of my WinXP start menu, so it launches each time i re-start-- thereby showing me my "to-do" list as statused the last time i viewed it-- if i restart once a day, i can see my personal to-do list once per day, and have the option of inserting new records, or modifying the "state of progress", an Enum, showing either Not Started, In Progress, or Completed.
since this is a single page-view in my broswer showing the data upon loading, i want little intervention to occur. i'd like to have in that display, currently 4 table cells showing task name, description, progress, and date added, to include an additional place for 3 radio buttons (or option /select -- any input method will do).
how do i approach the task of allowing for the UPDATE query to take place from that initial display-- where the SELECT query has already happened?
my first thought is that i have 2 options (and many more, i'm sure):
option/select dropdown "inside" of each item row in the table, so six items would yeild six dropdown boxes or radio buttons**
display the item_id (primary key) next to each item in the table display, and offer only one select box showing all ids, and one radio button set offering the 3 Enum choices-- so that i can enter the item id, and do an update progress state to XYZ-radio where item_id = (my option value)
then i want the page to reload w/ the updated info, again offering the option to update a status or go to another page (or the same page) and enter a completely new to-do list item.
this is simple, i know-- but, does it sound like the latter of my choices above will be all i need? i wish i could do the former, but i can't think how that would be done w/out having to go though and re-status each individual item's buttons or list, so that upon UPDATE, they are all statused the same as before. -- i suppose that's really my inquiry here-- if i chose to use that method, it would be as follows:
**How could i get 3 radio buttons, or 3 select lists to show the current status respective to each item when the dynamic data is drawn-- based on their existing state on startup?
this is important to me because i see the value in how i could apply it to a more complex, 'real world' application some day-- in which the latter of my options above might NOT be an available choice. considering that scenario, i was thinking i would need to use javascript to do the former of the two ideas above, but perhaps not? hmph-- and i thought this was going to be a great opportunity to learn a little javascript! ugh, so many ways to do the same thing!
🙂
thanks for reading!! i look forward to your reply.
