You can use following methods to redirect a page using jQuery window.location.replace("http://www.keredari.com"); window.location.href = "http:// www.keredari .com"; $(location).attr('href', 'http://www.keredari.com'); $(window).attr("location","http://www.keredari.com");
Use below MySql query to get wordpress posts with featured image SELECT p1 .*, wm2 . meta_value FROM wp_posts p1 LEFT JOIN wp_postmeta wm1 ON ( wm1 . post_id = p1 . id AND wm1 . meta_value IS NOT NULL AND wm1 . meta_key = "_thumbnail_id" ) LEFT JOIN wp_postmeta wm2 ON ( wm1 . meta_value = wm2 . post_id AND wm2 . meta_key = "_wp_attached_file" AND wm2 . meta_value IS NOT NULL ) WHERE p1 . post_status = "publish" AND p1 . post_type = "post" ORDER BY p1 . post_date DESC
Sets join statement variables. If you want DataTables to include data from another table, you can define an a table along with its columns and foreign key relationship. $this->datatables->join('states', 'cities.state_id = states.id', 'left'); $this->datatables->select('cities.id,cities.name,states.name as state_name') ->from('cities');