Implement non-PHP MySQL database into WordPress website?

  • My dad runs a small internet service company and would like to redesign his website. I told him I could redesign it in WordPress because I have some knowledge of wordpress from running the website for my school’s newspaper. The big problem is we can’t start the creation of the website until we find a way to implement his existing Python and Paearl based MySQL database running on linux of customers into the site. I have absolutely zero knowledge of this subject so I’m turning to you guys (the experts) for advice. So…

    1. How do we integrate the database into the website? Is there a plugin we can use? Can we build it into a embed code and just put it on a page?

    2. Is there a specific theme or theme type we should use to design the site around this database?

    3. Can we even use this database? My dad has thought about migrating it to QuickBooks Online; Would that be a better platform to build into the site?

    4. How long will this take to implement?

Viewing 1 replies (of 1 total)
  • Dion

    (@diondesigns)

    1a. It doesn’t matter which language is used to access the database, as long as the queries are MySQL.

    1b. You’ll need to write the plugin yourself since it will be custom to a particular database.

    1c. That might work but would probably look ugly, and the site will probably be sluggish.

    2. The theme should be the last thing to worry about. Getting the customer database in order is much more important.

    3a. See 1a.

    3b. Depends on whether your dad values functionality (QuickBooks) over appearance (WordPress). (Yes, I know that’s a blasphemous statement to make here, but WordPress is often not the best solution for a website.)

    4. You seem to think this will be a turnkey project with WordPress; it will not. If you go the WordPress route, your dad will most likely need to hire someone to write a custom plugin (maybe two) and to heavily modify a theme.

    If QuickBooks could work for your dad, he should probably try that first. If that doesn’t work out, then you can persuade him to go the WordPress route.

Viewing 1 replies (of 1 total)
  • The topic ‘Implement non-PHP MySQL database into WordPress website?’ is closed to new replies.