Databases
StackOverflow2013
Postsdbo
POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
    primarykey
    data
    text
    <p>I am attempting to query SQL to get an array of values to use for typeahead and I'm apparently missing the fundamentals of arrays because it's not giving me even close to the results that I expect</p> <p>I want to gather the "Name" column from SQL for distinct data only</p> <p>Here is my MySQL query</p> <pre><code>$data['typeahead'] = $this-&gt;db-&gt;query('SELECT DISTINCT Name from table')-&gt;result_array(); </code></pre> <p>Here is the output it gives on var_dump</p> <pre><code>array(287) { [0]=&gt; array(1) { ["Name"]=&gt; string(16) "'67 Shelby GT500" } [1]=&gt; array(1) { ["Name"]=&gt; string(8) "Tooligan" } [2]=&gt; array(1) { ["Name"]=&gt; string(24) "'67 Pontiac Firebird 400" } [3]=&gt; array(1) { ["Name"]=&gt; string(17) "Volkswagen Beetle" } } </code></pre> <p>The only thing I'm trying to do is build an array with the data from the columns. I'm using CodeIgniter for FrameWork and will be using Bootstrap's JS to work with the typeahead, but I'm stuck on the data array section.</p> <p>Any help would be greatly appreciated, I've found numerous tutorials on how to use non MySQL arrays as typeahead, but none working with MySQL.</p> <p>^^ Solved</p> <p>Issue now:</p> <p>Typeahead isn't pulling data from array</p> <p>controller code:</p> <pre><code> $name_array = $this-&gt;db-&gt;query('SELECT DISTINCT Name from table')-&gt;result_array(); $typeahead_string = ''; foreach ($name_array as $name) { $formatted_name = '"' . $name['Name'] . '", '; $typeahead_string .= $formatted_name; } $option_list = "[" . rtrim($typeahead_string, ", ") . "]"; $data['typeahead'] = $option_list; </code></pre> <p>View Code:</p> <pre><code>&lt;input type="text" class="span3 search-query" placeholder="Search" id="typeahead" data-provide="typeahead" data-source="&lt;?php echo $typeahead; ?&gt;"&gt;&lt;button type="submit" class="btn"&gt;&lt;i class="icon-search"&gt;&lt;/i&gt;&lt;/button&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAndrew
    1. USAndrew
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
      1. USAndrew
      1. VTFavorite
    1. COThat's not an array, that's an object that represents a query result. I know nothing about CI but I'm sure the documentation explains how to make a database query.
      singulars
      1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
      1. USÁlvaro González
    2. CO@ÁlvaroG.Vicario you were correct, I added ->result_array() and now i'm getting an array inside an array. I just need to figure out how to remove the first array completely
      singulars
      1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
      1. USAndrew
    3. COYou could try and see what `row_array()` returns instead `result_array()`, or get your array data by using `$newArray = $oldArray[0];`. This simply puts into `$newArray` a first element of `$oldArray` (that first element happens to be an array too).
      singulars
      1. POPHP: Bootstrap, CodeIgniter - Typeahead data pulling from MySQL
      1. USSlavenko Miljic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload