query($sql_checkform);
$value_checkform = $result_checkform->fetch_object();
$deadline = $value_checkform->deadline;
$opentocountry = $value_checkform->opentocountry;
$getmetalang="metatitle".$selectlang;
$getmetatitle=$value_checkform->$getmetalang;
$metatitleuse="IMA Franchise Enquiry";
if ($getmetatitle != ""){
$metatitleuse=$getmetatitle;
}else {
}
function read_englishfranchise($conn2, $word, $selectlang)
{
//$lang_id = 9;
//$lang_id = $_GET['lang'];
$lang_id = $selectlang;
if ($lang_id=="0"){
$lang_id="1";
}
//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($conn2, $selectSQL_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'];
}
//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($conn2, $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;
}
?>