26 Comments

1. 

   Jan Kampherbeek on 2020-07-26 at 7:39 pm

   Hi Peter,
   Glad I found your WP Data Access project. Looks great!
   Jan

   Reply
   • 

     Peter Schulz on 2020-07-27 at 2:59 pm

     Thank you for your compliment Jan! 🙂 Great to see you on my website! 🙂

     Warm regards,
     Peter

     Reply
2. 

   Yamoun on 2020-09-21 at 9:22 am

   Hello , I followed your tutorial but when I try to display the table, it only shows me the columns ! how could i fix it ?
   Yani

   Reply
   • 

     Peter Schulz on 2020-09-21 at 11:56 am

     Which tutorial do you mean Yani?
     Thanks, Peter

     Reply
3. 

   Michael A Krause on 2021-05-04 at 2:25 pm

   Peter, WP Data Access is a FABULOUS piece of work! Thank you!

   I’ve been searching through the doc for help on using the SQL SUM function to show, of course, the SUM of a column, but I haven’t found any reference to SUM.

   Can you help, please?

   Reply
4. 

   Jörg Hartgen on 2021-12-04 at 8:14 pm

   Hi there,

   as you probably know support for AngularJS will be deprecated on December 31. 2021.

   Do you have plans to replace the AngularJS parts of the application?

   Best regards
   Jorg

   Reply
5. 

   Peter Schulz on 2021-12-06 at 3:36 pm

   Hi Jorg,

   Good point! Data Forms consist of two parts: (1) tables using jQuery DataTables and (2) data entry forms using AngularJS. With a team of developers I’m working on a React solution. This solution will help to replace the AngularJS part of Data Forms and will become available as a stand-alone product as well. For now I hope the extended long term support available until 2026 will help to cover security fixes.

   Best regards,
   Peter

   Reply
6. 

   Sean B on 2021-12-18 at 6:17 am

   Hi,

   Can we create SQL functions using WP Data Access?

   Reply
   • 

     Peter Schulz on 2021-12-18 at 10:10 am

     Hi Sean,

     The Query Builder is in fact a kind of SQL command line interface running in a browser. It supports any SQL command the connected user is authorized to execute. If you are allowed to create functions, you can use the Query Builder for that purpose. Please keep in mind that many ISP’s do not support functions, triggers, remote connections and other great features. Features not supported by your ISP are not available within the Query Builder.

     Hope this helps,
     Peter

     Reply
7. 

   Ken Lyle on 2021-12-25 at 5:18 pm

   I don’t see how I can share a query to another user or role in the Free version. Is this a Premium feature? Did I miss it?

   Reply
   • 

     Peter Schulz on 2021-12-27 at 7:41 pm

     Hi Ken,

     Queries are stored in the usermeta table and therefor onlt accessible to the login user. It is currently not possible to share a query with other users. This feature is planned as a future update and will be available in the free version.

     Best regards,
     Peter

     Reply
8. 

   Cees on 2022-03-16 at 3:05 pm

   Hi Peter,
   I want to use the Data Access plugin on both Windows10 and LinuxMint (20.3). On Linux the plugin is working OK but on Windows I can’t import (under Data Explorer) the 4 SQL files of the SAS application. On Linux the import was running OK.
   There are no messages in the logs; it just does nothing. Any idea ?
   Specs: PHP 8.0.12, MariaDB 10.4.21, Apache 2.4.51.
   I hope you can help me.

   Regards Cees

   Reply
   • 

     Peter Schulz on 2022-03-17 at 10:14 am

     Hi Cees,

     Are the tables crated when you open file wpda_sas_create_tables.sql with an editor and copy the content into the Query Builder? Please make sure to change to ; into / to allow the Query Builder to process multiple commands.

     Best regards,
     Peter

     Reply
9. 

   Cees on 2022-03-19 at 4:14 pm

   Hi Peter,
   I’m not using the Query Builder. On the Data Explorer page I click on the “Import SQL files” tab, then I click “Select files”, select wpda_sas_create_tables.SQL, and at last I click on the button “Import files/Execute script”. On Linux this is working fine, on Windows nothing happens.

   Reply
10. 

    Cees on 2022-03-19 at 5:08 pm

    Sorry. Not the correct answer. I used Query Builder and copied the statements for wpda_sas-class. Table created now.
    Using all statements and replacing ; by / produced lots of error messages.

    Reply
    • 

      Peter Schulz on 2022-03-20 at 8:34 am

      Hi Cees,

      Can you please check two things for me:
      – When you open the Data Explorer, enter wpda_sas in the search field and press enter: do you any results?
      – When you open wpda_sas_create_tables.sql and copy the first create table statement into your Query Builder without the ; can you send me the error message you see?

      Thanks,
      Peter

      Reply
11. 

    Cees on 2022-03-20 at 1:18 pm

    Hi Peter,
    I used the “Import/Execute SQL files” tab again.

    – When you open the Data Explorer, enter wpda_sas in the search field and press enter: do you any results?
    No results.
    – When you open wpda_sas_create_tables.sql and copy the first create table statement into your Query Builder without
    the ; can you send me the error message you see?
    Query OK, 0 rows affected
    Raw output:
    show_errors: false,
    suppress_errors: true,
    last_error: “”,
    num_queries: 36,
    num_rows: 0,
    rows_affected: 0,
    insert_id: 0,
    last_query: “–
    — Create table `wpda_sas_class`
    —
    CREATE TABLE `wpda_sas_class` (
    `course_id` int(11) NOT NULL,
    `student_id` int(11) NOT NULL,
    PRIMARY KEY (`course_id`,`student_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8”,
    last_result: [],
    queries: null,
    prefix: “wp_”,
    base_prefix: “wp_”,
    ready: true,
    blogid: 0,
    siteid: 0,
    tables: [10 items],
    old_tables: [3 items],
    global_tables: [2 items],
    ms_global_tables: [7 items],
    comments: “wp_comments”,
    commentmeta: “wp_commentmeta”,
    links: “wp_links”,
    options: “wp_options”,
    postmeta: “wp_postmeta”,
    posts: “wp_posts”,
    terms: “wp_terms”,
    term_relationships: “wp_term_relationships”,
    term_taxonomy: “wp_term_taxonomy”,
    termmeta: “wp_termmeta”,
    usermeta: “wp_usermeta”,
    users: “wp_users”,
    blogs: null,
    blogmeta: null,
    registration_log: null,
    signups: null,
    site: null,
    sitecategories: null,
    sitemeta: null,
    field_types: {34 items},
    charset: “utf8mb4”,
    collate: “utf8mb4_unicode_ci”,
    func_call: “$db->query(\”–
    — Create table `wpda_sas_class`
    —
    CREATE TABLE `wpda_sas_class` (
    `course_id` int(11) NOT NULL,
    `student_id` int(11) NOT NULL,
    PRIMARY KEY (`course_id`,`student_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8\”)”,
    is_mysql: true,
    time_start: null,
    error: null,
    categories: “wp_categories”,
    post2cat: “wp_post2cat”,
    link2cat: “wp_link2cat”

    Hope that’s not too much info

    Regards, Cees

    Reply
12. 

    Cees on 2022-03-20 at 1:20 pm

    Hi Peter,

    I forgot: table wpda_sas_class has been created.

    Cees

    Reply
13. 

    john mcfetridge on 2022-03-24 at 2:55 pm

    we inherited a wordpress web site that are struggling to get it to access data in our corporate MYSQL database. that database has key info on users like address, phone numbers etc. our web master is a plugin only guy and is using plugins like Ultimate membership for login and directory operations. he had to create an intermediate data source in WP and I find this disturbing . we now have key data in 2 places where directly accessing the corporate DB would be a much cleaner and maintainable solution. I am a ASP.NET dev and used to having everything accessible directly from a DB. Hoping that your tool can help us.
    Thanks

    Reply
    • 

      Peter Schulz on 2022-03-24 at 4:03 pm

      Hi John,

      WP Data Access allows you to remote connect to your MySQL database. Once connected you can access your remote database just like your WordPress database to create queries, publication, projects and charts. The following page explain how to connect to a remote MySQL database:
      https://wpdataaccess.com/docs/remote-databases/mysql-mariadb/

      Hope this helps,
      Peter

      Reply
14. 

    Pete Martin on 2022-03-26 at 7:07 am

    Hi – I am trying to create a site where customers log in and go through a series of forms entering information. As they go through these forms earlier answers need to appear so they can add new information. Finally I need to create a report based on their answers which they can print. I think two tables, one for customer information and one for their answers would be sufficient; can WP Data Access help me to create this site?
    Thanks
    Pete Martin

    Reply
    • 

      Peter Schulz on 2022-03-26 at 8:05 am

      Hi Pete,

      Your question is hard to answer. It depends on your work flow. WP Data Access supports parent child pages which you can use to build the necessary relationship. Pages are based on CRUD principals. If your work flow can be supported with CRUD pages, it should work. If you require specific handling during specific phases it might not be possible. Just give it a try with the free version.

      Hope this helps,
      Peter

      Reply
15. 

    Jopo on 2022-10-14 at 10:36 am

    Hi, if I activate an annual billing and after one year I cancel the billing, will I have still the Premium version without updates and support?

    Reply
    • 

      Kim Leong on 2022-10-17 at 3:01 pm

      Hi Jopo,

      You’re right. 🙂 You will still be able to use the premium version of the plugin. Only the premium data service requires an active license.

      Reply
16. 

    Edward on 2022-10-26 at 5:00 am

    What are the premium data services that requires an active license?

    Reply
    • 

      Peter Schulz on 2022-10-26 at 12:02 pm

      Hi Edward,

      This is a service that allows you to connect to foreign databases like SQL Server or ProgreSQL. You can find the documentation here: https://wpdataaccess.com/docs/premium-data-services/remote-connection-wizard/

      Hope this helps,
      Peter

      Reply