Search the Community
Showing results for tags 'ajax search'.
Found 1 result
-
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
