ACKNOWLEDGEMENT I take immense pleasure in expressing my thanks to the management for their continuous support throughout the project

ACKNOWLEDGEMENT
I take immense pleasure in expressing my thanks to the management for their continuous support throughout the project.

I am extremely gratefull our Principal Dr.P. BABY SHAKILA Sri Krishna Arts and Science College(Autonomous) for providing all the facilities to do this project.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

I am grately indebeted to Dr.V.S.ANITA SOFIA ,Head Department of Computer Technology for her continuous support throughout the project.

I wish to express my sincere thanks to my project guide MS. A.CAROLINEMARY M.Sc.,(Ph.D), Assistant Professor,Department of Computer Technology for her continuous involvement,encouragement and valuable suggestion to improve and finish this project successfully.

I express my deep gratitude to the faculty members of the department for their valuable suggestions and lending a helping hand for the successful completion of my project.

I take this opportunity to thank my parents and friends for their support,contribution and motivation which helped me a lot to complete this project successfully.

CONTENTS
SYNOPSIS
1. INTRODUCTION PAGE NO
2 1.1 ORGANIZATION PROFILE 3 1.2 SYSTEM SPECIFICATION 4 1.2.1 HARDWARE AND SOFTWARE CONFIGURATION 4
1.2.2 SOFTWARE SPECIFICATION 4 2. SYSTEM STUDY 7 2.1 EXISTING SYSTEM 7 2.1.1 DRAWBACKS 7 2.2 PROPOSED SYSTEM 8 2.2.1 ADVANTAGES OF PROPOSED SYSTEM 8 3. SYSTEM DESIGN AND DEVELOPMENT 9 3.1 FILE DESIGN 9 3.2 INPUT DESIGN 9 3.3 OUTPUT DESIGN 10 4. TEST AND IMPLEMENTATION 12 CONCLUSION16SCOPE FOR FUTURE DEVELOPMENT
GENERAL OBSERVATION AT IETBIBLIOGRAPHY17APPENDICES18
DATAFLOW DIAGRAM18TABLE STRUCTURE20
SAMPLE INPUT24SAMPLE OUTPUT25SYNOPSIS
The project entitled as Email Campaigning is a web based application developed using PHP as sever scripting language and HTML, CSS as front end tools, MySQL as backend tool.

The main aim of this application is to develop a solution for Email campaigning, normally in a business organization, we send many emails to different type of peoples, it is really a difficult job to design templates for sending emails every time, also sending same email to many people also becomes a difficult task.

In the existing email systems there is no option of setting time for sending the email automatically; also the user cannot send a calendar for resending same emails regularly to the recipients.

The proposed system will contain email templates in different formats, like templates for customers, employee, marketing etc. when the user want to send a email to his customers he can just select any one of the template he can edit the template and can send.

Another attractive feature of this application is the user can set the time when the emails need to be delivered. Also he can send assign the time and date for delivering the email to the recepients list
CHAPTER -1
INTRODUCTION
The main aim of this application is to develop a solution for Email campaigning, normally in a business organization, we send many emails to different type of peoples, it is really a difficult job to design templates for sending emails every time, also sending same email to many people also becomes a difficult task. In the existing email systems there is no option of setting time for sending the email automatically; also the user cannot send a calendar for resending same emails regularly to the recipients.

The proposed system will contain email templates in different formats, like templates for customers, employee, marketing etc. when the user want to send a email to his customers he can just select any one of the template he/she can edit the template and can send.

Another attractive feature of this application is the user can set the time when the emails need to be delivered. Also he can send assign the time and date for delivering the email to the recipients list.

With help of this application the user can set a calendar to resend the mail frequently to the recipients, by which if the user want send a email every month 2nd day he can set the calendar to send the email on the specified date.

ORGANIZATION PROFILE
ABILE TECHNOLOGIES
Abile Technologies is a Leading Software solution provider situated in Coimbatore, which has its client network spread across the geographical area. Abile Technologies with its expertise group of management team provides diversified services to its clients. The services include Application Development, Software application Migration, Web application Development, Mobile applications, Software/Web Designing and Software Training.

At Abile Technologies we focus on delivering client satisfaction based on high end solutions with innovations. Within a short span of time Abile Technologies has become a demanding software solution provider in the IT market.

Marching Towards Innovation: At Abile Technologies On Each and Every step of action we try to deliver a creative and innovative solution to our customer. We make creativity as a Habit and Innovation as a Product.

Abile Technologies focus on providing open source based software solutions. We have a dedicated team to work on enhancing the open source software model and to provide a cost effective solution to our customer with open source tools.

Abile Technologies vision always has been marching towards Innovation. Our mission is to give our customers and clients complete satisfaction in what we deliver.

SYSTEM SPECIFICATION
HARDWARE CONFIGURATION Processor : intel(R)Pentium(R)[email protected] Ram:4.00 GB
System type :64 bit operating system.

SOFTWARE CONFIGURATION
Operating system: Windows10
Front end: CSS(cascading style sheet)
Backend: My sql2.11.9.2
Scripts: JavaScript and Html
SOFTWARE SPECIFICATION FRONT END
HTML
Hypertext Markup Language is the standard markup language for creating web pages and web applications. With Cascading Style Sheets and JavaScript, it forms a triad of cornerstone technologies for the World Wide Web
CSS
Cascading Style Sheets is a style sheet language used for describing the presentation of a document written in a mark-up language like HTML. CSS is a cornerstone technology of the World Wide Web, alongside HTML and JavaScript. CSS helps Web developers create a uniform look across several pages of a Web site. Instead of defining the style of each table and each block of text within a page’s HTML, commonly used styles need to be defined only once in a CSS document
FRONT END: PHP 5.0
PHP stands for php:Hypertext Preprocessor and is a programming language which is used for writing web applications – from ordinary web page to full blog or forum. Being a server- side scripting language PHP runs on the web server,unlike the client-side languages which run on the web browser,and gives a lot of possibilities other programming languages cannot.

Besides. The server-side code appears to be more protected than client-side one as it stays on the web browser and the visitors are not able to view and edit it.When the web page opens,PHP sends only the output(not the very code) to the visitor’s browsers,so it may be sure no one will pilfer user script.However, PHP code that is kept within a server and runs scripts is an open source which means that it is easily accessible.PHP is available for free and is well supported being provided with source code so the users can easily build and customize it according to their own preferences.

OBJECTIVES OF PHP
Options for working with HTML code,e.g. inserting PHP in the HTML page,
Facilities for creating graphics,
Function of addressing to database,e.g. MySQL,
Ease at handling web forms and setting cookies,
The possibility to check email by POP3 or IMAP.

PHP can be used also for command-line scripting and perfectly connects with most web servers,platforms and operating systems as well as database system of relational types.

THE ADVANTAGES OF PHP
PHP is easy to understand and learn,especially for those with backgrounds in programming such as C,JavaScript and HTML.

PHP also runs on just about every platform including most UNIX,Macs and Windows versions.

PHP has tons of server interfaces,database interfaces and other modules available.

Of the server interfaces,PHP can load into Apache,IIS,Roxen,THTTPD and AOLserver.it can also be runs as a CGI module.

Database interfaces are available for MySQL, MS SQL,Informix,Oracle and plenty of others.If a database is not supported,ODBC is an option.

The main PHP source repository is loaded with modules and interfaces that users have written and contributed. There user can find modules for flash movies,PDF files,calenders and more.

BACK END: MySQL 2.11.9.2
MySQL is a database management system.

A database is a structured collection of data. To add,access and process data stored in a computer database, user need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing as standalone utilities,or as parts of other applications.

MySQL is a relational database management system.

A relational database stores data in separate tables rather than putting all the data in one big storeroom.This adds speed and flexibility.

The SQL part of “MySQL” stands for “Structured Query Language”.SQLis the most common standardized language used to access databases and is defined by the ANSI/ISO/SQL Standard.

MySQL software is Open Source.

Open Source means that it is possible for anyone to use and modify the software. Anybody can download MySQL software from the internet and use it without paying
CHAPTER-2
SYSTEM STUDY
EXISTING SYSTEM
In the client side they are using the third party email software to send emails, In the existing system there is no templates available, without template the user need design the email each time when they wanted to send emails, it becomes more difficult if the user want to send different type of emails to different users. So for every different receptionist the user needs to design and send emails.

And in the existing system there is no option for scheduling the emails, so the user need to remember of sending the emails or need to separately maintain a database to send emails to the recipients a time sheet need to be maintained for performing this activity,
Another major draw in the existing system is the address book is saved in the email server so the security of contact details are less, this may lead hackers to hack the contact details from the email server.

DRAWBACK IN THE EXISTING SYSTEM
The major drawbacks in the existing system are
There is no address book for facility to store the address details in the local server.

There is no templates options available in the existing system
In the existing system we cannot schedule the emails.

Less security easy to hack.

Need to redo the email designing work each time.

PROPOSED SYSTEM
The proposed system is developed to provide an effective solution to overcome the problems in the existing system.

The main aim of this application is to develop a solution for Email campaigning, normally in a business organization, we send many emails to different type of peoples, it is really a difficult job to design templates for sending emails every time, also sending same email to many people also becomes a difficult task.

The proposed system will contain email templates in different formats, like templates for customers, employee, marketing etc. when the user want to send a email to his customers he can just select any one of the template he can edit the template and can send.

ADVANTAGES OF PROPOSED SYSTEM
There are many advantages of using the proposed system, they are
The proposed system is developed using open source tools so it a cost effective system compared with other system.

The E-mail Campaign will provide a complete solution for email communication, in the organization.

This will reduce the work load of design the E-mail each time to send the mail to various peoples related to business.

The option of email scheduling will help to send email automatically on time, there is no need to monitor sending emails.

The option of address book will help to store the contact details in the local system.

The work of creating a email is made much simpler by using the templates.

CHAPTER-3
SYSTEM DESIGN AND DEVELOPMENT
FILE DESIGN-MODULE DESCRIPTION ADMIN MODULE
With this module admin can create address book, can customize the templates and can schedule the email to be sent and also he can sent email to the receptionist.

TEMPLATE DESIGN AND CREATION MODULE
In this module the admin or the programmer can design and customize new templates, he also can update the existing templates.

SCHEDULING MANAGEMENT
In this module we can manage scheduling to user when, to whom and what we need to send, So mail sends appropriate time what time set in the timesheet.

ADDRESS BOOK MODULE
In this module we can manage clients address and contactdetails.

INPUT DESIGN
The input design is the link between the information system and the user. It comprises the developing specification and procedures for data preparation and those steps are necessary to put transaction data in to a usable form for processing can be achieved by inspecting the computer to read data from a written or printed document or it can occur by having people keying the data directly into the system. The design of input focuses on controlling the amount of input required, controlling the errors, avoiding delay, avoiding extra steps and keeping the process simple.

The input is designed in such a way so that it provides security and ease of use with retaining the privacy. Input Design considered the following things:
What data should be given as input?
How the data should be arranged or coded?
The dialog to guide the operating personnel in providing input.

Methods for preparing input validations and steps to follow when error occur.

914400213320
OUTPUT DESIGN
A quality output is one, which meets the requirements of the end user and presents the information clearly. In any system results of processing are communicated to the users and to other system through outputs. In output design it is determined how the information is to be displaced for immediate need and also the hard copy output. It is the most important and direct source information to the user. Efficient and intelligent output design improves the system’s relationship to help user decision-making.

Designing computer output should proceed in an organized, well thought out manner; the right output must be developed while ensuring that each output element is designed so that people will find the system can use easily and effectively. When analysis design compute output, they should Identify the specific output that is needed to meet the requirements.

Select methods for presenting information.

Create document, report, or other formats that contain information produced by the system.

The output form of an information system should accomplish one or more of the following objectives:
Convey information about past activities, current status or projections of the Future.

Signal important events, opportunities, problems, or warnings.

Trigger an action.

Confirm an action
1143000215946
CHAPTER -4
SYSTEM TESTING AND IMPLEMENTATION
System testing is actually a series of different tests whose primary purpose is to fully exercise the computer-based system. Although each test has a different purpose, all work to verify that all system elements have been integrated and perform allocated functions.

TESTING METHODOLOGIES VALIDATION TESTING
The validation testing is done to check that all the controls that accept only numeric character and also to ensure that they don’t accept alphanumeric characters. After the integration of the modules, the validation test is carried out over the system. It is found that all the modules work well together and meet the overall system function and performance.

914400126874
ACCEPTANCE TESTING
The user acceptance testing of the system is the key factor for the success of any system. The system under consideration is tested for user acceptance and format that the users were satisfied with its functioning
914400130652
SYSTEM IMPLEMENTATION
Implementation is the stage of the project where the theoretical design is turned into a working system. At this stage the main work load, the greatest upheaval and the major impact on the existing system shifts to the user department. If the implementation is not planned and controlled it can cause chaos and confusion.

The process of putting the developed system in actual use is called system implementation. This includes all those activities that take place to convert from the old system to the new system. The system can be implemented only after through testing is done and if it is found to be working according to the specifications. The system personally check the feasibility of the system.

The implementation stage involves following tasks:
Careful planning
Investigation of system and constraints.

Design of methods to achieve the changeover.

Training of the staff in the changeover phase.

Evaluation of the changeover method.

IMPLEMENTATION PROCEDURES
Implementation of software refers to the final installation of the package in its real environment, to the specification of the intended users and the operation of the system.

In many organizations someone who will not be operating it, will commission the software development project.

The people unaware that the software is meant to make their job easier. In the initial stage, they doubt about the software but we have to ensure that the resistance does not build up as one has to make sure that,The active user must be aware of the benefits of using the system.Their confidence in the software is built
4051300857885createddate
00createddate
5937250819150listname
00listname
5089525914400listtype
0listtype
center182880ENTITY RELATIONSHIP DIAGRAM
4000020000ENTITY RELATIONSHIP DIAGRAM

268132162231490012610836223149Campaign content detail
00Campaign content detail
42418006450330Campaign recipient id
00Campaign recipient id
63658756326505listid
00listid
25742906505575content
0content
14693907248525templatetype
0templatetype
5270507029450campaignid
0campaignid
1365256496050campigncontentid
00campigncontentid
47459907000875Campaign id
00Campaign id
5270500636460500563245063836550058413656848475subscribers
00subscribers
57181756353175576580063646050049371255981700Campaign existing recipient
Campaign existing recipient
417512561626753603625591502503889375404050600523240023114000188912518415Header img
00Header img
22034506953250templatename
00templatename
11271256638925385127530003750013747756648450014890756638925001879601665797600574675651510033274003676650campaignmaster
0campaignmaster
63849244152900clickdate
00clickdate
55657755124450Campaign id
00Campaign id
49180754714875emailid
00emailid
5394325414337454038504038599005146675408622560229764600575Click id
0Click id
537527640576500050133253619500Subscriber statistics clicks
0Subscriber statistics clicks
40322502905125002060575415290010033005734050password
00password
24034765467350timezone
00timezone
195580041998900026892254648201firstname
00firstname
24130004991100lastname
00lastname
20415244181475001555750424815016605252524125Img1
00Img1
16129001638300006604012333625footerlink
00footerlink
26511254276725email id
00email id
16605255324475usertype
00usertype
6318255324475contactno
0contactno
4603754952999address
00address
4508504552950country
00country
2698754162425timezone
00timezone
22225014152900001841499417195000139382441433750012414253905250001136650379095000106044937433250013176253714750004318003629025timezone
00timezone
25177753028950User
name
name
00User
name
name
23272752590800Img2
00Img2
255587516859250013366753009900companyname
00companyname
284099029432250022796503400425006985003171825userid
00userid
140335034290001936750336232517557753762375usermaster
usermaster
553720024765000062230002847975testid
00testid
614680023526750065659002447925userid
0userid
64325502000250emailid
0emailid
560387421240740062134751657350testdate
00testdate
550862518478490051269902181225Testaddress
0Testaddress
435610023241003756025581025Img3
00Img3
27432007620000026416001095375003441700923925Template type
00Template type
207009916668750010699751943100content
0content
1822449159067500327025981075subtitle
00subtitle
1050924126682500180340015621007842261514475maintitle
00maintitle
258445154292400194627566675000822325361950Campaigning id
0Campaigning id
1308100971550templateid
00templateid
2994025257175footerimg
00footerimg
2422525371475187959913144490025654001343025templatedetails
templatedetails
2860675165735047752005143505413375400049005946775581025userid
userid
5527675933450552767513138150060229751095375listid
00listid
45466001333500List_master
00List_master
3927475158115000center2133600Email campaigning
00Email campaigning

CONCLUSION
The software developed has fulfilled the necessary requirements as required by the user. It is ensured that all the programs are working properly in “Email Campaigning”. The system is used to operate in a user friendly manner. The system that has been developed in PHP is to improve more user interactivity. This project avoid errors. This project has been implemented and tested.

FUTURE DEVELOPMENT
Every system has scope for future enhancement or development. This proposed system the “Email Campaigning” can be developed for future development. The system is highly flexible to modify if needed.In future we can add extra features like creating interactive email experiences,live polling in emails.

GENERAL OBSERVATION AT IET
Got knowledge about how people work in IT company. Learnt about web designing and development
Learnt how to create and design a website. Got some idea of webdesigning and database
BIBLIOGRAPHY
David Sklar and Adam Trachtenberg,”PHP COOK BOOK”, O’Reilly Publications, 2002 Edition.

Tobias Rats chiller and Till Gerken,”WEB APPLICATION DEVELOPMENT WITH PHP”, New Riders Publications, 2000 Edition.

BipinC.Desai,”ANINTRODUCTIONTOTHEDATABASESYSTEM”,Galgotia
Publications, 1991.

Abraham SilberSchatz,”SYSTEM ANALYSIS AND DESIGN”, Tata McGraw Hill Publications.

WEBSITES
www.php.com, www.msdn.microsoft.com/library/designtool/php.aspx www.phpbuilder.com,www.dreamweaver.com 7.APPENDICES
A)DATA FLOW DIAGRAM

The Behavioral model of what the behavior of the system must be in order to deal successfully with the environment. It graphically indicates the flow control from one part to the order. It is represented in the form of a network of processes and control flows between them.

Complete understanding of the system is possible only with the help of the DFD. Data flow diagram represents the logical floe of the system. They are used to analyze the system and to set constraints, system requirements and identify major transformation of the data. Level 0 and Level 1 are used in dataflow diagram to spilit the flow from early stage and proceed step by step. Level 0 and Level 1 are probably the easiest for someone to create, because they are done at such as high level. Level 1 is almost the same thing but, will make the main process into black boxes.

24955506921500External entity:
249555032575500Data flow:
24955509842500Data store:
249555024701500
25622256032500Data process:
25622251460500Report:
Level 1: User login ; Registration
424180-4561205New
Template
Add Templates
Templates Database
Registered
Select Templates
Name
Login
Email Client
Email
Campaign
Create a
Campaign
User
00New
Template
Add Templates
Templates Database
Registered
Select Templates
Name
Login
Email Client
Email
Campaign
Create a
Campaign
User
View Campaign Details
362902510858500
B.TABLE DESIGN
Tablename: campaign_content_detail
Field Name Data type Length Constraints
Campaign_content_i d Int 11 Primary key
Campaign_id Int 11 Not Null
template_name varchar 30 Not Null
template_type Varchar 12 Not Null
Content longtext Not Null
Tablename : campaign_existing_recipient
Field Name Data type Length Constraints
campaign_recipient_id int 11 Primary key
Campaign_id int 11 Not null
List_id int 11 Not null
subscribers Long text Not null
Tablename : campaign_master
Field Name Data type Length Constraints
Campaign_id int 11 primarykey
User_id int 11 Not null
Campaign_na me Varchar 2000 Not null
Subject varchar 2000 Null
from_name varchar 30 Not null
Email_id varchar 45 Not null
Email_replies varchar 30 Not null
Created_date date Not null
Sent_date Varchar 10 Not null
Status varchar 5 Not null
Scheduled varchar 10 Not null
Tablename : list_master
Field Name Data type Length Constraints
List_id Int 11 Primary key
User_id Int 11 Not null
List_name Varchar 30 Not null
List_type Varchar 45 Not null
Created_date Date Not null
Tablename: subscriber_click_statistics
Field Name Data type Length Constraints
Click_id Int 11 Primary key
Campaign_id Int 11 Not Null
Email_id varchar 30 Not Null
Click _date Varchar 10 Not Null
Tablename: Template_detail
Field Name Data type Length Constraints
template_id Int 11 Primary key
Campaign_id Int 11 Not Null
Template_type varchar 30 Not Null
Header_img Varchar 255 Not Null
Footer_img Longtext Not Null
Footer_image varchar 255 Not Null
Main_title Longtext Null
Sub_title longtext Null
Footer_links longtext Not Null
content longtext Not Null
Img1 varchar 255 Not Null
Img2 varchar 255 Not Null
Img3 varchar 255 Not Null
Tablename: Test_address
Field Name Data type Length Constraints
test_id Int 11 Primary key
User_id Int 11 Not Null
Email_id varchar 30 Not Null
Test_date Date Not Null
Tablename: User_master
Field Name Data type Length Constraints
user_id Int 11 Primary key
Company_name varchar 45 Not Null
User name varchar 30 Not Null
password Varchar 32 Not Null
Email _id varchar 45 Not Null
firstname varchar 30 Not Null
lastname Varchar 30 Not Null
Contactno varchar 11 Not Null
address varchar 90 Not Null
country varchar 30 Not Null
timezone varchar 200 Not Null
Timezone_constant varchar 100 Not Null
User_type varchar 5 Not Null
C) SAMPLE INPUT
Defining the campaigning
914400152970
Template selection
914400151068
D)SAMPLE OUTPUT
Scheduling the email
914400151363

x

Hi!
I'm Mila

Would you like to get a custom essay? How about receiving a customized one?

Check it out