• About
  • Requests
  • Free Add-ons
  • Paid Add-ons
    • Admin Access Levels
    • Bundler
    • Data Wizard
    • Google Analytics 4
    • Menu Master
    • Master Password
    • Order Editor
    • Page Content Pro
    • Payment
      • Braintree – Apple Pay
      • Braintree – Credit Cards
    • Price Levels
    • Product Manager
    • PDF
      • PDF Invoices
      • PDF Packing Slips
    • Reporting Tool
    • Shipping
      • UPS Pro
  • Reviews
  • My account
  • Forums
  • DEMO
  • About
  • Requests
  • Free Add-ons
  • Paid Add-ons
    • Admin Access Levels
    • Bundler
    • Data Wizard
    • Google Analytics 4
    • Menu Master
    • Master Password
    • Order Editor
    • Page Content Pro
    • Payment
      • Braintree – Apple Pay
      • Braintree – Credit Cards
    • Price Levels
    • Product Manager
    • PDF
      • PDF Invoices
      • PDF Packing Slips
    • Reporting Tool
    • Shipping
      • UPS Pro
  • Reviews
  • My account
  • Forums
  • DEMO
home/Knowledge Base/Free Addons/Database Tool

Database Tool

414 views 0 October 2, 2020 March 30, 2021

Add-on Name: Admin – Database Tool
Version: 0.2.0
Updated: 03/04/2021
Supports CE Phoenix: >= 1.0.7.0
Supports OS Commerce:  >= 2.3.4.0

Description of Add-on

This admin tool will allow you to lookup database structures as well as query the database.

Example queries:

  • Select * FROM address_book ORDER BY address_book_id DESC LIMIT 10;
  • DELETE FROM <tablename> WHERE <condition>
  • UPDATE <tablename> SET <column>=<value> WHERE <condition>
  • CREATE TABLE zipurDBToolHistory (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,user VARCHAR(50) NOT NULL,querytext TEXT NOT NULL,query_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
  • DROP table zipurDBToolHistory;

This tool can be very handy when applying updates and small SQL adjustment queries are needed.

Be careful as there is no undo. Make sure you have a good backup before you get too carried away!

Change Log

  • 0.2.0 (03/04/2021)
    • Fixed display issue with schema.
  • 0.1.8 Oct 2, 2020
    • Each query line separated by a semi-colon and a line ending (;\n) will now be split into its own query allowing for multi-line multi-query. Prior to this each query had to be executed individually. MAKE SURE YOUR QUERIES END WITH A SEMI COLON AND NO TRAILING SPACES.
    • Creation of zipurDBToolHistory table will now include DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  •  0.1.7
    • Some code cleanup
    • Queries larger than 500 characters will no longer be save to history
    • If query is a duplicate of last query, do not save to database and limit duplicates in history drop down.
  •  0.1.6
    • You can now export to csv. Just do a “SELECT” query and you’ll see a CSV option after loading the data
  •  0.1.5
    • Fixed some layout issues in Google Chrome for table formatting
  •  0.1.4
    • Remove the need for zipur toolbox functions and release as a standalone app
    • minor adjustments
    • auto install of database table if it is not already installed for query histories
  • 0.1.3
    • Misc adjustments and bug fixes
  • 0.1.2 – July 9, 2020
    • Updated to work with new zipur Toolbox (formerly zipur Updater)
  • 0.1.1 Aug 8, 2020
      • Moved core functions into zipur_updater functions file. You must install zipurUpdater 0.1.7 in order to use the new Database Tool.
  • 0.1.0 Aug 5, 2020
    • Initial release

Download(s)

You can now download this addon from the Phoenix Cart Forum Addons Library

https://phoenixcart.org/forum/app.php/addons/free_addon/database_tool/

Tags:PhoenixOS CommerceApp

Do you like this item?

Yes  No
Related Articles
  • Fav Icon
  • Google Fonts
  • Left Admin Menu
  • Product Image Zoom
  • Info Pages – Pretty URLs
  • USPS Shipping Module



Recent reviews
  • Zipur's Phoenix Bundler (2.x)
    Rated 5 out of 5
    by Daniel Kofod Primdahl
  • Zipur's Phoenix Bundler (2.x)
    Rated 5 out of 5
    by Director - cornishhoney.co.uk
  • Phoenix Data Wizard
    Rated 5 out of 5
    by Zia Haq
  • Phoenix Order Editor by @Iian
  • Phoenix Menu Master
    Rated 5 out of 5
    by Director - cornishhoney.co.uk
  • Phoenix - Zipur's Braintree Credit Card Module
    Rated 5 out of 5
    by Cary Laurenson
  • Phoenix - UPS Pro Shipping Module
    Rated 5 out of 5
    by Cary Laurenson
  • Master Password
    Rated 5 out of 5
    by Patrick
  • Zipur Reporting Tool
    Rated 5 out of 5
    by René
  • Zipur Product Manager
    Rated 5 out of 5
    by Omar
Need an add-on? Request it!

If your idea turns into a Paid Add-on … I’ll give you a copy for free.

Don’t forget to like the Free Add-ons so I know which ones are worth maintaining.

Like  Nope
Docs
  • Phoenix Docs 11
Latest Free Add-ons
  • USPS Shipping Module
  • UPS Shipping Module
  • Simple Header Message
  • ShareThis – Add to product pages
  • Product Image Zoom
  • OSCommerce to CE Phoenix Migration Utility
  • Language Tool (Search/Edit)
  • Info Pages – Pretty URLs
  • Google Fonts
  • Favorite Countries
  • Fav Icon
  • Database Tool
  • Core Compare Tool
  • Canada Post Shipping Module
  • Left Admin Menu
Follow me on YouTube

  • Privacy Policy

© Copyright 2020 Intricate Networks Inc.