Parts Search
template_dir = './templates/';
$smarty->compile_dir = './templates_c/';
$queryString=("SELECT
attach_place,
product_name,
year_of_model,
url,
fit_info,
product_code,
price,
price_with_tax,
product_info,
note,
page_of_catalog
FROM en_parts 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("parts.tpl");
?>