1 / 25

Streamlining Business with WordPress and MySQL Integration

This presentation by Peter Mantos at a WordPress Meetup explores the value of integrating websites with MySQL to enhance business efficiency, particularly for small businesses. It emphasizes that such integration is relatively straightforward for WordPress sites and doesn't require programming skills. The talk covers ways to synchronize data, relieve duplicate entry, and keep information current while showcasing tools like the “Read and Understood” plugin to enhance user engagement. Audience members will gain insights into leveraging existing WordPress capabilities to add value to their web solutions.

sonel
Télécharger la présentation

Streamlining Business with WordPress and MySQL Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Site Integrationusing WordPress MySql A presentation (that should have been made) to WordPress Meetup By Peter Mantos; MantosI.T.Consulting, Inc. http://mantos.com 13-Feb-2014

  2. Presentation Objectives • Show Web Site Integration as a valuable and viable Business Strategy for small business • Show Web Site Integration is relatively easy for sites developed using WordPress Web Site Integration - Mantos.com

  3. Intended Audience • Original presentation MISSED target audience • This is for WordPress Web Site Developers • Assumes familiarity with WordPress • Does NOT assume any programming (PHP) • Shows where to find some resources • Includes some screen shots Web Site Integration - Mantos.com

  4. Integration • Data exchange between information systems • Relieves people of duplicate entry • Keeps data in synch • Same email address in two different systems • Confident that you have THE correct address • Makes data available that otherwise isn’t • Employees can access blog/post re. new insurance • HR doesn’t know if “Fred” has read that post • Fred doesn’t know if he is eligible for insurance Web Site Integration - Mantos.com

  5. Web Site Integration Web Site Integration - Mantos.com

  6. WordPress has a Database? • WP has its own database • Open Source MySql • Holds pages / posts • Hold usernames & logins • Can be accessed outside of WordPress • Can be augmented to hold “other” data Web Site Integration - Mantos.com

  7. Example: Read and Understood • The Problem: • How to know that “Fred” has read the post on the new insurance plan? • The Solution: • Use the “Read and Understood” WordPress plugin • Function(s) • Gives Fred a button to acknowledge the post • Gives HR a list of acknowledgements Web Site Integration - Mantos.com

  8. How to Install / Configure“Read and Understood”(RnU) • WordPress Admin Dashboard => Plugins • Click “Add New” (Plugin) • Search for “Read and Understood” • Press “Install Now”, then “Activate” • Option: add category & posts to acknowledge • Click “Settings”; select “Read and Understood” • Select category to acknowledge, Save changes Web Site Integration - Mantos.com

  9. RnU Plugin Settings (admin) Web Site Integration - Mantos.com

  10. How Reader Acknowledges • Login to WordPress (optionally, not required) • Read a postunacknowledged Post in category • Press “Read and Understood” Button (after post) Web Site Integration - Mantos.com

  11. How to Get a List of Acknowledgements • Login as WP Admin • Go to RnU Settings • Enter Date Range • Press Export • Save CSV file or • Open with a program such as Microsoft Excel Web Site Integration - Mantos.com

  12. Exported Acknowledgements Web Site Integration - Mantos.com

  13. How does RnU work? • When Installing RnU, a table is created in the existing WordPress MySql database • When Acknowledged, a record is saved with user info, posting info, and date-time • “Export” looks into the table to find records Web Site Integration - Mantos.com

  14. Can Store Data from Anywherein the WordPress MySql Database • Example gets who, what, when from user. • Could get data from anywhere to populate • From company’s HR system (or spreadsheets) • From government web site • Just as easy to write data into table as export • Plugin is just a one-page program in PHP • Most plugins exploit WP Database • Could write custom program to read/write Web Site Integration - Mantos.com

  15. Accessing MySql Data w/o Plugin • Assuming the host permits MySql access • You need the Hostname to the MySqldatabase • And the authorized username and password • You can access data using : • MySqlWorkBench(download it MySql.org) • PhpAdmin (usually on your Host’s control panel) • Custom Programs (written in PHP, C++, etc.) • Linked Tables (such as using MS Access or eXcel) Web Site Integration - Mantos.com

  16. Low Hanging Fruit • Capabilities needed for Web Site integration are: • Have a MySql database • Can already run programs (plugins / custom PHP) • User Login mechanism to secure access to data • WordPress Web Sites alreadyhave those • Potential Custom Development effort: • 1 added table to existing database • 1 program to display 1 additional interactive page • Low cost; possible huge value to clients Web Site Integration - Mantos.com

  17. Conclusion • You have already paid for the capabilities to push/pull data to/from your website • Web Sites enabled with company data are • Secured via logins • More valuable to customers • More attractive to potential customers • Web Site Integration can be simple • Do it ahead of your competitors Web Site Integration - Mantos.com

  18. Questions? • Feel free to contact: Peter Mantos (505) 291-1047 Mantos I.T. Consulting, Inc. peter@mantos.com • See more on the web at: • http://mantos.com/services/web-site-integration/ Web Site Integration - Mantos.com

  19. Extra: Accessing Data using MySql Workbench Web Site Integration - Mantos.com

  20. Extra: PhpAdmin Web Site Integration - Mantos.com

  21. Extra:MS Access Database linked to MySqltable on Website • Download and install MySql Connector/ODBC 5.1.13 (32 bit) from dev.mysql.org • Create new MSACCESS (2010) database • Select External Data ODBC database • Select Link to Data Source using linked tables • Create/Choose Machine Data Source • Can now use MSACESS queries, forms, reporting tools to read, write, & delete Web Site Integration - Mantos.com

  22. Example: MS Access (2 of 4) Web Site Integration - Mantos.com

  23. Example: MS Access (3 of 4) Web Site Integration - Mantos.com

  24. Example: MS Access (4 of 4) Web Site Integration - Mantos.com

  25. Extra: Accessing MySql from WP using PHP • global $wpdb; • is already accessible within WordPress • Can even be used outside of WordPress: • include_once($_SERVER['DOCUMENT_ROOT'].'/…/wp-load.php' ); // … depends on your site • Is an instance of a class: “WordPress Database” • Contains properties such as $wpdb->prefix • Contains methods such as $wpdb->query() • Host, Username, & Password already included! Web Site Integration - Mantos.com

More Related