1) It is easy to create tables in WP. I suggest making a plugin to handle this for you. See the codex for more info: https://codex.wordpress.org/Creating_Tables_with_Plugins
2) Again, I suggest using WP to handle this for security purposes. As you stated, you would have connection details that could potentially be exploited.
3) I think there are plugins for this. Another way is to write your PHP into Theme files so that users will not be changing this. It is not good practice to store your PHP code in the database.
Related Posts:
- Has anyone tried putting PHP ActiveRecord on WordPress?
- How to return number of found rows from SELECT query
- How do I make an HTML table from a database table?
- what is the use of /wp-includes/SimplePie?
- How to check if image is already stored in a site’s post database? (network)
- Inserting dynamic content into a page
- Check if post of title already exists
- How to export/import theme customizer settings?
- $wpdb->delete column values IN ARRAY()?
- Inserting choice in database table
- WP API V2 returning Invalid User ID
- How To Make Connection To WordPress Data Base In A Plugin?
- Changing user_nicename
- Does WordPress cache get_user_meta() results?
- How to auto login user again after change user_login
- WordPress will not operate correctly
- Export User Info to CSV from Front End
- How to Join two tables from separate databases within WordPress
- WordPress admin never finishes saving page on site with large page count
- Retrieving and Displaying Data From a Table
- Refresh page after update_post_meta
- Search and Replace in database: How to replace data in SQL dump file on Windows?
- Duplicate domain database to local – How?
- error importing localhost export file to server
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- How to sort results from a custom database table
- How can I call a row of user specific data from a custom table added to the WP Database
- How to merge local and live databases?
- How to track a users progress through pages by inserting data into WordPress Database?
- Why WordPress uses 4 tables to manage terms
- Import 10,000 Users into WordPress WITH a specific ID for each user
- WPDB: how to get the value of a field in a custom database table
- WP database error for comments_popup_link()
- if statement on database query
- Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- No wp-config.php file on local install of wordpress – site still displays
- How to create Sub Sub domain Multi User blogs?
- How to find the output of contact form 7 shortcode? [closed]
- Issue with foreach on duplicate meta_key’s
- Access/update database with jQuery
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Different database query in function.php using mysqli
- How to generate page content from database the right way?
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- Add custom php database code above
- wp_insert_post not working
- Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
- Store and Work with huge array in WP [closed]
- phpMyAdmin displays error when importing database
- Prevent Data Resubmission On Page refresh
- Adding Custom Forms
- SQL QUERY – Select a value directly from the database
- How to get the POST TITLE using the POST ID?
- Why is the post meta[] empty when I make a call to the wordpress rest api?
- Is it necessary to sanitize wp_set_password user input?
- Any possible way to make $wpdb->get_results() return anything else than array?
- database interactions using OOP
- WordPress Scheduled Event Request Blocking
- Transferring working local PHP site to wordpress – with database (MySQL)
- Accessing the database from a plugin outside of action hooks
- Trying to establish connection to External Database
- Create WP_Query to search for posts by their categories or their parent/child categories
- Getting id of poll from WP database
- Storing Array from returned database query and using the array in a new query
- How to insert a single row to WP database table?
- WordPress not reflecting changed of the database
- $wpdb->update with multiple parameters gives error
- How to save checkbox values for logged in users?
- wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
- How does WordPress know wich language is chosen when there is a database connection error
- How can I save unique user data on my site? [closed]
- Is it possible to create a wordpress database with php code?
- Update results, Before deleting the related category [closed]
- Store a default value for a transient on plugin activation
- How WordPress reacts to a lack of memory of the server [closed]
- Split reads to a different connection string
- custom user role wordpress – grant guest access to edit.php without insert/update/delete
- Execute long and heavy processes
- Dynamic content in template
- database sent to a JSON file
- inserting a post from an extern php file but post content doesn’t show on wp site
- How to separate HTML and WordPress files
- Using custom tables for old posts
- Databases – Submitting data from inputs to database [closed]
- db converts decimal number wrong
- Not connecting to database in file with multiple MySQL connections
- Filtering a Database Query
- Display Data in Table from External Database in WP using Shortcodes
- Is it best to avoid using $wpdb for security issues?
- How can I import an excel column into wordpress database?
- Blob file download problem
- WordPress Block developer from exporting Database via PHP
- How to retrieve the data from the sever and displaying it in a page?
- Execute a function every hour in the background
- wpdb prepare insert table doesn’t work
- Should I use WordPress to skin a database website?
- How do I display offsite database info on my wordpress site?
- Creating Database Table vs. Adding MetaData to Post & User