PHP Phone Book

mileloader

* Project Name: PHP Phone Book
* Programmer: mileloader
* Type: Web
* Technology: PHP / Apache
* IDE: Dreamwaver
* Description: This a php- Free Phone Book Project using Mysql database server and Apache web server.It is so simple to understand.
Attachment:
File comment: List of files

ph.gif [ 10.7 KiB | Viewed 37190 times ]

Attachment:
File comment: Project source
PhoneBook2.rar [6.35 KiB]
Downloaded 11639 times

Attachment:
File comment: Screenshot

1.gif [ 5.33 KiB | Viewed 54549 times ]

It provide the following functions:

1. Login and Register.
2. Add Contacts.
3. Show Contacts .
4. Delete Contacts .
5. Search Contacts .
6. Remove Contact.
sample code : After_search.php
php code

<? session_start();?>
<html>
<link rel="stylesheet" href="my_layout.css"  type="text/css" />
<title>Phone Book Project</title>
<body class="my_body">
        <div id="my_divition">  
 <?php
 
       include('Control.php');
	   $connect=mysql_connect ("localhost", "root", "");
      			 mysql_select_db ("phonebook"); 
				  
				$fname=$_POST['fname'];
				$lname=$_POST['lname'];
			 
				$id=$_SESSION['id'];
				
			    $sqlQuery="select * from contact where f_name='$fname' AND l_name='$lname' AND                   M_id='$id'"; 
                 	 $result=mysql_query($sqlQuery); 
					 	 $number=mysql_num_rows($result);
						 
						 echo "<b><u><br>The search result is : </u></b><br><br>";
					  echo "<table border=1> ";
					  					  echo "<tr><th>First name</th><th>Last name</th>
										  <th>Phone number</th></tr>";
				    if($number>0)
				 {
				 
 
 
                   $fname=mysql_result($result,$number-1,"f_name");			
                   $lname=mysql_result($result,$number-1,"l_name");			
				   $phone=mysql_result($result,$number-1,"phone_number");			
                      					  echo "<center><tr><th>$fname</th><th>$lname</th>
										  <th>$phone</th></tr></center>";
     
	 
                 $number--;
				}	
				    else
					{
					
					 echo "</table> <br/> Sorry :no contact found with Name=$fname $lname  !  ";
					 }
           ?>
		   
		   				 
 </div>
 </body>
 </html>

Database DFL :
sql code

-- Server version: 4.1.9
-- PHP Version: 4.3.10
-- 
-- Database: `phonebook`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `contact`
-- 

CREATE TABLE `contact` (
  `C_id` int(4) NOT NULL auto_increment,
  `f_name` varchar(10) NOT NULL default '',
  `l_name` varchar(10) NOT NULL default '',
  `phone_number` varchar(15) NOT NULL default '',
  `M_id` int(4) NOT NULL default '0',
  PRIMARY KEY  (`C_id`),
  KEY `M_id` (`M_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

-- 
-- Dumping data for table `contact`
-- 

INSERT INTO `contact` VALUES (17, 'rwer', 'eqwr', '342355', 1);
INSERT INTO `contact` VALUES (16, 'sss', 'sss', 'fff', 1);
INSERT INTO `contact` VALUES (18, 'eee', 'qqq', '123345', 1);
INSERT INTO `contact` VALUES (19, 'eee', 'qqq', '123345', 1);
INSERT INTO `contact` VALUES (20, 'eee', 'qqq', '123345', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `members`
-- 

CREATE TABLE `members` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(10) NOT NULL default '',
  `pass` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `members`
-- 

INSERT INTO `members` VALUES (1, 'msi_333', '11991199');
INSERT INTO `members` VALUES (2, 'msi_333', '11991199');
INSERT INTO `members` VALUES (3, 'mmm', '11991199');
INSERT INTO `members` VALUES (4, '', '');

Casper

wow, thanks so much dude, keep on the good work

DrRakha

Good

strandcentury

in the package there is no sql file for the mysql database - how to I set up the database without the sql file, since I do not know the database structure. Please help!

DrRakha

strandcentury wrote:

in the package there is no sql file for the mysql database - how to I set up the database without the sql file, since I do not know the database structure. Please help!

DrRakha

you are welcome

new.boss

please help how can i update database ?? using this .txt file i am new bee . . . .

DrRakha

use the phpmyadmin for mysql it is a great tool

siginigin

well, i've to warn you (sorry mr. author), but this phonebook has many potetial security risks like non-sanitized inputs = no protection against well-known attacks (XSS, session_fixation, ...) so I highly don't recommend this software until biggest mistakes are fixed...
on the other side, if you want to use it inside your home network behind reliable firewall, i've no objections...

re5tekp. siginigin.

siginigin

http://voip-manager.net/downloads.php - free for 3 users

but unfortunately it seems it requires installed free PBX Aterisk on the server = requires admin rights on server and this isn't often possible

F|_|CK

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

PHP Phone Book

Topic Tags