Dieses Plugin ist nicht mit den jüngsten 3 Hauptversionen von WordPress getestet worden. Es wird möglicherweise nicht mehr gewartet oder unterstützt und kann Kompatibilitätsprobleme haben, wenn es mit neueren Versionen von WordPress verwendet wird.

Enhanced SQL Portal Bridge

Beschreibung

This bridge plugin automatically logs you into your database with the Enhanced SQL Portal (ESP). You can either login to your WordPress database with 1 click or go to the login screen and login to a different database on your server. ESP is a database management GUI that makes it easier to:

  • Manage Tables

    • Organize tables into folders and easily search for tables to manage large databases
    • Quickly create/copy and delete tables, with or without data.
    • Create and manage indexes on tables, using an easy-to-use graphical interface
    • Create and manage foreign keys between tables. Never get an error 150 ever again, since we check for almost every cause before attempting to create a foreign key
  • See Results of Custom Queries

    • Automatically saves a history of queries that you have performed so you can go back without retyping. These persist between sessions.
    • With two clicks, turn any query into a MySQL view, which then becomes available in the Table Manager with all of its benefits.
    • Organize and save queries for later use. You can organize queries for later use using the searchable organizer tree.

My website has a demo that you can test to get a feel for the system.

Screenshots

  • WordPress DashBoard->ESP Bridge Page to Login to ESP
  • Enhanced SQL Portal->Home Page
  • Enhanced SQL Portal->Login Screen
  • Enhanced SQL Portal->Table Manager
  • Enhanced SQL Portal->Example Form to Add Row to Table
  • Enhanced SQL Portal->Query Browser
  • Enhanced SQL Portal->Function to Dump Database
  • Enhanced SQL Portal->Function to Dump Current Database Tables

Installation

Installation from WordPress.org

  1. Download Enhanced SQL Portal Bridge
  2. Go to Plugins menu
  3. Click ‚Add New‘
  4. Click ‚Upload Plugin‘
  5. Choose the downloaded file
  6. Activate with your Plugins page

Installation from WordPress Dashboard

  1. Go to Plugins menu
  2. Click ‚Add New‘
  3. Search Enhanced SQL Portal Bridge
  4. Click ‚Install Now‘
  5. Activate with your plugins page

FAQ

What is the Enhanced SQL Portal(ESP)?

ESP is a database management systme that extends the capabilities of MySQL, giving anyone the ability to manage a database. Using the system’s Table Manager, tables can easily be created, modified, including adding indexes and foreign keys. The system’s Query Browser will allow you to create custom queries.

You can create forms using various built-in field types such as drop-downs, number fields, text fields,date and date-time fields, google location and direction fields, and code fields (for editing code like HTML, javascript, etc.). You can change the layout of the forms using a built-in HTML editor.

The Query Browser allows you to execute and command or query on your databases, and will save your queries for you as well as allow you to turn any query into a MySQL view, which can then be used in the Table Manager.

That Admin Manager allows you to export single or multiple databases or single or multiple tables within a database using mysqldump.

Beyond that, ESP has several other apps that can be added to your system to add functionality.

How do I export my database?

Go to the Admin Manager App in ESP. In the ‚Database Setup‘ tab, there is a ‚Dump Current Database‘ option. Clicking on this will pop up a page with dumping options. Choose any/all tables that you want to dump and hit submit. This will download a zip file with the mysql dump in it.

What are the system requirements to use this bridge and/or ESP?

The Enhanced SQL Portal is well tested on linux servers with MySQL 5.x, and PHP 5.x (greater than 5.3). IT requires PHP PDO_MySQL or PHP MySQLi. While not well tested, it should work with Windows-type servers such as WAMP. To export your database or database tables, the server must have mysqldump installed and available from the command line.

How can I access a different database with the ESP system

On the ESP Bridge page there is a button labeled ‚Login into Other Database‘. Clicking that will take you to the ESP login page, where you can specify database and user.

How can I create a new database?

There are two ways to create a new database. The first is to click the ‚Login into WP Database button‘. Once there, you can use the Admin Manager, click on the Database Setup section, and click on Create New Database.

You can also click the ‚Login into Other Database button.‘ When you are at the login page, you can type the name of your new database into the database box. If the database doesn’t exist, upon login, it will ask you if you want to create the database.

How can I create a new table

Go the Table Manager app and click ‚File‘, then ‚New‘, and then ‚Table.‘ This will pop up a form where you can choose the table name and enter other information, and the table will be created.

How can I add columns to a table

Find the table in the table manager in the tree on the left. Click on it. A tab that says „Format“ will appear when the table is selected. You can manage the columns from that tab. Click on „Add“ at the bottom to create a new column. By changing the validation, you can choose what kind of field that column will be represented by; there are various other options there for column definitions as well.

How can I add a foreign key to a table

Find the table in the table manager in the tree on the left. Click on it. A tab that says „Foreign Keys“ will appear when the table is selected. You can manage the foreign keys from that tab. Click on „Add“ at the bottom to create a new foreign key.

How can I add an index to a table

Find the table in the table manager in the tree on the left. Click on it. A tab that says „Indexes“ will appear when the table is selected. You can manage the indexes from that tab. Click on „Add“ at the bottom to create a new index.

Mitwirkende & Entwickler

„Enhanced SQL Portal Bridge“ ist Open-Source-Software. Folgende Menschen haben an diesem Plugin mitgewirkt:

Mitwirkende

Änderungsprotokoll

1.0.1 (2015/7/8)

  • Updated instructions to make them clearer
  • Fixed issue with directory path due to a case issue

1.0.0 (2015/6/29)

  • First Version of Enhanced SQL Portal Bridge