TELEPHONE DIRECTORY SYSTEM

blahboatsInternet και Εφαρμογές Web

13 Δεκ 2013 (πριν από 3 χρόνια και 4 μήνες)

81 εμφανίσεις

Application no: 1

Date:

20.7.2012



TELEPHONE DIRECTORY SYSTEM



1.

ABSTRAC
T

The p
roject titled Telephone Directory System is telephone directory
processing

management softwar
e for monitoring and processing the tra
nsactions
in a telephone system
.

The proje
ct “
Telephone Directory
System”
is developed
using IDE NETBEANS6.9,

Technology used

PHP
as front end
and XAMP
P
Control Panel as the Back
End
which

mainly focuses
on basic operations in an
telephone directory system like adding new subscriber details such a
s
Su
bscriber
Name, Subscriber No
,

Address, City and Mobile Nu
mber. Search

particular
subscriber details by using Subscriber No.



Telephone Directory System
” is a web based
application
designed to help
administrator maintain and organize Directory process
. Our software is easy to
use for both beginners and advanced users. It features a familiar and well thought
-
out, an attractive user interface,

combined with strong searching,

i
nsertion and
reporting capabilities. The repor
t generation facility of telephon
e directory
system
helps to get
information about subscriber details and makes administrator

possibl
e
to generate reports and also subscriber can be able to view the report of
telephone
directory process,
search particular subscriber details in the system
.






















2.

OBJECTIVE OF THE PROJECT






The
“TELEPHONE DIRECTORY SYSTEM”

process made
computerized to reduce human errors and to increase the efficiency.




The main focus of this project is to less human efforts. The maintenance of
the records is

made efficient, as all the records are stored in the XAMPP
Control Panel database, through which data can be retrieved easily.




The navigation control is provided in all the forms to navigate through the
large amount of records.




If the numbers of recor
ds are very large then a
dministrator has to just type

the subscriber no and gets the results immediately. The editing is also
made simpler.




The administrator has to just type in the required field and press the update
button to update the desired field.






















3.

SYSTEM REQUIREMENT
S



3.1 HARDWARE SPECIFICATION:


Processor



:


Intel Pentium 4

Processor Speed


:


2.5 GHZ

RAM




:


256 MB

HDD




:


80 GB

Monitor



:


15” Color Monitor

Key board




:


104 ke
ys




3.2 SOFTWARE SPECIFICATION:


Operating System



:

Windows XP Professional


IDE






:

Net Beans 6.9

Front End



:

PHP

Back End





:

XAMPP control panel

Internet Browser





:

Microsoft Internet Explorer 6.0









3.3 ABOUT THE SOFTWARE:


3.3.1
NetBeans

IDE

6.9
:



NetBeans

refers to both a

platform framework for Java desktop
applications, and an

integrated development environment (IDE) for developing with

Java,

JavaScript,

PHP,

Python,

Ruby,

Groovy,

C,

C++,

Scala,

Clojure, and others.




The NetBeans IDE is written in Java and runs everywhere where a

JVM is
installed, including Windows, Mac OS, Linux, and Solaris. A

JDK is required for Java
dev
elopment functionality, but is not required for development in other programming
languages.

Current Versions:


NetBeans IDE 6.0 introduced support for developing IDE modules and
rich client applications based on the NetBeans platfor
m, a Java Swing

GUI builder
(formerly known as “Project Matisse”), improved

CVS support,

Web logic 9 and

JBoss 4
support, and many editor enhancements. NetBeans 6 is available in official repositories of
major Linux distributions.


Net
Beans IDE 6.5, released in November 2008, extended the existing

Java
EE features (including Java Persistence support, EJB 3 and JAX
-
WS). Additionally, the

NetBeans Enterprise Pack supports development of Java EE 5 enterprise applications,
including

SOA vis
ual design tools, XML schema tools, web services orchestration (for
BPEL), and

UML modeling. The

NetBeans IDE Bundle for C/C++ supports C/C++
development.


T
he NetBeans IDE 6.8 is the first IDE to provide complete support of Java
EE
6 and the

GlassFish Enterprise Server v3. Developers hosting their open
-
source
projects onkenai.com additionally benefit from instant messaging and issue tracking
integration and navigation right in the IDE, support for web application development
with PHP

5.3 and the Symfony framework, and improved code completion, lay outing,
hints and navigation in JavaFX projects.



NetBeans IDE 6.9, released in June 2010, added support
for

OSGi,

Spring Framework 3.0, Java EE dependency injec
tion (JSR
-
299),

Zend
Framework for

PHP, and easier code navigation (such as “Is Overridden/Implemented”
annotations), formatting, hints, and refactoring across several languages.



3.3.2

PHP

PHP is a general
-
purpose scripting language that is especially su
ited to server
-
side


web
development where PHP generally runs on a web server. Any PHP code in a
requested file is executed by the PHP runtime, usually to create dynamic web page
content or dynami
c images used on Web sites or elsewhere.

It can also be used for
command
-
line scripting and client
-
side graphical user interface (GUI) applications. PHP
can be deployed on most Web servers, many operating systems and platforms, and can be
used with many re
lational database management systems (RDBMS). It is available free
of charge, and the PHP Group provides the complete source code for users to build,
customize and extend for their own use.

PHP acts primarily as a filter,

taking input from a file or stream

containing text
and/or PHP instructions and outputting another stream of data; most commonly the
output will be HTML. Since PHP 4, the PHP parser compiles input to produce byte

code
for processing by the Zend Engine, giving improved performance over its i
nterpreter
predecessor.

Originally designed to create dynamic Web pages, PHP now focuses mainly on
server
-
side scripting, and it is similar to other server
-
side scripting languages that provide
dynamic content from a Web server to a client, such as Microso
ft's ASP.NET, Sun
Microsystems' Java

Server Pages,

and mod_perl. PHP has also attracted the development
of many frameworks that provide building blocks and a design structure to promote rapid
application development (RAD). Some of these include CakePHP, Sy
mfony, Code

Igniter, Yii Framework, and Zend Framework, offering features similar to other web
application frameworks



















3.3.3

XAMPP Control Panel:


XAMPP

is an integrated server package of Apache, mySQL, PHP and Perl (the
AMPP in XAMPP) tha
t all run from a removable drive. Everything is pre
-
configured and
ready to go just by unzipping or installing it.XAMPP is a complete web, database and
FTP server package for Windows that's ready to go in minutes and completely portable.
The full XAMPP pac
kage includes:



Apache



MySQL



PHP + PEAR



MiniPerl



OpenSSL



phpMyAdmin



XAMPP Control Panel



Webalizer



Mercury Mail Transport System



FileZilla FTP Server



SQLite



ADODB



Zend Optimizer



XAMPP Security



Tomcat

XAMPP Lite

leaves off the additional packages and sticks t
o Apache, mySQL,
phpMyAdmin, SQLite and related packages resulting in an installation that's significantly
smaller. There are no upgrade packages for XAMPP Lite like there are for XAMPP,
though.
















4.

SYSTEM

DESIGN



4.1 DATA FLOW DIAGRAM:





































TELEPHONE DIRECTORY

SYSTEM

ADMIN

USER

Checking
Username
& Password

Search &
View

Register,
Search &
View

Telephone






4.2

E
-
R DIAGRAM:

































Telephone1

Subscriber
Name

Subscriber No

City

Address

Mobile No





4.3

SYSTEM FLOW DIAGRAM:










































MAIN MENU

Login

Search

Report

Enter
new
Subs
c
riber
details

Individual Subscriber
details

Details of entire
subscriber

DATA
BASE

DATA
BASE

DATA
BASE




4.
4

USE
-
CASE DIAGRAM:

















Admin

search

User

report

login

Register




5. DATABASE DESIGN



TELEPHONE
:



Field Name

Data Type

Size

Subscriber Name

Varchar

15

Subscriber No

Int

5

Address

Varchar

30

City

Varchar

15

Mobile No

Int

12



























6
.

SYSTEM IMPLEMENTATION



6
.1 LOGIN

MODULE:


In this module, system has to check the username and password of the Telephone
Directory System. If the login is successful, the administrator can access the Telephone
Directory System. Otherwise the access is denied.



6
.2 REGISTRATION MODULE
:



In this module, the administrator to store the subscriber details such as Subscriber
name,

Subscriber No, Address, City and Mobile Number are updated.



6
.3 SEARCH MODULE
:



In this module,

not only administrator even user also can search particul
ar reco
rd
and also view all the

details of

the
subscriber.
























7. TESTING



Software testing is a critical element of a software quality assurance and represents
the ultimate reviews of specification, design and coding. Testing presents

an interesting
anomaly for the software. During earlier definition and development phases, it was
attempted to build software from an abstract concept to a tangible implementation.



The testing phase involves the testing of the developed system using
various test
data. Preparation of test data plays a vital roll in the system testing. After the preparing
the test data system under study was tested using those test data. While testing the system
by using test data, errors were found and corrected by usi
ng following testing steps and
corrections are also noted for future use.


Thus, a series of testing was performed for the proposed system before the system
was ready for the implementation.


7.1 TESTING OBJECTIVES:



There are several r
ules that can server as testing objectives. They are



Testing is a process of executing a program with the intent of
finding an error.



A good case is one that has a high probability of finding an
undiscovered error.



A successful test is one that uncovers an

undiscovered error.



If testing is conducted successfully according to the objectives
stated above, it will uncover errors in the software. Also testing
demonstrates that software functions appear to the working
according to specification that performance
requirements appear to
have been set.



7.2 TYPES OF TESTING:




The various types testing done on the system are:



Unit Testing



Integration Testing



Validation Testing



Verification Testing

Unit Testing:



Unit testing focuses verification effort on the sm
allest unit of software design the
module. This is also known as module testing. The unit testing is always white box
oriented and the step can be contacted in parallel for modules. In this testing each module
is found to be working satisfactory as regards

to the expected output from the module.



Integration Testing:



Integration testing is a symmetric technique for constructing the program structure
while at the same time conducting tests to uncover errors associated with interfacing. The
objective is to

take unit tested modules and build a program structure that has been
dictated by design.


A set of errors encountered. Correction is difficult because the isolation of causes
is complicated by the vast expense of the entire program. Using integrated test
plans
prepare in the design phase of the system development as guide, the integration testing
was carried out. All the errors found in the system were corrected of the next testing
steps.


Validation Testing:



All the culmination of integration testing, s
oftware is completely assembled as
package, interfacing error have been uncovered and corrected and a final series of
software tests


the validation testing begins. Validation testing can be defined in many
ways, but a simple definition is that validation

succeeds when the software function in a
manner that can be reasonably expected by the user /customer. Software validation
conformity is followed with the following requirements.


Verification Testing:


Verification is intended to check that a product, se
rvice, or system (or portion
thereof, or set thereof) meets a set of initial design requirements, specifications, and
regulations. In the development phase, verification procedures involve performing special
tests to model or simulate a portion, or the ent
irety, of a product, service or system, then
performing a review or analysis of the modeling results. In the post
-
development phase,
verification procedures involve regularly repeating tests devised specifically to ensure
that the product, service, or syst
em continues to meet the initial design requirements,
specifications, and regulations as time progresses.
















8
.

PROCEDURE


XAMPP Control Panel:


Step

1:

Open XAMPP Control Panel application.

Step

2:

Start the following options Apache,MySQL and
FileZilla.

Step

3:

Then open Internet Explorer and run the local host.














Step
4:

Select phpMyAdmin and Create Database.




















Step
5:

Then Create Table and add the number of fields in the table.







Step
6:

Save the fields and

then close the Internet Explorer,

and open Net Beans IDE 6.9.

















NET BEANS IDE 6.9:


Step
1:

Open Net Beans IDE 6.9 and Click New Project in the File option and select the
PHP application.




Step
2:

Then click next and give a projec
t name,

C
lick Finish

Step
3:

An
d type PHP

c
oding

in the project.

Step 4
:

And then e
xecute the project











9
.

CODING



INDEX:


<!DOCTYPE HTML PUBLIC "
-
//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<meta http
-
equiv="Content
-
Type" content="text/
html; charset=UTF
-
8">

<title>Login form</title>

</head>

<body>

<form action="check.php" method="post">

<p><b><center><h1>WELCOME TO TELEPHONE DIRECTORY
SYSTEM</h1></center></b>

</p>

<h1><b> Admin Login Form</b></h1>

<table border="1" style="margin
-
top:100p
x;margin
-
left: 500px;">

<tr>

<td>User Name:</td>

<td><input name="username" type="text" id="username" size="10" /></td>

</tr>

<tr>

<td>Password:</td>

<td><input name="password" type="password" id="password" size="10" /></td>

</tr>

<tr>

<td>&nbsp;</td>

<td

align="center"><input type="submit" value="Login"><input name="reset"
type="reset" value="Clear" class="flashit"></td>

</tr>

</table><b>

<h2><center><a href="search.php">Search</a></center></h2>

<h2><center><a href="view1.php">View All</a></center></h2>

</form>

</body>

</html>








INDEX 1:


<!DOCTYPE HTML PUBLIC "
-
//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<meta http
-
equiv="Content
-
Type" content="text/html; charset=UTF
-
8">

<title>Telephone Directory</title>

</head>

<body>

<form>

<p><b><cent
er><h1>WELCOME TO TELEPHONE DIRECTORY
SYSTEM</h1></center></b>

</p>

<h1><a href="second.php">New User Register</a></h1><br>

<h1><a href="search.php">Search</a></h1>

<h1><a href="view.php">Report</a></h1>

<h1><a href="index.php">Logout</a></h1>

</form>

</bo
dy>

</html>



SECOND:


<html>

<head>

<meta http
-
equiv="Content
-
Type" content="text/html; charset=UTF
-
8">

<title>Registration</title>

</head>

<body>

<form action="edit.php" method="post">

<p>SubsciberName :<input type="text" name="SubscriberName"/><br>

</p>

<p>SubscriberNo :<input type="text" name="SubscriberNo"/><br>

</p>

<p>Address :<input type="text" name="Address"/><br>

</p>

<p>City :<input type="text" name="City"/><br>

</p>

<p>MobileNo :<input type="text" name="MobileNo"/><br>

</p>

<p><input name="submi
t" type="submit"/></p>

</form>

</body>

</html>




EDIT:


<?php

$con= mysql_connect("localhost","root");

if(!$con)

{

die('Could not connect:'.mysql_error());

}

mysql_select_db("telephone",$con);

$sql="INSERT INTO
telephone1(SubscriberName,SubscriberNo,Addr
ess,City,MobileNo) VALUES
('$_POST[SubscriberName]','$_POST[SubscriberNo]','$_POST[Address]','$_POST[City]
','$_POST[MobileNo]')";

if(!mysql_query($sql,$con))

{

die('Error:'.mysql_error());

}

echo"<h1>1 record added</h1>";

mysql_close($con);

?>

<h2><a href=
"view.php">view All Records</a></h2>


























VIEW:


<?php

$con=mysql_connect("localhost","root","");

if(!$con)

{

die('Could not connect:'.mysql_error());

}

mysql_select_db("telephone",$con);

$result=mysql_query("SELECT * FROM telephone1");

echo"<table border='1'>

<tr>

<th>SubscriberName</th>

<th>SubscriberNo</th>

<th>Address</th>

<th>City</th>

<th>MobileNo</th>

</tr>";

while($row=mysql_fetch_array($result))

{

echo"<tr>";

echo"<td>".$row['SubscriberName']."</td>";

echo"<td>".$row['Subscriber
No']."</td>";

echo"<td>".$row['Address']."</td>";

echo"<td>".$row['City']."</td>";

echo"<td>".$row['MobileNo']."</td>";

echo"<tr>";

}

echo"</tables>";

mysql_close($con);

?><br>

<h2><center><a href="index.php">HOME</a></center></h2>















SEARCH:


<
html>

<title>Searching </title>

<head><h1>Search a Record</h1></head>

<body>

<form action="individualname.php" method="post">

<p>&nbsp;</p>

<p>Enter the Subscriber Number

<input type="text" name="SubscriberNo" />

<br>

</p>

<p><input name="submit" type="sub
mit" value="submit"/> </p>

</form>

</body>

</html>





INDIVIDUAL NAME:


<?php

$SubscriberNo =$_POST['SubscriberNo'];

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('could not connect:'.mysql_error());

}

mysql_select_db("telephone",$con);

$r
esult=mysql_query("SELECT * FROM telephone1 where
SubscriberNo='$SubscriberNo'");

echo"<table border='1'>

<tr>

<th>SubscriberName</th>

<th>SubscriberNo</th>

<th>Address</th>

<th>City</th>

<th>MobileNo</th>

</tr>";







while($row=mysql_fetch_array($result
))

{

echo"<tr>";

echo"<td>".$row['SubscriberName']."</td>";

echo"<td>".$row['SubscriberNo']."</td>";

echo"<td>".$row['Address']."</td>";

echo"<td>".$row['City']."</td>";

echo"<td>".$row['MobileNo']."</td>";

echo"<tr>";

}

echo"</tables>";

mysql_close($con);

?>

<h1><a href="search.php">Search another record</a></h1>

<h1><a href="index1.php">Home</a></h1>






ERROR :


<?php

echo 'Invalid Username and Password';

?>

<h1><a href="index.php">Relogin</a></h1>


CHECK :

<?php

$user=$_POST['username'];

$pass=$_POST['
password'];

if ($user =='admin' && $pass =='admin' )

{

header("Location: index1.php");

}

else

{

header("Location: error.php");

}

?>






10
.

SCREEN SHOTS



LOGIN :


















REGISTRATION
:



















ENTER SUBSCRIBER DETAILS
:
















SEARCH A

RECORD:














DISPLAY INDIVIDUAL RECORD
:














TEST CASE 1:














TEST CASE 2:















DISPLAY
INVALID LOGIN:














11.REPORT






















12
.

CONCLUSION



This project is really a user
-
friendly

pro
ject and very flexible too
.
The main goal
of the project is to implement the telephone directory system using internet based
technology. The details of the subscriber can be collected from anywhere in the world.


The user detail that is the subscriber deta
il are stored and processed in a very
efficient manner.