Code – Raul Sanchez

Get Post By post_name

$post_name = 'my-post';

$querystr = 'SELECT * FROM "wp_posts" WHERE "post_name" = "' $post_name . '"';

$results = $wpdb->get_results($querystr, OBJECT);


if(!empty($results)) {
	foreach ($results as $result) {
		// do your magic
		break;
	}
} else {
	echo 'post '. $post_name . ' was not found.';
}

// see: https://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

$post_name = 'my-post';

$querystr = 'SELECT * FROM "wp_posts" WHERE "post_name" = "' $post_name . '"';

$results = $wpdb->get_results($querystr, OBJECT);

if(!empty($results)) {

foreach ($results as $result) {

// do your magic

break;

}

} else {

echo 'post '. $post_name . ' was not found.';

}

// see: https://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

htaccess: set and use environment variables inside your htaccess

A while ago I learned how to set a variable in my .htaccess that can later on be user in PHP:

.htaccess

PHP:

Something that I could not figure out was how to use the defined variable inside the htaccess. While searching for CORS implementation, I ran across this post on stackoverflow.com:

There there is the answer to my question, how to set and get an environment variable in htaccess:

SetEnvIf Origin "^(.*\.example\.com)$" ORIGIN_SUB_DOMAIN=$1
<FilesMatch "\.woff$">
    Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN
</FilesMatch>

SetEnvIf Origin "^(.*\.example\.com)$" ORIGIN_SUB_DOMAIN=$1

Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN

</FilesMatch>

htaccess: allow access control from subdomains

When having an application running on the top domain of your site you may want to allow subdomains to make ajax requests to the top domain. If that is the case, and if you do not know which subdomain will be making the request, you should consider adding the following rule to you .htaccess file in your top domain:

SetEnvIf Origin "^(.*\.(appcropolis|simplifysites|localhost.+)\.com)$" ORIGIN_SUB_DOMAIN=$1
Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN

1 2	SetEnvIf Origin "^(.*\.(appcropolis\|simplifysites\|localhost.+)\.com)$" ORIGIN_SUB_DOMAIN=$1 Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN

Add Template File to a Post Using Shortcode

// read file
function include_template_file ($template_path=null) {
	if($template_path == null)
		return '';
	ob_start();
    load_template( get_template_directory() .'/'. $template_path );
	$content = ob_get_contents();
	ob_end_clean();
	return $content;
}

// shortcode code
function include_template_shortcode($atts, $content=''){
	 extract( shortcode_atts( array(
	      'path' => null
     ), $atts ) );
	return include_template_file($path);
}

add_shortcode( 'include_template', 'include_template_shortcode' );

// Example:
// [include_template path='assets/my-file.php']

// read file

function include_template_file ($template_path=null) {

if($template_path == null)

return '';

ob_start();

load_template( get_template_directory() .'/'. $template_path );

$content = ob_get_contents();

ob_end_clean();

return $content;

}

// shortcode code

function include_template_shortcode($atts, $content=''){

extract( shortcode_atts( array(

'path' => null

), $atts ) );

return include_template_file($path);

}

add_shortcode( 'include_template', 'include_template_shortcode' );

// Example:

// [include_template path='assets/my-file.php']