| px | top | add code | search | signup | login | help |
<?php
//address_book.php
//see record in address book
/*
create table in your database
CREATE TABLE useraddress (
user_id int(4) NOT NULL auto_increment,
user_name varchar(30) default NULL,
user_address varchar(250) default NULL,
user_city varchar(100) default NULL,
user_phone varchar(30) default NULL,
user_email varchar(30) default NULL,
PRIMARY KEY (user_id)
) TYPE=MyISAM;
*/
//database connection
//connect.php
$host_name = "localhost";
$username = "root";
$password = "root";
$db_name = "test";
$link = mysql_connect($host_name, $username, $password) or die(mysql_error());
$selectdb = mysql_select_db('test',$link) or die(mysql_error());
//connect to database
include("connect.php");
?>
<html>
<head>
<title>Address Book</title>
</head>
<body>
<h2>Address Book</h2>
<table border cellpadding=3>
<tr>
<th width=100>Name</th>
<th width=100>Adress</th>
<th width=200>City</th>
<th width=100>Phone</th>
<th width=100>E-mail</th>
<th width=100>Edit</th>
</tr>
<?
$select_info = "SELECT * FROM useraddress ORDER BY user_name ASC";
$exec_info = mysql_query($select_info);
//Print "<td colspan=5 align=right><a href=" .$_SERVER[’PHP_SELF’]. "?mode=add>Add Contact</a></td>";
while($fetch_info = mysql_fetch_object($exec_info))
{
?>
<tr>
<td><? echo $fetch_info->user_name;?></td>
<td><? echo $fetch_info->user_address;?></td>
<td><? echo $fetch_info->user_city;?></td>
<td><? echo $fetch_info->user_phone;?></td>
<td><? echo $fetch_info->user_email;?></td>
<td><a href="update_add.php?id=<? echo $fetch_info->user_id;?>">Update</a></td>
</tr>
<?
}
?>
</table>
<table>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="add_address.php">Add Address ?</a></td>
</tr>
</table>
</body>
</html>
<?
//add information in address_book
//add_address.php
$check = $HTTP_POST_VARS['mode'];
include("connect.php");
if(2 == $check)
{
$name = trim($HTTP_POST_VARS['name']);
$address = trim(addslashes($HTTP_POST_VARS['address']));
$city = trim($HTTP_POST_VARS['city']);
$phone = $HTTP_POST_VARS['phone'];
$email = $HTTP_POST_VARS['email'];
$insert_data = "INSERT INTO useraddress (user_id, user_name, user_address, user_city, user_phone, user_email)
VALUES (NULL, '$name', '$address', '$city', '$phone', '$email')";
$exec_insert = mysql_query($insert_data);
if(!$exec_insert)
{
echo "Your Data Not Inserted Properly, Please try again";
}
else
{
echo "<font color = 'red'><b>Your Data Inserted Properly</b></font>";
}
}
?>
<html>
<head>
<title>Address Book</title>
</head>
<body>
<form action="<? echo $PHP_SELF;?>" method="post">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td>City:</td><td><input type="text" name="city"></td></tr>
<tr><td>Phone:</td><td><input type="text" name="phone"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="Submit Data"></td></tr>
<input type="hidden" name="mode" value="2">
</table>
</form>
<table>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="address_book.php">Address Book</a></td>
</tr>
</table>
</body>
</html>
<?
//update information in address book
//update_add.php
include("connect.php");
$user_id = $HTTP_GET_VARS['id'];
$check = $HTTP_POST_VARS['mode'];
if($user_id != '')
{
$select_info = "select * from useraddress where user_id=".$user_id;
$exec_info = mysql_query($select_info);
$fetch_info = mysql_fetch_object($exec_info);
$user_name = $fetch_info->user_name;
$user_address = $fetch_info->user_address;
$user_city = $fetch_info->user_city;
$user_phone = $fetch_info->user_phone;
$user_email = $fetch_info->user_email;
}
if(2 == $check)
{
$name = trim($HTTP_POST_VARS['name']);
$address = trim(addslashes($HTTP_POST_VARS['address']));
$city = trim($HTTP_POST_VARS['city']);
$phone = $HTTP_POST_VARS['phone'];
$email = $HTTP_POST_VARS['email'];
$userid = $HTTP_POST_VARS['userid'];
$update_data = "update useraddress set user_name = '$name', user_address = '$address', user_city = '$city',
user_phone = '$phone', user_email = '$email' where user_id = ". $userid;
$exec_update = mysql_query($update_data);
if(!$exec_update)
{
echo "Your Data Not Update Properly, Please try again";
}
else
{
echo "<font color = 'red'><b>Your Data Update Properly</b></font>";
}
}
?>
<html>
<head>
<title>Address Book</title>
</head>
<body>
<form action="<? echo $PHP_SELF;?>" method="post">
<table>
<tr><td>Name:</td><td><input type="text" name="name" value="<? echo $user_name;?>"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address" value="<? echo $user_address;?>"></td></tr>
<tr><td>City:</td><td><input type="text" name="city" value="<? echo $user_city;?>"></td></tr>
<tr><td>Phone:</td><td><input type="text" name="phone" value="<? echo $user_phone;?>"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" value="<? echo $user_email;?>"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="update Data"></td></tr>
<input type="hidden" name="mode" value="2">
<input type="hidden" name="userid" value="<? echo $user_id; ?>">
</table>
</form>
<table>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="address_book.php">Address Book</a></td>
</tr>
</table>
</body>
</html>
Comments or questions?
PX is running PHP 5.2.11
Thanks to Miranda Productions for hosting and bandwidth.
Use of any code from PX is at your own risk.