WordPress PHPMyAdmin: Access MySQL database tables from WordPress

Recommend this page to a friend!
  Info   Documentation   View files (17)   Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2019-12-23 (7 months ago) Not yet rated by the usersTotal: 95 All time: 9,434 This week: 318
Version License PHP version Categories
wordpress-phpmyadmin 1.0.0The PHP License5PHP 5, Systems administration, Blogs
Description Author

This package provides means to access MySQL database tables from WordPress.

It is a plugin for WordPress that provides a Web interface to perform operations to access MySQL database tables from the WordPress administration interface.

The Web interface allows users to perform operations on MySQL database tables and table records like creating, reading, updating, deleting table records, as well exporting data from tables into CSV files.

Innovation Award
PHP Programming Innovation award nominee
December 2019
Number 10
WordPress is a popular publication platform that uses MySQL to store the content data records.

It also provides an administration interface that can be extended by plugins to provide additional functionality.

This package implements a WordPress plugin that allows administrators to manage MySQL database schemata like PHPMyAdmin application.

Manuel Lemos
Picture of Zacchaeus Bolaji
  Performance   Level  
Name: Zacchaeus Bolaji <contact>
Classes: 13 packages by
Country: Nigeria Nigeria
Age: ???
All time rank: 302016 in Nigeria Nigeria
Week rank: 246 8 in Nigeria Nigeria
Innovation award
Innovation award
Nominee: 8x

?=== ZacWP PhpMyAdmin ===
Contributors: djunehor
Donate link: https://djunehor.com/donate
Tags: mysql, crud, table, database, simple, export, query
Requires at least: 4.6
Tested up to: 5.2
Stable tag: 1.0
Requires PHP: 5.0
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html

ZacWP PhpMyAdmin enables database management, custom queryand exporting them to CSV files through minimal database interface from your wp-admin page menu.

== Description ==
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.

ZacWP PhpMyAdmin enables editing table records and exporting them to CSV files through minimal database interface from your wp-admin page menu.

* Simply CRUD table contents on your wp-admin screen
* Search and sort table records
* No knowledge on MySQL or PHP required
* Export table records to a CSV file
* User can edit table structure
* User can create new table
* User can run custom SQL query

== NOTE ==
* Admin is not allowed to modify wordpress default tables' structure.
* Admin is not allowed to change user password.
* Admin is not allowed to edit site and blog url so you don't get locked out admin panel.

== Installation ==

1. Upload the entire `zacwp-phpmyadmin` folder to the `/wp-content/plugins/` directory
2. Activate the plugin through the 'Plugins' menu in WordPress
3. Click `PhpMyAdmin Manager` in the admin sidebar

== Screenshots ==

1. `PhpMyAdmin Manager` 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

== Frequently Asked Questions ==

= Can I customize this plugin =

This plugin is open-source, as such, you can customise as you want as long as you know what you're doing.

= Why is my password requested when I try to run custom query =

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.

= I want some other features added to this plugin =

You can request for custom features by sending a mail to corporate@djunehor.com

== Changelog ==
= 1.0 =
* Stable release

== Upgrade Notice ==
File Role Description
config (2 files)
style (1 file)
view (9 files)
init.php Example Example script
license.txt Doc. Documentation
readme.txt Doc. Documentation
zacwp_pma_controller.php Class Class source
zacwp_pma_model.php Class Class source

  Files  /  config  
File Role Description
   settings.ini Data Auxiliary data
   settings.ini.default Data Auxiliary data

  Files  /  style  
File Role Description
   style-admin.css Data Auxiliary data

  Files  /  view  
File Role Description
   add-table.tpl Example Example script
   add.tpl Example Example script
   custom-query.tpl Example Example script
   edit-table.tpl Example Example script
   edit.tpl Example Example script
   list.tpl Example Example script
   settings.tpl Example Example script
   table.tpl Example Example script
   util.php Aux. Auxiliary script

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:9,434
This week:318

For more information send a message to info at phpclasses dot org.