F 7 & GRID Multi with PHP Mysql is multi-functional CRUD. F7 Multi which helps you understand certain more complex functionalities. Of course everything is connected to the MySql database.
F 7 & GRID Multi have many functionalities such as:
- Clone table
- Join & Union
- Change status
- Multi tag
I will also show you a tutorial for Privilege & Role here.
Database
CREATE TABLE `accounts` (
`id` int(20) NOT NULL,
`firstname` varchar(200) NOT NULL,
`lastname` varchar(200) NOT NULL,
`email` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
`enabled` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `accounts2` (
`id` int(20) NOT NULL,
`firstname` varchar(200) NOT NULL,
`lastname` varchar(200) NOT NULL,
`email` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
`enabled` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adress` (
`ip_id` int(20) NOT NULL,
`name` varchar(200) NOT NULL,
`ipaddress` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `categories` (
`cat_id` int(5) NOT NULL,
`cat_name` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `check_button` (
`check` varchar(100) NOT NULL,
`id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `developers` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`skills` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `radio_button` (
`id` int(20) NOT NULL,
`radio` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `products` (
`product_id` int(5) NOT NULL,
`product_name` varchar(30) NOT NULL,
`cat_id` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`check` varchar(255) NOT NULL,
`role` varchar(100) NOT NULL,
`date` varchar(100) NOT NULL,
`product` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `accounts`
ADD PRIMARY KEY (`id`);
ALTER TABLE `accounts2`
ADD PRIMARY KEY (`id`);
ALTER TABLE `adress`
ADD PRIMARY KEY (`ip_id`);
ALTER TABLE `categories`
ADD PRIMARY KEY (`cat_id`);
ALTER TABLE `check_button`
ADD PRIMARY KEY (`id`);
ALTER TABLE `developers`
ADD PRIMARY KEY (`id`);
ALTER TABLE `radio_button`
ADD PRIMARY KEY (`id`);
ALTER TABLE `products`
ADD PRIMARY KEY (`product_id`);
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
ALTER TABLE `accounts`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
ALTER TABLE `accounts2`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `adress`
MODIFY `ip_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `categories`
MODIFY `cat_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
ALTER TABLE `check_button`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
ALTER TABLE `developers`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `radio_button`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
ALTER TABLE `products`
MODIFY `product_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
Connect (conn.php)
<?php
$server = "localhost";
$user = "root";
$password = "root";
$base = "f7_21";
$con = mysqli_connect($server, $user, $password, $base);
?>
