prepare($sql_checkform);
$stmt->bind_param("i", $setid);
$stmt->execute();
$stmt->bind_result($id, $deadline, $opentocountry, $status);
$stmt->fetch();
$value_checkform = (object) ['id' => $id, 'deadline' => $deadline, 'opentocountry' => $opentocountry, 'status' => $status];
$stmt->close();
//print($selectlang);
$getmetalang="metatitle".$selectlang;
$getmetatitle=$value_checkform->$getmetalang;
$metatitleuse="IMA Franchise Enquiry";
if ($getmetatitle != ""){
$metatitleuse=$getmetatitle;
}else {
}
function read_englishfranchise($conn, $word, $selectlang)
{
$lang_id = $selectlang;
$lang=$lang_id;
if ($lang == "cn"){
$language_id = "9";
}
else if ($lang == "en") {
$language_id = "1";
}else if($lang =="ar"){
$language_id = "10";
}
else if($lang =="kr"){
$language_id = "11";
}
else if($lang =="kz"){
$language_id = "12";
}
else if($lang =="ir"){
$language_id = "16";
}
else if($lang =="vn"){
$language_id = "17";
}
else if($lang =="tk"){
$language_id = "18";
}
else if($lang =="de"){
$language_id = "19";
}
else if($lang =="jp"){
$language_id = "20";
}
else if($lang =="fr"){
$language_id = "21";
}
else if($lang =="es"){
$language_id = "22";
}
else if($lang =="it"){
$language_id = "23";
}
else if($lang =="Th"){
$language_id = "24";
}
else if($lang =="Id"){
$language_id = "31";
}
else if($lang =="cb"){
$language_id = "26";
}
else if($lang =="tc"){
$language_id = "27";
}
else if($lang =="bm"){
$language_id = "28";
}
else if($lang =="enus"){
$language_id = "30";
}
else if($lang =="pt"){
$language_id = "32";
}
else {
$language_id = "1";
}
// if ($lang_id=="0"){
// $lang_id="1";
// }
//echo "$lang_id";
$lang_id=$language_id;
//echo "$lang_id";
$selectSQL_word="select * from english_listing where english_word like '%$word%' and page_name=''";
//$selectSQL_word="select * from english_listing where english_word like '$word' and page_name=''";
//echo "
";
//print($selectSQL_word);
$resultSQL_word=mysqli_query($conn, $selectSQL_word);
//print_r($resultSQL_word);
$translated_word=$word;
$english_listing_id=0;
//$english_listing_id=$_GET["listing_id"];
if(mysqli_num_rows($resultSQL_word)>0)
{
//echo "22222";
// print($selectSQL_word);
$rowSQL_word=mysqli_fetch_assoc($resultSQL_word);
$english_listing_id=$rowSQL_word['listing_id'];
}
//print($english_listing_id);
//echo "2323"
//if($lang_id!="" && $lang_id!="0")
if($lang_id!="")
{
$selectSQL_english_listing_language="select * from english_listing_language where listing_id='$english_listing_id' and language_id='$lang_id'";
//print($selectSQL_english_listing_language);
//print($english_listing_id);
$resultSQL_english_listing_language=mysqli_query($conn, $selectSQL_english_listing_language);
if(mysqli_num_rows($resultSQL_english_listing_language)>0)
{
$rowSQL_english_listing_language=mysqli_fetch_assoc($resultSQL_english_listing_language);
if(trim($rowSQL_english_listing_language['translated_word'])!="")
{
$translated_word=$rowSQL_english_listing_language['translated_word'];
}
}
}
echo $translated_word;
}
//print "checkhere $lang_id";
?>