StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLivesearch function with JSON
primarykey
Id
4001723
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-10-22T23:49:42.117
FavoriteCount
0
LastActivityDate
2010-10-23T13:28:57.723
LastEditDate
2010-10-23T00:12:59.773
LastEditorUserId
141661
OwnerUserId
484765
ParentId
0
PostTypeId
1
Score
1
ViewCount
987
LastEditorDisplayName
text
Body
I currently have a method whereby there is an <pre><code><input type="text" id="politician" name="politician" onkeyup="showResult(this.value)" value="Enter a politician's name"/> </code></pre> tag. In that same file that includes the input tag, there is a link to an external javascript file called ajax.js The contents of that file are as follows: <pre><code>function showResult(str) { if (str.length==0) { document.getElementById("livesearch").innerHTML=""; document.getElementById("livesearch").style.border="0px"; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("livesearch").innerHTML=xmlhttp.responseText; document.getElementById("livesearch").style.border="1px solid #A5ACB2"; } } xmlhttp.open("GET","livesearch.php?politician="+str,true); xmlhttp.send(); } </code></pre> Basically, what the javascript file does is say that whenever a value is inserted into the input textbox, a request is sent to a php file called "livesearch.php" which parses the content of a hardcoded XML document called politicians.xml. The livesearch.php file is as follows: <pre><code><?php //Make sure we have something set before we go doing work if (isset($_GET["politician"])){ $q = $_GET["politician"]; if ($q == "") exit(); $xmlDoc = new DOMDocument(); $xmlDoc->load("politicians.xml"); $x=$xmlDoc->getElementsByTagName('Politicians'); $hint = ""; for($i=0; $i<($x->length); $i++) { $y=$x->item($i)->getElementsByTagName('name'); $z=$x->item($i)->getElementsByTagName('url'); $w=$x->item($i)->getElementsByTagName('location'); $v=$x->item($i)->getElementsByTagName('position'); $u=$x->item($i)->getElementsByTagName('photo'); if($y->item(0)->nodeType==1) { //Find a link matching the search text if(stristr($y->item(0)->childNodes->item(0)->nodeValue,$q)) { if($hint != "") { $hint .= " "; } $hint .= "<h1 id='poli'><a id='blue' href='"; $hint .= $z->item(0)->childNodes->item(0)->nodeValue; $hint .= "'>"; $hint .= $y->item(0)->childNodes->item(0)->nodeValue; $hint .= "</a> <a id='green'>"; $hint .= $v->item(0)->childNodes->item(0)->nodeValue; $hint .= "</a><a id='green'>"; $hint .= $w->item(0)->childNodes->item(0)->nodeValue; $hint .= "</a> <img width='30' height='40' id='schmidt' src='politicians/"; $hint .= $u->item(0)->childNodes->item(0)->nodeValue; $hint .= ".png' /></h1>"; } } } } // Set output to "no suggestion" if no hint were found // or to the correct values if($hint == "") echo "No suggestions"; else echo $hint; ?> </code></pre> A friend of mine recently told me that JSON is a great alternative to XML because using JSON will put less strain on the server since it wont need to rely on PHP to parse the content of the XML document. The client would parse it instead. But, I don't have enough experience with JSON to rewrite this function so that it works with a JSON document. Could anyone give me a few tips? Any help would be greatly appreciated!
Tags
<php><javascript><xml><json>
Title
Livesearch function with JSON
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPaulG
UserOwnerUserId
1. USLance Newman
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POLivesearch function with JSON
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COPlease indent all code by at least four spaces so that it's easier to read.
 singulars
 PostPostId
 POLivesearch function with JSON
 UserUserId
 USma11hew28
2. COYou have to select HTML tags as code if you want them to be visible...
 singulars
 PostPostId
 POLivesearch function with JSON
 UserUserId
 USŠime Vidas

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.