PHP Classes

WordPress PHPMyAdmin: Access MySQL database tables from WordPress

Recommend this page to a friend!
  Info   Documentation   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 115 All time: 9,572 This week: 560Up
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: 17 packages by
Country: Nigeria Nigeria
Age: ???
All time rank: 245515 in Nigeria Nigeria
Week rank: 250 Up9 in Nigeria Nigeria Up
Innovation award
Innovation award
Nominee: 12x

Winner: 1x

Documentation

?=== 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 ==

  Files folder image Files (17)  
File Role Description
Files folder imageconfig (2 files)
Files folder imagestyle (1 file)
Files folder imageview (9 files)
Accessible without login Plain text file init.php Example Example script
Accessible without login Plain text file license.txt Doc. Documentation
Accessible without login Plain text file readme.txt Doc. Documentation
Plain text file zacwp_pma_controller.php Class Class source
Plain text file zacwp_pma_model.php Class Class source

  Files folder image Files (17)  /  config  
File Role Description
  Accessible without login Plain text file settings.ini Data Auxiliary data
  Accessible without login Plain text file settings.ini.default Data Auxiliary data

  Files folder image Files (17)  /  style  
File Role Description
  Accessible without login Plain text file style-admin.css Data Auxiliary data

  Files folder image Files (17)  /  view  
File Role Description
  Accessible without login Plain text file add-table.tpl Example Example script
  Accessible without login Plain text file add.tpl Example Example script
  Accessible without login Plain text file custom-query.tpl Example Example script
  Accessible without login Plain text file edit-table.tpl Example Example script
  Accessible without login Plain text file edit.tpl Example Example script
  Accessible without login Plain text file list.tpl Example Example script
  Accessible without login Plain text file settings.tpl Example Example script
  Accessible without login Plain text file table.tpl Example Example script
  Accessible without login Plain text file util.php Aux. Auxiliary script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:115
This week:0
All time:9,572
This week:560Up