Wordpress site - using custom PHP and database

Question

I have finally finished coding a project with an HTML form for file upload, and a large PHP file that submits a 200 field CSV into my database. It first uploads to a staging table and then splits the data into smaller tables.

This all works perfectly but I'm having problems with the next step: This is needed to run on a wordpress site that already exists. I have a database just for this project with tables for users, clients, staging, meters, etc. I need all of these tables in their own database because these users are separate from the WP users.

I found a plugin that allows you to insert PHP into pages, but I need to know how to work with a custom database in WP, I've only ever worked with the actual database. Any help is greatly appreciated.

do you need to connect & use both the databases in your website? — manian
– manian, Commented Mar 31, 2017 at 1:18
Yes, the main database is being used currently. We set up a subdomain from the site to use for this project where two different people will upload CSV files at different times into the same database (our custom one) and it needs to be kept separate if possible — H.Norman
– H.Norman, Commented Mar 31, 2017 at 14:07

Alice · Accepted Answer · 2017-03-30 14:49:52Z

3

Include wordpress db file in your script 'wp-admin/includes/upgrade.php' and then call

global $wpdb;
$wpdb->query($your_query_string);

This way you can use wordpress database. But go through wordpress once so you will be aware of tables. Because wordpress save specific data to specific tables, say - any informartion about user to user_meta table.

If you are trying to insert new users then you may need to enter data into user table.

Another method is there.

You can open your wordpress theme's function.php then you can write scripts to enter your data or what ever fuctionality you are looking for. And I think that is a better way to work with wordpress.

answered Mar 30, 2017 at 14:49

Alice

1,4331 gold badge19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

n8bar · Accepted Answer · 2017-03-30 16:52:00Z

2

If you want to use php, try this tutorial: https://www.w3schools.com/php/php_ref_mysqli.asp

If you are developing wordpress plugins check out the wordpress codex: https://codex.wordpress.org/Creating_Tables_with_Plugins

This is going to take a bit of research on your part. Good luck!

answered Mar 30, 2017 at 16:52

n8bar

5932 gold badges8 silver badges26 bronze badges

Collectives™ on Stack Overflow

Wordpress site - using custom PHP and database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related