how to show the data from a myqsl database in a post [closed]

use:
$myrows = $wpdb->get_results( “SELECT id, name FROM mytable” );

then use $myrows in for or foreach loop.

Reference WP wpdb class:

http://codex.wordpress.org/Class_Reference/wpdb

Related Posts:

  1. Creating 20,000 Posts or Pages using a .csv file?
  2. Search and replace text across all posts
  3. Convert WordPress posts to products in WooCommerce
  4. Can I explicitly specify ENGINE=InnoDB in WordPress?
  5. Bad Request (Invalid Hostname) on working server, database problem
  6. How can I list only sites that use a particular theme or plugin?
  7. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  8. Changing BIGINT to INT
  9. Replace existing pages with new pages, keep menu links
  10. Can I run multiple queries with $wpdb->prepare?
  11. How to remove duplicate Custom Fields?
  12. wordpress in nginx docker container connected to php:8-fpm container and mariadb container isn’t creating any tables on plugin activation
  13. How to write one comment and publish on every post using database or plugin?
  14. How to get number of Affected rows from wordpress dbDelta() function
  15. How to determine what is generating large amount of database queries?
  16. Get post by ASC from custome field DATE picker
  17. MySql database help for a plugin
  18. How to remove Database Table in WordPress via Function file?
  19. Bulk edit existing shortcode within custom field
  20. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  21. Creating mySQL procedure with $wpdb
  22. WpDataTables – View Image Directory
  23. get current date + 90 days and checking every day
  24. How do I run SQL queries on a WordPress web page? [closed]
  25. How can I perform high-level database merging for WordPress within continues delivery?
  26. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  27. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  28. Enabling WP_USE_EXT_MYSQL to support old plugin
  29. how to access all user dashboard on fronted page [closed]
  30. Insert data from .sql file in wordpress plugin
  31. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  32. WordPress Backend HA (Automatic failover)
  33. Automatic switch to backup database on fail
  34. SQL to order by CPT results by user->display_name w/only user->ID known
  35. Migrating to WordPress Recipe Plugin and Some SQL Issues
  36. Enabling plugin failed because MySQL user do not have CREATE permissions
  37. WordPress page and plugin list using sql query
  38. Multiple instance of data in plugin custom database table on plugin activation
  39. WP-DownloadManager – Query most download per week/month etc
  40. Errors when trying to use a plugin to write to the database
  41. _prime_post_caches in wordpress
  42. pagination on data fetched using SQL query
  43. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  44. Speeding SQL queries for a large database?
  45. Mass SQL WordPress Meta Key deletion
  46. dbDelta not adding additional columns in plugin database update
  47. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  48. Always get creating a new table with foreign key
  49. How to do database for download stats?
  50. How can I fetch data from another website to my wordpress website with mysql database
  51. Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
  52. External wpdb connections in different plugins on single page
  53. speed up pagination for huge database
  54. Way to send multiple values for column to MySQL?
  55. WordPress plugin: efficient way to store large data
  56. Plugin generating unexpected output – on WP mysql dump import
  57. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  58. Integrating Custom Database with WordPress
  59. How to display results from a data table with an encrypted user id?
  60. add_action for publish_post doesn’t work
  61. WordPress Cache delete on plugin uninstall
  62. need to find duplicated meta value in custom filed and view the posts that have the same value
  63. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  64. JOIN and SUM different statement results (Mailster Database)
  65. Getting current user data with MySQL statement
  66. Some error in mysql script ? Can’t working to create table
  67. How to get the custom field value using SQL query
  68. Memcaching recurring SQL Queries
  69. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  70. WP Function does not trigger on Webhook API Call
  71. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  72. Cant create table on plugin activation
  73. Performing CRUD operations on front end in wordpress
  74. Display a number value from mysql query in WP
  75. WordPress UPDATE queries on MySQL database stuck
  76. Store GravityForm data in phpmyadmin (mysql)
  77. Moving a few select DB tables to a new WP instance
  78. dbDelta not CREATING TABLE
  79. WordPress database problem wp_posts, primary key
  80. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  81. Delete user meta based on key value that is an array
  82. HyperDB failover Delay
  83. Resetting AUTO_INCREMENT primary key
  84. Re-writing MySQl query for execute faster
  85. Create Database Tables on Plugin Activation hook
  86. Write mysql credentials in plugin
  87. Help with sorting and storing data on WordPress
  88. Slow WordPress admin panel with a total query time of 1664ms
  89. Linking Plugin Files to WP
  90. MySql Query for WordPress
  91. Using wp config to connect to a DB from a plugin
  92. how to search through plugin in wordpress cimy-user-extra-fields?
  93. Get all the related data from WordPress DB
  94. Trying to insert a row from a Plugin
  95. 504/502 errors plauging our site
  96. How can I delete the options from DB when the plugin is deleted?
  97. Share or sync user table data with another user table
  98. Split Million WordPress Post’s Into Multiple Database Server
  99. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  100. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there