<?php
$phrase = get_the_content();
// This is where wordpress filters the content text and adds paragraphs
$phrase = apply_filters('the_content', $phrase);
preg_match_all('/href="(http:\/\/[^\/"]+\/?)?([^"]*)"*/',$phrase, $matches);
//echo '<pre>';
//print_r($matches[2]);
$i=0;
$string="";
foreach($matches[2] as $val){
$value =substr($val,strpos($val,'/')+1);
$slug=rtrim($value, "/");
$getpostid = $wpdb->get_results( "SELECT ID FROM wp_posts
WHERE post_status= 'publish' AND post_name like '%$slug%'" );
$id=$getpostid[0]->ID;
$ids[]="href=http://blog.saginfotech.com/app-single-post?id=".$id;
}
$newphrase = str_replace($matches[0],$ids, $phrase);
$content =str_replace('"','',$newphrase);
$content =
preg_replace(array('{<a[^>]*><img}','{/></a>}'), array('<img','/>'), $content);
echo $content;
?>
<?php
$page = get_page_by_title( 'About' );
$content = apply_filters('the_content', $page->post_content);
echo $content;
?>
$querystr1 = "SELECT p.ID,p.post_title,t.term_id FROM wp_posts p LEFT JOIN wp_term_relationships rel ON rel.object_id = p.ID LEFT JOIN wp_term_taxonomy tax ON tax.term_taxonomy_id = rel.term_taxonomy_id LEFT JOIN wp_terms t ON t.term_id = tax.term_id where tax.term_taxonomy_id=5 ORDER BY p.ID DESC limit 1"; $pageposts1 = $wpdb->get_results($querystr1); print_r($pageposts1);
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post'
AND $wpdb->posts.post_date < NOW()
ORDER BY $wpdb->posts.post_date DESC
LIMIT 1
";
$pageposts = $wpdb->get_results($querystr, OBJECT);
//print_r($pageposts);
global $wpdb;
$wpdb->insert( 'table name', array( 'col name1' => value,'col name2' => value ),
array('%d','%s' ) );
<?php wp_nav_menu(array(
'menu' => 'header',
'theme_location' => 'primary',
'items_wrap' => '<ul id="%1$s" class="nav navbar-nav navbar-right">
%3$s</ul>' ,
));
//dynamic_sidebar('sidebar-3');
?>
Jaipur