title: How i get variable value saved in database?
body: <p>i had save data in mysql data base and i had create template html tags in one column. now i want to display template data in php, but its not working.</p>
  
  <p>MYSQL DATABASE IMAGE CLICK HEAR TO SHOW DATABASE
  <a href="https://i.stack.imgur.com/OU0ql.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OU0ql.png" alt="enter image description here"></a></p>
  
  <p>Controller </p>
  
  <pre><code>class Project extends CI_Controller{
  
      function template(){
          $query = $this-db-&gt;query("select * from templete where id='11' ");
          $result = $query-&gt;result_array();
          $data['result'] = $result[0];
  
          $this-&gt;load-&gt;view('template_view',$data);
      }
  }
  </code></pre>
  
  <p>View</p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;&lt;/head&gt;
  &lt;body&gt;
  &lt;?php
      extract($result);
  
      echo $template_data;
  ?&gt;
  &lt;/body&gt;
  &lt;/html&gt; 
  </code></pre>
  
  <p>Output : </p>
  
  <pre><code>{$ticker}
  {$address1}
  {$address2}
  {$city}
  {$phone}
  {$website}
  </code></pre>
  
  <p>I want output</p>
  
  <pre><code>HSPG.OL
  SparebankgÃƒÂ¥rden
  BjÃƒÂ¸rkelangen
  http://www.hsbank.no
  </code></pre>
  
  <p>template data dyanamic 
  its gone be </p>
  
  <pre><code>&lt;p&gt;{$ticker}&lt;/p&gt;&lt;p&gt;{$address1}&lt;/p&gt;&lt;p&gt;{$address2}&lt;/p&gt;&lt;p&gt;{$city}&lt;/p&gt;&lt;p&gt;{$phone}&lt;/p&gt;&lt;p&gt;{$website}&lt;/p&gt;
  </code></pre>
  
  <p>or  </p>
  
  <pre><code>&lt;p&gt;{$ticker}&lt;/p&gt;&lt;p&gt;{$address1}&lt;/p&gt;&lt;p&gt;{$address2}&lt;/p&gt;&lt;p&gt;{$city}&lt;/p&gt;
  </code></pre>
  
  <p>any one help, i am post this question 2nd time with full coding.</p>