LGSearch: search_function.php annotate

annotate search_function.php @ 5:1cf7bb8db5dd

modify passwd popup

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 12 Oct 2015 15:36:13 +0200
parents	bc6ce492f15d
children	23dcd1b5e9c4

rev	line source
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1 <?php
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	2 include_once('config/Lib_mb_utf8.php');
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	3 include_once('config/config.php');
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 set_time_limit(0);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6 ini_set('memory_limit', '-1');
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 mysql_query("SET NAMES utf8");
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	10
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	11 if (!$link_mysql) {
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12 die('Could not connect: ' . mysql_error());
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	14
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 $db_selected = mysql_select_db($mysql_database, $link_mysql);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 if (!$db_selected) {
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17 die ('Can\'t use foo : ' . mysql_error());
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 }
5 1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	19
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	20
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	21 $func = $_POST["func"];
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	22 switch ($func) {
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	23 case 'checkPassword':
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	24 checkPassword($_POST["password"]);
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	25 break;
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	26 default:
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	27 break;
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	28 }
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	29
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	30 function checkPassword($passwd){
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	31 global $password;
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	32 if ($password == $passwd) {
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	33 echo 1;
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	34 } else {
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	35 echo 0;
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	36 }
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	37 }
1cf7bb8db5dd modify passwd popup Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 3 diff changeset	38
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 function trimKeyword($keywords){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40 $token=strtok($keywords,",");
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 while($token!=false){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 $token=trim($token);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 $keywordArray[]=$token;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44 $token=strtok(",");
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 return $keywordArray;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 function search($keywordArray){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 $condition="";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 foreach($keywordArray as $i=>$keyword){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52 if($i!=0){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 $condition.=" OR ";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	55 $condition.=" contents.content LIKE '%".$keyword."%' ";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 //books.name AS book_name, books.level1, books.level2, books.period, contents.books_id, contents.line, contents.content
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 $query="SELECT books.level1 AS LEVEL1, books.level2 AS LEVEL2,
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 books.name AS Name, books.period AS PERIOD,
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 books.start_year AS 'TimeSpan:begin', books.end_year AS 'TimeSpan:end',
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 books.id AS BOOK_ID, contents.line AS PAGE, contents.content AS CONTENT,
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 books.volume AS VOLUME, books.author AS AUTHOR, books.edition AS EDITION
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 FROM contents
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 JOIN books ON contents.books_id = books.id
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 WHERE ".$condition."
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67 ORDER BY contents.books_id, contents.line";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68 $result = mysql_query($query);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 if (!$result) {
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70 echo mysql_error();
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72 echo "result length: ".mysql_num_rows($result)."<br>";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74 while ($row = mysql_fetch_assoc($result)) { //Find the section(s) where the page belongs to
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75 //$resultArray[$i]=$row;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	76 $query = "SELECT MAX(`id`) FROM `sections_versions` WHERE `books_id` ='".$row['BOOK_ID']."'";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 $r = mysql_fetch_row(mysql_query($query));
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79 $max_version_id = $r[0];
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81 $subQuery = "";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 if ($max_version_id) {
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 $subQuery="SELECT id, name, start_page, end_page
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84 FROM sections_revisions
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85 WHERE books_id=".$row['BOOK_ID']." AND start_page<=".$row['PAGE']." AND end_page>=".$row['PAGE']." AND sections_revisions.deleted=0 AND sections_revisions.versions_id=".$max_version_id;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87 } else {
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88 $subQuery="SELECT id, name, start_page, end_page
2 45cbafdec56e modified code for updated db tables Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 1 diff changeset	89 FROM sections_index
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 WHERE books_id=".$row['BOOK_ID']." AND start_page<=".$row['PAGE']." AND end_page>=".$row['PAGE'];
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 $subResult=mysql_query($subQuery);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 $sectionArray=array();
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 while($subRow=mysql_fetch_assoc($subResult)){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	96 $sectionArray[]=$subRow;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98 $row['SECTION']=$sectionArray;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 $resultArray[]=$row;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 //echo "array length: ".sizeof($resultArray)."<br>";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 return $resultArray;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105 $NO_TAG=0;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	106 $LOCUST_TEMPLE=1;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 function printTable($array,$keywordArray,$filename,$tag){ //print HTML
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109 global $NO_TAG, $LOCUST_TEMPLE;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 $header='<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 <html>
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112 <head>
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
1 38851c894301 path config Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 0 diff changeset	114 <link href="../search.css" type="text/css" rel="stylesheet"/>
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
1 38851c894301 path config Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 0 diff changeset	116 <script src="../search.js" charset="utf-8"></script>
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117 </head>
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 <body>';
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 $keywordStr="";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 foreach($keywordArray as $i=>$keyword){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121 if($i!=0){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 $keywordStr.=", ";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 $keywordStr.=$keyword;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	126
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 global $system_root_url, $server_host, $lgserver_url;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	130 if ($fp=fopen("./search_results/".$filename.".html","w")) {
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	131
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	132 //$fp=fopen("./search_results/".$filename.".html","w");
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	133 fwrite($fp,$header);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	134 $str="<a href='".$server_host."LGMap/get_coordinates_for_listed_books.php?file=".$filename.".csv&name=".$keywordStr."' target='_blank'>view the distribution on the map (click here at the first time)</a><br><br>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	135 $str.="<a href='".$server_host."LGMap/map.php?mode=1&file=".$filename.".csv&name=".$keywordStr."' target='_blank'>view the distribution on the map</a><br><br>";
2 45cbafdec56e modified code for updated db tables Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 1 diff changeset	136
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	137 fwrite($fp,$str);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	138 $str.="<a href='".$system_root_url."search_results/".$filename.".html' target='_blank'>html version</a><br><br>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	139 // $str.="<a href='http://".$_SERVER['HTTP_HOST']."/LGSearch/search_results/".$filename.".html' target='_blank'>html version</a><br><br>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	140 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	141 echo sizeof($array)." result(s) of \"".$keywordStr."\" ";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	142 fwrite($fp,sizeof($array)." result(s) of \"".$keywordStr."\"<br>");
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	143 $str="<table>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	144 $str.="<tr>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	145 $str.="<td class='sequence'>#<td class='bookId'>book id<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='sectionName'>section info<td class='page'>page<td class='content'>content";
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 fwrite($fp,$str);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 echo $str;
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	148 $i=1;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	149 foreach($array as $row){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	150 $str="<tr>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	151 $str.="<td>".$i;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	152 $str.="<td>".$row['BOOK_ID'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	153 $str.="<td>".$row['Name'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	154 $str.="<td>".$row['LEVEL1'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	155 $str.="<td>".$row['LEVEL2'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	156 $str.="<td>".$row['PERIOD'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	157 $str.="<td>";
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 fwrite($fp,$str);
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	159 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	160 foreach($row['SECTION'] as $section){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	161
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	162 $str="<div class='section'><a>".$section['name']."</a>p".$section['start_page']."-".$section['end_page']."</div>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	163 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	164 /*
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	165 // redirect to LGServer?
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	166 $str="<div class='section'><a href='".$lgserver_url."' target='_blank'>".$section['name']."</a>p".$section['start_page']."-".$section['end_page']."</div>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	167 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	168 $str="<div class='section'><a href='".$lgserver_url."' target='_blank'>".$section['name']."</a>p".$section['start_page']."-".$section['end_page']."</div>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	169 */
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	170 /* origial
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	171 $str="<div class='section'><a href='/interface/tagging_text.php?id=".$section['id']."' target='_blank'>".$section['name']."</a>p".$section['start_page']."-".$section['end_page']."</div>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	172 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	173 $str="<div class='section'><a href='/interface/tagging_text.php?id=".$section['id']."' target='_blank'>".$section['name']."</a>p".$section['start_page']."-".$section['end_page']."</div>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	174 */
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	175 fwrite($fp,$str);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	176 }
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	177 $str="<td>".$row['PAGE'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	178 if($tag==$NO_TAG){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	179 $str.="<td>".$row['CONTENT'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	180 }else if($tag==$LOCUST_TEMPLE){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	181 $str.="<td>".findLocustTempleDescription($row['CONTENT'],$keywordArray,0);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	182 }
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	183 fwrite($fp,$str);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	184 echo $str;
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	185 $i++;
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 }
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	187
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	188 echo "</table>";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	189 fwrite($fp,"</table></body></html>");
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	190 fclose($fp);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	191
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	192 } else {
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	193 error_log("error when opening file: "."./search_results/".$filename.".html" ,0);
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	194 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 function findLocustTempleDescription($str,$keywordArray,$findUnknownTemple){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 $result="";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199 $pattern[0]="/(.*)(";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 foreach($keywordArray as $i=>$keyword){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201 $pattern[0].=$keyword;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202 if($i!=sizeof($keywordArray)-1){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203 $pattern[0].="\|";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 $pattern[0].=")(.*)/u";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 //0=whole,1=text,2=locust temple,3=description
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 $pattern[1]="/(.\s+)(\S{1,5}[廟寺祠])(.)/u";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 //0=whole,1=descripption,2=unknown temple,3=text
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 $success=preg_match($pattern[$findUnknownTemple],$str,$match); //note that preg_match only matches the last match!
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 if($findUnknownTemple==0){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 if($success==1){//find string "locust temple"
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 $result=findLocustTempleDescription($match[1],$keywordArray,0);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214 $result.="<keyword>".$match[2]."</keyword>";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 $result.=findLocustTempleDescription($match[3],$keywordArray,1);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 return $result;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 }else{//no string "locust temple"
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 return "<irrelevant>".$str."</irrelevant>";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 }else{
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	221 if($success==1){//find the pattern "locust temple......unknown temple"
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	222 $result=findLocustTempleDescription($match[1],$keywordArray,1);
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223 $result.="<irrelevant>".$match[2].$match[3]."</irrelevant>";
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 //$result.="<keyword>".$match[2]."</keyword>".$match[3];
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	225 return $result;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	226 }else{//can't find the pattern
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	227 return $str;
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	228 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	229
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	230 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	231 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233 function writeCsvFile($array,$fileName){
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234 $columnNameArray=['BOOK_ID','LEVEL1','LEVEL2',
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235 'Name','PERIOD','TimeSpan:begin','TimeSpan:end','PAGE','SECTION','CONTENT',
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236 'Description'];
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	237 if( $fp=fopen("./csv_files/".$fileName.".csv","w")) {
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	238 // $fp=fopen("./csv_files/".$fileName.".csv","w");
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	239 fputcsv($fp,$columnNameArray);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	240 foreach($array as $row){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	241 $book=array();
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	242 $row['Description']='';
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	243 foreach($columnNameArray as $column){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	244 $book[$column]=$row[$column];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	245 }
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	246 $book['Name']="(".$row['PERIOD'].") ".$row['Name'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	247 $row['AUTHOR']=str_replace("（","(",$row['AUTHOR']);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	248 $row['AUTHOR']=str_replace("）",") ",$row['AUTHOR']);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	249 $book['Description']=$row['VOLUME']." ╱ ".$row['AUTHOR']." ╱ ".$row['EDITION'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	250 $book['SECTION']='';
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	251 foreach($row['SECTION'] as $idx=>$section){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	252 $book['SECTION'].=$section['name']." ".$section['start_page']."-".$section['end_page'];
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	253 if($idx!=sizeof($row['SECTION'])){
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	254 $book['SECTION'].=" ╱ ";
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	255 }
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	256 }
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	257 fputcsv($fp,$book);
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	258 }
3 bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	259 fclose($fp);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	260
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	261 } else {
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	262 error_log("error when opening file: "."./csv_files/".$fileName.".csv", 0);
bc6ce492f15d add passwd in search page, php error log Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 2 diff changeset	263 }
0 c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	264 }
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	265
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	266 ?>
c9363a90b8b5 first commit to development server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	267

Mercurial > hg > LGSearch

annotate search_function.php @ 5:1cf7bb8db5dd