$res_type = query("SELECT id FROM jba_type WHERE name='$section_name'"); $row_type = $res_type->fetch_assoc(); $section_id = $row_type["id"]; if($page_name == "چند جواهر") $result_jewel = query("SELECT g.* FROM jba_goods AS g LEFT JOIN jba_goods_stone AS s ON g.id=s.good_id WHERE g.type=$section_id AND g.name='".$name."' GROUP BY good_id HAVING COUNT(*)>1"); else { $res_stone = query("SELECT id FROM jba_stone WHERE name='$page_name'"); $row_stone = $res_stone->fetch_assoc(); $page_id = $row_stone["id"]; $result_jewel = query("SELECT g.* FROM jba_goods AS g LEFT JOIN jba_goods_stone AS s ON s.good_id = g.id WHERE g.name='$name' AND g.type=$section_id AND (g.stone=$page_id OR s.stone_id=$page_id)"); } if(mysqli_num_rows($result_jewel)) { $row = $result_jewel->fetch_assoc(); $jewel_id = $row["id"]; $jewel_code = $row["code"]; $name = $row['name']; $keywords = $row['keywords'];
if($page_name == "چند جواهر") $result_jewel = query("SELECT g.* FROM jba_goods AS g LEFT JOIN jba_goods_stone AS s ON g.id=s.good_id WHERE g.type=$section_id AND g.name='".$name."' GROUP BY good_id HAVING COUNT(*)>1"); else { $res_stone = query("SELECT id FROM jba_stone WHERE name='$page_name'"); $row_stone = $res_stone->fetch_assoc(); $page_id = $row_stone["id"]; $result_jewel = query("SELECT g.* FROM jba_goods AS g LEFT JOIN jba_goods_stone AS s ON s.good_id = g.id WHERE g.name='$name' AND g.type=$section_id AND (g.stone=$page_id OR s.stone_id=$page_id)"); } if(mysqli_num_rows($result_jewel)) { $row = $result_jewel->fetch_assoc(); $jewel_id = $row["id"];
function convertNum2($string) { $persian = array('۰', '۱', '۲', '۳', '۴', '۵', '۶', '۷', '۸', '۹'); $num = range(0, 9); return str_replace($num, $persian, $string); } require_once("Includes/check_page.php"); require_once("Includes/meta.php"); ?> <!-- **** Hamze QaemPanah **** 2018 --> <!DOCTYPE html>
$_SESSION = [ '__flash' => [], 'refer' => 'www.javaheribina.com/%D8%AA%D8%B3%D8%A8%DB%8C%D8%AD/%D9%83%D9%87%D8%B1%D8%A8%D8%A7/%D8%AA%D8%B3%D8%A8%DB%8C%D8%AD-%D9%83%D9%87%D8%B1%D8%A8%D8%A7-%D9%BE%D9%88%D8%AF%D8%B1%DB%8C-%D8%AF%D8%A7%D9%86%D9%87-%DA%A9%D8%B1%D9%88%DB%8C', ];