define('LEV', '../');
define('PAGEGROUP', "p");
require_once(LEV."func/parts.php");
ss_t();
sud();
$connect = sql_s();
$hnb0 = $_GET['hnb'];
# 復号化
$hnb = dechnb($hnb0);
$sql = "select * from t_sif54, t_product
where t_sif54.hinban = t_product.hinban
and t_sif54.hinban = '".$hnb."'
and t_product.flg_pd_j != 0
limit 1";
mysql_set_charset('utf8');
if(!$res = mysql_query($sql)){die($sql);}
if(mysql_num_rows($res) < 1){header("Location: ".PAGE01);exit;}
$row = mysql_fetch_array($res);
if($row['seihinbunrui_cd'] == 6){header("Location: ./shokuhin_detail.html?hnb=".$hnb0);exit;}
mysql_free_result($res);
$pagename = mb_convert_kana($row['jpn_hinmei'], "as", "UTF8");
$pagename =str_replace("<","<",$pagename);
$pagename =str_replace(">",">",$pagename);
// 原料
$sqlo = "select * from t_origin where hinban = '".$hnb."'";
if(!$reso = mysql_query($sqlo)){die($sqlo);}
$genryo = "";
while($rowo = mysql_fetch_array($reso)){
$genryo .= mb_convert_kana($rowo['kigen_j'], "as", "UTF8").'
';
}
$genryop = str_replace("
", "", $genryo);
mysql_free_result($reso);
// inci
$sqlh = "select * from t_inci_msds, m_inci
where t_inci_msds.inci_id = m_inci.inci_id
and t_inci_msds.hinban = '".$hnb."'
order by t_inci_msds.index_no desc";
if(!$resh = mysql_query($sqlh)){die($sqlh);}
$pinci= "";
while($rowh = mysql_fetch_array($resh)){
$pinci .= $rowh['inci_name'].",";
}
$pinci = ereg_replace("\,$","",$pinci);
$kouka=0;
$koukap = "";
$koukap2 = "";
//期待される作用(データ
$sqle = "select distinct sayo_j from m_efficacy, t_efficacy_item
where m_efficacy.e_code = t_efficacy_item.e_code
and t_efficacy_item.hinban = '".$hnb."'
and m_efficacy.e_code != 'E000'
and t_efficacy_item.siryo = '自社データ'
order by m_efficacy.sayo_j_kana";
if(!$rese = mysql_query($sqle)){die($sqle);}
while($rowe = mysql_fetch_row($rese)){
if($kouka == 0){
$koukap .= ereg_replace("\(.*\)", "", mb_convert_kana($rowe[0], "as", "UTF8"));
$koukap2 .= $koukap;
$kouka++;
}elseif($kouka == 1){
$tg = ereg_replace("\(.*\)", "", mb_convert_kana($rowe[0], "as", "UTF8"));
if($koukap <> $tg){
$koukap .= "・".$tg;
$koukap2 .= ",".$tg;
$kouka++;
}
}elseif($kouka == 2){
$koukap .= "など";
$kouka++;
}
}
//期待される作用(文献
$sqle2 = "select distinct sayo_j from m_efficacy, t_efficacy_item
where m_efficacy.e_code = t_efficacy_item.e_code
and t_efficacy_item.hinban = '".$hnb."'
and m_efficacy.e_code != 'E000'
and t_efficacy_item.siryo = '文献'
order by m_efficacy.sayo_j_kana";
if(!$rese2 = mysql_query($sqle2)){die($sqle2);}
while($rowe2 = mysql_fetch_row($rese2)){
if($kouka == 0){
$koukap .= ereg_replace("\(.*\)", "", mb_convert_kana($rowe2[0], "as", "UTF8"));
$koukap2 .= $koukap;
$kouka++;
}elseif($kouka == 1){
$tg = ereg_replace("\(.*\)", "", mb_convert_kana($rowe2[0], "as", "UTF8"));
if($koukap <> $tg){
$koukap .= "・".$tg;
$koukap2 .= ",".$tg;
$kouka++;
}
}elseif($kouka == 2){
$koukap .= "など";
$kouka++;
}
}
top();
?>
=$pagename?>:=$genryop?>:=$koukap?>|一丸ファルコス株式会社
head1();
accordion();
?>
header2();
?>
=$pagename?>
原料 |
=$genryo?> |
期待される作用(データ) |
if(!$rese = mysql_query($sqle)){die($sqle);}
while($rowe = mysql_fetch_row($rese)){
print(mb_convert_kana($rowe[0], "as", "UTF8").' ');
}
mysql_free_result($rese);
print(' |
期待される作用(文献) |
');
if(!$rese2 = mysql_query($sqle2)){die($sqle2);}
while($rowe2 = mysql_fetch_row($rese2)){
print($rowe2[0].' ');
}
mysql_free_result($rese2);
// 成分コード企画コード
$sqlf = "select * from t_jsqi
where hinban = '".$hnb."'
order by index_no desc";
if(!$resf = mysql_query($sqlf)){die($sqlf);}
print(' |
成分コード |
規格コード |
成分名 |
');
$ii=0;
while($rowf = mysql_fetch_array($resf)){
print('
'.$rowf['seibun_cd'].' |
'.$rowf['kikaku_cd'].' |
'.$rowf['seibun_j'].' |
');
$ii++;
}
mysql_free_result($resf);
if($ii == 0){
print('
- |
- |
- |
');
}
print('
|
表示名称(化粧品) |
');
$sqlg = "select * from t_cosl
where hinban = '".$hnb."'
order by index_no desc";
if(!$resg = mysql_query($sqlg)){die($sqlg);}
while($rowg = mysql_fetch_array($resg)){
print(mb_convert_kana($rowg['hyojimei'], "as", "UTF8").' ');
}
mysql_free_result($resg);
?>
|
INCI名 |
学名 |
CAS No. |
EC No. |
if(!$resh = mysql_query($sqlh)){die($sqlh);}
while($rowh = mysql_fetch_array($resh)){
print('
'.$rowh['inci_name'].' |
'.$rowh['latin'].' |
'.$rowh['cas_no'].' |
'.$rowh['einecs_no'].' |
');
}
mysql_free_result($resh);
?>
|
$sqli = "select * from t_qual
where hinban = '".$hnb."'
order by index_no desc";
if(!$resi = mysql_query($sqli)){die($sqli);}
if(mysql_num_rows($resi) > 0){
?>
表示名称(部外品) |
成分名 |
別名 |
簡略名 |
while($rowi = mysql_fetch_array($resi)){
print('
'. mb_convert_kana($rowi['seibunmei'], "as", "UTF8").' |
'. mb_convert_kana($rowi['betumei'], "as", "UTF8").' |
'. mb_convert_kana($rowi['kanryakumei'], "as", "UTF8").' |
');
}
?>
|
}
mysql_free_result($resi);
/*-------- 梱包単位 --------*/
$sqlj = "select * from t_wrapping
where hinban = '".$hnb."'";
if(!$resj = mysql_query($sqlj)){die($sqlj);}
$konpo = "";
while($rowj = mysql_fetch_array($resj)){
if(!empty($rowj['yoryo_j'])){
$konpo .= $rowj['yoryo_j'].'
';
}
}
mysql_free_result($resj);
if(!empty($konpo)){
?>
包装単位 |
=$konpo?> |
}
/*-------- コメント --------*/
$sqlj = "select * from t_product
where hinban = '".$hnb."'";
if(!$resj = mysql_query($sqlj)){die($sqlj);}
$comment = "";
while($rowj = mysql_fetch_array($resj)){
if(!empty($rowj['comment_j'])){
$comment .= $rowj['comment_j'].'
';
}
}
mysql_free_result($resj);
if(!empty($comment)){
?>
コメント |
=$comment?> |
}
?>
$sqlk = "select * from t_product
where hinban = '".$hnb."'";
if(!$resk = mysql_query($sqlk)){die($sqlk);}
$rowk = mysql_fetch_array($resk);
mysql_free_result($resk);
mysql_close($connect);
if(!empty($rowk['web_pg_date'])){
$pdate = substr($rowk['web_pg_date'], 0, 4)."年".substr($rowk['web_pg_date'], 5, 2)."月".substr($rowk['web_pg_date'], 8, 2)."日";
?>
本資料は=$pdate?>現在の情報に基づいて作成されております。
}
?>
最新情報は弊社営業担当にお尋ね下さい。
技術者限定資料です。ご利用規約をお読み下さい。
contact_b();
totop();
?>
sidemenu();
?>
footer();
?>