1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

//First Add this to extend jQuery

    $.extend({
      getUrlVars: function(){
        var vars = [], hash;
        var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
        for(var i = 0; i < hashes.length; i++)
        {
          hash = hashes[i].split('=');
          vars.push(hash[0]);
          vars[hash[0]] = hash[1];
        }
        return vars;
      },
      getUrlVar: function(name){
        return $.getUrlVars()[name];
      }
    });

    //Second call with this:
    // Get object of URL parameters
    var allVars = $.getUrlVars();

    // Getting URL var by its name
    var byName = $.getUrlVar('name');

<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>//First Add this to extend jQuery </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a> $.extend({ </span><span id="L-4"><a name="L-4"></a> getUrlVars: function(){ </span><span id="L-5"><a name="L-5"></a> var vars = [], hash; </span><span id="L-6"><a name="L-6"></a> var hashes = window.location.href.slice(window.location.href.indexOf(&#39;?&#39;) + 1).split(&#39;&amp;&#39;); </span><span id="L-7"><a name="L-7"></a> for(var i = 0; i &lt; hashes.length; i++) </span><span id="L-8"><a name="L-8"></a> { </span><span id="L-9"><a name="L-9"></a> hash = hashes[i].split(&#39;=&#39;); </span><span id="L-10"><a name="L-10"></a> vars.push(hash[0]); </span><span id="L-11"><a name="L-11"></a> vars[hash[0]] = hash[1]; </span><span id="L-12"><a name="L-12"></a> } </span><span id="L-13"><a name="L-13"></a> return vars; </span><span id="L-14"><a name="L-14"></a> }, </span><span id="L-15"><a name="L-15"></a> getUrlVar: function(name){ </span><span id="L-16"><a name="L-16"></a> return $.getUrlVars()[name]; </span><span id="L-17"><a name="L-17"></a> } </span><span id="L-18"><a name="L-18"></a> }); </span><span id="L-19"><a name="L-19"></a> </span><span id="L-20"><a name="L-20"></a> //Second call with this: </span><span id="L-21"><a name="L-21"></a> // Get object of URL parameters </span><span id="L-22"><a name="L-22"></a> var allVars = $.getUrlVars(); </span><span id="L-23"><a name="L-23"></a> </span><span id="L-24"><a name="L-24"></a> // Getting URL var by its name </span><span id="L-25"><a name="L-25"></a> var byName = $.getUrlVar(&#39;name&#39;); </span></pre></div> </td></tr></table>

1
2
3
4
5
6
7
8

input[type="number"]::-webkit-outer-spin-button,
input[type="number"]::-webkit-inner-spin-button {
   -webkit-appearance: none;
   margin: 0;
}
input[type="number"] {
   -moz-appearance: textfield;
}

<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>input[type=&quot;number&quot;]::-webkit-outer-spin-button, </span><span id="L-2"><a name="L-2"></a>input[type=&quot;number&quot;]::-webkit-inner-spin-button { </span><span id="L-3"><a name="L-3"></a> -webkit-appearance: none; </span><span id="L-4"><a name="L-4"></a> margin: 0; </span><span id="L-5"><a name="L-5"></a>} </span><span id="L-6"><a name="L-6"></a>input[type=&quot;number&quot;] { </span><span id="L-7"><a name="L-7"></a> -moz-appearance: textfield; </span><span id="L-8"><a name="L-8"></a>} </span></pre></div> </td></tr></table>

1
2
3
4
5
6
7
8
9

-- Drop the constraint if it exists
set @var=if((SELECT true FROM information_schema.TABLE_CONSTRAINTS WHERE
   CONSTRAINT_SCHEMA = DATABASE() AND
   TABLE_NAME        = 'bluebookfacts' AND
   CONSTRAINT_NAME   = 'fk_bb_log_facts' AND
   CONSTRAINT_TYPE   = 'FOREIGN KEY') = true,'ALTER TABLE bluebook DROP FOREIGN KEY fk_bb_log_facts', 'select 1');
prepare stmt from @var;
execute stmt;
deallocate prepare stmt;

<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a> <a href="#L-9">9</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>-- Drop the constraint if it exists </span><span id="L-2"><a name="L-2"></a>set @var=if((SELECT true FROM information_schema.TABLE_CONSTRAINTS WHERE </span><span id="L-3"><a name="L-3"></a> CONSTRAINT_SCHEMA = DATABASE() AND </span><span id="L-4"><a name="L-4"></a> TABLE_NAME = &#39;bluebookfacts&#39; AND </span><span id="L-5"><a name="L-5"></a> CONSTRAINT_NAME = &#39;fk_bb_log_facts&#39; AND </span><span id="L-6"><a name="L-6"></a> CONSTRAINT_TYPE = &#39;FOREIGN KEY&#39;) = true,&#39;ALTER TABLE bluebook DROP FOREIGN KEY fk_bb_log_facts&#39;, &#39;select 1&#39;); </span><span id="L-7"><a name="L-7"></a>prepare stmt from @var; </span><span id="L-8"><a name="L-8"></a>execute stmt; </span><span id="L-9"><a name="L-9"></a>deallocate prepare stmt; </span></pre></div> </td></tr></table>