ImageVerificationToolPHP/fillin4.php at master · cfilt/ImageVerificationToolPHP · GitHub

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
<html><head>

<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>

<?php
$con=mysql_connect("localhost", "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];
	$exec2=mysql_query("SELECT synset_words from hwn_linking.english_synset_data where synset_id=$english_id");
	$fetchdata2=mysql_fetch_row($exec2);
	$words=$fetchdata2[0];
	$exec3=mysql_query("UPDATE imageeval SET eng_words='$words' WHERE engid='$english_id'");
}
echo "Done!";
mysql_close($con);
?>