Put submission from input field into SQL query after LIKE
<p>How can I access the value the user submits in the input field at the top and place it in the code after "LIKE" in the SQL query? My code works with the given value, 9999, but I want that value to instead be whatever the user enters into the input field.</p>

<pre><code>&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;body&gt;

Enter Tracking Code: &lt;input type="text"&gt;
&lt;input type="button" value="Submit"&gt;

&lt;table id="switch-hitters" class="table table-condensed table-striped"&gt;&lt;/table&gt;

&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-sheetrock/1.0.1/dist/sheetrock.min.js"&gt;&lt;/script&gt;

&lt;script&gt;

var mySpreadsheet = 'https://docs.google.com/spreadsheets/d/1_1elTo5zH1ew6KPYwoWtixX9hzFc8oxdRy5A0LWFkwg/edit#gid=0';
$('#switch-hitters').sheetrock({
    url: mySpreadsheet,
    query: "select A,B,C,D,E where A like 9999"
});


&lt;/script&gt;

&lt;/body&gt;
&lt;/html&gt;
</code></pre>

<hr>

<p>Updated code:</p>

<pre><code>&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;body&gt;

Enter Tracking Code: &lt;input type="text" id="textbox_id"&gt;
&lt;input type="button" value="Submit"&gt;

&lt;table id="switch-hitters" class="table table-condensed table-striped"&lt;/table&gt;

&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"&gt;&lt;/script&gt;
&lt;script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-sheetrock/1.0.1/dist/sheetrock.min.js"&gt;&lt;/script&gt;

&lt;script&gt;

var mySpreadsheet = 'https://docs.google.com/spreadsheets/d/1_1elTo5zH1ew6KPYwoWtixX9hzFc8oxdRy5A0LWFkwg/edit#gid=0';
var elem =  document.getElementById('textbox_id').value;
$('#switch-hitters').sheetrock({
    url: mySpreadsheet,
    query: "select A,B,C,D,E where A like "+elem
});
</code></pre>

<p></p>

<p>
</p>