Total members 11889 |It is currently Thu Mar 28, 2024 10:31 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka



Go to page 1, 2, 3, 4  Next



* 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
ph.gif [ 10.7 KiB | Viewed 36414 times ]

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

Attachment:
File comment: Screenshot
1.gif
1.gif [ 5.33 KiB | Viewed 53773 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, '', '');




_________________
Please recommend my post if you found it helpful


Author:
Beginner
User avatar Posts: 95
Have thanks: 2 time

For this message the author mileloader has received gratitude : HTMM2009

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


_________________
Please recommend my post if you found it helpful. ,
java,j2ee,ccna ,ccnp certified .


Author:
Expert
User avatar Posts: 838
Have thanks: 2 time

Good :gOOd:


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

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!



Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time

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!




Attachments:
New Text Document (2).txt [1.66 KiB]
Downloaded 5044 times

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada
Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

you are welcome


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

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



Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time

use the phpmyadmin for mysql it is a great tool


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

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.



Author:
Newbie
User avatar Posts: 2
Have thanks: 0 time

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



Author:
Newbie
User avatar Posts: 2
Have thanks: 0 time
Post new topic Reply to topic  [ 34 posts ]  Go to page 1, 2, 3, 4  Next

  Related Posts  to : PHP Phone Book
 Phone Book     -  
 Phone Book     -  
 I download the phone book coding from your site     -  
 Full Phone Book System php and mysql     -  
 phone directory     -  
 speaker phone with JTapi     -  
 Communication from pc to cell phone     -  
 how to build cell phone app     -  
 How i can transfer voice during call from phone to PC?     -  
 validate international phone number value     -  



Topic Tags

PHP Project
cron






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com