Untitled
php
last edit: Jan, 3rd 2013 | jump to bottom
<?php include('../../../../wp-config.php'); header('Content-type:text/html;charset=utf-8'); $keyword = $_GET['k']; $sql_full_keyword = "SELECT * from wp_posts WHERE post_title LIKE '$keyword%'"; $search_full_keyword = mysql_query($sql_full_keyword) or die(mysql_error()); search($search_full_keyword,"Full keyword(s) = '$keyword'"); $keywords_split = explode(" ",$keyword); for($i=0;$i<count($keywords_split);$i++){ $sql_split_keyword = "SELECT * from wp_posts WHERE post_title LIKE '$keywords_split[$i]%'"; $search_split_keyword = mysql_query($sql_split_keyword) or die(mysql_error()); search($search_split_keyword,"Split keyword = '$keywords_split[$i]'"); } for($i=0;$i<count($keywords_split);$i++){ $sql_split_keyword = "SELECT * from wp_posts WHERE post_content LIKE '$keywords_split[$i]%'"; $search_split_keyword = mysql_query($sql_split_keyword) or die(mysql_error()); search($search_split_keyword,"Split keyword = '$keywords_split[$i]' (Content)"); } mysql_close(); $tags = str_replace(" ","-",$keyword).",".str_replace(" ",",",$keyword); query_posts(array('post_type'=>array('one','two,'three') ,'tag' => $tags,'posts_per_page'=>-1)); while (have_posts()):the_post(); echo '<li>#'.get_the_ID().' '.get_the_title().'</li>'; endwhile; function search($keyword,$mark){ while($data=mysql_fetch_array($keyword)){ if($data['post_status']=='publish'){ echo '<li>#'.$data['ID'].' '.htmlentities($data['post_title']).' ('.$mark.')</li>'; } } } ?>
88 views




