メーカー名(※必須) 車名(※必須) 型式(※必須) その他
template_dir = './templates/'; $smarty->compile_dir = './templates_c/'; if ( strcmp($additional,$compare) == 0 ) { $queryString=("SELECT product_name, url, icon, product_code, price, price_with_tax, adjust_range_f, adjust_range_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,additional, fit_info, note FROM adjustsearch WHERE ". "manufact='". $manufact. "' and car_name='". $car_name. "' and kata='". $kata. "'"); } else { $queryString=("SELECT product_name, url, icon, product_cat, price, product_code, price, price_with_tax, adjust_range_f, adjust_range_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, additional, fit_info, note FROM adjustsearch WHERE ". "manufact='". $manufact. "' and car_name='". $car_name. "' and kata='". $kata. "' and additional='". $additional. "'"); } // 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("index_renew.tpl"); ?>