Function 7 - MASTER is a multi-purpose crud that is suitable for developing multi-purpose applications. Consists of:
- Add
-
- Single
- Multi
- Export
-
- Print all (PDF)
- Print single
- Copy to Clipboard
- Excel
- CSV
- Search
-
- Search by (Id, Firts Name, Last Name, Eamil, Date)
- Search by key word
- Search by date (From date - to date)
- Check
-
- Hide columns (Firts Name, Last Name, Eamil, Date)
- Multi crud (multi view, edit or delete)
- Search by date (From date - to date)
Content (conn.php)
<?php
$server = "localhost";
$user = "root";
$password = "root";
$base = "fun_7";
$con = mysqli_connect($server, $user, $password, $base);
?>
Database
CREATE TABLE `users` (
`user_id` int(20) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`image` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
ALTER TABLE `users`
MODIFY `user_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;