Coilover Kit Search
template_dir = './templates/';
$smarty->compile_dir = './templates_c/';
$queryString=("SELECT product_name,
url,
icon,
product_cat,
price,
product_code,
price,
price_with_tax,
adjust_range_f,
adjust_range_r,
maxrange_f,
maxrange_r,
spring_varie_f,
spring_varie_r,
upper_mount_f,
upper_mount_r,
height_adjust_type_f,
height_adjust_type_r,
damping_adjust_f,
damping_adjust_r,
sample_height,
econ,
fit_info,
note FROM enadjust WHERE ". "manufact='". $manufact. "' and car_name='". $car_name. "' and kata='". $kata. "'");
// for debug
//print $queryString;
include 'dbcon.php';
//DB接続
$conn = mysql_pconnect($hostname, $username, $password) or die("データベースの接続に失敗しました。");
mysql_query("SET NAMES utf8",$conn);
//結果取得
$result=mysql_db_query($dbname,$queryString);
while($data = mysql_fetch_array($result, MYSQL_ASSOC)) {
//Smartyに投げる
$smarty->append("resultSet", $data);
}
//Smartyに検索項目を投げる
$smarty->assign("Manufacturer", $manuInfo);
$smarty->assign("carname", $carInfo);
$smarty->assign("kata", $kataInfo);
$smarty->display("coilover_kit.tpl");
?>