PHP AJAX CRUD using PDO - Delete

hi dear friend, In this tutorial is part four of php Ajax Crud System make by using PDO Extention. So in this tutorial we discussing on delete data from mysql database with delete from folder uploaded image by using php procedural form programming script ajax response without page refresh. so need to do this row id, we will get id by using data attribute value then we delete row to ajax response. we have seen not only how to you delete data from mysql Database even you can learn how to delete uploaded image from folder path without page refresh with we use When will successfully delete row data then we show success alert, We not use browser default alert, We have use sweet alert must be load sweet js file. If you can use so First include css and js files by using ofline Download or CDN links for these files. When we send data to action file by jquery ajax reponse. we have action method POST so we get value by $_POST[] Supper global variable then delete query will delete data from db_users_account database into table tbl_users. I have also provide sql file with source code see in this post. Now do this and Fellow our video tutorial We have also provide youtube Video in this post. In next video tutorial we will make discussing on how to fetch delete row from Mysql table and image from folder by using AJAX response. So please share my post and go to my youtube channel and subscribe and share videos with your friends. Thanks Next Tutorilas Link these:

Files structure Fellow:
• Application root folder
  • upload
  //This Folder from delete, update and upload files when will match action value condition
  • action.php
  //This file will delete, update, fetch all rows data and handle for Insert data into Database Table
  • index.php
  //This file for view table data and Create form with update

Sourse Code:

action.php

index.php

Database file sql

--
-- Database: `db_users_account`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `u_id` int(11) NOT NULL,
  `u_name` varchar(255) NOT NULL,
  `u_email` varchar(255) NOT NULL,
  `u_sex` varchar(11) NOT NULL,
  `u_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`u_id`, `u_name`, `u_email`, `u_sex`, `u_image`) VALUES
(27, 'Ruhi', 'women@gmail.com', '2', '10695.jpg'),
(28, 'Roman', 'Roman@gmail.com', '1', '7156.jpg'),
(29, 'aslamhasib', 'aslamhasib@gmail.com', '1', '28445.png'),
(30, 'ibrahim', 'ibrahim@gmail.com', '1', '21906.png'),
(33, 'Programmer Rayhan', 'icttask.com.rayhan@gmail.com ', '1', '23019.jpg'),
(34, 'Rakib', 'Rakib@gmail.com', '1', '2610.jpg'),
(35, 'Rayhan', 'programmer@gmail.com', '1', '29472.jpg');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`u_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;