Board index   FAQ   Search  
Register  Login
Board index PHP PHP General

Feedback System PHP/MySQL

General discussions related to php

Moderators: macek, egami, gesf

Feedback System PHP/MySQL

Postby Pritesh23 » Sun Aug 25, 2013 6:47 am

I need to develop Feedback module in PHP/MySQL. I would like to know the database design and flow to manage this system.

There are questions for 2 tools which i need to store in my databse and need to create report like %of Positive Response, % of Negative Response, No. of Users for Tool1/2 etc.

I would like to how one can create for Question 2? I mean it based on first response, IF NO, then and then it should ask for WHY.


It would be great if i have any similar example/code/link etc.

Thanks in advanced for your input.

Tool 1
Code: Select all
1.Are you satisfied with the performance of the tool ? Yes/No
2.Are you satisfied with the support provided? Yes/No
         IF NO, Why ?
3.If you need to improve, they are the three major changes you propose Yes/No
         IF Yes, -----****----
4.What are the general points (up to 3) that you would like to improve on the project Yes/No
         IF Yes, -----****----


Tool 2
Code: Select all
1.Are you satisfied with the performance of the tool ? Yes/No
2.Are you satisfied with the support provided? Yes/No
         IF NO, Why ?
3.If you need to improve, they are the three major changes you propose Yes/No
         IF Yes, -----****----
4.What are the general points (up to 3) that you would like to improve on the project Yes/No
         IF Yes, -----****----


:help: :)
Pritesh23
New php-forum User
New php-forum User
 
Posts: 25
Joined: Wed Jul 17, 2013 12:42 pm

Re: Feedback System PHP/MySQL

Postby johnj » Sun Aug 25, 2013 7:26 pm

Just go ahead and design the application.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Feedback System PHP/MySQL

Postby Pritesh23 » Sun Aug 25, 2013 11:48 pm

Just go ahead and design the application.


For DB:
One possible solution can be like this:

Tool[tool_id(PK),tool_name,description(if required)]
User[user_id(PK),user_name,email_id,display_name(if registered user)]
Question[question_id(PK),question]
feedback[feedback_id,user_id,tool_id,question_id,comment,satisfaction(0 for No/1 for Yes)].

I am not sure it is best solution or not.

I don't know for the report chart and Question 2.
Pritesh23
New php-forum User
New php-forum User
 
Posts: 25
Joined: Wed Jul 17, 2013 12:42 pm

Re: Feedback System PHP/MySQL

Postby johnj » Tue Aug 27, 2013 5:23 am

do a database design - draw an entity relationship diagram, then do 1 nornal form, 2 NF and 3NF and then reduce this to relevant tables.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Feedback System PHP/MySQL

Postby johnj » Tue Aug 27, 2013 5:24 am

I cannot do the database design for you unless you are willing to pay me.
johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Feedback System PHP/MySQL

Postby johnj » Tue Aug 27, 2013 5:35 am

johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Feedback System PHP/MySQL

Postby Pritesh23 » Tue Aug 27, 2013 12:39 pm

I cannot do the database design for you unless you are willing to pay me.


Thanks for your input but i am not asking for total design DB / module. :)

I just would like to get ruff idea and best possible options before starting my work. :D
Pritesh23
New php-forum User
New php-forum User
 
Posts: 25
Joined: Wed Jul 17, 2013 12:42 pm

Re: Feedback System PHP/MySQL

Postby johnj » Tue Aug 27, 2013 7:59 pm

johnj
php-forum Super User
php-forum Super User
 
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Feedback System PHP/MySQL

Postby Pritesh23 » Thu Sep 05, 2013 8:49 am

It seems good but i believe the databse design is almost based on the link that you gave.

Any example would be great for Question 2.

:help:
Pritesh23
New php-forum User
New php-forum User
 
Posts: 25
Joined: Wed Jul 17, 2013 12:42 pm


Return to PHP General

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron