Get all posts which contain specific shortcode

While working on some project, I was stuck on one issue.

The issue was, User was multiple posts and he was use my shortcode on some of them.

And I was trying to figure out which are the posts which content have my shortcode.


The answer is in my question. To do this I need to search the shortcode from all the post content.

To achieve this I have used SELECT query. E.g.

My shortcode was something like myshortcode (Not exactly this shortcode, I have use this shortcode for example purpose.)

Example 1: Search shortcode myshortcodein all the posts. (Including posts, pages, custom post types)

global $wpdb;
$ids = $wpdb->get_row("SELECT ID FROM {$wpdb->postmeta} WHERE meta_value LIKE '%myshortcode%'", ARRAY_A);

// print_r( $ids ); // Print all the IDs.

Above SELECT query return the array of IDs of all the posts, pages, custom post types which post content contain myshortcode.


Example 2: Search shortcode myshortcode ONLY in PAGES.

global $wpdb;
$ids = $wpdb->get_row("SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE '%[myshortcode AND post_type='page'", ARRAY_A);

// print_r( $ids ); // Print all the IDs.

List of all default Rest API endpoints in WordPress website

In WordPress there are lot of default rest API endpoints which may help you while development.

How to access rest API endpoints?

You can access rest API endpoints though URLs. E.g. http://wpdigits.com/wp-json/wp/v2/posts

Above URL show the list of all posts in the form of JSON.

In this example endpoint, Domain name is http://wpdigits.com/ and the /wp-json/ shows all the default endpoints.


Below is the list of all default rest API endpoints from any WordPress fresh setup.

/wp/v2/posts,
/wp/v2/posts/(?P<id&gt;[\d]+),
/wp/v2/posts/(?P<parent&gt;[\d]+)/revisions,
/wp/v2/posts/(?P<parent&gt;[\d]+)/revisions/(?P<id&gt;[\d]+),
/wp/v2/posts/(?P<id&gt;[\d]+)/autosaves,
/wp/v2/posts/(?P<parent&gt;[\d]+)/autosaves/(?P<id&gt;[\d]+),
/wp/v2/pages,
/wp/v2/pages/(?P<id&gt;[\d]+),
/wp/v2/pages/(?P<parent&gt;[\d]+)/revisions,
/wp/v2/pages/(?P<parent&gt;[\d]+)/revisions/(?P<id&gt;[\d]+),
/wp/v2/pages/(?P<id&gt;[\d]+)/autosaves,
/wp/v2/pages/(?P<parent&gt;[\d]+)/autosaves/(?P<id&gt;[\d]+),
/wp/v2/media,
/wp/v2/media/(?P<id&gt;[\d]+),
/wp/v2/blocks,
/wp/v2/blocks/(?P<id&gt;[\d]+),
/wp/v2/blocks/(?P<id&gt;[\d]+)/autosaves,
/wp/v2/blocks/(?P<parent&gt;[\d]+)/autosaves/(?P<id&gt;[\d]+),
/wp/v2/types,
/wp/v2/types/(?P<type&gt;[\w-]+),
/wp/v2/statuses,
/wp/v2/statuses/(?P<status&gt;[\w-]+),
/wp/v2/taxonomies,
/wp/v2/taxonomies/(?P<taxonomy&gt;[\w-]+),
/wp/v2/categories,
/wp/v2/categories/(?P<id&gt;[\d]+),
/wp/v2/tags,
/wp/v2/tags/(?P<id&gt;[\d]+),
/wp/v2/users,
/wp/v2/users/(?P<id&gt;[\d]+),
/wp/v2/users/me,
/wp/v2/comments,
/wp/v2/comments/(?P<id&gt;[\d]+),
/wp/v2/search,
/wp/v2/block-renderer/(?P<name&gt;core/block),
/wp/v2/block-renderer/(?P<name&gt;core/latest-comments),
/wp/v2/block-renderer/(?P<name&gt;core/archives),
/wp/v2/block-renderer/(?P<name&gt;core/categories),
/wp/v2/block-renderer/(?P<name&gt;core/latest-posts),
/wp/v2/block-renderer/(?P<name&gt;core/shortcode),
/wp/v2/settings,
/wp/v2/theme

Create the post on wordpress.com site using oAuth and Rest API

Working on Rest API and OAuth is very interesting.

WordPress merged Rest API support into the core in WordPress 4.7 “Vaughan” check out the Rest API Merge Proposal.

In this post, I’m creating the post on my site https://maheshwaghmare.wordpress.com/ though rest API and OAuth.

Let’s Try it Step by Step

Step 1:

Create new app wordpress.com app from https://developer.wordpress.com/apps/new/

OR

Do you already have an app then select existing app from https://developer.wordpress.com/apps/

Step 2:

Copy below code and add your app authentication details. After adding details you get and auth key.

// Step: 1  Add authentication details to get auth key.
$auth_args = array(
	'username'      => '',
	'password'      => '',
	'client_id'     => '',
	'client_secret' => '',
	'grant_type'    => 'password', // Keep this as it is.
);
$access_key = get_access_key( $auth_args );

Note: Keep grant_type as password. Its required!

  • username – Your website username.
  • password – Your website password.
  • client_id – Your App client ID.
  • client_id – Your App client ID.

Step 3:

Use below function which return the auth key from your given app details.

/**
 * Get Access Key.
 * 
 * @param  array $args 	Auth arguments.
 * @return mixed       	Auth response.
 */
function get_access_key( $args ) {

	// Access Token.
	$curl = curl_init( 'https://public-api.wordpress.com/oauth2/token' );
	curl_setopt( $curl, CURLOPT_POST, true );
	curl_setopt( $curl, CURLOPT_POSTFIELDS, $args );
	curl_setopt( $curl, CURLOPT_RETURNTRANSFER, 1);
	$auth = curl_exec( $curl );
	$auth = json_decode($auth);

	// Access Key.
	return $auth->access_token;
}

Step 4:

Add your new post details. Such as post title, post content etc. like below:

// Step: 2  Set post arguments and pass it create the post.
$post_args = array(
	'title'       => 'Hello APA World',
	'content'     => 'Hello. I am a test post. I was created by the API',
	'tags'        => 'tests',
	'post_status' => 'draft',
	'categories'  => 'API',
);

Step 5:

Now, Simply call a function and pass the Auth key and post arguments.

// Create a post with the access key.
create_post( $access_key, $post_args );

Step 6:

/**
 * Create post with access key.
 * 
 * @param  string $access_key 	Access key.
 * @param  array $post_args 	Post arguments.
 * @return mixed       			Post response.
 */
function create_post( $access_key, $post_args )
{
	$options  = array (
		'http' => array(
			'ignore_errors' => true,
			'method'        => 'POST',
			'header'        => array(
		    	0 => 'authorization: Bearer ' . $access_key,
		    	1 => 'Content-Type: application/x-www-form-urlencoded',
		  	),
		  	'content' => http_build_query( $post_args ),
		),
	);
	 
	$context  = stream_context_create( $options );
	$response = file_get_contents(
	    'https://public-api.wordpress.com/rest/v1/sites/YOURSITEID/posts/new/',
	    false,
	    $context
	);
	return json_decode( $response );
}

Here,

https://public-api.wordpress.com/rest/v1/sites/YOURSITEID/posts/new/

Replace YOURSITEID with your wordpress.com site ID.

To get it follow below quick simple steps:

  • Goto api console
  • Add string /me/sites and select method GET
  • Press Enter.

It’ll show all your sites from WordPress.com. Check the below screenshot for reference.


Step 7:

Yup! Its not a step.

That’s it. Your first post successfully created!

Use below Complete Code snippet.Try this and let me know in comments.

The complete code snippet to create a post on wordpress.com is below:

Conclusion

In above example you can create a post on wordpress.com with the help of get_access_key() and create_post() functions from above code snippet.

Note: use unique prefix for get_access_key and create_post() to avoid the conflict with existing function with same name.

Working with Rest API is pretty simple. Let’s try it and let me know in comments.

Git vs SVN commands

We use Git and SVN for managing projects.

I personally work on Github, GitLab and BitBucket. I’m more familiar with Git commands.

WordPress itself use the SVN for hosting plugins and themes. I have created a WordPress Theme and Plugins. But, I personally not use SVN though command line.

I personally use Tortoise SVN for managing my theme and plugins. It provides a GUI (Graphic User Interface) which allow working on SVN with a very easy way. Read more about Tortoise SVN.

I was always querying about,

  1. How to work on SVN though command line?
  2. Which are the basic SVN commands like Git?
  3. What is the difference between Git and SVN commands?
  4. etc.

I’ll create an article on all the above questions which I have tried to resolve soon.

For now, I have created a table of Git vs SVN commands. You can also check below the table of Git vs SVN commands for reference.

Description GIT Command SVN Command
Copy a repository git clone svn checkout
Record changes to file history git commit svn commit
View commit details git show svn cat
Confirm status git status svn status
Check differences git diff svn diff
Check log git log svn log
Addition git add svn add
Move git mv svn mv
Delete git rm svn rm
Cancel change git checkout svn revert1
Cancel change git reset svn revert1
Make a branch git branch svn copy2
Switch branch git checkout svn switch
Merge git merge svn merge
Create a tag git tag svn copy2
Update git pull svn update
Update git fetch svn update
It is reflected on the remote git push svn commit
Ignore file list .gitignore .svnignore

 

Get all posts by post meta key and meta value

Description

For some situations, we need to get all the posts which have specific meta key and meta value.

We can do it with the help of the WP_Query class.

Example

Note: I’m giving you an imaginary example just for a reference to understand, In which situation you can use below code snippet.

Suppose,

  • We have a custom post type properties.
  • We have 15 properties are published.
  • We have store the location of each property in meta key property-location
  • And, We want to get all the properties which meta key is property-location with meta value Pune.

Code Snippet

$query_args = array(
	'post_type'  => 'properties',
	'meta_query' => array(
	    array(
			'key'   => 'property-location',
			'value' => 'Pune',
	    ),
	)
);

$query = new WP_Query( $query_args );

Here,
post_type is our custom post type slug. In our example its properties.
key is meta key. In our example its property-location
value is meta value. In our example its Pune

Gist Snippet

You can use below complete gist code snippet for reference.
Note: In below code snippet you need to change the parameters as you need.


Here,
I have added some extra parameters to optimize the WordPress query.

  • fields with value ids which return ONLY array post IDs of all found items.
  • no_found_rows with value true which optimizes the query.
  • posts_per_page with value -1 to get all the posts. Default it return only 10 items.

Show all READY scheduled events OR READY corn jobs in WordPress

Description

By using the function wp_get_ready_cron_jobs() to get all the READY scheduled events OR READY corn jobs.

Note: Use below code snippet for ONLY debugging/development purpose.

Code Snippet

Output

Array
(
    [1551289036] => Array
        (
            [wp_import_astra_sites_cron] => Array
                (
                    [40cd750bba9870f18aada2478b24840a] => Array
                        (
                            [schedule] => wp_import_astra_sites_cron_interval
                            [args] => Array
                                (
                                )

                            [interval] => 300
                        )

                )

        )

)

Show all scheduled events OR corn jobs in WordPress

Description

By using the funciton wp_get_schedules () to get all the scheduled events OR corn jobs.

Note: Use below code snippet for ONLY debugging/development purpose.

Code Snippet

Output

Array
(
    [wp_import_astra_single_site_cron_interval] => Array
        (
            [interval] => 300
            [display] => Every 5 Minutes
        )

    [wp_import_astra_images_site_cron_interval] => Array
        (
            [interval] => 300
            [display] => Every 5 Minutes
        )

    [wp_import_astra_site_terms_cron_interval] => Array
        (
            [interval] => 300
            [display] => Every 5 Minutes
        )

    [wp_import_astra_sites_cron_interval] => Array
        (
            [interval] => 300
            [display] => Every 5 Minutes
        )

    [hourly] => Array
        (
            [interval] => 3600
            [display] => Once Hourly
        )

    [twicedaily] => Array
        (
            [interval] => 43200
            [display] => Twice Daily
        )

    [daily] => Array
        (
            [interval] => 86400
            [display] => Once Daily
        )

)