Menu
▾
▴
[DL-Learner SVN] SF.net SVN: dl-learner:[1062] trunk/src/dbpedia-navigator
|
From: <sk...@us...> - 2008-08-13 12:54:23
|
Revision: 1062
http://dl-learner.svn.sourceforge.net/dl-learner/?rev=1062&view=rev
Author: sknappe
Date: 2008-08-13 12:54:21 +0000 (Wed, 13 Aug 2008)
Log Message:
-----------
added search using mysql database, not perfect yet, have to add categories to get tag cloud
Modified Paths:
--------------
trunk/src/dbpedia-navigator/index-new.php
Added Paths:
-----------
trunk/src/dbpedia-navigator/ajax_search.php
Added: trunk/src/dbpedia-navigator/ajax_search.php
===================================================================
--- trunk/src/dbpedia-navigator/ajax_search.php (rev 0)
+++ trunk/src/dbpedia-navigator/ajax_search.php 2008-08-13 12:54:21 UTC (rev 1062)
@@ -0,0 +1,40 @@
+<?php
+ include('helper_functions.php');
+
+ $label=$_POST['label'];
+ $list=$_POST['list'];
+ session_start();
+ $id=$_SESSION['id'];
+ $ksID=$_SESSION['ksID'];
+ session_write_close();
+
+ setRunning($id,"true");
+
+ //get parts of the list
+ $checkedInstances=preg_split("[,]",$list,-1,PREG_SPLIT_NO_EMPTY);
+
+ //initialise content
+ $content="";
+ /*try{
+ require_once("DLLearnerConnection.php");
+ $sc=new DLLearnerConnection($id,$ksID);
+
+ $subjects=$sc->getSubjects($label,$checkedInstances);
+
+ $content.=getTagCloud($subjects['tagcloud'],$subjects['tagcloudlabel']);
+ $content.=getResultsTable($subjects['subjects']);
+ } catch (Exception $e){
+ $content=$e->getMessage();
+ }*/
+ mysql_connect('localhost','navigator','dbpedia');
+ mysql_select_db("navigator_db");
+ $query="SELECT name, label FROM rank WHERE MATCH (label) AGAINST ('$label') ORDER BY number LIMIT 3";
+ $res=mysql_query($query);
+ while ($result=mysql_fetch_array($res)){
+ $content.='<a href="" onclick="get_article(\'label='.$result['name'].'&cache=-1\');return false;">'.$result['label'].'</a><br/>';
+ }
+
+ print $content;
+ print '$$';
+ print "Searchresult for ".$label;
+?>
\ No newline at end of file
Modified: trunk/src/dbpedia-navigator/index-new.php
===================================================================
--- trunk/src/dbpedia-navigator/index-new.php 2008-08-13 07:42:33 UTC (rev 1061)
+++ trunk/src/dbpedia-navigator/index-new.php 2008-08-13 12:54:21 UTC (rev 1062)
@@ -103,6 +103,32 @@
XhrObj.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
XhrObj.send(param);
}
+
+ function search(param)
+ {
+ if (document.all){
+ //IE
+ var XhrObj = new ActiveXObject("Microsoft.XMLHTTP");
+ }
+ else{
+ //Mozilla
+ var XhrObj = new XMLHttpRequest();
+ }
+
+ XhrObj.open("POST",'ajax_search.php');
+
+ XhrObj.onreadystatechange = function()
+ {
+ if (XhrObj.readyState == 4 && XhrObj.status == 200){
+ var response = XhrObj.responseText.split('$$');
+ document.getElementById('articlecontent').innerHTML=response[0];
+ document.getElementById('ArticleTitle').innerHTML=response[1];
+ }
+ }
+
+ XhrObj.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
+ XhrObj.send(param);
+ }
</script>
</head>
<body>
@@ -122,7 +148,7 @@
<!-- Search:<br/> -->
<form onSubmit="get_article('label='+document.getElementById('label').value+'&cache=-1');return false;">
<input type="text" name="label" id="label" /><br/>
- <input type="button" value="Article" class="button" onclick="get_article('label='+document.getElementById('label').value+'&cache=-1');return false;" /> <input type="button" value="Search" class="button" onclick="var list=tree.getAllChecked();return false;" />
+ <input type="button" value="Article" class="button" onclick="get_article('label='+document.getElementById('label').value+'&cache=-1');return false;" /> <input type="button" value="Search" class="button" onclick="var list=tree.getAllChecked();search('label='+document.getElementById('label').value+'&list='+list);return false;" />
<!-- <input type="button" value="Fulltext" class="button" onclick=""/> -->
</form>
</div> <!-- boxcontent -->
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
