1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<?PHP
set_time_limit ( 0 ) ;
mysql_connect('localhost', 'root', 'kandisa');
mysql_select_db('wordnet30');
$q1 = "SELECT *
FROM `word`
WHERE `lemma` REGEXP CONVERT( _utf8 '^[a-z]*[a-z]$'
USING latin1 )
COLLATE latin1_swedish_ci";
$result = mysql_query($q1) or die('mysql_query1:'.mysql_error());
$num_rows = mysql_num_rows($result);
while($num_rows > 0){
$row = mysql_fetch_assoc($result);
$q2 = "INSERT into `las_word` (`wordid`, `lemma`) VALUES ( '".$row['wordid']."', '".$row['lemma']."' )";
$result2 = mysql_query($q2) or print('mysql_query:2'.mysql_error());
$q3 = "SELECT * FROM `sense` WHERE `wordid` = '".$row['wordid']."'";
$result3 = mysql_query($q3) or print('mysql_query:3'.mysql_error());
$num_rows3 = mysql_num_rows($result3);
for($i = 0; $i< $num_rows3; $i++){
$row3 = mysql_fetch_assoc($result3);
$q4 = "INSERT INTO `las_sense` (`wordid`, `synsetid`, `rank`) VALUES ('".$row3['wordid']."', '".$row3['synsetid']."', '".$row3['rank']."')";
$result4 = mysql_query($q4) or print('mysql_query:4'.mysql_error());
$q5 = "SELECT * FROM `synset` WHERE `synsetid` = '".$row3['synsetid']."'";
$q6 = "SELECT * FROM `sample` WHERE `synsetid` = '".$row3['synsetid']."'";
$result5 = mysql_query($q5) or print('mysql_query:5'.mysql_error());
$num_rows5 = mysql_num_rows($result5);
$result6 = mysql_query($q6) or print('mysql_query:6'.mysql_error());
$num_rows6 = mysql_num_rows($result6);
for($j = 0;$j < $num_rows5; $j++){
$row5 = mysql_fetch_assoc($result5);
$def = addslashes($row5['definition']);
$q7 = "INSERT INTO `las_synset` (`synsetid`, `pos`, `definition`) VALUES ('".$row5['synsetid']."', '".$row5['pos']."', '".$def."')";
$result7 = mysql_query($q7) or print('mysql_query:7'.mysql_error().$q7);
}
for($k = 0;$k < $num_rows6; $k++){
$row6 = mysql_fetch_assoc($result6);
$sample = addslashes($row6['sample']);
$q8 = "INSERT INTO `las_sample` (`synsetid`, `sampleid`, `sample`) VALUES ('".$row6['synsetid']."', '".$row6['sampleid']."', '".$sample."')";
$result8 = mysql_query($q8) or print('mysql_query:8'.mysql_error());
}
}
$num_rows --;
//echo "<br/>".$row['wordid'].":".$row['lemma'];
}
if(num_rows == 0)
echo "Done :)";
?>
|
