title: How to translate this SQL query to DB::getInstance() class?
body: <p>Prestashop 1.6.0.13
  Theme: Panda 1.1.1 (Themeforest)</p>
  
  <p>I'm trying to develop a web that change the prices in real time.</p>
  
  <p>This is the process:</p>
  
  <p>After the web is loaded, this jquery is executed.</p>
  
  <pre><code>     $('#divId').load('../../price.php');
      setInterval(function(){
          $('#divId').load('../../price.php');
  }, 3600); 
  </code></pre>
  
  <p>That call this price.php</p>
  
  <pre><code>&lt;?php
  $data = file_get_contents("https://gold-feed.com/paid/38940e/all_metals_json_eur.php");
  $obj = json_decode($data, true);
  $a = $obj['gold_ask_eur_toz'];
  echo $a."    ".time();
  
  /*
  $name = 10;
  Db::getInstance()-&gt;insert('ps_54z_product_shop', array(
      'price'      =&gt; pSQL($name),
  ));
  */
  ?&gt; 
  </code></pre>
  
  <p>The first part calls a JSON file which contains the live prices. 
  I know that this bit works. </p>
  
  <p>The las bit doesn't work for me. The SQL query in MySQL</p>
  
  <pre><code>UPDATE `ps_54z_product_shop` SET `price`= 10 
  </code></pre>
  
  <p>Works perfectly.</p>
  
  <p>How I can do to translate this query</p>
  
  <pre><code>UPDATE `ps_54z_product_shop` SET `price`= 10
  </code></pre>
  
  <p>to Db::getInstance() and put it in a php file?</p>