PHP - Cms Crud Tree/recursive Menu

Hi, I am creating my first OOP MVC content management system.

I created a CRUD where on the Tag view page, you click edit and it takes you to the Tag edit page.

But I want to improve the user experience, so when a user clicks edit, a modal window displays allowing editing of Tag, upon clicking save, modal window closes and AJAX updates Tag view page without refresh.

You can see my Tag view.html here which is using Twig template system:

{% extends "backendbase.html" %}

{% block title %}Manage Tags{% endblock %}

{% block body %}

<h1 class="ui header">View Tags</h1>

{% if tags.errors is not empty %}
<div class="ui error message">
    <p>Errors:</p>
    {% for error in tags.errors %}
    <div>{{ error }}</div>
    {% endfor %}
</div>
{% endif %}



<table class="ui striped table">
    <thead>
    <tr>
        <th>Id</th>
        <th>Tag</th>
        <th>Directory</th>
        <th>Synonyms</th>
        <th>Edit</th>
        <th>Test</th>
        <th>Delete</th>
    </tr>
    </thead>
    <tbody>
    {% for tag in tags %}
    <tr>
        <td>{{ tag.id }}</td>
        <td>{{ tag.tag }}</td>
        <td>{{ tag.tag_dir }}</td>
        <td>{{ tag.synonyms }}</td>
        <td><a class="edit" onclick="return false;" href="../edit/?edit={{ tag.id }}">Edit</a></td>
        <td><a href="../test/?test={{ tag.id }}">Test</a></td>
        <td><a href="../delete/?delete={{ tag.id }}">Delete</a></td>
    </tr>
    {% endfor %}
    </tbody>
</table>

<div class="ui modal">
    <i class="close icon"></i>
    <div class="header">
        Edit Tag
    </div>
    <div class="image content">
        <!--<div class="ui medium image"></div>-->
        <div class="description">
            <!--
            <div class="ui header">We've auto-chosen a profile image for you.</div>
            <p>We've grabbed the following image from the <a href="https://www.gravatar.com" target="_blank">gravatar</a> image associated with your registered e-mail address.</p>
            <p>Is it okay to use this photo?</p>
            -->

        </div>
    </div>
    <div class="actions">
        <div class="ui black deny button">
            Cancel
        </div>
        <div class="ui positive right labeled icon button">
            Save
            <i class="checkmark icon"></i>
        </div>
    </div>
</div>

<div class="ui divider"></div>

<div class="ui pagination menu">
    {% for page in pages %}
    <a href="{{ page.number|e }}" class="{{ page.isactive|e }}">{{ page.number|e }}</a>
    {% endfor %}
</div>

{% endblock %}

If I add a form in the modal window with {{ tag.id }} and {{ tag.name }}, nothing displays obviously because it is not in the for in loop.  My question is, what is the industry standard way of getting data into this modal window form?  I could use a $_GET["id"] but then I am breaking MVC model by including code in template.  Is the solution to use JavaScript to get ID from edit link, in the background get data from database then use JavaScript to create form in modal?

Your help would be much appreciated!

Hello I need a great help for my problem, I tried to insert multiple checkboxs for "$_POST active" in my CRUD and the values must be saved in the database but will be saved as "Array" everytime.
I used this code but where exactly I need to put it?

foreach($_POST['active'] as $act){//query? }

Here the PHP code

<?php
require_once "../lakota/config.php";

if ($_SERVER["REQUEST_METHOD"] == "POST") {

    if (isset($_POST['faction'], $_POST['stations'], $_POST["active"], $_POST['pending'], $_POST['influence'], $_POST['id_fact'])) {
    
    if(isset($_POST["submit"])){
	$activearr=$_POST["active"];
	$newvalues=  implode(",", $activearr);
	include_once "../lakota/checkboxClass.php";
	$checkBoxClass=new checkboxClass();
	echo $checkBoxClass->addtoDatabase($newvalues);
}
    
        $sql = "INSERT INTO lakotabgs (faction, stations, active, pending, influence, id_fact) VALUES (?,?,?,?,?,?)";
        
        if ($stmt = $link->prepare($sql)) {
            $stmt->bind_param("ssssss", $_POST['faction'], $_POST['stations'], $_POST["active"], $_POST['pending'], $_POST['influence'], $_POST['id_fact']);
            
            if ($stmt->execute()) {
                header("location: ../lakota/index.php");
                exit();
            } else {
                echo "Error! Try again later.";
            }
            $stmt->close();
        }
    }

    $link->close();
}
?>

HTML code

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Add new info</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
          integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
                    
  			<form action="<?php echo $_SERVER["PHP_SELF"] ?>" method="post">                   
                        <label><b>Active States</b></label>
                        <input name="active[]" class="form-control" id="example1" type="checkbox" value="None"  />
                        <label for="example1">None</label>
                        <input name="active[]" class="form-control" id="example2" type="checkbox" value="Everybody"  />
                        <label for="example2">Everybody</label>
                        <input name="active[]" class="form-control" id="example3" type="checkbox" value="Unknown"  />
                        <label for="example3">Unknown</label>
                    <input type="submit" id="submit" name="submit" class="btn btn-primary" value="Add new info">
                    <a href="../lakota/index.php" class="btn btn-default">Back</a>
                </form>
</body>
</html>

if(isset($_POST['action']))

    {                        

        $functionSelected = $_POST["action"];

    }



if(isset($functionSelected)){

    switch($functionSelected){

        case "insert":

            $initialize_flag = "N";

            // Store POST(ed) user-entered values into memory variables

            $store_name = $_POST['store_name'];    

            $item_description = $_POST['item_description'];    

            $qty_pkg = $_POST['qty_pkg'];    

            $pkg_of = $_POST['pkg_of'];    

            $price = $_POST['price'];    

            $flyer_page = $_POST['flyer_page'];    

            $limited_time_sale = $_POST['limited_time_sale'];    

            $flyer_date_start = $_POST['flyer_date_start'];    

            $nos_to_purchase = $_POST['nos_to_purchase'];    

                                    

            // Setup customized query

            $sql = "INSERT INTO shoplist

                        (store_name, item_description, qty_pkg, pkg_of, price, flyer_page, limited_time_sale, flyer_date_start, nos_to_purchase, shopper1_buy_flag, shopper2_buy_flag, purchased_flag, purchase_later_flag)

                    VALUES

                        (:store_name, :item_description, :qty_pkg, :pkg_of, :price, :flyer_page, :limited_time_sale, :flyer_date_start, :nos_to_purchase, :shopper1_buy_flag, :shopper2_buy_flag, :purchased_flag, :purchase_later_flag)";



            try {

                $statement = $conn->prepare($sql);

                                    

                $statement->bindParam(':store_name', $store_name);

                $statement->bindParam(':item_description', $item_description);

                $statement->bindParam(':qty_pkg', $qty_pkg);

                $statement->bindParam(':pkg_of', $pkg_of);

                $statement->bindParam(':price', $price);

                $statement->bindParam(':flyer_page', $flyer_page);

                $statement->bindParam(':limited_time_sale', $limited_time_sale);

                $statement->bindParam(':flyer_date_start', $flyer_date_start);

                $statement->bindParam(':nos_to_purchase', $nos_to_purchase);

                $statement->bindParam(':shopper1_buy_flag', $initialize_flag);

                $statement->bindParam(':shopper2_buy_flag', $initialize_flag);

                $statement->bindParam(':purchased_flag', $initialize_flag);

                $statement->bindParam(':purchase_later_flag', $initialize_flag);                                        



                // Execute the query

                $statement->execute();                            

                $statement->closeCursor();

                $functionSelected = "";     // WILL THIS STATEMENT NOT SERVE TO INITIALIZE/RESET THE OPERATION???

                break;

            } catch (PDOException $e) {

                print "Error!: " . $e->getMessage() . "<br/>";

            }

        case "update-delete":    

            ...

            ...

            ...

<?php

require 'vendor/autoload.php';

$client = new Elasticsearch/Client();

$root = realpath('~/elkdata/for_elk_test_2014_11_24/Agencies');

$iter = new RecursiveIteratorIterator(
		new RecursiveDirectoryIterator($root, RecursiveDirectoryIterator::SKIP_DOTS),
		RecursiveIteratorIterator::SELF_FIRST,
		RecursiveIteratorIterator::CATCH_GET_CHILD);
		
$paths = array($root);
foreach ($iter as $path => $dir) {
	if ($dir -> isDir()) {
		$paths[] = $path;
		}
	}

//Create the index and mappings
$mapping['index'] = 'rvuehistoricaldocuments2009-2013'; //mapping code
$mapping['body'] = array (
	'mappings' => array (
		'documents' => array (
			'_source' => array (
				'enabled' => true
			),
			'properties' => array(
				'doc_name' => array(
					'type' => 'string',
					'analyzer' => 'standard'
				),
				'description' => array(
					'type' => 'string'
				)
			)
		)
	)
);

$client ->indices()->create($mapping)


//Now index the documents

for ($i = 0; $i <= count($paths); $i++) {
	$params ['body'][] = array(
		'index' => array(
		'type' => 'documents'
		'body' => array(
			'foo' => 'bar' //Document body goes here
			
			)
		)
	);
	
	//Every 1000 documents stop and send the bulk request.
	
	if($1 % 1000) {
		$responses = $client->bulk($params);
	
	// erase the old bulk request
	$params = array();
	
	// unset the bulk response when you are done to save memory
	unset($responses);
	}
}
?>