Wordpress中自定义字段 custom fields 多字段 查询
程序员文章站
2022-05-05 16:15:14
...
Wordpress中实现多个自定义字段 custom fields 查询 例如下图
step1
插入字段wordpress会自动加入 wp_postmeta表中去
注意:最好想好要加那些字段 再添加 wordpress不支持 通过界面删除自定义字段
必须要通过SQL语句删除
Step2
在TwentyEleven 主题的基础上的index.php文件中 添加上如下代码
<?php /** * The main template file. * * This is the most generic template file in a WordPress theme * and one of the two required files for a theme (the other being style.css). * It is used to display a page when nothing more specific matches a query. * E.g., it puts together the home page when no home.php file exists. * Learn more: http://codex.wordpress.org/Template_Hierarchy * * @package WordPress * @subpackage Twenty_Eleven */ get_header(); ?> <script language="JavaScript" type="text/JavaScript"> function showorhidediv(){ var sizeRadio=document.getElementById("SizeRadio"); var vehicleRadio=document.getElementById("VehicleRadio"); var size=document.getElementById("SizeDiv"); var vehicle=document.getElementById("VehicleDiv"); if(sizeRadio.checked) { vehicle.style.display='none'; size.style.display='block'; } else if(vehicleRadio.checked) { size.style.display='none'; vehicle.style.display='block'; } } </script> <div id="primary"> <div id="content" role="main"> <form method="get" action=""> Search Tyres By <input type="radio" name="category" value="Vehicle" id="VehicleRadio" onClick="showorhidediv()" checked/> <label for="VehicleRadio">Vehicle</label> <input type="radio" name="category" value="Size" id="SizeRadio" onClick="showorhidediv()"/> <label for="SizeRadio">Size</label> <div id="SizeDiv" style="width:300px; height:150px;border:1px red solid;"> <select name="car" id="car" size="1"> <option value='' selected="true">Car</option> <option value='CR_V'>CR_V</option> <option value='BMW'>BMW</option> <option value='Truck'>Truck</option> <option value='BENZ'>BENZ</option> <option value='QQ'>QQ</option> </select> <br/> <select name="tread" id="tread" size="1"> <option value='' selected="true">Tread Width</option> <option value='130'>130</option> <option value='140'>140</option> <option value='150'>150</option> <option value='450'>450</option> <option value='550'>550</option> <option value='650'>650</option> <option value='750'>750</option> </select> <br/> <select name="sidewallheight" id="sidewallheight" size="1"> <option value='' selected="true">SideWall Height</option> <option value='130'>130</option> <option value='140'>140</option> <option value='150'>150</option> <option value='450'>450</option> <option value='550'>550</option> <option value='650'>650</option> <option value='750'>750</option> </select> <br/> <select name="rim" id="rim" size="1"> <option value='' selected="true">Rim Diameter</option> <option value='130'>130</option> <option value='140'>140</option> <option value='150'>150</option> <option value='450'>450</option> <option value='550'>550</option> <option value='650'>650</option> <option value='750'>750</option> </select> </div> <div id="VehicleDiv" style="width:300px; height:150px;border:1px red solid; display:none;" onClick="showorhidediv()"> vehicle vehicle vehicle </div> <p> <input type="submit" value="SEARCH" /> </p> </form> <?php if ( ($_GET['rim'] == '') && ($_GET['tread'] == '') && ($_GET['car'] == '') && ($_GET['sidewallheight'] == '')) { ?> <?php if ( have_posts() ) : ?> <?php twentyeleven_content_nav( 'nav-above' ); ?> <?php /* Start the Loop */ ?> <?php while ( have_posts() ) : the_post(); ?> <?php get_template_part( 'content', get_post_format() ); ?> <?php endwhile; ?> <?php twentyeleven_content_nav( 'nav-below' ); ?> <?php else : ?> <article id="post-0" class="post no-results not-found"> <header class="entry-header"> <h1 class="entry-title"><?php _e( 'Nothing Found', 'twentyeleven' ); ?></h1> </header><!-- .entry-header --> <div class="entry-content"> <p><?php _e( 'Apologies, but no results were found for the requested archive. Perhaps searching will help find a related post.', 'twentyeleven' ); ?></p> <?php get_search_form(); ?> </div><!-- .entry-content --> </article><!-- #post-0 --> <?php endif; ?> <?php } else { ?> <?php $searched_posts = get_reviews_by_custom_search(); echo $_GET['car']; foreach ($searched_posts as $searched_post) { echo "<h1 class=\"entry-title\"><a href=\"" . get_permalink($searched_post->ID) . "\">" . $searched_post->post_title . "</a></h1>"; echo "RimDiameter - " . get_post_meta($searched_post->ID,'rim',true) . "<br>"; echo "TreadWidth - " . get_post_meta($searched_post->ID,'tread',true) . "<br>"; echo "Car Make - " . get_post_meta($searched_post->ID,'car',true) . "<br>"; echo "SideWallHeight - " . get_post_meta($searched_post->ID,'sidewallheight',true) . "<br>"; echo "<a href=\"" . get_permalink($searched_post->ID) . "\">Read More</a>"; } } ?> </div><!-- #content --> </div><!-- #primary --> <?php get_sidebar(); ?> <?php get_footer(); ?>
Step3 在functions.php中添加如下代码
function get_reviews_by_custom_search() { global $wpdb; $rim = $_GET['rim']; $tread = $_GET['tread']; $car = $_GET['car']; $sidewallheight = $_GET['sidewallheight']; if ($rim != '') { $rim_sql = " AND wpostmeta.meta_key = 'rim' AND wpostmeta.meta_value = '$rim' "; } if ($tread != '') { $tread_sql = " AND wpostmeta2.meta_key = 'tread' AND wpostmeta2.meta_value = '$tread' "; } if ($car != '') { $car_sql = " AND wpostmeta3.meta_key = 'car' AND wpostmeta3.meta_value like '$car' "; } if ($sidewallheight != '') { $sidewallheight_sql = " AND wpostmeta4.meta_key = 'sidewallheight' AND wpostmeta4.meta_value = '$sidewallheight' "; } $querystr = " SELECT DISTINCT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3,$wpdb->postmeta wpostmeta4 WHERE wposts.ID = wpostmeta.post_id AND wposts.ID = wpostmeta2.post_id AND wposts.ID = wpostmeta3.post_id AND wposts.ID = wpostmeta4.post_id " . $rim_sql . " " . $tread_sql . " " . $car_sql . " " . $sidewallheight_sql . " ORDER BY wposts.post_date DESC "; $searched_posts = $wpdb->get_results($querystr); return $searched_posts; }
推荐阅读
-
WordPress中编写自定义存储字段的相关PHP函数解析
-
WordPress中编写自定义存储字段的相关PHP函数解析,
-
WordPress中给文章添加自定义字段及后台编辑功能区域,
-
WordPress中给文章添加自定义字段及后台编辑功能区域,
-
WordPress中编写自定义存储字段的相关PHP函数解析
-
WordPress中给文章添加自定义字段及后台编辑功能区域
-
MySQL中给自定义的字段查询结果添加排名的方法_MySQL
-
WordPress中给文章添加自定义字段及后台编辑功能区域_PHP
-
WordPress中给文章添加自定义字段及后台编辑功能区域_PHP
-
Wordpress中自定义字段 custom fields 多字段 查询