Mercurial > hg > extraction-interface

comparison interface/add_dynasty.php @ 4:883ad980a43b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add dynasty column to table books
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 27 Jan 2015 16:40:30 +0100
parents
children cbbb7ef22394
comparison
equal deleted inserted replaced
3:f196939ccc03 4:883ad980a43b
1 <?php
2
3 include_once('Lib_mb_utf8.php');
4 include_once('config.php');
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
21 function add_dynasty($dynasty_info){
22 $dynasty = $dynasty_info[0];
23 $start_year = $dynasty_info[1];
24 $end_year = $dynasty_info[2];
25
26 $dir_path = "dynasty_period_list/";
27 $myfile = fopen($dir_path.$dynasty.".txt", "r") or die("Unable to open file!");
28
29 // Output one line until end-of-file
30 while(!feof($myfile)) {
31 $line = fgets($myfile);
32 $splited_line = preg_split('/\r\n|\r|\n/', $line);
33 $matched_period = $splited_line[0];
34
35 $query="SELECT id, period, start_year FROM books WHERE period='".$matched_period."'";
36
37 $result=mysql_query($query);
38
39 if(!$result){
40 echo json_encode("Failed during querying records.");
41 return;
42 }
43 while($row=mysql_fetch_assoc($result)){
44 echo $row['id']." ".$row['period']."<br>";
45 if ($row['start_year'] > ($start_year-10) && $row['start_year'] < ($end_year+10)) {
46 // write $dynasty into record
47 $query="UPDATE books SET dynasty='".$dynasty."' WHERE id='".$row['id']."'";
48 $res=mysql_query($query);
49 if(!$res){
50 echo json_encode("Failed during querying records.");
51 return;
52 }
53 }
54
55 }
56 echo "----------".$matched_period." books number: ".mysql_num_rows($result)."<br>";
57 }
58
59 fclose($myfile);
60
61 }
62
63
64
65 $dynasty = array("漢",-140,200);
66 add_dynasty($dynasty);
67 $dynasty = array("三國",220,280);
68 add_dynasty($dynasty);
69 $dynasty = array("晉",265,420);
70 add_dynasty($dynasty);
71 $dynasty = array("南北朝",386,589);
72 add_dynasty($dynasty);
73 $dynasty = array("隋",581,618);
74 add_dynasty($dynasty);
75 $dynasty = array("唐",618,907);
76 add_dynasty($dynasty);
77 $dynasty = array("五代",907,959);
78 add_dynasty($dynasty);
79 $dynasty = array("宋",960,1279);
80 add_dynasty($dynasty);
81 $dynasty = array("遼",916,1125);
82 add_dynasty($dynasty);
83 $dynasty = array("金",1115,1234);
84 add_dynasty($dynasty);
85 $dynasty = array("元",1260,1367);
86 add_dynasty($dynasty);
87 $dynasty = array("西夏",1032,1227);
88 add_dynasty($dynasty);
89 $dynasty = array("明",1368,1644);
90 add_dynasty($dynasty);
91 $dynasty = array("清",1616,1911);
92 add_dynasty($dynasty);
93 $dynasty = array("民國",1911,9999);
94 add_dynasty($dynasty);
95
96
97 // dynasty list ref: http://dict.revised.moe.edu.tw/htm/fulu/nh.htm
98
99 ?>