typeahead (ajax) search box

[wulfric]

May you please advise?

 

I've got tons of notes and tabs, and I feel like I'm really close. If you would like to lend some of your time and wisdom, I would be most grateful. I'm looking to contribute my first community addon to WHMCS.

 

I wish to query the tblknowledgebase table and return title and id into typeahead array that'll then open the echo in new tab / window. Did I say that right?

 

https://i.imgur.com/zu27hyb.png

 

This is where I'm at now:

 

<?php
   $key=$_GET['key'];
   $array = array();
   $con=mysql_connect("localhost","dbuser","dbpass");
   $db=mysql_select_db("dbname",$con);
   $query=mysql_query("select * from tblknowledgebase where title LIKE '%{$key}%'");
   // I just duped above line and replaced title with ID
   $query=mysql_query("select * from tblknowledgebase where id LIKE '%{$key}%'");
   while($row=mysql_fetch_assoc($query))
   {
     $array[] = [u]$row['title'][/u];
     // missing the row ID stuff and concenate stuff

   }
   echo json_encode($array);

?>

 

https://i.imgur.com/ZKC7D4t.png

 

This is what I desire output of $array[]:

 

<a href="knowledgebase.php?action=displayarticle&id={$kbarticle.id}" target="_blank">$row['title']</a>

<a href="knowledgebase.php?action=displayarticle&id=$row['title']" target="_blank">$row['title']</a>

 

 

Href stuff pulled from file: supportticketsubmit-kbsuggestions.tpl

Starting tutorial: https://codeforgeek.com/2014/09/ajax-search-box-php-mysql/

 

keywords used during research

• typeahead mysql fetch "link" + "href"

• add href OR link to $array[] = $row[

• json_encode href

• php concenate $row['

 

misc

• concenate

• mysql = deprecated?

• mysqli = new?

• http://www.codingcage.com/2016/12/autocomplete-search-with-href-link-php.html

• http://www.discussdesk.com/autocomplete-search-in-php-mysql-json-with-navigation.htm

• http://bit.ly/2nGCVGf

• http://au1.php.net/json_encode

• https://datatables.net/forums/discussion/28891/adding-hyperlink-to-each-row

• https://github.com/bassjobsen/Bootstrap-3-Typeahead

[markhughes]

Hey! The API can be a bit confusing to get around at first. It's very exciting making your first add-on.

 

Please do not use mysql_connect - use mysqli_connect! mysql_connect is deprecated and it has actually been removed all together in PHP 7.0!

 

 

Also you should filter variables if you're going to use them in the database. For example:

 

// this is _NOT_ safe to use in a query
$key = $_GET['key']; // BAD 

// this _IS SAFE_ to use in a query
$key = mysqli_real_escape_string($_GET['key']); // BETTER 

 

Hers an article on it: http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php

 

OK now, with this:

 

   while($row=mysql_fetch_assoc($query))
   {
     $array[] = $row['title'];

   }

 

You are only storing the title. You will want to grab the ID and title with this:

 

$array[] = [ 
   "id" => $row["id"],
   "title" => $row["title"]
];

 

You would then get an array of objects in JSON like this:

 

[
   {
       "id": 1,
       "title": "Your Title",
   },
   {
       "id": 2,
       "title": "Another Title",
   },
   {
       "id": 3,
       "title": "We love WHMCS",
   }
]