Mercurial > hg > LGMap

comparison get_coordinates_for_listed_books.php @ 0:57bde4830927

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first commit
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 24 Mar 2015 11:37:17 +0100
parents
children de2c442b6cbb
comparison
equal deleted inserted replaced
-1:000000000000 0:57bde4830927
1 <?php
2 include_once('../interface/Lib_mb_utf8.php');
3 include_once('../interface/config.php');
4
5 set_time_limit(0);
6 ini_set('memory_limit', '-1');
7
8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
9 mysql_query("SET NAMES utf8");
10
11 if (!$link_mysql) {
12 die('Could not connect: ' . mysql_error());
13 }
14
15 $db_selected = mysql_select_db($mysql_database, $link_mysql);
16 if (!$db_selected) {
17 die ('Can\'t use foo : ' . mysql_error());
18 }
19
20 function readCsvFile($fileName){
21 $fp=fopen("../search/csv_files/".$fileName,"r");
22 $data=fgetcsv($fp);
23 $columnNameMappingArray=['BOOK_ID','LEVEL1','LEVEL2',
24 'Name','PERIOD','TimeSpan:begin','TimeSpan:end','PAGE','SECTION','CONTENT',
25 'Description']; //columns from input array/file
26 $columnNameArray=['Address','ADMIN_TYPE','LEVEL1','LEVEL2',
27 'Name','PERIOD','TimeSpan:begin','TimeSpan:end','Longitude','Latitude',
28 'PAGE','SECTION','CONTENT',
29 'BOOK_ID','CHGIS_ID','1820_ID','1911_ID','CBDB_ID','Description']; //columns for output array/file (for map.php)
30 $columnNameArray=array_flip($columnNameArray); //key, value swap in order to keep the order of the columns after merge
31 $bookArray=array();
32 $count=0;
33 $line=0;
34 while(!feof($fp)){
35 $data=fgetcsv($fp);
36 if(sizeof($data)<sizeof($columnNameMappingArray)){
37 continue;
38 }
39 ///$bookId=$data[0];
40 foreach($columnNameMappingArray as $idx=>$newName){ //use column names as the array indices (instead of 0,1,2,... as from $data)
41 $bookInfo[$newName]=$data[$idx];
42 }
43 $bookId=$bookInfo['BOOK_ID'];
44 $coordinateArray=getCoordinateFromDatabase($bookId);
45 foreach($coordinateArray as $coordinate){ //merge a record from $booArray and ots cooresponding coordinateArray
46 $bookArray[$count]=array_merge($bookInfo,$coordinate);
47 $bookArray[$count]=array_merge($columnNameArray,$bookArray[$count]);
48 $count++;
49 }
50 }
51 fclose($fp);
52 return $bookArray;
53 }
54 function writeCsvFile($fileName,$bookArray){
55 $columnNameArray=['Address','ADMIN_TYPE','LEVEL1','LEVEL2',
56 'Name','PERIOD','TimeSpan:begin','TimeSpan:end','Longitude','Latitude',
57 'PAGE','SECTION','CONTENT',
58 'BOOK_ID','CHGIS_ID','1820_ID','1911_ID','CBDB_ID','Description'];
59 $fp=fopen("./datasets/".$fileName,"w");
60 fputcsv($fp,$columnNameArray);
61
62 foreach($bookArray as $book){
63 fputcsv($fp,$book);
64 }
65 fclose($fp);
66 }
67 function getCoordinateFromDatabase($bookId){
68 $query="SELECT place_name AS Address, admin_type AS ADMIN_TYPE, x AS Longitude, y AS Latitude,
69 chgis_id AS CHGIS_ID, 1820_id AS 1820_ID, 1911_id AS 1911_ID, cbdb_id AS CBDB_ID
70 FROM coordinates_books
71 WHERE books_id='".$bookId."'";
72 $result = mysql_query($query);
73 $coordinateArray=array();
74 while ($row = mysql_fetch_assoc($result)) {
75 $coordinateArray[]=$row;
76 }
77 return $coordinateArray;
78 }
79
80 $fileName=$_GET['file'];
81 $name=$_GET['name'];
82 $bookArray=readCsvFile($fileName);
83 writeCsvFile($fileName,$bookArray);
84 header("Location: map.php?mode=1&file=".$fileName."&name=".$name);
85 ?>