- 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 */;