PHP CRUD with File Uploading Using Ajax

Ajax

AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.

The example is below for insert, update, delete and file uploading in PHP.

Create files in a project folder like below :

- Project

- db.php

- insert.php

- delete.php

- view.php

db.php

insert.php

<?php 
include('db.php');
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
if(isset($_REQUEST['submit']))
{   
    $name = $_REQUEST['name'];
    $date=date("Y_h_m_s");
    $file_get_location = $_FILES['image']['tmp_name'];
    $file_name = $_FILES['image']['name'];
    $new_filename=$date.'_'.$file_name;
    $file_directory = "upload/".$new_filename;
    $query = "INSERT INTO demo (name,image_path) VALUES  ('$name','$file_directory')";
    try
    {
        if(move_uploaded_file($file_get_location,$file_directory)) 
            {
              if ($conn->query($query) === TRUE)
                {
                    //echo "New record created successfully";
                    header('location:view.php');
                }
                else 
                {
                    echo "Error: " . $query . "<br>" . $conn->error;
                }  
            }
        else
            {
                echo "Faile file uploading";
            }
    }
    catch(Exeption $e)
    {
        echo "Faile file uploading";
    }
}
?>

edit.php

<?php 
include('db.php');
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
if(isset($_REQUEST['id']))
{   
    $id = $_REQUEST['id'];
    $edit = "select * from demo where id = $id";
    $edit_data = $conn->query($edit);
    $row = $edit_data->fetch_object();
    $name = $row->name;
    $image_path = $row->image_path;
}
if(isset($_REQUEST['update']))
{
    $id = $_REQUEST['id'];
    $name = $_REQUEST['name'];
    $date=date("Y_h_m_s");
try
    {    
    if(!isset($_FILES['image']))
       {
           $query = "UPDATE demo SET name = '$name' where id = $id";  
           exit();
       }
       else
       {
           $file_get_location = $_FILES['image']['tmp_name'];
           $file_name = $_FILES['image']['name'];
           $new_filename=$date.'_'.$file_name;
           $file_directory = "upload/".$new_filename;
           $query = "UPDATE demo SET name = '$name',image_path = '$file_directory' where id = $id";
       }
    
    
        if(move_uploaded_file($file_get_location,$file_directory)) 
            {
              if ($conn->query($query) === TRUE)
                {
                    //echo "New record created successfully";
                   header('location:view.php');
                }
                else 
                {
                    echo "Error: " . $query . "<br>" . $conn->error;
                }
            }
        else
            {
                echo "Faile file uploading";
            }
    }
    catch(Exeption $e)
    {
        echo $e;
    }
    
}
if(isset($_REQUEST['update'])){
    //header('location:view.php');
}
?>
<h1>Edit </h1>
<form method="post" enctype="multipart/form-data" action="edit.php">
    <input type="hidden" name="id" value="<?php echo $id ?>">
    <input type="text" name="name" value="<?php echo $name ?>">
    <input type="file" name="image" id="file" value="\upload\2017_07_03_36_ariso.png">
    <img src="<?php echo $image_path ?>"/ width="100px" height="100px">
    <input type="submit" name="update">
</form>

delete.php

view.php

Master4PHP

Search This Blog

PHP CRUD with File Uploading Using Ajax

Comments

Post a Comment

Popular posts from this blog

How to change Dynamic URL to Static URL in php ?

How to register in php(Sign up form in php)

Login, Logout and Dashboard Using PHP and with MySQL database