You can create a simple plugin and either add a shortcode to run your php, or filter the_content
and add a conditional check for your specific page and inject your DB output. This way your code will be independent of the theme and more portable. Use the wpdb
class to query any database /table.
Related Posts:
- Undefined function mysql_connect()
- Fatal error: Call to undefined function mysql_connect()
- MySQL “Or” Condition
- the_date() not working
- How to return number of found rows from SELECT query
- Transaction when using WP functions rather than vanilla SQL?
- Can i use php sql functions instead of $wpdb?
- How to make WordPress plugin check for database changes and then do something?
- Custom SQL query to get List of posts with featured image url
- Jquery ajax to custom php file: returning blank data
- Add value to usermeta without removing previous values?
- Problems migrating WordPress to localhost
- 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?
- Successful or Error Message after running mysql code in functions.php
- Performance issues with large website [closed]
- Create a quick start wordpress installation [closed]
- theme options echoing multiple times
- PHP/MySQL issues when running WP on EC2 cloud [closed]
- WordPress 3 – how are passwords stored and how do I compare to them?
- WordPress get pagination on wpdb get_results
- How to create another version of my site based on the same database
- how to echo all tables that start with a prefix
- Looking for most performant way to execute several similar WP queries within shortcodes
- How to select WooCommerce products by post_meta and order them
- Stumped on migration
- PHP code inside shortcodes
- Show MySQL errors that occur when I excute $wpdb->insert()
- Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
- Remove one value in dismissed_wp_pointers?
- WordPress Site Running Extremely Slow on Dedicated Server
- Accessing data from a non-WP database/table within a page content
- Get updated query results on page after insert in database
- WordPress not reflecting changed of the database
- How can I fix WordPress installation errors?
- How can I save unique user data on my site? [closed]
- Ordering users by custom user meta
- How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
- Hacked WordPress website /Homepage redirect [closed]
- Refresh table data with Ajax
- Database query works fine outside WordPress
- Large Woocommerce Site (83,000 items), What Can I Do? [closed]
- Using custom tables for old posts
- Help with a $wpdb MySQL Query
- How i can obtain all the post meta for a specific post as an array?
- Multiple meta_key in one global $wpdb;
- WordPress member notification
- Can’t Query Custom Table Using $wpdb Method
- Moving wordpress site from localhost to live server using GoDaddy cPanel
- How does WP work in conjunction with a web server?
- $wpdb returns duplicate posts
- Update postmeta after theme switch
- Location of core code for database connection and get_header
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress and MySQL: trying to print data using PHP from user_meta custom field data
- Most commented posts by time period (last 12h, last 24h and etc)
- How can I add a new row in a separate database when someone registers via WordPress?
- Hide posts if user is added to it WP_query
- How to unserialize data from MySQL
- How to use mysql LIKE with wpdb?
- Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
- WordPress WP_Query without query GET parameters
- Known Issues in WordPress When Upgrading PHP to ver 7
- Processing ajax call to php to insert into mysql database
- Get the id of the row from database on click of a button [closed]
- WPDB secure custom form
- Query the links Database
- WordPress Custom Query: Combining Two Functions
- SQL error with custom query
- Modify WooCommerce used to get all orders in dashboard
- Display Results of SQL Query on WP site
- Weird fonts showing which are coming from database
- PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
- Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
- How to optimize and reduce excessive database queries
- WordPress Bad Request Error 400
- I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- How to display MySQL table data which is stored as an array?
- What is the correct way to search 3 custom fields only in WordPress?
- cant insert data in a custom table in phpmyadmin
- How to import woocommerce custom fields data into another site?
- PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- autocomplete in wordpress using ajax with json-data
- New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
- Inserting other fields to existing registration form in a WordPress theme
- Query doesn’t display text data with apostrophes
- I want show only data for today
- Splitting table data to pages with numbers
- Ajax not updating to database
- SQL Query Search page
- MySQL query in WordPress with AJAX
- MySQL queries in WordPress
- retrieve wordpress post-meta using php not wordpress functions
- Let users register weight each day and save it in DB
- How to pass username into form that sends data to database
- Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
- Getting invalid user ID error when creating a new user with wp_insert_user
- Custom form that stores data in mysql database
- Putting form result in my database
- How can I update a value of a field depending on outside source?