$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 "レコード取得に失敗しました。\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 .= <<$priceData[0] EOF; if( $priceData[1] != ""){ $_price = number_format($priceData[1]); $priceData[1] = number_format(ceil($priceData[1]*1.05)); $Main_form .= <<< EOF $_price 円(税込 $priceData[1]円 ) EOF; } $Main_form .= <<< EOF EOF; $amari = $pricePointer%4; if($amari==3){ $Main_form .= << EOF; } $pricePointer++; } } // MySQL 切断 mysql_close($link); ?> ラインプロップ 316 端末部品 詳細 - タキヤ株式会社 if($image2 != ""){ print <<< EOF EOF; } if($image3 != ""){ print <<< EOF EOF; } ?> echo $productName; ?> echo $detail; ?> 価格 echo $Main_form; ?>
echo $detail; ?>