-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfillin2
executable file
·38 lines (30 loc) · 1.04 KB
/
fillin2
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
<html><head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<?php
$con=mysql_connect("10.144.22.105", "dipak", "tmp123") or die(mysql_error());
mysql_set_charset("UTF8",$con) or die(mysql_error());
mysql_select_db ("hwn_linking") or die(mysql_error());
$query = "SELECT * from imageeval";
echo $query;
$exec=mysql_query($query) or die(mysql_error());
while($fetchdata=mysql_fetch_array($exec)){
$id=$fetchdata['hinid'];
//echo "</br>".$id;
//$exec2=mysql_query("SELECT english_id from english_hindi_id_mapping where hindi_id=$id");
//$fetchdata2=mysql_fetch_row($exec2);
//$english_id=$fetchdata2[0];
//echo $english_id."</br>";
//$exec2=mysql_query("UPDATE imageeval SET engid='$english_id' WHERE hinid='$id'");
$exec2=mysql_query("SELECT gloss from iwn_web_unicode.tbl_all_synset where synset_id=$id");
$fetchdata2=mysql_fetch_row($exec2);
$glossEg=$fetchdata2[0];
$glossEgg=explode(":",$glossEg);
$gloss=$glossEgg[0];
$example=$glossEgg[1];
echo $gloss;
echo $example;
}
echo "Done!";
mysql_close($con);
?>