Contact Information System

Submitted by alpha_luna on Wednesday, May 25, 2016 - 15:30.

If you are looking for Contact Information System then you are at the right place. I have a full source code of Contact Information System. This system works on how to add, update, and delete contact information. We're gonna use INSERT, UPDATE, and DELETE Statement for this system using PDO.

INSERT, UPDATE, and DELETE Statement

INSERT Statement Using PDO

<?php
include ('db.php');
 
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];
$contact_number=$_POST['contact_number'];
$email=$_POST['email'];
$address=$_POST['address'];
 
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO tbl_member (first_name, last_name, contact_number, email, address )
VALUES ('$first_name', '$last_name', '$contact_number', '$email', '$address')";
 
$conn->exec($sql);
echo "<script>alert('Successfully Added!'); window.location='index.php'</script>";
?>

UPDATE Statement Using PDO

<?php
include 'db.php';
 
$get_id=$_REQUEST['tbl_member_id'];
 
$first_name= $_POST['first_name'];
$last_name= $_POST['last_name'];
$contact_number= $_POST['contact_number'];
$email= $_POST['email'];
$address= $_POST['address'];
 
$sql = "UPDATE tbl_member SET first_name ='$first_name', last_name ='$last_name', 
contact_number ='$contact_number', email ='$email', address ='$address' WHERE tbl_member_id = '$get_id' ";
 
$conn->exec($sql);
echo "<script>alert('Successfully Edit The Account!'); window.location='index.php'</script>";
?>

DELETE Statement Using PDO

<?php
require_once('db.php');
 
$get_id=$_GET['tbl_member_id'];
 
// sql to delete a record
$sql = "Delete from tbl_member where tbl_member_id = '$get_id'";
 
// use exec() because no results are returned
$conn->exec($sql);
header('location:index.php');
?>

Form Field

Add Form Field

<form method="post" action="add_person_query.php">
<table border="1" cellspacing="5" cellpadding="5" width="100%">
        <tr>
                <td>
                        <label>First Name</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="first_name" autofocus="autofocus" placeholder="First Name ....." required />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Last Name</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="last_name" placeholder="Last Name ....." required />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Contact Number</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="contact_number" placeholder="Contact Number ....." required />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Email</label>
                </td>
                <td width="395px">
                        <input type="email" class="text_Box" name="email" placeholder="Email .....">
                </td>
        </tr>
        <tr>
                <td>
                        <label>Address</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="address" placeholder="Address ....." required />
                </td>
        </tr>
        <tr>
                <td colspan="2">
                        <a>
                                <button type="submit" class="btn_confirm">
                                        Save Data
                                </button>
                        </a>
                </td>
        </tr>
</table>
</form>

Update Form Field

<?php
include('db.php');
$result = $conn->prepare("SELECT * FROM tbl_member where tbl_member_id='$ID'");
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
$id=$row['tbl_member_id'];
?>
 
<form method="post" action="edit_person_query.php<?php echo '?tbl_member_id='.$id; ?>">
<table border="1" cellspacing="5" cellpadding="5" width="100%">
        <tr>
                <td>
                        <label>First Name</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="first_name" value="<?php echo $row['first_name']; ?>" autofocus="autofocus" placeholder="First Name ....."  />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Last Name</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="last_name" value="<?php echo $row['last_name']; ?>" placeholder="Last Name ....."  />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Contact Number</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="contact_number" value="<?php echo $row['contact_number']; ?>" placeholder="Contact Number ....."  />
                </td>
        </tr>
        <tr>
                <td>
                        <label>Email</label>
                </td>
                <td width="395px">
                        <input type="email" class="text_Box" name="email" value="<?php echo $row['email']; ?>" placeholder="Email .....">
                </td>
        </tr>
        <tr>
                <td>
                        <label>Address</label>
                </td>
                <td width="395px">
                        <input type="text" class="text_Box" name="address" value="<?php echo $row['address']; ?>" placeholder="Address ....."  />
                </td>
        </tr>
        <tr>
                <td colspan="2">
                        <a>
                                <button type="submit" class="btn_confirm">
                                        Save Data
                                </button>
                        </a>
                </td>
        </tr>
</table>
</form>
<?php } ?>

Delete Field

<a href="delete_contact.php<?php echo '?tbl_member_id='.$id; ?>">
        <button type="submit" class="btn_confirm1" onclick="return confirm(' Delete Contact ( <?php echo $first_name?> ) ? ');">
                Delete
        </button>
</a>

Result:

INSERT Data

UPDATE Data

DELETE Data

And, that's it. Kindly click the "Download Code" button below for full source code. Thank very much. Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Add new comment

171 views