<?

$id = $_GET['id'];

$show = 1;

//DBアカウント情報の設定
$sqltype = "mysql";
$server = "sys1.monocode.jp";
$user = "takiya";
$password = "takiya";
//データベース名
$dbname = "dev1";


$link = mysql_connect($server, $user, $password);
if (!$link) {
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db($dbname, $link);
if (!$db_selected) {
    die ('Can\'t use foo : ' . mysql_error());
}


$sql="SELECT id,productID,sect_a0,sect_a1,sect_a2,sect_a3,sect_a4,sect_a5,sect_a6,sect_a7,sect_a8,sect_a9,productName,productInfo0,productInfo1,productInfo2,productImage1,productImage2,productImage3,ecURL,cadData FROM products WHERE id = $id AND sect_a2 =',18,'";// AND publish2 = $show

//print $sql;

$result =mysql_query($sql);

if (!$result) {
	print "レコード取得に失敗しました。<br>\n";
	exit;
}
$row = mysql_fetch_assoc($result);


$productName = $row['productName'];
$detail = $row['productInfo0'];
$image = $row['productImage1'];
$image2 = $row['productImage2'];
$image3 = $row['productImage3'];

if($row['productInfo2'] != ""){
		$var = $row['productInfo2'];
		
		$var = str_replace("////////////", "", $var);
		
		$price = explode("///", $var);

$pricePointer = 0;

$endField = $price;

while (count($price)-1>$pricePointer) {

$priceData = explode( "price", $price[$pricePointer]);
$Main_form .= <<<EOF
							<td>$priceData[0]
EOF;

if( $priceData[1] != ""){
$_price = number_format($priceData[1]);
$priceData[1] = number_format(ceil($priceData[1]*1.05));


$Main_form .= <<< EOF
	$_price 円<br /><span class="taxText">(税込 $priceData[1]円 )</span>
EOF;
}


$Main_form .= <<< EOF
</td>
EOF;

$amari = $pricePointer%4;



if($amari==3){
$Main_form .= <<<EOF
							</tr>
							<tr>
EOF;
}

$pricePointer++;


}




}


// MySQL 切断
mysql_close($link);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ラインプロップ 316 端末部品 詳細 - タキヤ株式会社</title>
<link href="css/common316.css" rel="stylesheet" type="text/css" />
<link href="../../css/common.css" rel="stylesheet" type="text/css" />
<link href="css/detail.css" rel="stylesheet" type="text/css" />
<script src="js/jquery-1.2.1.pack.js" type="text/javascript" charset="utf-8"></script>
<script src="js/jquery.pngfix.js" type="text/javascript" charset="utf-8"></script>

<!-- Make call within DOM load handler (or place at the bottom of HTML) -->
<script type="text/javascript">
$(document).ready(function() {

$("img[@src$=png], #caption").pngfix({
	sizingMethod: "scale"
});

});
</script>
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<link href="navi/DropDownMenu.css" rel="stylesheet" type="text/css" media="all" />
<script src="js/navi.js" type="text/javascript"></script>
<script src="navi/DropDownMenu.js" type="text/javascript"></script>
<script type="text/javascript" src="js/swfobject.js"></script>
</head>

<body>
<!--HEADER START-->
<div id="headerWrapper">
	<div id="header">
		<h1><a href="../../"><img src="../../images/navi/logo.gif" alt="Line-prop 316" width="205" height="39" /></a></h1>
		<ul>
			<li><a href="../../news/"><img src="../../images/navi/naviNews.gif" alt="お知らせ" /></a></li>
			<li><a href="../../products/line-prop-316/index.html"><img src="../../images/navi/naviProducts.gif" alt="製品案内" /></a></li>

			<li><a href="../../company/"><img src="../../images/navi/naviCompany.gif" alt="会社案内" /></a></li>
			<li><a href="http://www.takiya.com/contact/" target="_blank"><img src="../../images/navi/naviContact.gif" alt="お問合わせ" /></a></li>
		</ul>
	</div>
</div>
<!--HEADER END-->

<!--MAIN START-->
<div id="mainWrapper" class="clearfix">
	<div id="main" class="clearfix">
	
		<div id="subNavi">
			<ul><!--
				--><li><!--
					--><ul><!--
						--><li><a href="#" class="menu" id="mmenu1" onMouseOver="mopen(1);" onMouseOut="mclosetime();"><img src="../../images/navi316/lineup.gif" alt="製品紹介" width="128" height="54" /></a>
					<div class="submenu" id="menu1" onMouseOver="mcancelclosetime()" onMouseOut="mclosetime();">
						<a href="rigid.html"><img src="../../images/navi316/rigid.gif" alt="" /></a>
						<a href="flexible.html"><img src="../../images/navi316/flexble.gif" alt="" /></a>
						<a href="terminal.html"><img src="../../images/navi316/terminal.gif" alt="" /></a>						</div>
						</li><!--
						--><li><a href="feature.html"><img src="../../images/navi316/feature.gif" alt="製品の特徴" /></a></li><!--
						--><li><a href="selection.html"><img src="../../images/navi316/select.gif" alt="部品の選定方法" /></a></li><!--
						--><li><a href="safety.html"><img src="../../images/navi316/safety.gif" alt="安全にお使いいただくために" /></a></li><!--
						--><li><a href="length.html"><img src="../../images/navi316/length.gif" alt="ワイヤ長さ算出方法" /></a></li><!--
					--></ul>
				</li>
			</ul>
		</div>
		
	
	</div>
</div>

<div>
	<div id="mainContents">
	
		<div id="column1">

			<div id="productsImage">
				<img src="http://www.takiya.com/products/images/main/<? echo $image; ?>" />
				<?
				
				if($image2 != ""){
					print <<< EOF
				<br /><img src="http://www.takiya.com/products/images/main/$image2" />			
EOF;
				}
				if($image3 != ""){
					print <<< EOF
				<br /><img src="http://www.takiya.com/products/images/main/$image3" />			
EOF;
				}		
				
				
				?>
			</div>
			<div id="info">
				<h3><? echo $productName; ?></h3>
				<p id="detail"><? echo $detail; ?></p>
				<h4>価格</h4>
				<table border="0" cellpadding="0" cellspacing="0" id="price"><? echo $Main_form; ?></table>

			</div>


		</div>
</div>


<!--MAIN END-->

<!--FOOTER START-->
<div id="footerWrapper">
	<div id="footer">
		<div id="copyRight">
		<p>「ラインプロップ」はタキヤ株式会社のオリジナルブランド商品です。<br />
			使用及び価格については、改良のため予告なく変更する場合があります。<br />
			サイトに掲載されているイラストおよび写真などを無断で複製・転載する事を禁じます。</p>
			<p><img src="../../images/cp.gif" alt="Copyright (c) 2010. TAKIYA All right reserved." /></p>
		</div>
		<div id="language">
			<ul>
			</ul>
		</div>
	</div>
</div>
<!--FOOTER END-->

</body>
</html>
