The Easiest Way to Save and Share Code Snippets on the web

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