My new Plugin for making cURL calls

Posted on December 2, 2012 by Eli Scheetz

I created this plugin that uses a shortcode to call wp_remote_get with parameters you pass to parsed and display a bit of HTML from a page on another site. You can include this shortcode in your page or post.

Here is an example of the shortcode that will display the Download Stats page for this Plugin on WordPress.org:
[remote_get url="https://wordpress.org/plugins/shortcurl/" start='<div class="entry-meta"' stop='!-- .entry-meta --' length="-1"].
and this is what you get:

Download of SHORTcURL from WordPress.org

26 thoughts on “My new Plugin for making cURL calls”

bobschecter on March 14, 2013 at 2:12 am said:

Since there seems to be no simple solution to resizing an iframe, your plugin/shortcode might work, except I have no idea how.

I’m trying to just grab a webpage http://dmiworks.com/announce.html and insert it into a WordPress page. It seems it will size the page according to the content. Nevertheless, I am lost. Am I barking up the wrong tree? Thanks

Reply ↓
- Eli Scheetz on March 14, 2013 at 7:42 am said:
  
  I just did a llittle testing on that URL you gave and here is what I found…
  
  This is simple and it works but it may no look great on your site depending on you CSS:
  [remote_get url="http://dmiworks.com/announce.html"]
  
  Then I tried this to bring in the images and cut out the header:
  [remote_get url="http://dmiworks.com/announce.html" start='<div ' stop='</body>' replace='src="' with='src="http://dmiworks.com/']
  
  Then I used this to bring in the CSS styles:
  [remote_get url="http://dmiworks.com/announce.html" start='<style ' stop='</body>' replace='src="' with='src="http://dmiworks.com/' replace2='href="' with2='href="http://dmiworks.com/']
  
  I have to say this is a difficult page to bring into another site because of all the positioning styles.
  
  Good luck!
  
  Reply ↓
bobschecter on March 14, 2013 at 7:55 am said:

Oh yeah! That’s it. Damn I wish I understood it all, but it works nonetheless. Thanks Eli

Reply ↓
bobschecter on March 15, 2013 at 2:00 am said:

Oops, one thing I keep forgetting is that the “preview” doesn’t always match up to the “saved” version in WordPress. Once I saved it, I got an error:

Fatal error: Cannot use object of type WP_Error as array in /home/schecter/public_html/nickyscorner/wp-content/plugins/shortcurl/index.php on line 71

Reply ↓
- Eli Scheetz on March 15, 2013 at 7:26 am said:
  
  This is a bug in error handling. It was easy to fix though. You can fix it using the plugin editor built into WordPress.
  Just change:
  print_r($got['url'], true)
  to:
  print_r($got, true)
  toward the end of line 71.
  
  Reply ↓
smrk on March 25, 2013 at 1:00 am said:

Hey there, your plugin looks like something I exactly was looking for. But I have some questions:
– is there any possibility to specify, that content of external page is in another charset (windows-1250 f.e.) and convert it into utf-8?
– Caching idea is great, but is there any chance to disable content caching or change the caching period (maybe by some parameter)? Because when Im trying debug blog post or page where I have shortcurl, it holds first version of content I have inserted.
Thanks anyway for your plugin! s.

Reply ↓
- Eli Scheetz on March 25, 2013 at 5:19 pm said:
  
  I’m not really sure how you you could change the character encoding, but changing the cache timeout setting is a great idea. I released an update to this plugin that allows you to pass an “expire” paramater to the remote_get shortcode. It will still default to 24 hours (60*60*24), but if you pass it a “1” (meaning 1 second) then you will not get the cached results.
  
  Please let me know how this works for you.
  
  Aloha, Eli
  
  Reply ↓
  - smrk on March 26, 2013 at 11:53 pm said:
    
    Thanks for your time and reply! I dont understand it. It is still caching, but now I’m not sure it is issue of your plugin. Im trying to embed a part of page which is dynamically generated by date parameter in url into post (or page) on my site. Cache directory in Shortcurl plugin’s directory is empty. I have no cache plugin installed in my WordPress. But anyway, if I change this date parameter in url used in shortcode (to embed content from another day) it still holds content, like I never change anything. Doesn’t matter if I’m updating page (or post) or create new one. When I paste this changed url right into browser’s adress bar, I can see exactly what I expect – content from day specified in date parameter. As I said, Im confused. Expire parameter in shortcode unfortunately doesn’t help in my case. s.
    
    Reply ↓
    - Eli Scheetz on March 27, 2013 at 6:30 am said:
      
      Can you give me some examples so I can try it too, or give me a login to edit the page on your site that you are working on?
      
      Reply ↓
      - smrk on April 8, 2013 at 8:53 am said:
        
        I have found another source which im processing on temp page (by PHP Simple HTML DOM Parser, because html code of this source is really poor and I want my WP blog valid). And your CURL plugin helps mi insert content from this temp page into my wordpress blog (with no caching issue). So everything now works right for me. Thanks.
      - Eli Scheetz on April 8, 2013 at 9:09 am said:
        
        That’s great. I could not get that other page to load right either, but I could get other dynamic pages to load. I must admit I had a hard time testing that content becuase I couldn’t read the language that the content was in. I don’t think it was a caching issue anyway but I’m glad you got it working another way.
GRT on May 27, 2013 at 9:14 am said:

Hi Eli, this plugin does what I need, GREAT, however can’t get it to work on multisite. I’m not a coder but hope it will be easy to resolve. THX

Reply ↓
- Eli Scheetz on May 27, 2013 at 12:12 pm said:
  
  Thanks, and sorry it’s not working for you on multisite. If you want to send me a WP Admin login I can troubleshoot the problem and find a fix for it.
  
  (Comments with private info will not be published on my site)
  
  Reply ↓
GRT on May 29, 2013 at 1:40 am said:

Hi Eli, figured it out, your plugin does not go well with Shortcodes Ultimate. Without this plugin yours worked fine on multisite. KR

Reply ↓
- Eli Scheetz on June 1, 2013 at 7:01 am said:
  
  Thanks for letting me know. I will look into this and see if there is anything I can do to accomodate this other plugin.
  
  Reply ↓
Radar on June 10, 2013 at 10:39 am said:

Hi, this plugin looks like something I really could use. I’m not the good in coding. How coul I fetch the ‘385’ pricing on the following page http://www.corendon.nl/titanic-beach-resort/antalya/turkije/hotel

Reply ↓
- Eli Scheetz on June 10, 2013 at 8:32 pm said:
  
  I’m not sure exactly what you want but here is an example that may be close to what you need:
  [remote_get url="http://www.corendon.nl/titanic-beach-resort/antalya/turkije/hotel" start='<div class="accoLowestPrice"' stop='<div class="tripsListing"']
  
  Reply ↓
  - Radar on June 24, 2013 at 11:28 am said:
    
    Thanks Eli! You helped me a lot.
    
    Can you see away to only get thwe pricing? See http://www.hoteltitanic.be/
    
    I tried the following [button]vanaf [remote_get url="http://www.corendon.be/titanic-beach-resort/antalya/turkije/hotel" start='<div class="acco_price pricerange" ' stop='</span'][/button]
    
    The problem is there is some sort of a break I can’t get rid of.
    
    Reply ↓
    - Eli Scheetz on June 24, 2013 at 1:42 pm said:
      
      Try wrapping the remote_get shortcode in my preg_replace shortcode to get rid of all the tags. So your whole button shortcode call would look somthing like this:
      
      [button]vanaf [preg_replace replace='/<.*?>/' with=''][remote_get url=”http://www.corendon.be/titanic-beach-resort/antalya/turkije/hotel” start=’
      
      Reply ↓
Flick on June 25, 2013 at 11:44 am said:

Hi Eli, really excited by your plugin – someone suggested it to me a while back but I have not had a chance to experiment with it till today.

Thank you for replying to previous comments – it made it easier for me to build my first curl query that also brought in styles/images.

On the test page I am experimenting with, the content in the table can be sorted using a select script – http://pastebin.com/GKaP2bce – so I thought it would be possible to replace ‘/cgi/’ with the full url of the source and the cgi folder. But it hasn’t worked – thus far, so was wondering if this was feasible and if so, what might be the best way of approaching it?

Many thanks in advance

Reply ↓
- Flick on June 25, 2013 at 12:02 pm said:
  
  Sorry – just to say that I was using replace3/with3 to do the search; using replace2/with2 seems to work fine for the actual replacement. Is there any chance replace3/4/5 may become available in future?
  
  Sadly the script actually loads the source page (rather than being in-situ on the site) so it looks as though I might need to investigate further about other options. Your advice would be very much welcomed :)
  
  Thanks again
  
  Reply ↓
  - Eli Scheetz on June 25, 2013 at 12:35 pm said:
    
    The remote_get shortcode only has replace/with and replace2/with2 to execute str_replace on the returned content. However, I think you might find my preg_replace shortcode in this same plugin to be exactly what you are looking for. Just wrap your remote_get call inside the preg_replace shortcode like this:
    [preg_replace replace='/regex/' with='text'][remote_get url='http://pastebin.com/GKaP2bce'][/preg_replace]
    
    You can use as many replaceX/withY pairs in the preg_replace shortcode as you can keep track of. One difference in the preg_replace shortcode though is that the replace attributes are REGEX not strings, so you should use one of the following to look for this path that contains slashes:
    replace=’/\/cgi\//’
    replace=’#/cgi/#’
    or if you want to replace the single quote too:
    replace=”#’/cgi/#'” with=”‘http://pastebin.com/cgi/”
    
    Hope that helps. Let me know how that works for you.
    
    Reply ↓
Dominic on September 14, 2013 at 8:55 pm said:

Hi Eli,

Found your script the other day and it’s proven to be a huge asset. I do have a question though.

I’m attempting to grab data from a website which forces you to view an advertisement for 15 seconds or click on a “continue to site” button.

When I do any query for data from the site, the advertisement page loads and after the countdown finishes it just refreshes the webpage and the advertisement starts over.

The website is http://www.mlgpro.com

Is there any way to bypass this issue, or do I simply have to find another site to get the data from?

Thanks a lot in advance.

Reply ↓
- Eli Scheetz on September 15, 2013 at 7:01 am said:
  
  That site look carefully crafted to be sure of displaying those add. What you want to do may be possible but it would take a log of experimentation and delicate engineering to get past all the adds to the content within. I would say it would be far easier if you could find another site to get this content from.
  
  Reply ↓
João Paulo on December 17, 2015 at 3:16 am said:

Hello.

I’m using this plugin on my blog. I have an issue here. When I visit my blog home, the plugin is not working on preview text before the “read more” tag on post. It only works on post view.

What should I do?

Thanks in advance!

Reply ↓
- Eli Scheetz on December 17, 2015 at 9:43 am said:
  
  I don’t know for sure but maybe your theme does not support shortcodes in the excerpts. Can you send me a link to the page where you are using the shortcode so I can see how it’s being implemented?
  
  Reply ↓

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/my-new-plugin-for-making-curl-calls/', 'CONTEXT_DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html', 'CONTEXT_PREFIX' => '', 'DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING' => 'br,gzip', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_AUTHORIZATION' => '', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'wordpress.ieonly.com', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'PATH' => '/bin', 'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins', 'QUERY_STRING' => '', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_HTTP_AUTHORIZATION' => '', 'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins', 'REDIRECT_SSL_TLS_SNI' => 'wordpress.ieonly.com', 'REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZRM5TVgilMtnKh4@673cdAAAAAM', 'REDIRECT_URL' => '/my-new-plugin-for-making-curl-calls/', 'REMOTE_ADDR' => '3.214.184.223', 'REMOTE_PORT' => '47512', 'REQUEST_METHOD' => 'GET', 'REQUEST_SCHEME' => 'https', 'SCRIPT_FILENAME' => '/home/elijah/sites/wordpress.ieonly.com/public_html/index.php', 'SCRIPT_NAME' => '/index.php', 'SERVER_ADDR' => '158.69.23.200', 'SERVER_ADMIN' => 'root@localhost', 'SERVER_NAME' => 'wordpress.ieonly.com', 'SERVER_PORT' => '443', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'SERVER_SIGNATURE' => '', 'SSL_TLS_SNI' => 'wordpress.ieonly.com', 'UNIQUE_ID' => 'ZRM5TVgilMtnKh4@673cdAAAAAM', 'dont_vary' => '1', 'no_gzip' => '1', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1695758669.302425, 'REQUEST_TIME' => 1695758669, );

INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695758669.7881190776824951171875', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (410) ORDER BY t.name ASC ;

INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-09', 40690, 7541, 16079, 59, '2023-09-26 20:04:30', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-26 20:04:30', wp_user = 0, hit_count = hit_count + 1;

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC ;

SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (410) ORDER BY t.name ASC ;

SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2092,2094,2095,2102,3957,3962,3966,4000,4063,8498 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2093,2097,2103,3959,3963,3968,4001,4064,8501 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2114,3990,4002 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2120,3991 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2281 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2282 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;

Profiler Initiaded	0.0000 ms	36337 kB
Profiler Noise	0.0041 ms	36337 kB
Profiler Stopped	1,053.0329 ms	93788 kB

0.2198 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.0629 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.0701 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/3.214.184.223/1695758669.4289' LIMIT 1;`
0.1929 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;`
0.1249 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.1440 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.2091 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.0861 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.0770 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.0761 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.0989 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.0708 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.1051 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.1581 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;`
0.0808 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.0899 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;`
0.0770 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.0770 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;`
0.0789 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1960 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.0789 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.4149 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.0930 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.1979 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.0761 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.0770 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;`
0.0730 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;`
0.1280 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.0858 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;`
0.0820 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;`
0.1068 [ms]	`SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0730 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.1662 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.0751 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.0691 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.0780 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.0801 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;`
0.0701 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.0689 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.0691 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.0679 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.0670 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.0710 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.0670 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0689 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.0780 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0701 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0689 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0679 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0670 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.0789 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;`
0.0691 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;`
0.4740 [ms]	INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695758669.7881190776824951171875', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
0.2918 [ms]	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('my-new-plugin-for-making-curl-calls') AND post_type IN ('page','attachment') ;`
0.1791 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'my-new-plugin-for-making-curl-calls' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC ;`
0.2689 [ms]	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (410) ORDER BY t.name ASC ;`
0.1721 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (86,84,85);`
0.1121 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (410) ORDER BY meta_id ASC;`
0.1171 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.214.184.223';`
0.0951 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'CCBot/2.0 (https://commoncrawl.org/faq/)';`
0.0870 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.0930 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/my-new-plugin-for-making-curl-calls/';`
0.4141 [ms]	INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-09', 40690, 7541, 16079, 59, '2023-09-26 20:04:30', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-26 20:04:30', wp_user = 0, hit_count = hit_count + 1;
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.0751 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.0758 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.1199 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;`
0.1152 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.0751 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.1400 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 105;`
0.3009 [ms]	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC ;`
0.3130 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (620,623,624,626,628,629) ORDER BY meta_id ASC;`
0.1528 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (44,103,21,35);`
0.1111 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;`
0.1669 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (410) ORDER BY t.name ASC ;`
0.2921 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.0870 [ms]	`SELECT * FROM wp_users WHERE ID IN (1);`
0.1371 [ms]	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2012-12-02 14:37:25' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1;`
0.0939 [ms]	`SELECT * FROM wp_posts WHERE ID = 406 LIMIT 1;`
0.1221 [ms]	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2012-12-02 14:37:25' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1;`
0.0911 [ms]	`SELECT * FROM wp_posts WHERE ID = 426 LIMIT 1;`
0.3841 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.1390 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2092,2094,2095,2102,3957,3962,3966,4000,4063,8498);`
0.2100 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2092,2094,2095,2102,3957,3962,3966,4000,4063,8498 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.1240 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2093,2097,2103,3959,3963,3968,4001,4064,8501);`
0.1850 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2093,2097,2103,3959,3963,3968,4001,4064,8501 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.1020 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2114,3990,4002);`
0.1700 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2114,3990,4002 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.0939 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2120,3991);`
0.2129 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2120,3991 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.0851 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2281);`
0.1609 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2281 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.0839 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2282);`
0.1500 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 410 AND comment_parent IN ( 2282 ) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC ;`
0.1259 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;`

Eli's WordPress Blog

My WordPress Plugins, and other stuff.

My new Plugin for making cURL calls

Ratings

Contributors

Support

Donate

26 thoughts on “My new Plugin for making cURL calls”

Leave a Reply Cancel reply

Meta

Ratings

Contributors

Support

Donate

26 thoughts on “My new Plugin for making cURL calls”

Leave a Reply Cancel reply