How to get post detail based on URL of the post
I have a custom php page where I need to display details of a WordPress post based on the URL entered from the Admin. In the Admin, when adding the project detail, we enter few URLs of article post which are linked to this project in a text box. The URLs are stored as comma separated values in the database. Through explode I'm able to fetch all of the URLs but I'm not able to get the details of the post based on the URL.
?php
$mark=explode(',', $rowPr['post_url']);//what will do here
foreach($mark as $out) {
$out;
}
?
So, I'm looking for the custom SQL query outside of WordPress to fetch the post detail based on the URL of the post. I will require the post title, post date, post author etc.
Topic post-meta custom-post-types Wordpress
Category Web