{"id":31219,"date":"2014-08-19T04:09:53","date_gmt":"2014-08-19T04:09:53","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/sql-table-lookup\/"},"modified":"2014-08-19T04:13:10","modified_gmt":"2014-08-19T04:13:10","slug":"sql-table-lookup","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/sql-table-lookup\/","author":7948763,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"0.1","stable_tag":"trunk","tested":"","requires":"3.0","requires_php":"","requires_plugins":"","header_name":"SQL Table Lookup","header_author":"Paul Harvey, SEO, harvest316","header_description":"","assets_banners_color":"","last_updated":"2014-08-19 04:13:10","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"http:\/\/wordpress.org\/extend\/plugins\/sql-table-lookup\/","header_author_uri":"http:\/\/corpseo.com.au\/","rating":5,"author_block_rating":0,"active_installs":10,"downloads":1860,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description"],"tags":[],"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"1"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":[],"screenshots":[],"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[],"plugin_category":[],"plugin_contributors":[94033,94032],"plugin_business_model":[],"class_list":["post-31219","plugin","type-plugin","status-publish","hentry","plugin_contributors-harvest316","plugin_contributors-seo","plugin_committers-harvest316"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/sql-table-lookup.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p>You can use these SQL lookup shortcodes to extract data from any table in your WordPress database:<\/p>\n\n<p>[sql query=\"SELECT a FROM b WHERE c='d';\"]<\/p>\n\n<p>[sql]SELECT a FROM b WHERE c='d';[\/sql]<\/p>\n\n<p>[sql table=\"b\" unique_lookup_field=\"c\" lookup_value=\"d\" return_field=\"a\"]<\/p>\n\n<p>If a table or column name has a space or other unusual character in it, wrap it in &#096;backticks&#096;.  If a value contains a \nspace or other unusual characters, wrap it in 'single quotes'.<\/p>\n\n<p>While I've taken considerable effort to prevent SQL injection attacks by escaping all other dangerous characters with esc_sql (which uses mysql_real_escape_string\/mysqli_real_escape_string and addslashes), I would advise against using this plugin on a site that accepts any kind of posts or comments from untrusted sources.<\/p>","raw_excerpt":"Provides shortcodes to retrieve a value from any table in the WordPress database.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/31219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=31219"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/harvest316"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=31219"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=31219"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=31219"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=31219"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=31219"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=31219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}