Thursday, February 28, 2008

Week 6 - Critique

For presentation:

1- Clean up links
a) list of links for participants
b) list of links for moderator

2- Activate checked with GUI. Change stickies logo to thought clouds

3 - Possibly make a flyer. Or just save paper...

Wednesday, February 27, 2008

Powerpoint Presentation Outline

10 Minute Presentation must answer the basic questions of What, Why, Who, Where and How.

This should take 5-7 minutes and leave 3 minutes for questions and discussion.

What
- A dynamic collaboration tool to help facilitate brainstorming sessions.

Why
- To be portable and easily replicate information.

How
- Using PHP, MySql and WAP standards the software tool will work on any platform with an internet connection and a web browser.

Where
- Since this is essentially a website, this site can be accessed anywhere.

Who
- For anyone that has brainstorming sessions. For companies that have multiple locations and require a tool for collaboration.

Things to do...

1 - Design participant and moderator pages
2 - Put functionality together
3 - Attach to GUI

More Moderator Functions

View a list of raw data with checkboxes:
LINK
After submit is clicked, a list of the items that were just checked are displayed. If nothing is checked, there is an error.

View a list of items that have been checked:
LINK
After submit is clicked, the checked column will zero out to reset the counter.

Tuesday, February 26, 2008

Duh! Making the checkbox work. (Part 2)

In addition, each item listed needed to be defined in an array:

<input type="checkbox" name="entry[]" value="$row[0]"/>

Then you can call it like this:

$entry = $_POST['entry'];
foreach($entry as $checked)
{
$SqlStatement1 = "UPDATE database_01 SET checked=1 WHERE id=$checked";

Monday, February 25, 2008

Duh! Making the checkbox work.

First get the syntax to UPDATE a database entry correctly. I had quotes where I didn't need them and that broke things.

Should look like:

$SqlStatement = "UPDATE table_name SET table_item=item, table_item2=item2 WHERE table_item="something";

So where it stands now is that the checked entry seems to update, but only one item. If I have multiple items checked, only the last item checked registers. Not sure why my loops are not working.

Wednesday, February 20, 2008

Week 5 - Critique

1 - Instead of post-its: perhaps thought bubbles or light bulbs
2 - Work on Powerpoint presentation
3 - Have working demo by next week