Computer

Public Opinion of Bangladesh and Online Polling System

Public Opinion of Bangladesh and Online Polling System

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

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.

online research2

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.

online research3

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;

Logical Design

login flowchart

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

IdInteger10999999Not Duplicate, auto increment and primary key
First NameVarchar40XXXXXXmust be valid and    Cannot be more than size
Last NameVarchar40XXXXXXmust be valid and    Cannot be more than size
Login NameVarchar40XXXXXXNot null must be valid and cannot be more than size
EmailVarchar45XXXXXXNot Duplicate, must be valid and not null
PhoneVarchar20333333must be valid and    cannot be more than size
AddressVarchar100XXXXXXmust be valid and    cannot be more than size
Post CodeInteger4999999must be valid and cannot be more than size
CityVarchar30XXXXXXNot null must be valid and cannot be more than size
CountryVarchar30XXXXXXNot null must be valid and cannot be more than size
ProfessionVarchar20XXXXXXNot null must be valid and cannot be more than size
SexVarchar20XXXXXXNot null must be valid and cannot be more than size
Facebook IdVarchar60XXXXXXMust be valid and cannot be more than size
PasswordVarchar20XXXXXXNot null must be valid and cannot be more than size
Birth dateVarcahr20XXXXXXnull must be valid and cannot be more than size
Create onData time20yy-mm-ddnull 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

IdInteger10999999Not Duplicate, auto increment and primary key
User nameVarchar30XXXXXXNot null, must be valid and cannot be more than size
PasswordVarchar25XXXXXXNot 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

IdInteger1099999Not Duplicate, auto increment and primary key
Login nameVarchar50XXXXXRelation member table login name
OpinionText25XXXXXXNot null, must be valid
Submit onData time20yy-dd-mmNot 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

IdInteger1099999Not Duplicate, auto increment and primary key
Login nameVarchar50XXXXXXRelation member table login name
OpinionText25XXXXXXNot null, must be valid
Submit onData time20yy-dd-mmNot 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

IdInteger1099999Not Duplicate, auto increment and primary key
QuestionText XXXXXXNot null, must be valid
PublishTiny Int30/1Yes/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

IdInteger1099999Not Duplicate, auto increment and primary key
AnswerVarchar45XXXXXXNot null, must be valid
Question IDInteger1099999999Relation 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

IdInteger1099999Not Duplicate, auto increment and primary key
Member IDInteger1099999Relation Member table, field name id
Answer IDInteger1099999Relation Question Details table, field name id
Vote timeDate time20yy-mm-ddDate and Time
Question IDInteger1099999Relation 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

IdInteger1099999Not Duplicate, auto increment and primary key
MassageText XXXXXXNot null, must be valid
Member IDInteger1099999Relation Member table, field name id
Date timeDate time yy-mm-ddDate 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

IdInteger1099999Not Duplicate, auto increment and primary key
Issue IDInteger1099999Relation Issue Master table, field name id
Sub MassageText XXXXXNot null, must be valid
Date timeDate time20yy-mm-ddDate and Time
Member IDInteger109999Relation 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;

Database Relation Ship

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 &copy; 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.

online voting system