Public opinion website is a general people’s opinion site. All kinds’ of society people says mind space here. We publish his/her important comment, remark, some day some time some news have very important, and observe all kind’s people. They give advice, suggestion, idea and wrath letter post my web. This website has an objective is to rectify specific people such as government minister, government employee, opposite party to government and other political leader even general people. On the other hand some news very affective in our society like culture, games, music, information technology, university, college, office, court, educational life. However news concerning comment very effective and this work finish by my website. They can comment about their division, district and Thana.
General problems:
- General people can’t give their opinion to authorize.
- General people share problem and solution.
Technical problems:
- The existing system takes more places to store the old folder/files.
- Sometimes folder/files may be destroyed by insects or by another way.
- It is a little unsecured approach to records confidential data.
- Inappropriate way of storing data.
Academic Challenge:
In this project I will meet people with real problems and these very much suitable for me to apply my academic knowledge in a real world project. In this project I have tried to emphasize on the whole system development life cycle from feasibility study to implement phase of the new proposed system. This system will cover the full development, which will definitely produce an effective and efficient system on demand.
Benefit of authorize:
Government and his administrator officer know what the problem is. On the other hand any authorize know their company or office can specify where the problem. Then they can find to easy way to solve this problem.
Benefit of people:
General people have many problems. But they can’t inform this problem to the administrator officer. So they can publish World Wide Web her/his problem with document. We hope it will be solved and people will be benefited.
Flexibility:
This web will be very flexible for both the users and organization. The organization can change any existing contain whenever they went to.But they will need proper authorization of the authority and the secret password.
Reliability:
This web will be very reliable. This web will provide all the support they need. So as long as the organization run their communication using this web it will works properly and will available to use.
Security:
This web will be very secured and reliable, because there used login id and password, and it can ensure that illegal access. So, no one but only the authorized person will be able to change, re-write the web contain.
Technical feasibility:
This is concerned about hardware and software. It may also include the facility to communication over a network between geographically separate sites of the organization. The feasibility study will need to consider whether the level of the technological advancement needed for the purpose has yet been reached, and to determine the availability and the stability of the appropriate technology. Another important facet of technical feasibility is that it concerns about the availability of the technological support.
Human factors:
There is no system that could be run without human support. Human factor considers the human, organizational and political aspects. The issue that is given priority under this topic is what are the effects that the proposed system is bringing on people’s job these issues are important. Because it is believed that technology reduces the need of human and authorized.
Language to be used:
- HTML
- JAVA SCRIPT
- CSS
- PHOTOSHOP
- FLASH
- PHP
- MYSQL
- JQUERY
SYSTEM SPECIFICATION:
Minimum Hardware Specification
- Processor Pentium VI 2.0 G Hz or Compatible
- H.D.D space at least 1 GB
- Additional Space for temporary files during installation and running.
- RAM DDR 1GB
- VGA (Video RAM) 64 MB
- Printer (if you print any news).
Software Specification:
- Operating System (Windows XP)
- Internet Information Services (IIS) application server
- MYSQL Server
- Apace Web Server
Designing & Documenting Specification:
- MS Office 2007
- Macromedia Dreamweaver
- Adobe Photoshop
- Macromedia flash 8
Initial Study
Public opinion website is a general people’s opinion site. All kinds’ of society people says mind space here. We publish his/her important comment, remark, some day some time some news have very important, and observe all kind’s people. They give advice, suggestion, idea and wrath letter post my web. This website has an objective is to rectify specific people such as government minister, government employee, opposite party to government and other political leader even general people. On the other hand some news very affective in our society like culture, games, music, information technology, university, college, office, court, educational life. However news concerning comment very effective and this work finish by my website. They can comment about their division, district and Thana.
The explosive growth of the Internet and the World Wide Web has given rise to an equally explosive growth in various types of online polls and surveys.
Online surveys can be scientific if the samples are drawn in the right way. Some online surveys start with a scientific national random sample and recruit participants while others just take anyone who volunteers. Online surveys need to be carefully evaluated before use.
Several methods have been developed to sample the opinions of those who have online access. The fundamental rules of sampling still apply online: the pollster must select those who are asked to participate in the survey in a random fashion. In those cases where the population of interest has nearly universal Internet access or where the pollster has carefully recruited from the entire population, online polls are candidates for reporting.
However, even a survey that accurately sampled all those who have access to the Internet would still fall short of a poll of all Bangladeshi, as about one in three adults do not have Internet access.
But many Internet polls are simply the latest variation on the pseudo-polls that have existed for many years. Whether the effort is a click-on Web survey, a dial-in poll or a mail-in survey, the results should be ignored and not reported. All these pseudo-polls suffer from the same problem: the respondents are self-selected. The individuals choose themselves to take part in the poll – there is no pollster choosing the respondents to be interviewed.
Remember, the purpose of a poll is to draw conclusions about the population, not about the sample. In these pseudo-polls, there is no way to project the results to any larger group. Any similarity between the results of a pseudo-poll and a scientific survey is pure chance.
Clicking on your candidate’s button in the “voting booth” on a Web site may drive up the numbers for your candidate in a presidential horse-race poll online. For most such efforts, no effort is made to pick the respondents, to limit users from voting multiple times or to reach out for people who might not normally visit the Web site.
Mail-in coupon polls are just as bad. In this case, the magazine or newspaper includes a coupon to be returned with the answers to the questions. Again, there is no way to know who responded and how many times each person did.
Another variation on the pseudo-poll comes as part of a fund-raising effort. An organization sends out a letter with a survey form attached to a large list of people, asking for opinions and for the respondent to send money to support the organization or pay for tabulating the survey. The questions are often loaded and the results of such an effort are always meaningless.
This technique is used by a wide variety of organizations from political parties and special-interest groups to charitable organizations. Again, if the poll in question is part of a fund-raising pitch, pitch it – in the wastebasket.
Flexibility Study
Benefit of authorize:
Government and his administrator officer know what the problem is. On the other hand any authorize know their company or office can specify where the problem. Then they can find to easy way to solve this problem.
Benefit of people:
General people have many problems. But they can’t inform this problem to the administrator officer. So they can publish World Wide Web her/his problem with document. We hope it will be solved and people will be benefited.
Flexibility:
This web will be very flexible for both the users and organization. The organization can change any existing contain whenever they went to. But they will need proper authorization of the authority and the secret password.
Reliability:
This web will be very reliable. This web will provide all the support they need. So as long as the organization run their communication using this web it will works properly and will available to use.
Security:
This web will be very secured and reliable, because there used login id and password, and it can ensure that illegal access. So, no one but only the authorized person will be able to change, re-write the web contain.
Technical feasibility:
This is concerned about hardware and software. It may also include the facility to communication over a network between geographically separate sites of the organization. The feasibility study will need to consider whether the level of the technological advancement needed for the purpose has yet been reached, and to determine the availability and the stability of the appropriate technology. Another important facet of technical feasibility is that it concerns about the availability of the technological support.
Analysis
Fact-Finding:
After approving my project proposal, I have started the fact-finding stage of the project development. In the fact-finding segment of this project, I have considered four methods for finding the required information of this organization. The methods are:
- Background Reading;
- Interview
Background Reading:
In the fact-finding part, at first, I have completed the background reading of people problem and visit the all opinion sites.
Because polls give approximate answers, the more people interviewed in a scientific poll, the smaller the error due to the size of the sample, all other things being equal. A common trap to avoid is that “more is automatically better.” While it is absolutely true that the more people interviewed in a scientific survey, the smaller the sampling error, other factors may be more important in judging the quality of a survey.
Who did the poll?
What polling firm, research house, political campaign, or other group conducted the poll? This is always the first question to ask.
If you don’t know who did the poll, you can’t get the answers to all the other questions listed here. If the person providing poll results can’t or won’t tell you who did it, the results should not be reported, for their validity cannot be checked.
Reputable polling firms will provide you with the information you need to evaluate the survey. Because reputation is important to a quality firm, a professionally conducted poll will avoid many errors.
Who should have been interviewed and was not? Or do response rates matter?
No survey ever reaches everyone who should have been interviewed. You ought to know what steps were undertaken to minimize non-response, such as the number of attempts to reach the appropriate respondent and over how many days.
When was the poll done?
Events have a dramatic impact on poll results. Your interpretation of a poll should depend on when it was conducted relative to key events. Even the freshest poll results can be overtaken by events. The President may have given a stirring speech to the nation, pictures of abuse of prisoners by the military may have been broadcast, the stock market may have crashed or an oil tanker may have sunk, spilling millions of gallons of crude on beautiful beaches.
Poll results that are several weeks or months old may be perfectly valid, but
The explosive growth of the Internet and the World Wide Web has given rise to an equally explosive growth in various types of online polls and surveys.
Online surveys can be scientific if the samples are drawn in the right way. Some online surveys start with a scientific national random sample and recruit participants while others just take anyone who volunteers. Online surveys need to be carefully evaluated before use.
Several methods have been developed to sample the opinions of those who have online access. The fundamental rules of sampling still apply online: the pollster must select those who are asked to participate in the survey in a random fashion. In those cases where the population of interest has nearly universal Internet access or where the pollster has carefully recruited from the entire population, online polls are candidates for reporting.
However, even a survey that accurately sampled all those who have access to the Internet would still fall short of a poll of all Americans, as about one in three adults do not have Internet access.
But many Internet polls are simply the latest variation on the pseudo-polls that have existed for many years. Whether the effort is a click-on Web survey, a dial-in poll or a mail-in survey, the results should be ignored and not reported. All these pseudo-polls suffer from the same problem: the respondents are self-selected. The individuals choose themselves to take part in the poll – there is no pollster choosing the respondents to be interviewed.
Remember, the purpose of a poll is to draw conclusions about the population, not about the sample. In these pseudo-polls, there is no way to project the results to any larger group. Any similarity between the results of a pseudo-poll and a scientific survey is pure chance.
Mail-in coupon polls are just as bad. In this case, the magazine or newspaper includes a coupon to be returned with the answers to the questions. Again, there is no way to know who responded and how many times each person did.
Another variation on the pseudo-poll comes as part of a fund-raising effort. An organization sends out a letter with a survey form attached to a large list of people, asking for opinions and for the respondent to send money to support the organization or pay for tabulating the survey. The questions are often loaded and the results of such an effort are always meaningless.
This technique is used by a wide variety of organizations from political parties and special-interest groups to charitable organizations. Again, if the poll in question is part of a fund-raising pitch, pitch it – in the wastebasket.
What questions were asked?
You must find out the exact wording of the poll questions. Why? Because the very wording of questions can make major differences in the results.
Perhaps the best test of any poll question is your reaction to it. On the face of it, does the question seem fair and unbiased? Does it present a balanced set of choices? Would most people be able to answer the question?
On sensitive questions – such as abortion – the complete wording of the question should probably be included in your story. It may well be worthwhile to compare the results of several different polls from different organizations on sensitive questions. You should examine carefully both the results and the exact wording of the questions.
In what order were the questions asked?
Sometimes the very order of the questions can have an impact on the results. Often that impact is intentional; sometimes it is not. The impact of order can often be subtle.
During troubled economic times, for example, if people are asked what they think of the economy before they are asked their opinion of the president, the presidential popularity rating will probably be lower than if you had reversed the order of the questions. And in good economic times, the opposite is true.
What is important here is whether the questions that were asked prior to the critical question in the poll could sway the results. If the poll asks questions about abortion just before a question about an abortion ballot measure, the prior questions could sway the results.
What else needs to be included in the report of a poll?
The key element in reporting polls is context. Not only does this mean that you should compare the poll to others taken at the same time or earlier, but it also means that you need to report on what events may have impacted on the poll results.
A good poll story not only reports the results of the poll but also assists the reader in the interpretation of those results. If the poll shows a continued decline in consumer confidence even though leading economic indicators have improved, your report might include some analysis of whether or not people see improvement in their daily economic lives even though the indicators are on the rise.
If a candidate has shown marked improvement in a horse race, you might want to report about the millions of dollars spent on advertising immediately prior to the poll.
Putting the poll in context should be a major part of your reporting.
So I’ve asked all the questions. The answers sound good. Should we report the results?
Yes, because reputable polling organizations consistently do good work.
Also remember that no matter how good the poll, no matter how wide the margin, no matter how big the sample, a pre-election poll does not show that one candidate has the race “locked up.” Things change – often and dramatically in politics. That’s why candidates campaign.
If the poll was conducted correctly, and you have been able to obtain the information outlined here, your news judgment and that of your editors should be applied to polls, as it is to every other element of a story.
In spite of the difficulties, the public opinion survey, correctly conducted, is still the best objective measure of the state of the views of the public.
Interview
After completing my observation part, I have started, to take interview from the journalist and general public. The interview details are given bellow:
Interview With journalist:
At first I have take interview from the journalist of the daily prothom- alow. I have already taken an appointment time from the journalist. At the appointment time, I am going to the journalist and start our conversation. The details of that conversation are given bellow:
Myself: Good Morning Sir!
Journalist: Good Morning.
Myself: Sir, I am Sabbir Ahmed, WPSI student of IDB-BISEW IT Scholarship Project. According to my course work, I have to establish a system as my project module. And I am going to establish a Public Opinion web site I have already said you. For analysis the current web, I need some information about this web. And for that, I need to talk to you about the web current system and about the problems that you are facing to carry out the daily activities. I hope you will be with me. Can I ask you some questions?
Journalist: Yah! Sure. You may start now.
Myself: OK, my first question is – How to look in this web?
Journalist: I want your site is space of Bangladesh.
Myself: How many subject are here?
Journalist: Have many subjects such as society problem, corruption, and current issue.
Myself: Thanks, have more subject?
Journalist: I think you gave some news paper link such as daily prothom-alow, banglanews24.com, bdnews24.com, shershownews.com etc.
Myself: What future have my web site?
Journalist: Much future shall have your web site such as like, comment, and suggestion.
Myself: Ok, thanks for giving time.
Journalist: Welcome, I wish you will be a good developer.
Interview With a student:
At first I have take interview from a student of the Asia Pacific Communication Ltd. I have taken an appointment time today Mr.Manik. At the appointment time, I am going to the student and start our conversation. The details of that conversation are given bellow:
Myself: Good Evening Manik!
Student: Good Evening.
Myself: Mr. Manik, I am Sabbir Ahmed, WPSI student of IDB-BISEW IT Scholarship Project. According to my course work, I have to establish a system as my project module. And I am going to establish a Public Opinion web site I have already said you. For analysis the current web, I need some information about this web. And for that, I need to talk to you about the web current system and about the problems that you are facing to carry out the daily activities. I hope you will be with me. Can I ask you some questions?
Student: Yah! Sure. You may start now.
Myself: OK, my first question is – How to look in this web?
Student: I want your site is very popular in Bangladesh.
Myself: How possible?
Student: Why Not? You have included many features such as anti corruption, gave zone and particular subject.
Myself: Thanks, have more suggested?
Student: Yah! We create can a comment issue.
Myself: Yes your object have my web site.
Student: Thanks, it is a good idea, because we create a custom issue subject. Can ask you?
Myself: Yes,
Student: Have any link your web about study?
Myself: Yes, such as www.studentrelation.com/, www.varsityadmission.com/, you have some others link here.
- Interview With a Business man :
At Third I have take interview from a Business man. He is Md. Atiqur Rahman Atiq. His have a shopping mol in KearyPlaza, Dhanmondi 15 no Bus Stand. I have taken an appointment time today Md. Atiqur Rahman At the appointment time, I am going to his Shopping mol and start our conversation. The details of that conversation are given bellow:
Myself: Good Morning Sir!
Md. Atiqur Rahman: Good Morning.
Myself: Sir, I am Sabbir Ahmed, WPSI student of IDB-BISEW IT Scholarship Project. According to my course work, I have to establish a system as my project module. And I am going to establish a Public Opinion web site I have already said you. For analysis the current web, I need some information about this web. And for that, I need to talk to you about the web current system and about the problems that you are facing to carry out the daily activities. I hope you will be with me. Can I ask you some questions?
Md. Atiqur Rahman: Yah! Sure. You may start now.
Myself: OK, my first question is – How to look in this web?
Md. Atiqur Rahman: I want your site is space of Bangladesh about current Business and price.
Myself: How many subject are here?
Md. Atiqur Rahman: Have many subjects such as society problem, business issue etc.
Myself: Thanks, have more subject?
Md. Atiqur Rahman: I think you gave some business website link such as http://www.dsebd.org and http://www.cse.com.bd/ etc.
Myself: What future have my web site?
Md. Atiqur Rahman: Much future shall have your web site such as like, comment, and suggestion.
Myself: Thank you for give your time.
Md. Atiqur Rahman: Thank also you, God blasé you. I wish to you, You will be success your mission.
Myself: Thanks.
Online Research
Object:
Giving voice the public opinion around the world. This web only online opinion release here.
Sitemap:
- Home
- About
- FAQ (Frequently Asked Questions)
- Media
- Contact Us
Design Specify:
- Regulation: This web Regulation Support minimum 800 X 600 pixels.
- Color Combination: Color Combination is very good.
- Layout: This web use 2 column liquid left sidebar, header and footer.
- Navigation Menu: This web site maintains proper navigation.
Features:
- Visitors like here world public opinion.
- Visitor choices specify nation opinion.
Strength:
- They discus world wise people opinion such as Asia, Africa, Europe etc.
- They use some report.
- They use other poll sources.
- They use search option.
Weakness:
- They don’t use line justify.
- They have free space left and right side.
Color Combination:
- Color combination is good.
Object:
This web mission is globally their country knows accounting, politics, nationality, game, and all subject gave opinion here.
Site Map:
- Menu
- Home
- Sections
- News Focus
- Special Feature
- About Us
- Contact Us
- China Digital Space
Design Specify:
- Regulation: This web Regulation Support minimum 1024 X 768 pixels.
- Color Combination: Color Combination is no bad.
- Layout: This web use 3 column liquid header and footer.
- Navigation Menu: This web site maintains proper navigation.
Features:
- Visitor’s like here her country opinion.
- Visitor’s choices specify subject opinion.
- Visitor’s send here any request.
- Visitor’s share facebook and email news and other feature.
Strength:
- They discuss their country which they strongly grow up.
- They use some report.
- They use other poll sources.
- They use search option.
- They use sub title.
- They embedded many languages.
- They news update any time.
Weakness:
- They don’t use line justify.
Color Combination:
- Color combination is good.
Object:
This website provides access to information about public opinion research contracted after August 1, 2006 for which the final reports have been submitted to Library and Archives Canada. It also allows authorized Government of Canada employees to submit their public opinion research reports to Library and Archives Canada, the Library of Parliament, and Public Works and Government Services Canada.
Sitemap:
- Home
- Contact us
- FAQ (Frequently Asked Questions)
- Introduction
- Fiend a report
- Submit a repot
Design Specify:
- Regulation: This web Regulation Support minimum 800 X 600 pixels.
- Color Combination: Color Combination is very good.
- Layout: This web use 3 column elastic, header and footer.
- Navigation Menu: This web site maintains proper navigation.
- They use vertical and horizontal menu
Features:
- Visitors write here country public opinion.
- Visitor choices specify nation opinion.
- Visitor fiend a report here.
- Visitors create a report here.
Strength:
- They discus country people opinion about canada.
- They use some report.
- They use other poll sources.
- They use search option.
- They use breadcome tool.
Weakness:
- They don’t use line justify.
- They use only html.
Color Combination:
- Color combination is good
- Web site outlook is better.
Requirement Specification
Module Name : Member Model
Operations:
- Add Member record;
- Delete Member record;
- Edit Member record;
- View Member details;
- Update Member details;
Module Name : Awamilige Opinion Model
Operations:
- Add Opinion record;
- Delete Opinion record;
- Edit Opinion record;
- View Opinion details;
- View Opinion member;
- About Opinion subject;
Module Name: BNP Opinion Model
Operations:
- Add Opinion record;
- Delete Opinion record;
- Edit Opinion record;
- View Opinion details;
- View Opinion member;
- About Opinion subject;
Module Name: BJP Opinion Model
Operations:
- Add Opinion record;
- Delete Opinion record;
- Edit Opinion record;
- View Opinion details;
- View Opinion member;
- About Opinion subject;
Module Name: Jamaat Opinion Model
Operations:
- Add Opinion record;
- Delete Opinion record;
- Edit Opinion record;
- View Opinion details;
- View Opinion member;
- About Opinion subject;
Data Design:
In this section I have produced-
- Data Dictionary;
- Entity Relationship Diagram;
Data dictionary:
Table: Member Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 999999 | Not Duplicate, auto increment and primary key | |
First Name | Varchar | 40 | XXXXXX | must be valid and Cannot be more than size | |
Last Name | Varchar | 40 | XXXXXX | must be valid and Cannot be more than size | |
Login Name | Varchar | 40 | XXXXXX | Not null must be valid and cannot be more than size | |
Varchar | 45 | XXXXXX | Not Duplicate, must be valid and not null | ||
Phone | Varchar | 20 | 333333 | must be valid and cannot be more than size | |
Address | Varchar | 100 | XXXXXX | must be valid and cannot be more than size | |
Post Code | Integer | 4 | 999999 | must be valid and cannot be more than size | |
City | Varchar | 30 | XXXXXX | Not null must be valid and cannot be more than size | |
Country | Varchar | 30 | XXXXXX | Not null must be valid and cannot be more than size | |
Profession | Varchar | 20 | XXXXXX | Not null must be valid and cannot be more than size | |
Sex | Varchar | 20 | XXXXXX | Not null must be valid and cannot be more than size | |
Facebook Id | Varchar | 60 | XXXXXX | Must be valid and cannot be more than size | |
Password | Varchar | 20 | XXXXXX | Not null must be valid and cannot be more than size | |
Birth date | Varcahr | 20 | XXXXXX | null must be valid and cannot be more than size | |
Create on | Data time | 20 | yy-mm-dd | null must be valid and cannot be more than size |
- Attributes: Member Information table
File Name : Member Information. txt
File Type : Binary
Record Name : Member Information
File size :
Functions: Member information. txt
- Edit record
- Delete record
- List
- Search
- Specific list
- Table: User Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 999999 | Not Duplicate, auto increment and primary key | |
User name | Varchar | 30 | XXXXXX | Not null, must be valid and cannot be more than size | |
Password | Varchar | 25 | XXXXXX | Not null, must be valid and cannot be more than size |
Functions: BJP opinion information. txt
- Add record ()
- Edit record ()
- Delete record ()
- List ()
- Search ()
- Table: BNP opinion Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Login name | Varchar | 50 | XXXXX | Relation member table login name | |
Opinion | Text | 25 | XXXXXX | Not null, must be valid | |
Submit on | Data time | 20 | yy-dd-mm | Not null |
- Attributes: BNP opinion Information table
File Name : BNP opinion Information. txt
File Type : Binary
Record Name : BNP opinion Information
File size :
- Table: Jamaat opinion Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Login name | Varchar | 50 | XXXXXX | Relation member table login name | |
Opinion | Text | 25 | XXXXXX | Not null, must be valid | |
Submit on | Data time | 20 | yy-dd-mm | Not null |
- Attributes: Jamaat opinion Information table
File Name : Jamaat opinion Information. txt
File Type : Binary
Record Name : Jamaat opinion Information
File size :
Functions: Jamaat opinion information. txt
- Add record
- Edit record
- Delete record
- List
- Search
- Table: Question Master Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Question | Text | XXXXXX | Not null, must be valid | ||
Publish | Tiny Int | 3 | 0/1 | Yes/No |
- Attributes: Question Master Information table
File Name : Question Master Information. txt
File Type : Binary
Record Name : Question Master Information
File size :
Functions: Question Master Information. txt
- Add record
- Edit record
- Delete record
- List
- Publish record
- Table: Question Details Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Answer | Varchar | 45 | XXXXXX | Not null, must be valid | |
Question ID | Integer | 10 | 99999999 | Relation Question Master table, field name id |
- Attributes: Question Details Information table
File Name : Question Details Information. txt
File Type : Binary
Record Name : Question Details Information
File size :
Functions: Question Details information. txt
- Add record
- Edit record ()
- Delete record
- List
- Publish record
- Table: Vote Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Member ID | Integer | 10 | 99999 | Relation Member table, field name id | |
Answer ID | Integer | 10 | 99999 | Relation Question Details table, field name id | |
Vote time | Date time | 20 | yy-mm-dd | Date and Time | |
Question ID | Integer | 10 | 99999 | Relation Question Master table, field name id |
- Attributes: Vote Information table
Functions: Vote information. txt
- Add record
- Edit record
- Delete record
- List
- Publish record
- Table: Issue Master Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Massage | Text | XXXXXX | Not null, must be valid | ||
Member ID | Integer | 10 | 99999 | Relation Member table, field name id | |
Date time | Date time | yy-mm-dd | Date and Time |
Functions: Issue Master Information. txt
- Add record
- Edit record
- Delete record
- List
- Publish record
- Table: Member Comments Information
Sl.no | Field Name | Data Type | Size | Format | Constraints |
Id | Integer | 10 | 99999 | Not Duplicate, auto increment and primary key | |
Issue ID | Integer | 10 | 99999 | Relation Issue Master table, field name id | |
Sub Massage | Text | XXXXX | Not null, must be valid | ||
Date time | Date time | 20 | yy-mm-dd | Date and Time | |
Member ID | Integer | 10 | 9999 | Relation member table, field name id |
- Attributes: Member Comments Information table
File Name : Member Comments Information. txt
File Type : Binary
Record Name : Member Comments Information
File size :
Functions: Member Comments Information. txt
- Add record
- Edit record
- Delete record
- List
- Publish record
Physical Design
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
`id` int(10) NOT NULL auto_increment,
`first_name` varchar(40) collate latin1_general_ci NOT NULL,
`last_name` varchar(40) collate latin1_general_ci default NULL,
`login_name` varchar(40) collate latin1_general_ci NOT NULL,
`email` varchar(45) collate latin1_general_ci NOT NULL,
`phone` varchar(20) collate latin1_general_ci default NULL,
`address` varchar(50) collate latin1_general_ci default NULL,
`post_code` varchar(10) collate latin1_general_ci NOT NULL,
`city` varchar(30) collate latin1_general_ci NOT NULL,
`country` varchar(40) collate latin1_general_ci NOT NULL,
`ip` varchar(20) collate latin1_general_ci default NULL,
`profession` varchar(20) collate latin1_general_ci NOT NULL,
`sex` varchar(20) collate latin1_general_ci NOT NULL,
`facebook_id` varchar(60) collate latin1_general_ci default NULL,
`activation_code` varchar(30) collate latin1_general_ci default NULL,
`inactive` tinyint(10) default ‘1’,
`password` varchar(20) collate latin1_general_ci NOT NULL,
`birth_date` varchar(20) collate latin1_general_ci NOT NULL,
`create_on` datetime default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(10) NOT NULL auto_increment,
`user_name` varchar(30) collate latin1_general_ci NOT NULL,
`password` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
CREATE TABLE `awamilige` (
`id` int(11) NOT NULL auto_increment,
`login_name` varchar(50) collate latin1_general_ci NOT NULL,
`opinion` text collate latin1_general_ci NOT NULL,
`submit_on` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `bjp`;
CREATE TABLE `bjp` (
`id` int(10) NOT NULL auto_increment,
`login_name` varchar(50) collate latin1_general_ci NOT NULL,
`opinion` text collate latin1_general_ci NOT NULL,
`submit_on` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `bnp`;
CREATE TABLE `bnp` (
`id` int(10) NOT NULL auto_increment,
`login_name` varchar(50) collate latin1_general_ci NOT NULL,
`opinion` text collate latin1_general_ci NOT NULL,
`submit_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `issue_master`;
CREATE TABLE `issue_master` (
`id` int(10) NOT NULL auto_increment,
`message` text collate latin1_general_ci,
`member_id` int(10) unsigned default NULL,
`datetime` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `jamaat`;
CREATE TABLE `jamaat` (
`id` int(10) NOT NULL auto_increment,
`login_name` varchar(50) collate latin1_general_ci default NULL,
`opinion` text collate latin1_general_ci NOT NULL,
`submit_on` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(10) NOT NULL auto_increment,
`user_name` varchar(35) collate latin1_general_ci NOT NULL,
`password` varchar(12) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `member_comments`;
CREATE TABLE `member_comments` (
`id` int(10) NOT NULL auto_increment,
`issue_id` int(10) default NULL,
`sub_message` text collate latin1_general_ci,
`datetime` datetime default NULL,
`member_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `question_details`;
CREATE TABLE `question_details` (
`id` int(10) unsigned NOT NULL auto_increment,
`answer` varchar(45) collate latin1_general_ci NOT NULL,
`question_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `question_master`;
CREATE TABLE `question_master` (
`id` int(10) unsigned NOT NULL auto_increment,
`question` text collate latin1_general_ci,
`publish` tinyint(3) unsigned default ‘0’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `vote` (
`id` int(10) unsigned NOT NULL auto_increment,
`member_id` int(10) unsigned default NULL,
`answer_id` int(10) unsigned default NULL,
`vote_on` datetime default NULL,
`question_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Index_2` USING BTREE (`member_id`,`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Coding
//Comment —– API–function ——–
<?php
require_once(“db_config.inc.php”);
function ddl($sql){
$db=new mysqli(SERVER,USER,PASSWORD,DATABASE);
$db->query($sql);
return $db;
}
function get_data($sql){
$db=new mysqli(SERVER,USER,PASSWORD,DATABASE);
$rs=$db->query($sql);
$row=$rs->fetch_array(MYSQLI_BOTH);
return $row[0];
}
function get_record($sql){
$db=new mysqli(SERVER,USER,PASSWORD,DATABASE);
$rs=$db->query($sql);
$row=$rs->fetch_array(MYSQLI_BOTH);
return $row;
}
function get_field($sql){
$db=new mysqli(SERVER,USER,PASSWORD,DATABASE);
$rs=$db->query($sql);
$temp=array();
$i=0;
while($row=$rs->fetch_array(MYSQLI_BOTH)){
$temp[$i]=$row[0];
$i++;
}
return $temp;
}
function query($sql){
$db=new mysqli(SERVER,USER,PASSWORD,DATABASE);
$rs=$db->query($sql);
return $rs;
}
?>
//Comment —– Index.php ——–
<?php session_start();
require_once(“api/db.inc.php”);
?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<title>Public Opinion</title>
<link rel=”stylesheet” href=”css/master.css” type=”text/css” />
</head>
<body>
<table id=”container” align=”center” cellspacing=”0″ cellpadding=”0″>
<tr>
<td><?php //signin show area
if(isset($_SESSION[“member_id”])){
//echo “<img src=’images/$_SESSION[member_id].jpg’ height=’100′ />”.$_SESSION[“login_name”];
echo “Hi..”.$_SESSION[“login_name”];
} ?>
<?php
if(isset($_SESSION[“member_id”])){
echo “<a href=’signout.php’>Sign out</a>”;
}?>
</td>
<td style=”text-align:right;”>
<?php include(“menus/hmenu.php”);?>
</td>
</tr>
<tr>
<td id=”bannerSection” colspan=”3″><img src=”images/banner.png” height=”117″ width=”100%” /></td>
</tr>
<tr>
<td colspan=”2″ style=”background-color:#ccc;”><?php include(“menus/vmenu.php”);?></td>
</tr>
<tr>
<td width=”200″ style=”border-right:1px solid #e3e3e3;”>
<?php include(“login_comp/login_index.php”);?> <br/><?php
if(isset($_SESSION[“member_id”])){
include(“moduls/member_info.php”);
}?>
<td width=”650″ id=”printContent”><br /><?php include(“print_content.php”);?></td>
</tr>
<tr>
<th colspan=”2″>Copyright © IDB-BISEW</th>
</tr>
</table>
</body>
</html>
// Comment —- print_content.php——–
<?php
if($_GET[“id”]==2000){
include(“poll_inc.php”);
echo “<hr size=’1’/>”;
include(“publish_poll_inc.php”);
echo “<hr size=’1’/>”;
include(“forum.php”);
}else if($_GET[“id”]==2001){
include(“pages/politics.php”);
}else if($_GET[“id”]==2002){
include(“pages/economics.php”);
}else if ($_GET[“id”]==2003){
include (“pages/current news.php”);
include (“pages/bangla.php”);
}else if ($_GET[“id”]==4){
include (“pages/current news.php”);
include (“pages/bangla.php”);
}else if ($_GET[“id”]==7){
include (“pages/contact us.php”);
}else if ($_GET[“id”]==2004){
include (“pages/anti corruption.php”);
}else if ($_GET[“id”]==2005){
include (“pages/game.php”);
}else if ($_GET[“id”]==2006){
include (“pages/contact_ui.php”);
}else if($_GET[“id”]==2007){
include(“pages/complain.php”);
}else if($_GET[“id”]==3000){
include(“moduls/show_member.php”);
}else if($_GET[“id”]==3010){
include(“moduls/update_account.php”);
}else if($_GET[“id”]==3001){
include(“moduls/complain.php”);
}else if ($_GET[“id”]==8){
include (“pages/open_account.php”);
}else if ($_GET[“id”]==31){
include (“pages/bnp.php”);
}else if ($_GET[“id”]==311){
include (“pages/show_bnp_opinion.php”);
}else if ($_GET[“id”]==32){
include (“pages/alig.php”);
}else if ($_GET[“id”]==2200){
include (“pages/bangla.php”);
}else if ($_GET[“id”]==321){
include (“pages/show_alige_opinion.php”);
}else if ($_GET[“id”]==33){
include (“pages/jamat.php”);
}else if ($_GET[“id”]==331){
include (“pages/show_jamaat_opinion.php”);
}else if ($_GET[“id”]==34){
include (“pages/bjp.php”);
}else if ($_GET[“id”]==341){
include (“pages/show_bjp_opinion.php”);
}else if ($_GET[“id”]==20){
include (“pages/football.php”);
}else if ($_GET[“id”]==21){
include (“pages/cricket.php”);
}else if ($_GET[“id”]==22){
include (“pages/tennis.php”);
}else if ($_GET[“id”]==23){
include (“pages/other.php”);
}else if ($_GET[“id”]==51){
include (“login_comp/forgate_password.php”);
}else if($_GET[“id”]==60){
include (“poll_inc.php”);
}else if($_GET[“id”]==28){
include(“pages/objective.php”);
}else{
include(“poll_inc.php”);
echo “<hr size=’1’/>”;
include(“publish_poll_inc.php”);
echo “<hr size=’1’/>”;
include(“forum.php”);
}
?>
//Comment ——- open_account.php———–
<?php
if(isset($_POST[‘btnSubmit’])){
$fname=$_POST[‘txtFName’];
$lname=$_POST[‘txtLName’];
$logname=htmlentities($_POST[‘txtLogName’]);
$pwd=$_POST[‘pwdPassword’];
$email=htmlentities ($_POST[‘txtEmail’]);
$phone=$_POST[‘txtPhone’];
$add=htmlentities($_POST[‘txtAddress’]);
$post=$_POST[‘txtPost’];
$city=$_POST[‘txtCity’];
$country=$_POST[‘txtCountry’];
$prof=$_POST[‘profession’];
$sex=$_POST[‘sex’];
$facebook=htmlentities($_POST[‘txtFid’]);
$birth_date=$_POST[‘birth_year’].”-“.$_POST[‘birth_month’].”-“.$_POST[‘birth_date’];
//print_r ($phone);
$error=””;
if(!preg_match(‘/^[^0-9]{1}[a-zA-Z ]{1,}$/’,$fname)){
$error.=”First Name invalid formate<br/>”;
}
if(!preg_match(‘/^[0-9a-zA-Z*@#]{1,15}$/’,$pwd)){
$error.=”Passwprd invalid formate<br/>”;
}
if(!preg_match(‘/^[0-9]{1,9}$/’,$post)){
$error.=”Post field Input Number<br/>”;
}
if(!preg_match(‘/^[a-zA-Z]{1,}$/’,$country)){
$error.=”Country field Input Charecter”;
}
if($error==””){
$r=ddl(“insert into member(first_name,last_name,login_name,email,phone,address,post_code,city,country,profession,sex,facebook_id,password,birth_date,create_on)values(‘$fname’,’$lname’,’$logname’,’$email’,’$phone’,’$add’,’$post’,’$city’,’$country’,’$prof’,’$sex’,’$facebook’,’$pwd’,’$birth_date’,now())”);
//$rs->query();
echo “Your data Submit Successfully chake Your email”.$r->insert_id;
}
define(“LOCATION”,”member”);
$file_name=$_FILES[“file”][“name”];
$file_type=$_FILES[“file”][“type”];
$file_tmp_name=$_FILES[“file”][“tmp_name”];
$file_size=$_FILES[“file”][“size”];
$up=move_uploaded_file($file_tmp_name,LOCATION.”/”.$r->insert_id.”.jpg”);
// echo “<img src=”.LOCATION.”/”.$r->insert_id.”.jpg width=’100′ />”;
}
?>
<fieldset style=”height:auto; width:600px; margin:0 auto; background-color:#f7f7f7;”>
<legend style=”margin:0 auto; border:.5px; background:#ccc;”><strong>Account Opening Form</strong></legend>
<form action=”” method=”post” enctype=”multipart/form-data”>
<table align=”center”>
<caption><?php echo “<font color=’red’>”.$error.”</font>”; ?></caption>
<tr>
<td> First Name</td>
<td><input type=”text” name=”txtFName” style=”width:200px;” /><font color=”#FF0000″>*</font></td>
</tr>
<tr>
<td> Last Name</td>
<td><input type=”text” name=”txtLName” style=”width:200px;” /></td>
<td> E-mail</td>
<td><input type=”text” name=”txtEmail” style=”width:200px;” /><font color=”#FF0000″>*</font></td>
<td>Address</td>
<td><textarea cols=”25″ rows=”3″ name=”txtAddress”></textarea></td>
<td><select name=”txtCity”>
<option>select city</option>
<option value=”Bagerhat”>Bagerhat </option>
<option value=”Bandarban “>Bandarban </option>
<option value=”Barguna “>Barguna </option>
<option value=”Barisal “>Barisal </option>
<option value=”Barnmanbaria “>Barnmanbaria </option>
<option value=”Bhola “>Bhola </option>
<option value=”Bogra “>Bogra </option>
<option value=”Chandpur “>Chandpur </option>
<option value=”Chittagong “>Chittagong </option>
<option value=”Chuadanga “>Chuadanga </option>
<option value=”Comilla “>Comilla </option>
<option value=”Cox’s Bazar “>Cox’s Bazar </option>
<option value=”Dhaka “>Dhaka </option>
<option value=”Dinajpur “>Dinajpur </option>
<option value=”Faridpur “>Faridpur </option>
<option value=”Feni “>Feni </option>
<option value=”Gaibandha “>Gaibandha </option>
<option value=”Gazipur “>Gazipur </option>
<option value=”Gopalganj “>Gopalganj </option>
<option value=”Habiganj “>Habiganj </option>
<option value=”Jaipurhat “>Jaipurhat </option>
<option value=”Jamalpur “>Jamalpur </option>
<option value=”Jessore”>Jessore</option>
<option value=”Jhalakathi “>Jhalakathi </option>
<option value=”Jhinaidah “>Jhinaidah </option>
<option value=”Khagrachari “>Khagrachari </option>
<option value=”Khulna “>Khulna </option>
<option value=”Kishoreganj “>Kishoreganj </option>
<option value=”Kurigram “>Kurigram </option>
<option value=”Kushtia “>Kushtia </option>
<option value=”Lakshmipur “>Lakshmipur </option>
<option value=”Lalmonirhat “>Lalmonirhat </option>
<option value=”Madaripur “>Madaripur </option>
<option value=”Magura “>Magura </option>
<option value=”Manikganj “>Manikganj </option>
<option value=”Meherpur “>Meherpur </option>
<option value=”Moulavibazar “>Moulavibazar </option>
<option value=”Munshiganj “>Munshiganj </option>
<option value=”Mymensingh “>Mymensingh </option>
<option value=”Naogaon “>Naogaon </option>
<option value=”Narayangan “>Narayangan </option>
<option value=”Narsingdi “>Narsingdi </option>
<option value=”Natore “>Natore </option>
<option value=”Nawabgonj “>Nawabgonj </option>
<option value=”Netrokona”>Netrokona</option>
<option value=”Nilphamari”>Nilphamari</option>
<option value=”Noakhali”>Noakhali</option>
<option value=”Norail”>Norail</option>
<option value=”Pabna”>Pabna</option>
<option value=”Panchagarh”>Panchagarh</option>
<option value=”Patuakhali”>Patuakhali</option>
<option value=”Pirojpur”>Pirojpur</option>
<option value=”Rajbari”>Rajbari</option>
<option value=”Rajshahi”>Rajshahi</option>
<option value=”Rangamati”>Rangamati</option>
<option value=”Rangpur”>Rangpur</option>
<option value=”Satkhira”>Satkhira</option>
<option value=”Shariyatpur”>Shariyatpur</option>
<option value=”Sherpur”>Sherpur</option>
<option value=”Sirajgonj”>Sirajgonj</option>
<option value=”Sunamganj”>Sunamganj</option>
<option value=”Sylhet”>Sylhet</option>
<option value=”Tangail”>Tangail</option>
<option value=”Thakurgaon”>Thakurgaon</option>
</select><font color=”#FF0000″>*</font>
<td>Country</td>
<td><input type=”text” name=”txtCountry”/><font color=”#FF0000″>*</font></td>
</tr>
<tr>
<td>Profession</td>
<td><select name=”profession”>
<option>select profession</option>
<option value=”doctor”>Doctor</option>
<option value=”Jarnalist”>Jarnalist</option>
<option value=”Employee”>Employee</option>
<option value=”Student”>Student</option>
<option value=”Business”>Business</option>
<option value=”Teacher”>Teacher</option>
<option value=”IT_profession”>IT Profession</option>
<option value=”Other”>Other</option>
</select><font color=”#FF0000″>*</font></td>
</tr>
<tr>
<td>Sex</td>
<td><select name=”sex”>
<option value=”male”>Male</option>
<option value=”female”>Female</option>
</select><font color=”#FF0000″>*</font></td>
</tr>
<tr>
<td>Facebook Id</td>
<td><input type=”text” name=”txtFid” style=”width:200px;”></td>
</tr>
<tr>
<td>Date of Birth</td>
<td>Date<select name=”birth_date”>
<option value=”01″>01</option>
<option value=”02″>02</option>
<option value=”03″>03</option>
<option value=”04″>04</option>
<option value=”05″>05</option>
<option value=”06″>06</option>
<option value=”07″>07</option>
<option value=”08″>08</option>
<option value=”09″>09</option>
<option value=”10″>10</option>
<option value=”11″>11</option>
<option value=”12″>12</option>
<option value=”13″>13</option>
<option value=”4″>14</option>
<option value=”15″>15</option>
<option value=”16″>16</option>
<option value=”17″>17</option>
<option value=”18″>18</option>
<option value=”19″>19</option>
<option value=”20″>20</option>
<option value=”21″>21</option>
<option value=”22″>22</option>
<option value=”23″>23</option>
<option value=”24″>24</option>
<option value=”25″>25</option>
<option value=”26″>26</option>
<option value=”27″>27</option>
<option value=”28″>28</option>
<option value=”29″>29</option>
<option value=”30″>30</option>
<option value=”31″>31</option>
</select>
Month<select name=”birth_month”>
<option value=”January”>January</option>
<option value=”February”>February</option>
<option value=”March”>March</option>
<option value=”Appril”>Appril</option>
<option value=”May”>May</option>
<option value=”June”>June</option>
<option value=”Julay”>Julay</option>
<option value=”August”>August</option>
<option value=”September”>September</option>
<option value=”October”>October</option>
<option value=”November”>November</option>
<option value=”December”>December</option>
</select>
Year<select name=”birth_year”>
<option value=”1960″>1960</option>
<option value=”1961″>1961</option>
<option value=”1962″>1962</option>
<option value=”1963″>1963</option>
<option value=”1964″>1964</option>
<option value=”1965″>1965</option>
<option value=”1966″>1966</option>
<option value=”1967″>1967</option>
<option value=”1968″>1968</option>
<option value=”1969″>1969</option>
<option value=”1970″>1970</option>
<option value=”1971″>1971</option>
<option value=”1972″>1972</option>
<option value=”1973″>1973</option>
<option value=”1974″>1974</option>
<option value=”1975″>1975</option>
<option value=”1976″>1976</option>
<option value=”1977″>1977</option>
<option value=”1978″>1978</option>
<option value=”1979″>1979</option>
<option value=”1980″>1980</option>
<option value=”1981″>1981</option>
<option value=”1982″>1982</option>
<option value=”1983″>1983</option>
<option value=”1984″>1984</option>
<option value=”1985″>1985</option>
<option value=”1986″>1986</option>
<option value=”1987″>1987</option>
<option value=”1988″>1988</option>
<option value=”1989″>1989</option>
<option value=”1990″>1990</option>
<option value=”1991″>1991</option>
<option value=”1992″>1992</option>
<option value=”1993″>1993</option>
<option value=”1994″>1994</option>
<option value=”1995″>1995</option>
<option value=”1996″>1996</option>
<option value=”1997″>1997</option>
<option value=”1998″>1998</option>
<option value=”1999″>1999</option>
<option value=”2000″>2000</option>
<option value=”2001″>2001</option>
<option value=”2002″>2002</option>
<option value=”2003″>2003</option>
<option value=”2004″>2004</option>
<option value=”2oo5″>2005</option>
<option value=”2006″>2006</option>
<option value=”2007″>2007</option>
<option value=”2008″>2008</option>
<option value=”2009″>2009</option>
<option value=”2010″>2010</option>
<option value=”2011″>2011</option>
<td>Photo</td>
<td><input type=”file” name=”file” /></td>
</tr>
<tr>
<th colspan=”2″>
<input type=”submit” name=”btnSubmit” value=”Submit” />
<input type=”reset” name=”btnReset” value=”Reset” />
</table>
</form>
</fieldset>
</body>
</html>
// Comment — signout.php —
<?php session_start();
unset($_SESSION[“member_id”]);
unset($_SESSION[“login_name”]);
session_destroy();
echo “<script>window.location=’index.php’;</script>”;
// Comment —- forum.php——
<script>
function isValidIssue(form){
if(form.txtNewIssue.value==””){
alert(“Field is empty!”);
return false
function isValidComment(form){
if(form.txtMessage.value==””){
alert(“Field is empty!”);
return false;
}else{
return true;
</script>
<?php session_start();
$issue_id=$_POST[“txtIssue”];
$member_id=$_POST[“txtMember”];
$message=htmlspecialchars($_POST[“txtMessage”]);
$new_issue=htmlspecialchars($_POST[“txtNewIssue”]);
$new_member_id=$_POST[“txtNewMember”];
if(isset($_POST[“btnSubmit”])){
ddl(“insert into member_comments(member_id,sub_message,issue_id,`datetime`) values(‘$member_id’,’$message’,’$issue_id’,now())”);
}else if(isset($_POST[“btnIssue”])){
ddl(“insert into issue_master(member_id,message,`datetime`) values(‘$new_member_id’,’$new_issue’,now())”);
<style>
#issue{
margin:0em;
list-style-position: inside;
background-color:#F3F3F3;
border-bottom:1px solid white;
padding:.5em;
text-align:left;
#issue_master{
margin:0em;
list-style-position: inside;
background-color:#F3F3F3;
border-bottom:1px solid white;
padding:.5em;
text-align:left;
#issue_master img{
width:4em;
height:4em;
#issue_master li{
list-style:none;
padding-left: 4em;
#issue_master li a{
list-style:none;
display:block;
margin:.1em;
#issue_master li a img{
width:3em;
height:3em;
textarea{border:1px solid lightgray; margin-bottom:1em;
height:3em;}
</style>
<center>
<ul id=”issue”>
<form action=’#’ method=’post’ onSubmit=”return isValidIssue(this);”>
<p><strong>Write New Topic</strong></p><textarea rows=’2′ cols=’60’ name=’txtNewIssue’ id=’txtNewIssue’ style=”float:left”></textarea>
<input type=”submit” name=”btnIssue” value=”New Post” style=”float:left;” />
<input id=’txtNewMember’ name=’txtNewMember’ type=’hidden’ value=<?php echo $_SESSION[“member_id”];?>/>
<?php
$rs=query(“select id,member_id,message,`datetime` from issue_master order by id desc”);
while($rows=$rs->fetch_array(MYSQLI_BOTH)){
$rs2=query(“select id,member_id,sub_message,`datetime` from member_comments where issue_id=$rows[0]”);
if(file_exists(“icons/member_thumb/$rows[1].jpg”)==true){
echo “<ul id=’issue_master’>
<img src=’icons/member_thumb/$rows[1].jpg’ title=’$rows[1]’ style=’float:left;’ /> $rows[2] <span style=’float:right;margin-right:1em;’>$rows[3]</span><br clear=’all’> “;
}else{
$img=$_SESSION[“sex”]==”0″?”male_default_thumb”:”female_default_thumb”;
echo “<ul id=’issue_master’>
<img src=’icons/member_thumb/$img.jpg’ title=’$rows[1]’ style=’float:left;’ /><b> $rows[2]</b> <span style=’float:right;margin-right:1em;’>$rows[3]</span><br clear=’all’> “;
}
while($rows2=$rs2->fetch_array(MYSQLI_BOTH)){
$first_name=get_data(“select concat_ws(‘ ‘,first_name,last_name) from member where id=’$rows2[1]'”);
if(file_exists(“icons/member_thumb/$rows2[1].jpg”)==true){
echo “<li><span style=’float:left;’><a href=’#’><img src=’icons/member_thumb/$rows2[1].jpg’ title=’$first_name Commented at $rows2[3]’ /></a></span>$rows2[2]</li>”;
echo “<br clear=’left’>”;
}else{
$img=$_SESSION[“sex”]==”0″?”male_default_thumb”:”female_default_thumb”;
echo “<li><span style=’float:left;’><a href=’#’><img src=’icons/member_thumb/$img.jpg’ title=’$first_name Commented at $rows2[3]’ /></a></span>$rows2[2]</li>”;
echo “<br clear=’left’>”;
echo “<form action=’#’ method=’post’ onsubmit=’return isValidComment(this)’>
<textarea id=’txtMessage’ name=’txtMessage’ rows=’1′ cols=’40’ style=’float:left;’></textarea>
<input id=’txtMember’ name=’txtMember’ type=’hidden’ value=$_SESSION[member_pic_id] />
<input id=’txtIssue’ name=’txtIssue’ type=’hidden’ value=$rows[0] />
<input type=submit value=’submit’ name=’btnSubmit’ style=’float:left;’/>”;
echo “</ul></form><br clear=’left’>”;
//Comment —– poll.php——–
<?php
error_reporting(E_ALL ^ E_NOTICE);
//get content of textfile
$filename = “poll_result.txt”;
$content = file($filename);
//put content in array
$array = explode(“,”, $content[0]);
$a=$array[0];
$b=$array[1];
$j=$array[2];
$n=$array[3];
$d=$array[4];
$total=$a+$b+$j+$n+$d;
if(isset($_GET[‘vote’])){
$vote = $_GET[‘vote’];
if ($vote == 1)
{
$a = $a + 1;
}else
if ($vote == 2)
$b = $b + 1;
}else
if ($vote == 3)
$j = $j + 1;
}else
if ($vote == 4)
$n = $n + 1;
}else
if ($vote == 5)
$d = $d + 1;
//insert votes to txt file
$insertvote = $a.”,”.$b.”,”.$j.”,”.$n.”,”.$d;
$fp = fopen($filename,”w”);
fputs($fp,$insertvote);
fclose($fp);
<h3>Total Vote Casting:<?php echo $total;?></h3>
<table id=”vote”>
<tr>
<td width=”124″ height=”26″>Awami league:</td>
<td width=”96″>
<img src=”poll.gif”
width='<?php if($total!=0)echo(100*round($a/($total),2)); ?>’
height=’10’>
<?php if($total!=0) echo(100*round($a/($total),2));else echo 0; ?>%</td>
</tr>
<tr>
<td height=”26″>BNP:</td>
<td>
<img src=”poll.gif”
width='<?php if($total!=0) echo(100*round($b/($total),2)); ?>’ height=’10’>
<?php if($total!=0) echo(100*round($b/($total),2)); else echo 0;?>%
</td>
</tr>
<tr>
<td height=”26″>Jamaat:</td>
<td>
<img src=”poll.gif”
width='<?php if($total!=0) echo(100*round($j/($total),2)); ?>’
height=’10’>
<?php if($total!=0) echo(100*round($j/($total),2));else echo 0; ?>%
</td>
</tr>
<tr>
<td height=”26″>Jatiya party:</td>
<td>
<img src=”poll.gif”
width='<?php if($total!=0) echo(100*round($n/($total),2)); ?>’
height=’10’>
if(isset($_POST[‘btnLogin’])){
$name=$_POST[‘txtUserName’];
$pwd=$_POST[‘txtPassword’];
//$db=new mysqli(SERVER,USER,PWD,DB);
$record=get_record(“select id,first_name,last_name from member where login_name=’$name’ and password=’$pwd'”);
// $record=$rs->fetch_array(MYSQLI_BOTH);
$log_error=””;
//echo $record[0];
if(isset($record[0])){
$_SESSION[“member_id”]=$record[0];
$_SESSION[“login_name”]=$record[1].” “.$record[2];
$_SESSION[“sex”]=0;
// header(“location:home.php”);
echo “<script>window.location=’index.php’; </script>”;
}else{
$log_error=”Login name & Passward not match !!”;
<form action=”” method=”post”>
<ul id=”login”>
<li><?php echo “<font color=’red’>”.$log_error.”</font>”; ?></li>
<li>Login Name</li>
<li><input type=”text” id=”txtUserName” name=”txtUserName” /></li>
<li>Password</li>
<li><input type=”password” id=”txtPassword” name=”txtPassword” /></li>
<li> <input type=”submit” id=”btnLogin” name=”btnLogin” value=”Login” /> <a href=”index.php?id=51″>Forget password?</a></li>
<li><a href=”index.php?id=8″>New account</a> </li>
// Comment ——- forgate.php——
<?php
include(“isl/phprpc_client.php”);
$client = new PHPRPC_Client(‘http://www.intelsft.com/software/rpc_lib.php’);
if(isset($_POST[“btnSubmit”])){
$email=$_POST[“txtEmail”];
$head= “Hello Dear Member”;
$body=”Your Password is : “;
$rs=get_record(“select password from member where email=’$email'”);
if(isset($rs[0])){
$send=$client->send_mail(“asabbir09@yahoo.com”,$email,$head,”<h1>$body $rs[0]</h1>”);
echo “<font color=’green’>Please Check Your Email</font>”;
//echo “<script>window.alert(‘ok’)<//script>”; // “success”; //
}else{
echo “error”;
<fieldset style=”margin: 0 auto; background-color:#f7f7f7;”>
<legend><strong style=”margin:0 auto; border:1px #CCCCCC; background-color:#f7f7f7;”>Forget Password !!</strong></legend>
<form action=”” method=”post”>
<table align=”center”>
<caption></caption>
<tr>
<td width=”84″>Your Email </td>
<td width=”324″><input type=”text” name=”txtEmail” style=”width:270px;”/></td>
</tr>
<tr>
<th colspan=”2″><input type=”submit” name=”btnSubmit” value=”Submit” /></th>
</tr>
</table>
</form>
</fieldset>
// Comment —- bnp.php —–
<script>
function isValidComment(form){
if(form.textBnp.value==””){
alert(“Field is empty!”);
return false;
}else{
return true
</script>
<?php
include(“politics.php”);
if(isset($_POST[‘bnpSubmit’])){
if(isset($_SESSION[‘member_id’])){
$_SESSION[‘login_name’];
$logname=$_SESSION[‘login_name’];
$opinion=htmlentities($_POST[‘textBnp’]);
if($berror==””){
ddl(“insert into bnp(login_name,opinion,submit_time)values(‘$logname’,’$opinion’,now())”);
$berror = “<b style=’color:green;’>Thank you for your openino.</b>”;
}else{
$berror=”<font color=’red’>Please Login </font>”;
?>
<table width=”100%” align=”center”>
<tr>
<td width=”42%”>
<h4>Bangladesh Nationalist Party </h4><td width=”1%”>
<td width=”57%”><a href=”http://bangladeshnationalistparty-bnp.org/”target=”_blank”>About bnp</a>|<a href=”index.php?id=311″>Show Opinion </a></td>
</table>
<form action=”” method=”post” onsubmit=”return isValidComment(this)”>
<table border=”0″>
<caption><?php echo $berror?> </caption>
<td>Type Your Comment :</td>
<td><textarea cols=”50″ name=”textBnp”></textarea></td>
</tr>
<th colspan=”2″><input type=”submit” name=”bnpSubmit” value=”Submit”/>
<input type=”reset” value=”Reset” /></th>
</table>
</form>
<?php
include “show_bnp_opinion.php”;
// Comment —- show_bnp_opinion.php ——-
<body>
<?php
$rs=query(“select login_name,opinion, submit_time from bnp”);
echo “<table border=’0′ bgcolor=’#f7f7f7′>”;
echo “<tr><th style=’width:80px;’>Name</th><th>Opinion</th><th>Opinion Time</th></tr>”;
while($rows=$rs->fetch_array(MYSQLI_BOTH)){
echo “<tr><td>”.$rows[0].”</td><td>”.$rows[1].”</td><td>”.$rows[2].”</td></tr>”;
</body>
// Comment— alig.php—–
<script>
function isValidComment(form){
if(form.textAlige.value==””){
alert(“Field is empty!”);
return false;
}else{
return true
</script>
<?php
include(“politics.php”);
if(isset($_POST[‘aligeSubmit’])){
if(isset($_SESSION[‘member_id’])){
$_SESSION[‘login_name’];
$logname=$_SESSION[‘login_name’];
$opinion=htmlentities($_POST[‘textAlige’]);
if($aerror==””){
ddl(“insert into awamilige(login_name,opinion,submit_on)values(‘$logname’,’$opinion’,now())”);
$aerror = “<b style=’color:green;’>Thank you for your openino.</b>”;
}else{
$aerror=”<font color=’red’>Please Login </font>”;
<table width=”100%” align=”center”>
<tr>
<td width=”42%”>
<h4>Bangladesh Awami League</h4><td width=”1%”>
<td width=”57%”><a href=”http://www.albd.org/”target=”_blank”>About A-lige</a>|<a href=”index.php?id=321″>Show Opinion </a></td>
</tr>
</table>
<form action=”” method=”post” onsubmit=”return isValidComment(this)”>
<table border=”0″>
<caption><?php echo $aerror?> </caption>
<tr>
<td>Type Your Comment :</td>
<td><textarea cols=”50″ name=”textAlige”></textarea></td>
</tr>
<th colspan=”2″><input type=”submit” name=”aligeSubmit” value=”Submit”/>
<input type=”reset” value=”Reset” /></th>
</table>
</form>
<?php
include “show_alige_opinion.php”;
// Comment — show_alige_opinion.php—–
<body>
<?php
$rs=query(“select login_name,opinion,submit_on from awamilige”);
echo “<table border=’0′ bgcolor=’#f7f7f7′>”;
echo “<tr><th style=’width:80px;’>Name</th><th>Opinion</th><th>Opinion Time</th></tr>”;
while($rows=$rs->fetch_array(MYSQLI_BOTH)){
echo “<tr><td>”.$rows[0].”</td><td>”.$rows[1].”</td><td>”.$rows[2].”</td></tr>”;
echo “</table>”;
?>
</body>
// Comment — jammat.php—
<script>
function isValidComment(form){
if(form.textJamaat.value==””){
alert(“Field is empty!”);
return false;
}else{
return true;
</script>
<?php
include(“politics.php”);
if(isset($_POST[‘jammatSubmit’])){
if(isset($_SESSION[‘member_id’])){
$_SESSION[‘login_name’];
$logname=$_SESSION[‘login_name’];
$opinion=htmlentities($_POST[‘textJamaat’]);
$jerror=””;
//if();
if($jerror==””){
ddl(“insert into jamaat(login_name, opinion, submit_on)values(‘$logname’,’$opinion’,now())”);
$jerror = “<b style=’color:green;’>Thank you for your openino.</b>”;
}else{
$jerror=”<font color=’red’>Please Login </font>”;
<table width=”100%” align=”center”>
<tr>
<td width=”42%”>
<h4>Bangladesh Jamaat-e-Islam</h4><td width=”1%”>
<td width=”57%”><a href=”http://jamaat-e-islami.org/”target=”_blank”>About Jamaat</a>|<a href=”index.php?id=331″>Show Opinion </a></td>
</tr>
</table>
<form action=”” method=”post” onsubmit=”return isValidComment(this)”>
<table border=”0″>
<caption><?php echo $jerror?></caption>
<tr>
<td>Type Your Comment :</td>
<td><textarea cols=”50″ name=”textJamaat” id=”txtNewIssue”></textarea></td>
</tr>
<th colspan=”2″><input type=”submit” name=”jammatSubmit” value=”Submit”/>
<input type=”reset” value=”Reset” /></th>
</table>
</form>
<?php
include “show_jamaat_opinion.php”;
// Comment —– show_jammat_opinion.php —-
<body>
<?php
$rs=query(“select login_name, opinion, submit_on from jamaat”);
echo “<table border=’0′ bgcolor=’#f7f7f7′>”;
echo “<tr><th style=’width:80px;’>Name</th><th>Opinion</th><th>Submit Time</th></tr>”;
while($rows=$rs->fetch_array(MYSQLI_BOTH)){
echo “<tr><td>”.$rows[0].”</td><td>”.$rows[1].”</td><td>”.$rows[2].”</td></tr>”;
<script>
function isValidComment(form){
if(form.textBjp.value==””){
alert(“Field is empty!”);
return false;
}else{
return true;
</script>
<?php
include(“politics.php”);
if(isset($_POST[‘bjpSubmit’])){
if(isset($_SESSION[‘member_id’])){
$_SESSION[‘login_name’];
$logname=$_SESSION[‘login_name’];
$opinion=htmlentities($_POST[‘textBjp’]);
if($bjerror==””){
ddl(“insert into bjp(login_name,opinion,submit_on)values(‘$logname’,’$opinion’,now())”);
$bjerror = “<b style=’color:green;’>Thank you for your openino.</b>”;
<body>
Testing
I have a plan for test the system properly. This plan contains four steps. They are –
- Step 1: At first I have decided what I want to see as output;
- Step 2: To get required output, what data should be as input;
- Step 3: Trying the input data;
- Step 4: Check the result;
- Step 5: Check all the input form are ok;
- Step 6: If there is any error, I have to find out the error and should solve it.
- Step 7: Show the testing status.