phpmyadmin/tests/unit/Controllers/Table/Fixtures/Sql-testSqlController.html

<div id="page_settings_modal"><div class="page_settings"><form method="post" action="index.php&#x3F;route&#x3D;&#x25;2F&amp;db&#x3D;test_db&amp;table&#x3D;test_table&amp;server&#x3D;2&amp;lang&#x3D;en" class="config-form disableAjax">
  <input type="hidden" name="tab_hash" value="">
      <input type="hidden" name="check_page_refresh" id="check_page_refresh" value="">
    <input type="hidden" name="lang" value="en"><input type="hidden" name="token" value="token">
  <input type="hidden" name="submit_save" value="Sql">

  <ul class="nav nav-tabs" id="configFormDisplayTab" role="tablist">
          <li class="nav-item" role="presentation">
        <a class="nav-link active" id="Sql_queries-tab" href="#Sql_queries" data-bs-toggle="tab" role="tab" aria-controls="Sql_queries" aria-selected="true">SQL queries</a>
      </li>
          <li class="nav-item" role="presentation">
        <a class="nav-link" id="Sql_box-tab" href="#Sql_box" data-bs-toggle="tab" role="tab" aria-controls="Sql_box" aria-selected="false">SQL Query box</a>
      </li>
      </ul>
  <div class="tab-content">
          <div class="tab-pane fade show active" id="Sql_queries" role="tabpanel" aria-labelledby="Sql_queries-tab">
        <div class="card border-top-0">
          <div class="card-body">
            <h5 class="card-title visually-hidden">SQL queries</h5>
                          <h6 class="card-subtitle mb-2 text-body-secondary">SQL queries settings.</h6>
            
            <fieldset class="optbox">
              <legend>SQL queries</legend>

                            
              <table class="table table-borderless">
                <tr>
  <th>
    <label for="ShowSQL">Show SQL queries</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_ShowSQL" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Defines whether SQL queries generated by phpMyAdmin should be displayed.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="ShowSQL" id="ShowSQL" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#ShowSQL" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="Confirm">Confirm DROP queries</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_Confirm" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Whether a warning (&quot;Are your really sure…&quot;) should be displayed when you&#039;re about to lose data.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="Confirm" id="Confirm" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#Confirm" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="QueryHistoryMax">Query history length</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_QueryHistoryMax" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>How many queries are kept in history.</small>
      </th>

  <td>
          <input type="number" name="QueryHistoryMax" id="QueryHistoryMax" value="25" class="">
    
    
    
          <a class="restore-default hide" href="#QueryHistoryMax" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="IgnoreMultiSubmitErrors">Ignore multiple statement errors</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_IgnoreMultiSubmitErrors" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>If enabled, phpMyAdmin continues computing multiple-statement queries even if one of the queries failed.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="IgnoreMultiSubmitErrors" id="IgnoreMultiSubmitErrors">
      </span>
    
    
    
          <a class="restore-default hide" href="#IgnoreMultiSubmitErrors" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="MaxCharactersInDisplayedSQL">Maximum displayed SQL length</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_MaxCharactersInDisplayedSQL" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Maximum number of characters used when a SQL query is displayed.</small>
      </th>

  <td>
          <input type="number" name="MaxCharactersInDisplayedSQL" id="MaxCharactersInDisplayedSQL" value="1000" class="">
    
    
    
          <a class="restore-default hide" href="#MaxCharactersInDisplayedSQL" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="RetainQueryBox">Retain query box</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_RetainQueryBox" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Defines whether the query box should stay on-screen after its submission.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="RetainQueryBox" id="RetainQueryBox">
      </span>
    
    
    
          <a class="restore-default hide" href="#RetainQueryBox" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="CodemirrorEnable">Enable CodeMirror</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_CodemirrorEnable" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Use user-friendly editor for editing SQL queries (CodeMirror) with syntax highlighting and line numbers.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="CodemirrorEnable" id="CodemirrorEnable" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#CodemirrorEnable" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="LintEnable">Enable linter</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_LintEnable" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Find any errors in the query before executing it. Requires CodeMirror to be enabled.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="LintEnable" id="LintEnable" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#LintEnable" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="EnableAutocompleteForTablesAndColumns">Enable autocomplete for table and column names</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_EnableAutocompleteForTablesAndColumns" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Autocomplete of the table and column names in the SQL queries.</small>
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="EnableAutocompleteForTablesAndColumns" id="EnableAutocompleteForTablesAndColumns" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#EnableAutocompleteForTablesAndColumns" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="DefaultForeignKeyChecks">Foreign key checks</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_DefaultForeignKeyChecks" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
          <small>Default value for foreign key checks checkbox for some queries.</small>
      </th>

  <td>
          <select name="DefaultForeignKeyChecks" id="DefaultForeignKeyChecks" class="w-75">
                            <option value="default" selected>Server default</option>
                            <option value="enable">Enable</option>
                            <option value="disable">Disable</option>
              </select>
    
    
    
          <a class="restore-default hide" href="#DefaultForeignKeyChecks" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>

              </table>
            </fieldset>
          </div>

                  </div>
      </div>
          <div class="tab-pane fade" id="Sql_box" role="tabpanel" aria-labelledby="Sql_box-tab">
        <div class="card border-top-0">
          <div class="card-body">
            <h5 class="card-title visually-hidden">SQL Query box</h5>
                          <h6 class="card-subtitle mb-2 text-body-secondary">Customize links shown in SQL Query boxes.</h6>
            
            <fieldset class="optbox">
              <legend>SQL Query box</legend>

                            
              <table class="table table-borderless">
                <tr>
  <th>
    <label for="SQLQuery-Edit">Edit</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_SQLQuery_Edit" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="SQLQuery-Edit" id="SQLQuery-Edit" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#SQLQuery-Edit" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="SQLQuery-Explain">Explain SQL</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_SQLQuery_Explain" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="SQLQuery-Explain" id="SQLQuery-Explain" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#SQLQuery-Explain" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="SQLQuery-ShowAsPHP">Create PHP code</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_SQLQuery_ShowAsPHP" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="SQLQuery-ShowAsPHP" id="SQLQuery-ShowAsPHP" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#SQLQuery-ShowAsPHP" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>
<tr>
  <th>
    <label for="SQLQuery-Refresh">Refresh</label>

          <span class="doc">
        <a href="index.php?route=/url&amp;url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Fconfig.html%23cfg_SQLQuery_Refresh" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
      </span>
    
    
      </th>

  <td>
          <span class="checkbox">
        <input type="checkbox" name="SQLQuery-Refresh" id="SQLQuery-Refresh" checked>
      </span>
    
    
    
          <a class="restore-default hide" href="#SQLQuery-Refresh" title="Restore default value"><img src="themes/dot.gif" title="Restore default value" alt="Restore default value" class="icon ic_s_reload"></a>
    
          </td>

  </tr>

              </table>
            </fieldset>
          </div>

                  </div>
      </div>
      </div>
</form>

<span id="configInlineParamsData"
      data-field-validators="&#x5B;&#x7B;&quot;fieldId&quot;&#x3A;&quot;QueryHistoryMax&quot;,&quot;name&quot;&#x3A;&quot;validatePositiveNumber&quot;,&quot;args&quot;&#x3A;null&#x7D;,&#x7B;&quot;fieldId&quot;&#x3A;&quot;QueryHistoryMax&quot;,&quot;name&quot;&#x3A;&quot;validateUpperBound&quot;,&quot;args&quot;&#x3A;&#x5B;25&#x5D;&#x7D;,&#x7B;&quot;fieldId&quot;&#x3A;&quot;MaxCharactersInDisplayedSQL&quot;,&quot;name&quot;&#x3A;&quot;validatePositiveNumber&quot;,&quot;args&quot;&#x3A;null&#x7D;&#x5D;"
      data-default-values="&#x7B;&quot;ShowSQL&quot;&#x3A;true,&quot;Confirm&quot;&#x3A;true,&quot;QueryHistoryMax&quot;&#x3A;&quot;25&quot;,&quot;IgnoreMultiSubmitErrors&quot;&#x3A;false,&quot;MaxCharactersInDisplayedSQL&quot;&#x3A;&quot;1000&quot;,&quot;RetainQueryBox&quot;&#x3A;false,&quot;CodemirrorEnable&quot;&#x3A;true,&quot;LintEnable&quot;&#x3A;true,&quot;EnableAutocompleteForTablesAndColumns&quot;&#x3A;true,&quot;DefaultForeignKeyChecks&quot;&#x3A;&#x5B;&quot;default&quot;&#x5D;,&quot;SQLQuery-Edit&quot;&#x3A;true,&quot;SQLQuery-Explain&quot;&#x3A;true,&quot;SQLQuery-ShowAsPHP&quot;&#x3A;true,&quot;SQLQuery-Refresh&quot;&#x3A;true&#x7D;"></span>
</div></div><form method="post" action="index.php?route=/import&server=2&lang=en" class="ajax lock-page" id="sqlqueryform" name="sqlform" enctype="multipart/form-data">
  <input type="hidden" name="db" value="test_db"><input type="hidden" name="table" value="test_table"><input type="hidden" name="server" value="2"><input type="hidden" name="lang" value="en"><input type="hidden" name="token" value="token">
  <input type="hidden" name="is_js_confirmed" value="0">
  <input type="hidden" name="pos" value="0">
  <input type="hidden" name="goto" value="index.php?route=/table/sql&amp;server=2&amp;lang=en">
  <input type="hidden" name="message_to_show" value="Your SQL query has been executed successfully.">
  <input type="hidden" name="prev_sql_query" value="SELECT * FROM `test_table` WHERE 1">

      <a id="querybox"></a>

    <div class="card mb-3">
      <div class="card-header">Run SQL query/queries on table <a href="index.php?route=/sql&server=2&lang=en&db=test_db&table=test_table&server=2&lang=en">test_db.test_table</a>: <a href="index.php?route=/url&url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Fselect.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a></div>
      <div class="card-body">
        <div id="queryfieldscontainer">
          <div class="row">
            <div class="col">
              <div class="mb-3">
                <textarea class="form-control" tabindex="100" name="sql_query" id="sqlquery" cols="40" rows="15" data-textarea-auto-select="false" aria-label="SQL query">SELECT * FROM `test_table` WHERE 1</textarea>
              </div>
              <div id="querymessage"></div>

              <div class="btn-toolbar" role="toolbar">
                                  <div class="btn-group me-2" role="group">
                    <input type="button" value="SELECT *" id="selectall" class="btn btn-secondary button sqlbutton">
                    <input type="button" value="SELECT" id="select" class="btn btn-secondary button sqlbutton">
                    <input type="button" value="INSERT" id="insert" class="btn btn-secondary button sqlbutton">
                    <input type="button" value="UPDATE" id="update" class="btn btn-secondary button sqlbutton">
                    <input type="button" value="DELETE" id="delete" class="btn btn-secondary button sqlbutton">
                  </div>
                
                <div class="btn-group me-2" role="group">
                  <input type="button" value="Clear" id="clear" class="btn btn-secondary button sqlbutton">
                                      <input type="button" value="Format" id="format" class="btn btn-secondary button sqlbutton">
                    <input type="button" value="Format as a single line" id="formatSingleLine" class="btn btn-secondary button sqlbutton">
                                  </div>

                <input type="button" value="Get auto-saved query" id="saved" class="btn btn-secondary button sqlbutton">
              </div>

              <div class="my-3">
                <div class="form-check">
                  <input class="form-check-input" type="checkbox" name="parameterized" id="parameterized">
                  <label class="form-check-label" for="parameterized">
                    Bind parameters
                    <a href="index.php?route=/url&url=https%3A%2F%2Fdocs.phpmyadmin.net%2Fen%2Flatest%2Ffaq.html%23faq6-40" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
                  </label>
                </div>
              </div>
              <div class="mb-3" id="parametersDiv"></div>
            </div>

                          <div class="col-xl-2 col-lg-3">
                <div class="mb-3">
                  <label class="visually-hidden" for="fieldsSelect">Columns</label>
                  <select class="form-select resize-vertical" id="fieldsSelect" name="dummy" size="15" multiple>
                                          <option value="`id`" title=&quot;&quot;>
                        id
                      </option>
                                          <option value="`name`" title=&quot;&quot;>
                        name
                      </option>
                                          <option value="`datetimefield`" title=&quot;&quot;>
                        datetimefield
                      </option>
                                      </select>
                </div>

                <input type="button" class="btn btn-secondary button" id="insertBtn" name="insert" value="<<" title="Insert">
              </div>
                      </div>
        </div>

              </div>
      <div class="card-footer">
        <div class="row row-cols-lg-auto g-3 align-items-center">
          <div class="col-12">
            <div class="input-group me-2">
              <span class="input-group-text">Delimiter</span>
              <label class="visually-hidden" for="id_sql_delimiter">Delimiter</label>
              <input class="form-control" type="text" name="sql_delimiter" tabindex="131" size="3" value=";" id="id_sql_delimiter">
            </div>
          </div>

          <div class="col-12">
            <div class="form-check form-check-inline">
              <input class="form-check-input" type="checkbox" name="show_query" value="1" id="checkbox_show_query" tabindex="132">
              <label class="form-check-label" for="checkbox_show_query">Show this query here again</label>
            </div>
          </div>

          <div class="col-12">
            <div class="form-check form-check-inline">
              <input class="form-check-input" type="checkbox" name="retain_query_box" value="1" id="retain_query_box" tabindex="133">
              <label class="form-check-label" for="retain_query_box">Retain query box</label>
            </div>
          </div>

          <div class="col-12">
            <div class="form-check form-check-inline">
              <input class="form-check-input" type="checkbox" name="rollback_query" value="1" id="rollback_query" tabindex="134">
              <label class="form-check-label" for="rollback_query">Rollback when finished</label>
            </div>
          </div>

          <div class="col-12">
            <div class="form-check">
              <input type="hidden" name="fk_checks" value="0">
              <input class="form-check-input" type="checkbox" name="fk_checks" id="fk_checks" value="1" checked>
              <label class="form-check-label" for="fk_checks">Enable foreign key checks</label>
            </div>
          </div>

          <div class="col-12">
            <input class="btn btn-primary ms-1" type="submit" id="button_submit_query" name="SQL" tabindex="200" value="Go">
          </div>
        </div>
      </div>
    </div>
  
  
  </form>

<div id="sqlqueryresultsouter"></div>

<div class="modal fade" id="simulateDmlModal" tabindex="-1" aria-labelledby="simulateDmlModalLabel" aria-hidden="true">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="simulateDmlModalLabel">Simulate query</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>