Friday, 24 June 2016

How to Create Add, Delete and Edit project using php and mysql ?

                                   Add , Delete and Edit Project                       

 

                                          add.html


<html>
<head>
    <title>Add Data</title>
</head>

<body>
    <a href="index.php">Home</a>
    <br/><br/>

    <form action="add.php" method="post" name="form1">
        <table width="25%" border="0">
            <tr>
                <td>Name</td>
                <td><input type="text" name="name"></td>
            </tr>
            <tr>
                <td>Age</td>
                <td><input type="text" name="age"></td>
            </tr>
            <tr>
                <td>Email</td>
                <td><input type="text" name="email"></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" name="Submit" value="Add"></td>
            </tr>
        </table>
    </form>
</body>
</html>










                                                add.php



<html>
<head>
    <title>Add Data</title>
</head>

<body>
<?php
//including the database connection file
include_once("config.php");

if(isset($_POST['Submit'])) {   
    $name = $_POST['name'];
    $age = $_POST['age'];
    $email = $_POST['email'];
       
    // checking empty fields
    if(empty($name) || empty($age) || empty($email)) {
               
        if(empty($name)) {
            echo "<font color='red'>Name field is empty.</font><br/>";
        }
       
        if(empty($age)) {
            echo "<font color='red'>Age field is empty.</font><br/>";
        }
       
        if(empty($email)) {
            echo "<font color='red'>Email field is empty.</font><br/>";
        }
       
        //link to the previous page
        echo "<br/><a href='javascript:self.history.back();'>Go Back</a>";
    } else {
        // if all the fields are filled (not empty)
           
        //insert data to database   
        $result = mysql_query("INSERT INTO users(name,age,email) VALUES('$name','$age','$email')");
       
        //display success message
        echo "<font color='green'>Data added successfully.";
        echo "<br/><a href='index.php'>View Result</a>";
    }
}
?>
</body>
</html>








                                          config.php



<?php

// mysql_connect("database-host", "username", "password")
$conn = mysql_connect("localhost","root","")
            or die("cannot connected");

// mysql_select_db("database-name", "connection-link-identifier")
@mysql_select_db("test1",$conn);
   
?>

delete.php
<?php
//including the database connection file
include("config.php");

//getting id of the data from url
$id = $_GET['id'];

//deleting the row from table
$result = mysql_query("DELETE FROM users WHERE id=$id");

//redirecting to the display page (index.php in our case)
header("Location:index.php");
?>


                                           edit.php

<?php
// including the database connection file
include_once("config.php");

if(isset($_POST['update']))
{   
    $id = $_POST['id'];
   
    $name=$_POST['name'];
    $age=$_POST['age'];
    $email=$_POST['email'];   
   
    // checking empty fields
    if(empty($name) || empty($age) || empty($email)) {   
           
        if(empty($name)) {
            echo "<font color='red'>Name field is empty.</font><br/>";
        }
       
        if(empty($age)) {
            echo "<font color='red'>Age field is empty.</font><br/>";
        }
       
        if(empty($email)) {
            echo "<font color='red'>Email field is empty.</font><br/>";
        }       
    } else {   
        //updating the table
        $result = mysql_query("UPDATE users SET name='$name',age='$age',email='$email' WHERE id=$id");
       
        //redirectig to the display page. In our case, it is index.php
        header("Location: index.php");
    }
}
?>
<?php
//getting id from url
$id = $_GET['id'];

//selecting data associated with this particular id
$result = mysql_query("SELECT * FROM users WHERE id=$id");

while($res = mysql_fetch_array($result))
{
    $name = $res['name'];
    $age = $res['age'];
    $email = $res['email'];
}
?>
<html>
<head>   
    <title>Edit Data</title>
</head>

<body>
    <a href="index.php">Home</a>
    <br/><br/>
   
    <form name="form1" method="post" action="edit.php">
        <table border="0">
            <tr>
                <td>Name</td>
                <td><input type="text" name="name" value=<?php echo $name;?>></td>
            </tr>
            <tr>
                <td>Age</td>
                <td><input type="text" name="age" value=<?php echo $age;?>></td>
            </tr>
            <tr>
                <td>Email</td>
                <td><input type="text" name="email" value=<?php echo $email;?>></td>
            </tr>
            <tr>
                <td><input type="hidden" name="id" value=<?php echo $_GET['id'];?>></td>
                <td><input type="submit" name="update" value="Update"></td>
            </tr>
        </table>
    </form>
</body>
</html>

                                              index.php


<?php
//including the database connection file
include_once("config.php");

//fetching data in descending order (lastest entry first)
$result = mysql_query("SELECT * FROM users ORDER BY id DESC");
?>

<html>
<head>   
    <title>Homepage</title>
</head>

<body>
<a href="add.html">Add New Data</a><br/><br/>

    <table width='80%' border=0>

    <tr bgcolor='#CCCCCC'>
        <td>Name</td>
        <td>Age</td>
        <td>Email</td>
        <td>Update</td>
    </tr>
    <?php
    while($res = mysql_fetch_array($result)) {        
        echo "<tr>";
        echo "<td>".$res['name']."</td>";
        echo "<td>".$res['age']."</td>";
        echo "<td>".$res['email']."</td>";   
        echo "<td><a href=\"edit.php?id=$res[id]\">Edit</a> | <a href=\"delete.php?id=$res[id]\" onClick=\"return confirm('Are you sure you want to delete?')\">Delete</a></td>";       
    }
    ?>
    </table>
</body>
</html>

                                             database.sql

create database test;



CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `age` int(3) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
);

 

No comments:

Post a Comment