<div>
Assuming your model performs the query, it just returns the resulting set using json_encode to the controller. This one encapsulates the result into something like $data[&quot;json_result&quot;] and pass it to the view wich then will echoes it. If you can post some code I'll probably cane give you a better help.
</div>

<div>
Okay this is an example of the query I want to run: 
 

<pre><code class="code-1 nolinks" id="code-20-42050870-1">SELECT * FROM (`userorderdetails`) WHERE `detail_userid` = '13' AND `detail_refnum` = '11' AND `detail_userid` = '13' OR `detail_jobnumber` = '11' AND `detail_userid` = '13' OR `detail_custref` = '11' AND `detail_userid` = '13' ORDER BY `detail_pickupdate` desc
</code></pre>
 
and I need the results for this Jquery Autocomplete call: 
 

<pre><code class="code-10 nolinks" id="code-20-42050870-2">$(&quot;button&quot;).click(function(){
 var searchValue=$( &quot;#search_quotes&quot; ).val();
 $.post(&quot;search_invoice_auto.php&quot;,
 {
 name: 'searchValue' 
 },
 function(data, status){
 alert(&quot;Data: &quot; + data + &quot;\nStatus: &quot; + status);
 });
});
</code></pre>
 
and here what my NON WORKING USERS model looks like: 
 

<pre><code class="code-10 nolinks" id="code-20-42050870-3">	
 $id = $_SESSION['userId'];

 $this-&gt;load-&gt;database();
 	$this-&gt;db-&gt;where('detail_userid', $id);

 $search_string = $_POST['searchValue']; // IS THIS RIGHT? ARE WE GETTING THIS FROM AJAX?
 	
 	$this-&gt;db-&gt;where('detail_refnum', $search)-&gt;where('detail_userid', $id);
 	$this-&gt;db-&gt;or_where('detail_jobnumber', $search)-&gt;where('detail_userid', $id);
 	$this-&gt;db-&gt;or_where('detail_custref', $search)-&gt;where('detail_userid', $id);

 // NEED TO QUERY AND RETURN JSON RESULTS
</code></pre>
 
Thank you.
</div>

<div>
To this comment...
<blockquote>
// IS THIS RIGHT? ARE WE GETTING THIS FROM AJAX?
</blockquote>
PHP has a built-in function (and sometimes frameworks wrap this function in another function) that displays the contents of variables. &nbsp;You can use <a href="http://php.net/manual/en/function.var-dump.php" rel="ugc">var_dump($_POST)</a> to see what you are getting from the jQuery AJAX <a href="https://api.jquery.com/jquery.post/" rel="ugc">$.post()</a> request. 
 
In <a href="https://laravel.com/" rel="ugc">Laravel</a>, which seems to have supplanted CodeIgniter for all new development over the past few years, there is the handy <a href="https://laravel.com/docs/5.4/helpers#method-dd" rel="ugc">dd()</a> method.
</div>

<div>
For this you will have to download and install CURL library for codeigniter first. <a href="https://www.cloudways.com/blog/codeigniter-json-curl/" rel="ugc">Codeigniter CURL</a> can be downloaded from github repo and then can be loaded using following command: 
 

<pre><code class="code-1 nolinks" id="code-20-42709307-1">$this-&gt;load-&gt;library('Curl');
</code></pre>
 
Next, you can use Post to send JSON notation. Data can displayed in JSON using display_override hook controller.
</div>

<div>
<div class="content wysiwyg-content">
How do I return the results of a query as JSON echo to screen?
</div>
</div>

How do I return the results of a query as JSON echo to screen?

Codeigniter Query Help Returning JSON

CodeIgniter is an open-source software rapid development web framework used to build dynamic websites with PHP. The software is partly based on the model–view–controller (MVC) pattern, although models and views are optional. It is typically recognized for its speed when compared to other PHP frameworks.

CodeIgniter

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

JSON

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.