StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POjQuery UI - Changing Source to MySQL Data
primarykey
Id
8280929
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-26T19:19:23.007
FavoriteCount
0
LastActivityDate
2011-11-26T20:29:12.407
LastEditDate
2011-11-26T20:29:12.407
LastEditorUserId
118697
OwnerUserId
452749
ParentId
0
PostTypeId
1
Score
0
ViewCount
365
LastEditorDisplayName
text
Body
<p>I am trying to create several autocomplete fields in a web page. I have 2 working, one using a local array as the source and another using a page called search.php but the one using search.php is not working.</p> <p>Here is the code for the basic page:</p> <pre><code><!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>jQuery UI Autocomplete - Remote datasource</title> <link rel="stylesheet" href="../../themes/base/jquery.ui.all.css"> <script src="../../jquery-1.6.2.js"></script> <script src="../../ui/jquery.ui.core.js"></script> <script src="../../ui/jquery.ui.widget.js"></script> <script src="../../ui/jquery.ui.position.js"></script> <script src="../../ui/jquery.ui.autocomplete.js"></script> <link rel="stylesheet" href="../demos.css"> <style> .ui-autocomplete-loading { background: white url('images/ui-anim_basic_16x16.gif') right center no-repeat; } </style> <script type="text/javascript"> $(function() { var availableTags = ["c++", "java", "php", "coldfusion", "javascript", "asp", "ruby", "python", "c", "scala", "groovy", "haskell", "perl"]; $("#tags").autocomplete({ source: availableTags }); }); $(function() { var availableTags = ["c++", "java", "php", "coldfusion", "javascript", "asp", "ruby", "python", "c", "scala", "groovy", "haskell", "perl"]; $("#tags2").autocomplete({ source: "search2.php", minLength: 3 }); }); </script> <input id="tags" /> <input id="tags2" /> </body> </html> </code></pre> <p>And here is the search.php page code</p> <pre><code><?php // PHP5 Implementation - uses MySQLi. // mysqli('localhost', 'yourUsername', 'yourPassword', 'yourDatabase'); $db = new mysqli(localhost', 'username' ,'password', 'database_name'); if(!$db) { // Show error if we cannot connect. echo 'ERROR: Could not connect to the database.'; } $term = $_GET['term']; $result = $db->query("SELECT registeredName FROM names WHERE registeredName LIKE '%".$term."%' "); $array = array(); while ($data = mysql_fetch_array($result)) { $row_array['id'] = $data['id']; $row_array['value'] = "$data[value]"; array_push($array, $row_array); } echo json_encode($array); ?> </code></pre> <p>Any advice would be appreciated</p>
Tags
<php><jquery><jquery-autocomplete>
Title
jQuery UI - Changing Source to MySQL Data
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USChad Levy
UserOwnerUserId
1. USStaggan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.