From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../table/browse_foreigners/column_element.twig    |  12 +
 .../table/browse_foreigners/show_all.twig          |   5 +
 .../templates/table/chart/tbl_chart.twig           | 159 +++++++
 .../table/gis_visualization/gis_visualization.twig |  80 ++++
 srcs/phpmyadmin/templates/table/index_form.twig    | 223 +++++++++
 .../table/insert/continue_insertion_form.twig      |  19 +
 .../templates/table/operations/view.twig           |  31 ++
 .../templates/table/page_with_secondary_tabs.twig  |  22 +
 .../templates/table/relation/common_form.twig      | 223 +++++++++
 .../table/relation/dropdown_generate.twig          |   9 +
 .../templates/table/relation/foreign_key_row.twig  | 136 ++++++
 .../table/relation/relational_dropdown.twig        |  18 +
 .../table/search/column_comparison_operators.twig  |   3 +
 .../templates/table/search/fields_table.twig       |  33 ++
 .../templates/table/search/form_tag.twig           |   4 +
 .../templates/table/search/geom_func.twig          |  19 +
 .../templates/table/search/input_box.twig          |  97 ++++
 .../templates/table/search/replace_preview.twig    |  39 ++
 .../templates/table/search/rows_normal.twig        |  39 ++
 .../templates/table/search/rows_zoom.twig          |  74 +++
 .../templates/table/search/selection_form.twig     | 226 +++++++++
 .../templates/table/search/zoom_result_form.twig   |  86 ++++
 .../structure/action_row_in_structure_table.twig   |  31 ++
 .../table/structure/display_partitions.twig        | 145 ++++++
 .../table/structure/display_structure.twig         | 516 +++++++++++++++++++++
 .../table/structure/display_table_stats.twig       | 169 +++++++
 .../table/structure/partition_definition_form.twig |  14 +
 srcs/phpmyadmin/templates/table/tracking/main.twig | 132 ++++++
 .../templates/table/tracking/report_table.twig     |  27 ++
 .../table/tracking/structure_snapshot_columns.twig |  56 +++
 .../table/tracking/structure_snapshot_indexes.twig |  33 ++
 31 files changed, 2680 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig
 create mode 100644 srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig
 create mode 100644 srcs/phpmyadmin/templates/table/chart/tbl_chart.twig
 create mode 100644 srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig
 create mode 100644 srcs/phpmyadmin/templates/table/index_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/operations/view.twig
 create mode 100644 srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig
 create mode 100644 srcs/phpmyadmin/templates/table/relation/common_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig
 create mode 100644 srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig
 create mode 100644 srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/fields_table.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/form_tag.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/geom_func.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/input_box.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/replace_preview.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/rows_normal.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/rows_zoom.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/selection_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/search/zoom_result_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig
 create mode 100644 srcs/phpmyadmin/templates/table/structure/display_partitions.twig
 create mode 100644 srcs/phpmyadmin/templates/table/structure/display_structure.twig
 create mode 100644 srcs/phpmyadmin/templates/table/structure/display_table_stats.twig
 create mode 100644 srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig
 create mode 100644 srcs/phpmyadmin/templates/table/tracking/main.twig
 create mode 100644 srcs/phpmyadmin/templates/table/tracking/report_table.twig
 create mode 100644 srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig
 create mode 100644 srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig

(limited to 'srcs/phpmyadmin/templates/table')

diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig
new file mode 100644
index 0000000..f2ec2ba
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig
@@ -0,0 +1,12 @@
+<td{{ nowrap ? ' class="nowrap"' }}>
+    {{ is_selected ? '<strong>' }}
+        <a class="foreign_value" data-key="{{ keyname }}" href="#" title="
+            {%- trans 'Use this value' %}{{ title is not empty ? ': ' ~ title }}">
+            {% if nowrap %}
+                {{ keyname }}
+            {% else %}
+                {{ description }}
+            {% endif %}
+        </a>
+    {{ is_selected ? '</strong>' }}
+</td>
diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig
new file mode 100644
index 0000000..4de9b81
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig
@@ -0,0 +1,5 @@
+{% if foreign_data.disp_row is iterable and
+    (show_all and foreign_data.the_total > max_rows) %}
+    <input class="btn btn-secondary" type="submit" id="foreign_showAll" name="foreign_showAll" value="
+        {%- trans 'Show all' %}">
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig b/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig
new file mode 100644
index 0000000..4201599
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig
@@ -0,0 +1,159 @@
+<script type="text/javascript">
+    url_query = '{{ url_query }}';
+</script>
+{# Display Chart options #}
+<div id="div_view_options">
+    <form method="post" id="tblchartform" action="tbl_chart.php" class="ajax">
+        {{ get_hidden_inputs(url_params) }}
+        <fieldset>
+            <legend>
+                {% trans 'Display chart' %}
+            </legend>
+            <div class="chartOption">
+                <div class="formelement">
+                    <input type="radio" name="chartType" value="bar" id="radio_bar">
+                    <label for ="radio_bar">{% trans %}Bar{% context %}Chart type{% endtrans %}</label>
+                </div>
+                <div class="formelement">
+                    <input type="radio" name="chartType" value="column" id="radio_column">
+                    <label for ="radio_column">{% trans %}Column{% context %}Chart type{% endtrans %}</label>
+                </div>
+                <div class="formelement">
+                    <input type="radio" name="chartType" value="line" id="radio_line" checked="checked">
+                    <label for ="radio_line">{% trans %}Line{% context %}Chart type{% endtrans %}</label>
+                </div>
+                <div class="formelement">
+                    <input type="radio" name="chartType" value="spline" id="radio_spline">
+                    <label for ="radio_spline">{% trans %}Spline{% context %}Chart type{% endtrans %}</label>
+                </div>
+                <div class="formelement">
+                    <input type="radio" name="chartType" value="area" id="radio_area">
+                    <label for ="radio_area">{% trans %}Area{% context %}Chart type{% endtrans %}</label>
+                </div>
+                <span class="span_pie hide">
+                    <input type="radio" name="chartType" value="pie" id="radio_pie">
+                    <label for ="radio_pie">{% trans %}Pie{% context %}Chart type{% endtrans %}</label>
+                </span>
+                <span class="span_timeline hide">
+                    <input type="radio" name="chartType" value="timeline" id="radio_timeline">
+                    <label for ="radio_timeline">{% trans %}Timeline{% context %}Chart type{% endtrans %}</label>
+                </span>
+                <span class="span_scatter hide">
+                <input type="radio" name="chartType" value="scatter" id="radio_scatter">
+                <label for ="radio_scatter">{% trans %}Scatter{% context %}Chart type{% endtrans %}</label>
+                </span>
+                <br><br>
+                <span class="barStacked hide">
+                    <input type="checkbox" name="barStacked" value="1" id="checkbox_barStacked">
+                    <label for ="checkbox_barStacked">{% trans 'Stacked' %}</label>
+                </span>
+                <br><br>
+                <label for ="chartTitle">{% trans 'Chart title:' %}</label>
+                <input type="text" name="chartTitle" id="chartTitle">
+            </div>
+            {% set xaxis = null %}
+            <div class="chartOption">
+                <label for="select_chartXAxis">{% trans 'X-Axis:' %}</label>
+                <select name="chartXAxis" id="select_chartXAxis">
+                    {% for idx, key in keys %}
+                        {% if xaxis is same as(null) %}
+                            {% set xaxis = idx %}
+                        {% endif %}
+                        {% if xaxis is same as(idx) %}
+                            <option value="{{ idx }}" selected="selected">{{ key }}</option>
+                        {% else %}
+                            <option value="{{ idx }}">{{ key }}</option>
+                        {% endif %}
+                    {% endfor %}
+                </select>
+                <br>
+                <label for="select_chartSeries">
+                    {% trans 'Series:' %}
+                </label>
+                <select name="chartSeries" id="select_chartSeries" multiple="multiple">
+                    {% for idx, key in keys %}
+                        {% if fields_meta[idx].type in numeric_types %}
+                            {% if idx == xaxis and numeric_column_count > 1 %}
+                                <option value="{{ idx }}">{{ key }}</option>
+                            {% else %}
+                                <option value="{{ idx }}" selected="selected">{{ key }}</option>
+                            {% endif %}
+                        {% endif %}
+                    {% endfor %}
+                </select>
+                <input type="hidden" name="dateTimeCols" value="
+                    {% set date_time_types = ['date', 'datetime', 'timestamp'] %}
+                    {% for idx, key in keys %}
+                        {% if fields_meta[idx].type in date_time_types %}
+                            {{ idx ~ ' ' }}
+                        {% endif %}
+                    {% endfor %}">
+                <input type="hidden" name="numericCols" value="
+                    {% for idx, key in keys %}
+                        {% if fields_meta[idx].type in numeric_types %}
+                            {{ idx ~ ' ' }}
+                        {% endif %}
+                    {% endfor %}">
+            </div>
+            <div class="chartOption">
+                <label for="xaxis_panel">
+                    {% trans 'X-Axis label:' %}
+                </label>
+                <input style="margin-top:0;" type="text" name="xaxis_label" id="xaxis_label" value="{{ xaxis == -1 ? 'X Values'|trans : keys[xaxis] }}">
+                <br>
+                <label for="yaxis_label">
+                    {% trans 'Y-Axis label:' %}
+                </label>
+                <input type="text" name="yaxis_label" id="yaxis_label" value="{% trans 'Y Values' %}">
+                <br>
+            </div>
+            <div class="clearfloat"></div>
+            <div>
+                <input type="checkbox" id="chkAlternative" name="chkAlternative" value="alternativeFormat">
+                <label for="chkAlternative">{% trans 'Series names are in a column' %}</label>
+                <br>
+                <label for="select_seriesColumn">
+                    {% trans 'Series column:' %}
+                </label>
+                <select name="chartSeriesColumn" id="select_seriesColumn" disabled>
+                    {% for idx, key in keys %}
+                        <option value="{{ idx }}"
+                            {% if idx == 1 %}
+                                selected="selected"
+                            {% endif %}>
+                                {{ key }}
+                        </option>
+                        {% set series_column = idx %}
+                    {% endfor %}
+                </select>
+                <label for="select_valueColumn">
+                    {% trans 'Value Column:' %}
+                </label>
+                <select name="chartValueColumn" id="select_valueColumn" disabled>
+                    {% set selected = false %}
+                    {% for idx, key in keys %}
+                        {% if fields_meta[idx].type in numeric_types %}
+                            {% if not selected and idx != xaxis and idx != series_column %}
+                                <option value="{{ idx }}" selected="selected">{{ key }}</option>
+                                {% set selected = true %}
+                            {% else %}
+                                <option value="{{ idx }}">{{ key }}</option>
+                            {% endif %}
+                        {% endif %}
+                    {% endfor %}
+                </select>
+            </div>
+            {{ get_start_and_number_of_rows_panel(sql_query) }}
+            <div class="clearfloat"></div>
+            <div id="resizer" style="width:600px; height:400px;">
+                <div style="position: absolute; right: 10px; top: 10px; cursor: pointer; z-index: 1000;">
+                    <a class="disableAjax" id="saveChart" href="#" download="chart.png">
+                        {{ get_image('b_saveimage', 'Save chart as image'|trans) }}
+                    </a>
+                </div>
+                <div id="querychart" dir="ltr">
+                </div>
+            </div>
+        </fieldset>
+    </form>
+</div>
diff --git a/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig b/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig
new file mode 100644
index 0000000..9e82e2e
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig
@@ -0,0 +1,80 @@
+<div id="div_view_options">
+    <fieldset>
+        <legend>{% trans 'Display GIS Visualization' %}</legend>
+        <div id="gis_div" style="position:relative;">
+            <form method="post" action="tbl_gis_visualization.php">
+                {{ get_hidden_inputs(url_params) }}
+                <label for="labelColumn">
+                    {% trans "Label column" %}
+                </label>
+                <select name="visualizationSettings[labelColumn]" id="labelColumn" class="autosubmit">
+                    <option value="">{% trans "-- None --" %}</option>
+                    {% for value in label_candidates %}
+                        <option value="{{ value }}"{{ value == visualization_settings['labelColumn'] ? ' selected="selected"' }}>
+                            {{ value }}
+                        </option>
+                    {% endfor %}
+                </select>
+                <label for="spatialColumn">
+                    {% trans "Spatial column" %}
+                </label>
+                <select name="visualizationSettings[spatialColumn]" id="spatialColumn" class="autosubmit">
+                    {% for value in spatial_candidates %}
+                        <option value="{{ value }}"{{ value == visualization_settings['spatialColumn'] ? ' selected="selected"' }}>
+                            {{ value }}
+                        </option>
+                    {% endfor %}
+                </select>
+                <input type="hidden" name="displayVisualization" value="redraw">
+                    <tr>
+                        <td class="choice" colspan="2">
+                            <input type="checkbox"
+                                   name="visualizationSettings[choice]"
+                                   id="choice" value="useBaseLayer"
+                                   {% if visualization_settings['choice'] is defined %}
+                                        checked="checked"
+                                   {% endif %}>
+                            <label for="choice" id="labelChoice">
+                                {% trans "Use OpenStreetMaps as Base Layer" %}
+                            </label>
+                        </td>
+                    </tr>
+                {{ get_start_and_number_of_rows_panel(sql_query) }}
+            </form>
+
+            <div class="pma_quick_warp" style="width: 50px; position: absolute; right: 0; top: 0; cursor: pointer;">
+                <div class="drop_list">
+                    <span class="drop_button" style="padding: 0; border: 0;">
+                        {{ get_image('b_saveimage', 'Save'|trans) }}
+                    </span>
+                    <ul>
+                        <li class="warp_link">
+                            <a href="{{ download_url|raw }}&fileFormat=png" class="disableAjax">PNG</a>
+                        </li>
+                        <li class="warp_link">
+                            <a href="{{ download_url|raw }}&fileFormat=pdf" class="disableAjax">PDF</a>
+                        </li>
+                        <li class="warp_link">
+                            <a href="{{ download_url|raw }}&fileFormat=svg" class="disableAjax">SVG</a>
+                        </li>
+                    </ul>
+                </div>
+            </div>
+        </div>
+
+        <div class="clearfloat"></div>
+
+        <div id="placeholder"
+             style="width:{{ visualization_settings['width'] }}px;height:{{ visualization_settings['height'] }}px;">
+            {{ visualization|raw }}
+        </div>
+        <div id="openlayersmap"></div>
+        <input type="hidden" id="pmaThemeImage" value="{{ pma_theme_image }}">
+        <script language="javascript" type="text/javascript">
+            function drawOpenLayers()
+            {
+                {{ draw_ol|raw }}
+            }
+        </script>
+    </fieldset>
+</div>
diff --git a/srcs/phpmyadmin/templates/table/index_form.twig b/srcs/phpmyadmin/templates/table/index_form.twig
new file mode 100644
index 0000000..6364599
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/index_form.twig
@@ -0,0 +1,223 @@
+<form action="tbl_indexes.php"
+    method="post"
+    name="index_frm"
+    id="index_frm"
+    class="ajax">
+
+    {{ get_hidden_inputs(form_params) }}
+
+    <fieldset id="index_edit_fields">
+        <div class="index_info">
+            <div>
+                <div class="label">
+                    <strong>
+                        <label for="input_index_name">
+                            {% trans 'Index name:' %}
+                            {{ show_hint('"PRIMARY" <b>must</b> be the name of and <b>only of</b> a primary key!'|trans) }}
+                        </label>
+                    </strong>
+                </div>
+
+                <input type="text"
+                    name="index[Key_name]"
+                    id="input_index_name"
+                    size="25"
+                    maxlength="64"
+                    value="{{ index.getName() }}"
+                    onfocus="this.select()">
+            </div>
+
+            <div>
+                <div class="label">
+                    <strong>
+                        <label for="select_index_choice">
+                            {% trans 'Index choice:' %}
+                            {{ show_mysql_docu('ALTER_TABLE') }}
+                        </label>
+                    </strong>
+                </div>
+                {{ index.generateIndexChoiceSelector(create_edit_table)|raw }}
+            </div>
+
+            {% include 'div_for_slider_effect.twig' with {
+                'id': 'indexoptions',
+                'message': 'Advanced Options'|trans,
+                'initial_sliders_state': default_sliders_state
+            } only %}
+
+            <div>
+                <div class="label">
+                    <strong>
+                        <label for="input_key_block_size">
+                            {% trans 'Key block size:' %}
+                        </label>
+                    </strong>
+                </div>
+
+                <input type="text"
+                    name="index[Key_block_size]"
+                    id="input_key_block_size"
+                    size="30"
+                    value="{{ index.getKeyBlockSize() }}">
+            </div>
+
+            <div>
+
+                <div class="label">
+                    <strong>
+                        <label for="select_index_type">
+                            {% trans 'Index type:' %}
+                            {{ show_mysql_docu('ALTER_TABLE') }}
+                        </label>
+                    </strong>
+                </div>
+                {{ index.generateIndexTypeSelector()|raw }}
+            </div>
+
+            <div>
+                <div class="label">
+                    <strong>
+                        <label for="input_parser">
+                            {% trans 'Parser:' %}
+                        </label>
+                    </strong>
+                </div>
+
+                <input type="text"
+                    name="index[Parser]"
+                    id="input_parse"
+                    size="30"
+                    value="{{ index.getParser() }}">
+            </div>
+
+            <div>
+                <div class="label">
+                    <strong>
+                        <label for="input_index_comment">
+                            {% trans 'Comment:' %}
+                        </label>
+                    </strong>
+                </div>
+
+                <input type="text"
+                    name="index[Index_comment]"
+                    id="input_index_comment"
+                    size="30"
+                    maxlength="1024"
+                    value="{{ index.getComment() }}">
+            </div>
+        </div>
+        <!-- end of indexoptions div -->
+
+        <div class="clearfloat"></div>
+
+        <table id="index_columns">
+            <thead>
+                <tr>
+                    <th></th>
+                    <th>
+                        {% trans 'Column' %}
+                    </th>
+                    <th>
+                        {% trans 'Size' %}
+                    </th>
+                </tr>
+            </thead>
+            {% set spatial_types = [
+                'geometry',
+                'point',
+                'linestring',
+                'polygon',
+                'multipoint',
+                'multilinestring',
+                'multipolygon',
+                'geomtrycollection'
+            ] %}
+            <tbody>
+                {% for column in index.getColumns() %}
+                    <tr class="noclick">
+                        <td>
+                            <span class="drag_icon" title="{% trans 'Drag to reorder' %}"></span>
+                        </td>
+                        <td>
+                            <select name="index[columns][names][]">
+                                <option value="">
+                                    -- {% trans 'Ignore' %} --
+                                </option>
+                                {% for field_name, field_type in fields %}
+                                    {% if (index.getChoice() != 'FULLTEXT'
+                                            or field_type matches '/(char|text)/i')
+                                        and (index.getChoice() != 'SPATIAL'
+                                            or field_type in spatial_types) %}
+
+                                        <option value="{{ field_name }}"
+                                            {%- if field_name == column.getName() %}
+                                                selected="selected"
+                                            {%- endif %}>
+                                            {{ field_name }} [{{ field_type }}]
+                                        </option>
+                                    {% endif %}
+                                {% endfor %}
+                            </select>
+                        </td>
+                        <td>
+                            <input type="text"
+                                size="5"
+                                onfocus="this.select()"
+                                name="index[columns][sub_parts][]"
+                                value="{{ index.getChoice() != 'SPATIAL' ?
+                                    column.getSubPart() }}">
+                        </td>
+                    </tr>
+                {% endfor %}
+                {% if add_fields > 0 %}
+                    {% for i in range(1, add_fields) %}
+                        <tr class="noclick">
+                            <td>
+                                <span class="drag_icon" title="{% trans 'Drag to reorder' %}"></span>
+                            </td>
+                            <td>
+                                <select name="index[columns][names][]">
+                                    <option value="">-- {% trans 'Ignore' %} --</option>
+                                    {% set j = 0 %}
+                                    {% for field_name, field_type in fields %}
+                                        {% if create_edit_table %}
+                                            {% set col_index = field_type[1] %}
+                                            {% set field_type = field_type[0] %}
+                                        {% endif %}
+                                        {% set j = j + 1 %}
+                                        <option value="{{ col_index is defined ?
+                                            col_index : field_name }}"
+                                            {{- j == i ? ' selected="selected"' }}>
+                                            {{ field_name }} [{{ field_type }}]
+                                        </option>
+                                    {% endfor %}
+                                </select>
+                            </td>
+                            <td>
+                                <input type="text"
+                                    size="5"
+                                    onfocus="this.select()"
+                                    name="index[columns][sub_parts][]"
+                                    value="">
+                            </td>
+                        </tr>
+                    {% endfor %}
+                {% endif %}
+            </tbody>
+        </table>
+        <div class="add_more">
+
+            <div class="slider"></div>
+            <div class="add_fields hide">
+                <input class="btn btn-secondary" type="submit"
+                    id="add_fields"
+                    value="{{ 'Add %s column(s) to index'|trans|format(1) }}">
+            </div>
+        </div>
+    </fieldset>
+    <fieldset class="tblFooters">
+        <button class="btn btn-secondary" type="submit" id="preview_index_frm">{% trans 'Preview SQL' %}</button>
+        <input class="btn btn-primary" type="submit" id="save_index_frm" value="{% trans 'Go' %}">
+    </fieldset>
+</form>
diff --git a/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig b/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig
new file mode 100644
index 0000000..86a8215
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig
@@ -0,0 +1,19 @@
+<form id="continueForm" method="post" action="tbl_replace.php" name="continueForm">
+    {{ get_hidden_inputs(db, table) }}
+    <input type="hidden" name="goto" value="{{ goto }}">
+    <input type="hidden" name="err_url" value="{{ err_url }}">
+    <input type="hidden" name="sql_query" value="{{ sql_query }}">
+
+    {% if has_where_clause %}
+        {% for key_id, where_clause in where_clause_array %}
+            <input type="hidden" name="where_clause[{{ key_id }}]" value="
+                {{- where_clause|trim }}">
+        {% endfor %}
+    {% endif %}
+
+    {% set insert_rows %}
+        <input type="number" name="insert_rows" id="insert_rows" value="
+            {{- insert_rows_default }}" min="1">
+    {% endset %}
+    {{ 'Continue insertion with %s rows'|trans|format(insert_rows)|raw }}
+</form>
diff --git a/srcs/phpmyadmin/templates/table/operations/view.twig b/srcs/phpmyadmin/templates/table/operations/view.twig
new file mode 100644
index 0000000..e590532
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/operations/view.twig
@@ -0,0 +1,31 @@
+<!-- VIEW operations -->
+<div>
+    <form method="post" action="view_operations.php">
+        {{ get_hidden_inputs(db, table) }}
+        <input type="hidden" name="reload" value="1">
+        <fieldset>
+            <legend>{% trans 'Operations' %}</legend>
+            <table>
+                <!-- Change view name -->
+                <tr>
+                    <td>{% trans 'Rename view to' %}</td>
+                    <td><input type="text" name="new_name" onfocus="this.select()"
+                               value="{{ table }}"
+                               required>
+                    </td>
+                </tr>
+            </table>
+        </fieldset>
+        <fieldset class="tblFooters">
+            <input type="hidden" name="submitoptions" value="1">
+            <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}">
+        </fieldset>
+    </form>
+</div>
+
+<div>
+    <fieldset class="caution">
+        <legend>{% trans 'Delete data or table' %}</legend>
+        <ul>{{ delete_data_or_table_link | raw }}</ul>
+    </fieldset>
+</div>
diff --git a/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig b/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig
new file mode 100644
index 0000000..2aae85a
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig
@@ -0,0 +1,22 @@
+{% if cfg_relation['relwork'] or is_foreign_key_supported %}
+    <ul id="topmenu2">
+        {{ get_html_tab({
+            'icon': 'b_props',
+            'link': 'tbl_structure.php',
+            'text': 'Table structure'|trans,
+            'id': 'table_strucuture_id'
+        }, url_params) }}
+        {{ get_html_tab({
+            'icon': 'b_relations',
+            'link': 'tbl_relation.php',
+            'text': 'Relation view'|trans,
+            'id': 'table_relation_id'
+        }, url_params) }}
+    </ul>
+    <div class="clearfloat"></div>
+{% endif %}
+
+<div id="structure_content">
+    {% block content %}
+    {% endblock %}
+</div>
diff --git a/srcs/phpmyadmin/templates/table/relation/common_form.twig b/srcs/phpmyadmin/templates/table/relation/common_form.twig
new file mode 100644
index 0000000..e85c6ce
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/relation/common_form.twig
@@ -0,0 +1,223 @@
+{% extends 'table/page_with_secondary_tabs.twig' %}
+
+{% block content %}
+<form method="post" action="tbl_relation.php">
+    {{ get_hidden_inputs(db, table) }}
+    {# InnoDB #}
+    {% if is_foreign_key_supported(tbl_storage_engine) %}
+        <fieldset>
+            <legend>{% trans 'Foreign key constraints' %}</legend>
+            <div class="responsivetable jsresponsive">
+            <table id="foreign_keys" class="relationalTable">
+                <thead><tr>
+                    <th>{% trans 'Actions' %}</th>
+                    <th>{% trans 'Constraint properties' %}</th>
+                    {% if tbl_storage_engine|upper == 'INNODB' %}
+                        <th>
+                            {% trans 'Column' %}
+                            {{ show_hint('Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.'|trans) }}
+                        </th>
+                    {% else %}
+                        <th>
+                            {% trans 'Column' %}
+                            {{ show_hint('Only columns with index will be displayed. You can define an index below.'|trans) }}
+                        </th>
+                    {% endif %}
+                    <th colspan="3">
+                        {% trans 'Foreign key constraint' %}
+                        ({{ tbl_storage_engine }})
+                    </th>
+                </tr>
+                <tr>
+                    <th></th>
+                    <th></th>
+                    <th></th>
+                    <th>{% trans 'Database' %}</th>
+                    <th>{% trans 'Table' %}</th>
+                    <th>{% trans 'Column' %}</th>
+                </tr></thead>
+                {% set i = 0 %}
+                {% if existrel_foreign is not empty %}
+                    {% for key, one_key in existrel_foreign %}
+                        {# Foreign database dropdown #}
+                        {% set foreign_db = one_key['ref_db_name'] is defined
+                            and one_key['ref_db_name'] is not null
+                            ? one_key['ref_db_name'] : db %}
+                        {% set foreign_table = false %}
+                        {% if foreign_db %}
+                            {% set foreign_table = one_key['ref_table_name'] is defined
+                                and one_key['ref_table_name'] is not null
+                                ? one_key['ref_table_name'] : false %}
+                        {% endif %}
+                        {% set unique_columns = [] %}
+                        {% if foreign_db and foreign_table %}
+                            {% set table_obj = table_get(foreign_table, foreign_db) %}
+                            {% set unique_columns = table_obj.getUniqueColumns(false, false) %}
+                        {% endif %}
+                        {% include 'table/relation/foreign_key_row.twig' with {
+                            'i': i,
+                            'one_key': one_key,
+                            'column_array': column_array,
+                            'options_array': options_array,
+                            'tbl_storage_engine': tbl_storage_engine,
+                            'db': db,
+                            'table': table,
+                            'url_params': url_params,
+                            'databases': databases,
+                            'foreign_db': foreign_db,
+                            'foreign_table': foreign_table,
+                            'unique_columns': unique_columns
+                        } only %}
+                        {% set i = i + 1 %}
+                    {% endfor %}
+                {% endif %}
+                {% include 'table/relation/foreign_key_row.twig' with {
+                    'i': i,
+                    'one_key': [],
+                    'column_array': column_array,
+                    'options_array': options_array,
+                    'tbl_storage_engine': tbl_storage_engine,
+                    'db': db,
+                    'table': table,
+                    'url_params': url_params,
+                    'databases': databases,
+                    'foreign_db': foreign_db,
+                    'foreign_table': foreign_table,
+                    'unique_columns': unique_columns
+                } only %}
+                {% set i = i + 1 %}
+                <tr>
+                    <th colspan="6">
+                        <a class="formelement clearfloat add_foreign_key" href="">
+                            {% trans '+ Add constraint' %}
+                        </a>
+                    </th>
+                </tr>
+            </table>
+            </div>
+        </fieldset>
+    {% endif %}
+
+    {% if cfg_relation['relwork'] %}
+        {% if is_foreign_key_supported(tbl_storage_engine) %}
+            {% include 'div_for_slider_effect.twig' with {
+                'id': 'ir_div',
+                'message': 'Internal relationships'|trans,
+                'initial_sliders_state': default_sliders_state
+            } only %}
+        {% endif %}
+
+        <fieldset>
+            <legend>
+                {% trans 'Internal relationships' %}
+                {{ show_docu('config', 'cfg_Servers_relation') }}
+            </legend>
+            <table id="internal_relations" class="relationalTable">
+                <tr>
+                    <th>{% trans 'Column' %}</th>
+                    <th>{% trans 'Internal relation' %}
+                        {% if is_foreign_key_supported(tbl_storage_engine) %}
+                            {{ show_hint('An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.'|trans) }}
+                        {% endif %}
+                    </th>
+                    {% set saved_row_cnt = save_row|length - 1 %}
+                    {% for i in 0..saved_row_cnt %}
+                        {% set myfield = save_row[i]['Field'] %}
+                        {# Use an md5 as array index to avoid having special characters
+                           in the name attribute (see bug #1746964 ) #}
+                        {% set myfield_md5 = column_hash_array[myfield] %}
+
+                        {% set foreign_table = false %}
+                        {% set foreign_column = false %}
+
+                        {# Database dropdown #}
+                        {% if existrel[myfield] is defined %}
+                            {% set foreign_db = existrel[myfield]['foreign_db'] %}
+                        {% else %}
+                            {% set foreign_db = db %}
+                        {% endif %}
+
+                        {# Table dropdown #}
+                        {% set tables = [] %}
+                        {% if foreign_db %}
+                            {% if existrel[myfield] is defined %}
+                                {% set foreign_table = existrel[myfield]['foreign_table'] %}
+                            {% endif %}
+                            {% set tables = dbi.getTables(foreign_db) %}
+                        {% endif %}
+
+                        {# Column dropdown #}
+                        {% set unique_columns = [] %}
+                        {% if foreign_db and foreign_table %}
+                            {% if existrel[myfield] is defined %}
+                                {% set foreign_column = existrel[myfield]['foreign_field'] %}
+                            {% endif %}
+                            {% set table_obj = table_get(foreign_table, foreign_db) %}
+                            {% set unique_columns = table_obj.getUniqueColumns(false, false) %}
+                        {% endif %}
+
+                        <tr>
+                            <td class="vmiddle">
+                                <strong>{{ myfield }}</strong>
+                                <input type="hidden" name="fields_name[{{ myfield_md5 }}]"
+                                    value="{{ myfield }}">
+                            </td>
+
+                            <td>
+                                {% include 'table/relation/relational_dropdown.twig' with {
+                                    'name': 'destination_db[' ~ myfield_md5 ~ ']',
+                                    'title': 'Database'|trans,
+                                    'values': databases,
+                                    'foreign': foreign_db
+                                } only %}
+
+                                {% include 'table/relation/relational_dropdown.twig' with {
+                                    'name': 'destination_table[' ~ myfield_md5 ~ ']',
+                                    'title': 'Table'|trans,
+                                    'values': tables,
+                                    'foreign': foreign_table
+                                } only %}
+
+                                {% include 'table/relation/relational_dropdown.twig' with {
+                                    'name': 'destination_column[' ~ myfield_md5 ~ ']',
+                                    'title': 'Column'|trans,
+                                    'values': unique_columns,
+                                    'foreign': foreign_column
+                                } only %}
+                            </td>
+                        </tr>
+                    {% endfor %}
+            </table>
+        </fieldset>
+        {% if is_foreign_key_supported(tbl_storage_engine) %}
+            </div>
+        {% endif %}
+    {% endif %}
+
+    {% if cfg_relation['displaywork'] %}
+        {% set disp = get_display_field(db, table) %}
+        <fieldset>
+            <label>{% trans 'Choose column to display:' %}</label>
+            <select name="display_field">
+                <option value="">---</option>
+                {% for row in save_row %}
+                    <option value="{{ row['Field'] }}"
+                        {%- if disp is defined and row['Field'] == disp %}
+                            selected="selected"
+                        {%- endif %}>
+                        {{ row['Field'] }}
+                    </option>
+                {% endfor %}
+            </select>
+        </fieldset>
+    {% endif %}
+
+    <fieldset class="tblFooters">
+        <input class="btn btn-secondary preview_sql" type="button" value="{% trans 'Preview SQL' %}">
+        <input class="btn btn-primary" type="submit" value="{% trans 'Save' %}">
+    </fieldset>
+</form>
+{% if foreignKeySupported %}
+    {{ displayIndexesHtml|raw }}
+{% endif %}
+{% endblock %}
diff --git a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig b/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig
new file mode 100644
index 0000000..ff179bc
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig
@@ -0,0 +1,9 @@
+{{ dropdown_question is not empty ? dropdown_question -}}
+<select name="{{ select_name }}">
+{% for one_value, one_label in choices %}
+    <option value="{{ one_value }}"
+        {%- if selected_value == one_value %} selected="selected"{% endif %}>
+        {{ one_label }}
+    </option>
+{% endfor %}
+</select>
diff --git a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig b/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig
new file mode 100644
index 0000000..3df6c34
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig
@@ -0,0 +1,136 @@
+<tr>
+    {# Drop key anchor #}
+    <td>
+        {% set js_msg = '' %}
+        {% set this_params = null %}
+        {% if one_key['constraint'] is defined %}
+            {% set drop_fk_query = 'ALTER TABLE ' ~ backquote(db) ~ '.' ~ backquote(table)
+                ~ ' DROP FOREIGN KEY '
+                ~ backquote(one_key['constraint']) ~ ';'
+            %}
+            {% set this_params = url_params %}
+            {% set this_params = {
+                'goto': 'tbl_relation.php',
+                'back': 'tbl_relation.php',
+                'sql_query': drop_fk_query,
+                'message_to_show': 'Foreign key constraint %s has been dropped'|trans|format(
+                    one_key['constraint']
+                )
+            } %}
+            {% set js_msg = 'ALTER TABLE ' ~ db ~ '.' ~ table ~ ' DROP FOREIGN KEY ' ~ one_key['constraint'] ~ ';'|js_format %}
+        {% endif %}
+        {% if one_key['constraint'] is defined %}
+            <input type="hidden" class="drop_foreign_key_msg" value="
+                {{- js_msg }}">
+            {% set drop_url = 'sql.php' ~ get_common(this_params) %}
+            {% set drop_str = get_icon('b_drop', 'Drop'|trans) %}
+            {{ link_or_button(drop_url, drop_str, {'class': 'drop_foreign_key_anchor ajax'}) }}
+        {% endif %}
+    </td>
+    <td>
+        <span class="formelement clearfloat">
+            <input type="text" name="constraint_name[{{ i }}]" value="
+                {{- one_key['constraint'] is defined ? one_key['constraint'] -}}
+                " placeholder="{% trans 'Constraint name' %}" maxlength="64">
+        </span>
+        <div class="floatleft">
+            {# For ON DELETE and ON UPDATE, the default action
+               is RESTRICT as per MySQL doc; however, a SHOW CREATE TABLE
+               won't display the clause if it's set as RESTRICT. #}
+            {% set on_delete = one_key['on_delete'] is defined
+                ? one_key['on_delete'] : 'RESTRICT' %}
+            {% set on_update = one_key['on_update'] is defined
+                ? one_key['on_update'] : 'RESTRICT' %}
+            <span class="formelement">
+                {% include 'table/relation/dropdown_generate.twig' with {
+                    'dropdown_question': 'ON DELETE',
+                    'select_name': 'on_delete[' ~ i ~ ']',
+                    'choices': options_array,
+                    'selected_value': on_delete
+                } only %}
+            </span>
+            <span class="formelement">
+                {% include 'table/relation/dropdown_generate.twig' with {
+                    'dropdown_question': 'ON UPDATE',
+                    'select_name': 'on_update[' ~ i ~ ']',
+                    'choices': options_array,
+                    'selected_value': on_update
+                } only %}
+            </span>
+        </div>
+    </td>
+    <td>
+        {% if one_key['index_list'] is defined %}
+            {% for key, column in one_key['index_list'] %}
+                <span class="formelement clearfloat">
+                    {% include 'table/relation/dropdown_generate.twig' with {
+                        'dropdown_question': '',
+                        'select_name': 'foreign_key_fields_name[' ~ i ~ '][]',
+                        'choices': column_array,
+                        'selected_value': column
+                    } only %}
+                </span>
+            {% endfor %}
+        {% else %}
+            <span class="formelement clearfloat">
+                {% include 'table/relation/dropdown_generate.twig' with {
+                    'dropdown_question': '',
+                    'select_name': 'foreign_key_fields_name[' ~ i ~ '][]',
+                    'choices': column_array,
+                    'selected_value': ''
+                } only %}
+            </span>
+        {% endif %}
+        <a class="formelement clearfloat add_foreign_key_field" data-index="
+            {{- i }}" href="">
+            {% trans '+ Add column' %}
+        </a>
+    </td>
+    {% set tables = [] %}
+    {% if foreign_db %}
+        {% set tables = get_tables(foreign_db, tbl_storage_engine) %}
+    {% endif %}
+    <td>
+        <span class="formelement clearfloat">
+            {% include 'table/relation/relational_dropdown.twig' with {
+                'name': 'destination_foreign_db[' ~ i ~ ']',
+                'title': 'Database'|trans,
+                'values': databases,
+                'foreign': foreign_db
+            } only %}
+        </span>
+    </td>
+    <td>
+        <span class="formelement clearfloat">
+            {% include 'table/relation/relational_dropdown.twig' with {
+                'name': 'destination_foreign_table[' ~ i ~ ']',
+                'title': 'Table'|trans,
+                'values': tables,
+                'foreign': foreign_table
+            } only %}
+        </span>
+    </td>
+    <td>
+        {% if foreign_db and foreign_table %}
+            {% for foreign_column in one_key['ref_index_list'] %}
+                <span class="formelement clearfloat">
+                    {% include 'table/relation/relational_dropdown.twig' with {
+                        'name': 'destination_foreign_column[' ~ i ~ '][]',
+                        'title': 'Column'|trans,
+                        'values': unique_columns,
+                        'foreign': foreign_column
+                    } only %}
+                </span>
+            {% endfor %}
+        {% else %}
+            <span class="formelement clearfloat">
+                {% include 'table/relation/relational_dropdown.twig' with {
+                    'name': 'destination_foreign_column[' ~ i ~ '][]',
+                    'title': 'Column'|trans,
+                    'values': [],
+                    'foreign': ''
+                } only %}
+            </span>
+        {% endif %}
+    </td>
+</tr>
diff --git a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig b/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig
new file mode 100644
index 0000000..9d5f3c9
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig
@@ -0,0 +1,18 @@
+<select name="{{ name }}" title="{{ title }}">
+    <option value=""></option>
+    {% set seen_key = false %}
+    {% for value in values %}
+        <option value="{{ value }}"
+            {%- if foreign is not same as(false) and value == foreign %}
+                selected="selected"
+                {%- set seen_key = true -%}
+            {%- endif %}>
+            {{ value }}
+        </option>
+    {% endfor %}
+    {% if foreign is not same as(false) and not seen_key %}
+        <option value="{{ foreign }}" selected="selected">
+            {{ foreign }}
+        </option>
+    {% endif %}
+</select>
diff --git a/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig b/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig
new file mode 100644
index 0000000..b72e530
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig
@@ -0,0 +1,3 @@
+<select id="ColumnOperator{{ search_index }}" name="criteriaColumnOperators[{{ search_index }}]">
+    {{ type_operators|raw }}
+</select>
diff --git a/srcs/phpmyadmin/templates/table/search/fields_table.twig b/srcs/phpmyadmin/templates/table/search/fields_table.twig
new file mode 100644
index 0000000..8b74939
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/fields_table.twig
@@ -0,0 +1,33 @@
+<table class="data"{{ search_type == 'zoom' ? ' id="tableFieldsId"' }}>
+    <thead>
+        <tr>
+            {% if geom_column_flag %}
+                <th>{% trans 'Function' %}</th>
+            {% endif %}
+            <th>{% trans 'Column' %}</th>
+            <th>{% trans 'Type' %}</th>
+            <th>{% trans 'Collation' %}</th>
+            <th>{% trans 'Operator' %}</th>
+            <th>{% trans 'Value' %}</th>
+        </tr>
+    </thead>
+    <tbody>
+    {% if search_type == 'zoom' %}
+        {% include 'table/search/rows_zoom.twig' with {
+            'self': self,
+            'column_names': column_names,
+            'keys': keys,
+            'criteria_column_names': criteria_column_names,
+            'criteria_column_types': criteria_column_types
+        } only %}
+    {% else %}
+        {% include 'table/search/rows_normal.twig' with {
+            'self': self,
+            'geom_column_flag': geom_column_flag,
+            'column_names': column_names,
+            'column_types': column_types,
+            'column_collations': column_collations
+        } only %}
+    {% endif %}
+    </tbody>
+</table>
diff --git a/srcs/phpmyadmin/templates/table/search/form_tag.twig b/srcs/phpmyadmin/templates/table/search/form_tag.twig
new file mode 100644
index 0000000..1017abd
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/form_tag.twig
@@ -0,0 +1,4 @@
+<form method="post" action="{{ script_name }}" name="insertForm" id="{{ form_id }}" class="ajax lock-page">
+    {{ get_hidden_inputs(db, table) }}
+    <input type="hidden" name="goto" value="{{ goto }}">
+    <input type="hidden" name="back" value="{{ script_name }}">
diff --git a/srcs/phpmyadmin/templates/table/search/geom_func.twig b/srcs/phpmyadmin/templates/table/search/geom_func.twig
new file mode 100644
index 0000000..f7a7415
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/geom_func.twig
@@ -0,0 +1,19 @@
+{# Displays 'Function' column if it is present #}
+<td>
+    {% set geom_types = get_gis_datatypes() %}
+    {% if column_types[column_index] in geom_types %}
+        <select class="geom_func" name="geom_func[{{ column_index }}]">
+            {# get the relevant list of GIS functions #}
+            {% set funcs = get_gis_functions(column_types[column_index], true, true) %}
+
+            {% for func_name, func in funcs %}
+                {% set name = func['display'] is defined ? func['display'] : func_name %}
+                <option value="{{ name }}">
+                    {{ name }}
+                </option>
+            {% endfor %}
+        </select>
+    {% else %}
+        &nbsp;
+    {% endif %}
+</td>
diff --git a/srcs/phpmyadmin/templates/table/search/input_box.twig b/srcs/phpmyadmin/templates/table/search/input_box.twig
new file mode 100644
index 0000000..5c30535
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/input_box.twig
@@ -0,0 +1,97 @@
+{# Get inputbox based on different column types (Foreign key, geometrical, enum) #}
+{% if foreigners and search_column_in_foreigners(foreigners, column_name) %}
+    {% if foreign_data['disp_row'] is iterable %}
+        <select name="criteriaValues[{{ column_index }}]"
+            id="{{ column_id }}{{ column_index }}">
+            {{ foreign_dropdown(
+                foreign_data['disp_row'],
+                foreign_data['foreign_field'],
+                foreign_data['foreign_display'],
+                '',
+                foreign_max_limit
+            ) }}
+        </select>
+    {% elseif foreign_data['foreign_link'] == true %}
+        <input type="text"
+            id="{{ column_id }}{{ column_index }}"
+            name="criteriaValues[{{ column_index }}]"
+            id="field_{{ column_name_hash }}[{{ column_index }}]"
+            class="textfield"
+            {% if criteria_values[column_index] is defined %}
+                value="{{ criteria_values[column_index] }}"
+            {% endif %}>
+        <a class="ajax browse_foreign" href="browse_foreigners.php" data-post="
+            {{- get_common({'db': db, 'table': table}, '') -}}
+            &amp;field={{ column_name|url_encode }}&amp;fieldkey=
+            {{- column_index }}&amp;fromsearch=1">
+            {{ titles['Browse']|replace({"'": "\\'"})|raw }}
+        </a>
+    {% endif %}
+{% elseif column_type in get_gis_datatypes() %}
+    <input type="text"
+        name="criteriaValues[{{ column_index }}]"
+        size="40"
+        class="textfield"
+        id="field_{{ column_index }}">
+    {% if in_fbs %}
+        {% set edit_url = 'gis_data_editor.php' ~ get_common() %}
+        {% set edit_str = get_icon('b_edit', 'Edit/Insert'|trans) %}
+        <span class="open_search_gis_editor">
+            {{ link_or_button(edit_url, edit_str, [], '_blank') }}
+        </span>
+    {% endif %}
+{% elseif column_type starts with 'enum'
+    or (column_type starts with 'set' and in_zoom_search_edit) %}
+    {% set in_zoom_search_edit = false %}
+    {% set value = column_type|e|slice(5, -1)|replace({'&#039;': ''})|split(', ') %}
+    {% set cnt_value = value|length %}
+    {#
+    Enum in edit mode   --> dropdown
+    Enum in search mode --> multiselect
+    Set in edit mode    --> multiselect
+    Set in search mode  --> input (skipped here, so the 'else' section would handle it)
+    #}
+    {% if (column_type starts with 'enum' and not in_zoom_search_edit)
+        or (column_type starts with 'set' and in_zoom_search_edit) %}
+        <select name="criteriaValues[{{ column_index }}]"
+            id="{{ column_id }}{{ column_index }}">
+    {% else %}
+        <select name="criteriaValues[{{ column_index }}]"
+            id="{{ column_id }}{{ column_index }}"
+            multiple="multiple"
+            size="{{ min(3, cnt_value) }}">
+    {% endif %}
+    {# Add select options #}
+    <option value=""></option>
+    {% for i in 0..cnt_value - 1 %}
+        {% if criteria_values[column_index] is defined
+            and criteria_values[column_index] is iterable
+            and value[i] in criteria_values[column_index] %}
+            <option value="{{ value[i]|raw }}" selected>
+                {{ value[i]|raw }}
+            </option>
+        {% else %}
+            <option value="{{ value[i]|raw }}">
+                {{ value[i]|raw }}
+            </option>
+        {% endif %}
+    {% endfor %}
+    </select>
+{% else %}
+    {% set the_class = 'textfield' %}
+    {% if column_type == 'date' %}
+        {% set the_class = the_class ~ ' datefield' %}
+    {% elseif column_type == 'datetime' or column_type starts with 'timestamp' %}
+        {% set the_class = the_class ~ ' datetimefield' %}
+    {% elseif column_type starts with 'bit' %}
+        {% set the_class = the_class ~ ' bit' %}
+    {% endif %}
+    <input type="text"
+        name="criteriaValues[{{ column_index }}]"
+        size="40"
+        class="{{ the_class }}"
+        id="{{ column_id }}{{ column_index }}"
+        {% if criteria_values[column_index] is defined %}
+           value="{{ criteria_values[column_index] }}"
+        {%- endif %}>
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/table/search/replace_preview.twig b/srcs/phpmyadmin/templates/table/search/replace_preview.twig
new file mode 100644
index 0000000..e7a2423
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/replace_preview.twig
@@ -0,0 +1,39 @@
+<form method="post"
+      action="tbl_find_replace.php"
+      name="previewForm"
+      id="previewForm">
+    {{ get_hidden_inputs(db, table) }}
+    <input type="hidden" name="replace" value="true">
+    <input type="hidden" name="columnIndex" value="{{ column_index }}">
+    <input type="hidden" name="findString" value="{{ find }}">
+    <input type="hidden" name="replaceWith" value="{{ replace_with }}">
+    <input type="hidden" name="useRegex" value="{{ use_regex }}">
+
+    <fieldset id="fieldset_find_replace_preview">
+        <legend>{% trans 'Find and replace - preview' %}</legend>
+        <table id="previewTable">
+            <thead>
+            <tr>
+                <th>{% trans 'Count' %}</th>
+                <th>{% trans 'Original string' %}</th>
+                <th>{% trans 'Replaced string' %}</th>
+            </tr>
+            </thead>
+            <tbody>
+            {% if result is iterable %}
+                {% for row in result %}
+                    <tr>
+                        <td class="right">{{ row[2] }}</td>{# count #}
+                        <td>{{ row[0] }}</td>{# original #}
+                        <td>{{ row[1] }}</td>{# replaced #}
+                    </tr>
+                {% endfor %}
+            {% endif %}
+            </tbody>
+        </table>
+    </fieldset>
+
+    <fieldset class="tblFooters">
+        <input class="btn btn-secondary" type="submit" name="replace" value="{% trans 'Replace' %}">
+    </fieldset>
+</form>
diff --git a/srcs/phpmyadmin/templates/table/search/rows_normal.twig b/srcs/phpmyadmin/templates/table/search/rows_normal.twig
new file mode 100644
index 0000000..5e21efa
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/rows_normal.twig
@@ -0,0 +1,39 @@
+{% for column_index in 0..column_names|length - 1 %}
+    <tr class="noclick">
+        {# If 'Function' column is present trying to change comment #}
+        {% if geom_column_flag %}
+            {% include 'table/search/geom_func.twig' with {
+                'column_index': column_index,
+                'column_types': column_types
+            } only %}
+        {% endif %}
+        {# Displays column's name, type, collation and value #}
+        <th>
+            {{ column_names[column_index] }}
+        </th>
+        {% set properties = self.getColumnProperties(column_index, column_index) %}
+        <td dir="ltr">
+            {{ properties['type'] }}
+        </td>
+        <td>
+            {{ properties['collation'] }}
+        </td>
+        <td>
+            {{ properties['func']|raw }}
+        </td>
+        {# here, the data-type attribute is needed for a date/time picker #}
+        <td data-type="{{ properties['type'] }}">
+            {{ properties['value']|raw }}
+            {# Displays hidden fields #}
+            <input type="hidden"
+                name="criteriaColumnNames[{{ column_index }}]"
+                value="{{ column_names[column_index] }}">
+            <input type="hidden"
+                name="criteriaColumnTypes[{{ column_index }}]"
+                value="{{ column_types[column_index] }}">
+            <input type="hidden"
+                name="criteriaColumnCollations[{{ column_index }}]"
+                value="{{ column_collations[column_index] }}">
+        </td>
+    </tr>
+{% endfor %}
diff --git a/srcs/phpmyadmin/templates/table/search/rows_zoom.twig b/srcs/phpmyadmin/templates/table/search/rows_zoom.twig
new file mode 100644
index 0000000..dc46f1d
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/rows_zoom.twig
@@ -0,0 +1,74 @@
+{# Get already set search criteria (if any) #}
+{% set type = [] %}
+{% set collation = [] %}
+{% set func = [] %}
+{% set value = [] %}
+
+{% for i in 0..3 %}
+    {# After X-Axis and Y-Axis column rows, display additional criteria option #}
+    {% if i == 2 %}
+        <tr>
+            <td>
+                {% trans 'Additional search criteria' %}
+            </td>
+        </tr>
+    {% endif %}
+    <tr class="noclick">
+        <th>
+            <select name="criteriaColumnNames[]" id="tableid_{{ i }}" >
+                <option value="pma_null">
+                    {% trans 'None' %}
+                </option>
+                {% for j in 0..column_names|length - 1 %}
+                    {% if criteria_column_names[i] is defined
+                        and criteria_column_names[i] == column_names[j] %}
+                        <option value="{{ column_names[j] }}" selected="selected">
+                            {{ column_names[j] }}
+                        </option>
+                    {% else %}
+                        <option value="{{ column_names[j] }}">
+                            {{ column_names[j] }}
+                        </option>
+                    {% endif %}
+                {% endfor %}
+            </select>
+        </th>
+        {% if criteria_column_names[i] is defined
+            and criteria_column_names[i] != 'pma_null' %}
+            {% set key = keys[criteria_column_names[i]] %}
+            {% set properties = self.getColumnProperties(i, key) %}
+            {% set type = type|merge({i: properties['type']}) %}
+            {% set collation = collation|merge({i: properties['collation']}) %}
+            {% set func = func|merge({i: properties['func']}) %}
+            {% set value = value|merge({i: properties['value']}) %}
+        {% endif %}
+        {# Column type #}
+        <td dir="ltr">
+            {{ type[i] is defined ? type[i] }}
+        </td>
+        {# Column Collation #}
+        <td>
+            {{ collation[i] is defined ? collation[i] }}
+        </td>
+        {# Select options for column operators #}
+        <td>
+            {{ func[i] is defined ? func[i]|raw }}
+        </td>
+        {# Inputbox for search criteria value #}
+        <td>
+        </td>
+        <td>
+            {{ value[i] is defined ? value[i]|raw }}
+            {# Displays hidden fields #}
+            <input type="hidden"
+                name="criteriaColumnTypes[{{ i }}]"
+                id="types_{{ i }}"
+                {%- if criteria_column_types[i] is defined %}
+                    value="{{ criteria_column_types[i] }}"
+                {%- endif %}>
+            <input type="hidden"
+                name="criteriaColumnCollations[{{ i }}]"
+                id="collations_{{ i }}">
+        </td>
+    </tr>
+{% endfor %}
diff --git a/srcs/phpmyadmin/templates/table/search/selection_form.twig b/srcs/phpmyadmin/templates/table/search/selection_form.twig
new file mode 100644
index 0000000..2ba4d60
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/search/selection_form.twig
@@ -0,0 +1,226 @@
+{% if search_type == 'zoom' %}
+    {%