{"id":107137,"date":"2019-08-02T14:03:21","date_gmt":"2019-08-02T14:03:21","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/zacwp-phpmyadmin\/"},"modified":"2020-08-15T13:15:22","modified_gmt":"2020-08-15T13:15:22","slug":"zacwp-phpmyadmin","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/zacwp-phpmyadmin\/","author":17374050,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0","stable_tag":"1.0","tested":"5.5.18","requires":"4.6","requires_php":"5.0","requires_plugins":"","header_name":"ZacWP PhpMyAdmin","header_author":"Zacchaeus Bolaji","header_description":"Enables CRUD on tables and records and exporting them to CSV files through minimal database interface from your wp-admin page menu.","assets_banners_color":"fcf8f5","last_updated":"2020-08-15 13:15:22","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/djunehor.com\/donate","header_plugin_uri":"","header_author_uri":"https:\/\/github.com\/makinde2013","rating":0,"author_block_rating":0,"active_installs":10,"downloads":1333,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":[],"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":"2132839","resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":"2132839","resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"2133441","resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"2133441","resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"2132839","resolution":"3","location":"assets","locale":""},"screenshot-4.png":{"filename":"screenshot-4.png","revision":"2132839","resolution":"4","location":"assets","locale":""},"screenshot-5.png":{"filename":"screenshot-5.png","revision":"2132839","resolution":"5","location":"assets","locale":""},"screenshot-6.png":{"filename":"screenshot-6.png","revision":"2132839","resolution":"6","location":"assets","locale":""}},"screenshots":{"1":"<code>PhpMyAdmin Manager<\/code> menu in admin sidebar","2":"View of all the tables on wordpress database","3":"Add new table to database","4":"Settings page to set export file name and rows per page","5":"View all rows in a table","6":"Edit a table row"}},"plugin_section":[],"plugin_tags":[56868,153,1627,1378,2289],"plugin_category":[59],"plugin_contributors":[174632],"plugin_business_model":[],"class_list":["post-107137","plugin","type-plugin","status-closed","hentry","plugin_tags-crud","plugin_tags-database","plugin_tags-mysql","plugin_tags-simple","plugin_tags-table","plugin_category-utilities-and-tools","plugin_contributors-djunehor","plugin_committers-djunehor"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/zacwp-phpmyadmin_fcf8f5.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-1.png?rev=2133441","caption":"<code>PhpMyAdmin Manager<\/code> menu in admin sidebar"},{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-2.png?rev=2133441","caption":"View of all the tables on wordpress database"},{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-3.png?rev=2132839","caption":"Add new table to database"},{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-4.png?rev=2132839","caption":"Settings page to set export file name and rows per page"},{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-5.png?rev=2132839","caption":"View all rows in a table"},{"src":"https:\/\/ps.w.org\/zacwp-phpmyadmin\/assets\/screenshot-6.png?rev=2132839","caption":"Edit a table row"}],"raw_content":"<!--section=description-->\n<p>So, you're managing a website for a client and and need to make a quick edit on the DB, but don't have access to the server. This plugin allows you interact with the DB from wp-admin.<\/p>\n\n<p>ZacWP PhpMyAdmin enables editing table records and exporting them to CSV files through minimal database interface from your wp-admin page menu.<\/p>\n\n<ul>\n<li>Simply CRUD table contents on your wp-admin screen<\/li>\n<li>Search and sort table records<\/li>\n<li>No knowledge on MySQL or PHP required<\/li>\n<li>Export table records to a CSV file<\/li>\n<li>User can edit table structure<\/li>\n<li>User can create new table<\/li>\n<li>User can run custom SQL query<\/li>\n<\/ul>\n\n<h3>NOTE<\/h3>\n\n<ul>\n<li>Admin is not allowed to modify wordpress default tables' structure.<\/li>\n<li>Admin is not allowed to change user password.<\/li>\n<li>Admin is not allowed to edit site and blog url so you don't get locked out admin panel.<\/li>\n<\/ul>\n\n<!--section=installation-->\n<ol>\n<li>Upload the entire <code>zacwp-phpmyadmin<\/code> folder to the <code>\/wp-content\/plugins\/<\/code> directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n<li>Click <code>PhpMyAdmin Manager<\/code> in the admin sidebar<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt><h3>Can I customize this plugin<\/h3><\/dt>\n<dd><p>This plugin is open-source, as such, you can customise as you want as long as you know what you're doing.<\/p><\/dd>\n<dt><h3>Why is my password requested when I try to run custom query<\/h3><\/dt>\n<dd><p>We try to validate the password against the currently logged in user to be double sure you know what you're doing. We don't save your password.<\/p><\/dd>\n<dt><h3>I want some other features added to this plugin<\/h3><\/dt>\n<dd><p>You can request for custom features by sending a mail to corporate@djunehor.com<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0<\/h4>\n\n<ul>\n<li>Stable release<\/li>\n<\/ul>","raw_excerpt":"ZacWP PhpMyAdmin enables database management, custom query and exporting them to CSV files through minimal database interface from your wp-admin page  &hellip;","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/107137","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=107137"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/djunehor"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=107137"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=107137"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=107137"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=107137"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=107137"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=107137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}