Display single post inside accordion based on form submission results

Closing off as the issue is resolved. For anyone interested, the result is as follows (refer to the code detailed above for the initial DB-table connections, as the code below refers to the output only):

if (isset($SelectedLocationID) && isset($SelectedSchoolID)) { ?>
<div id="resultsDiv">
  <div id="resultsHead">
    <h3>Search results for routes between:</h3>
    <b><?php echo $selectedLocationName; ?></b>
    and <b><?php echo $selectedSchoolName; ?></b><br />

    (Click on route to view timetable and map)
  </div>

  <?php
  if ($getRouteID) { ?>
  <div id="routeResult">
    <div id="accordion">
    <?php
    foreach ($getRouteID as $route) {
      // Break the getRouteID results into separate variables
      $RouteName = $route->Name;
      $RouteID = $route->RouteID;
      $RouteDescription = $route->Description;
      $RoutePageID = $route->RoutePageURI;

      $getPost = $wpdb->get_results(
        $wpdb->prepare (
          "SELECT post_content, post_name
          FROM m6anby77we_posts
          WHERE post_name="%s"", $RoutePageID
        )
      );

      foreach ($getPost as $post) {
        $pName = $post->post_name;
        $pContent = $post->post_content;

        ?>
        <div class="accordion-header">
          <h4>Route: <?php echo $RouteName;?> <?php echo $RouteDescription;?></h4>
        </div>
        <div><?php echo $pContent; ?></div>
        <?php
      }
    }
    ?>
    </div>
  </div>
<?php } else { ?>
  <div id="routeResult">
    <h4>Results:</h4>
    No Route found for your selection.<br />
  </div>
<?php } ?> </div> <?php } ?>

Only trick/ painful thing is that the post content is brought in as a string (to be expected) – so you’ll have to go into the text editor within each post to ensure that you’ve formated it properly in there so that the string can then be printed as html.

Have fun y’all

Related Posts:

  1. Building a form with WordPress, and also pulling that data for a user page
  2. Insert data in database using form
  3. When is it appropriate to create a new table in the WordPress database?
  4. Loop.php vs looping inside template file
  5. How do I prevent one of two multiple loops from repeating on a second page?
  6. Show newly added posts since last user login time /date
  7. How do I override part of the main loop in my child theme?
  8. Fix inefficient loop breaks post.php on form submit
  9. Select data from database and list it in Loop (WordPress)
  10. How to create and work with custom data / tables (i.e., for arbitrary data)?
  11. Adding a Table to the wordpress database
  12. Recent posts on a static home page
  13. Filter the loop by categories using checkbox form
  14. Retrieve data from the database to table such as comments in the admin control panel
  15. show random image in loop if image is not set
  16. How to display posts by vote count and if no value continue with latest posts with no votes?
  17. Page-loop is looping content from custom loops on the same site. How to avoid that?
  18. Split wordpress loop to multiple layouts
  19. How do I automate multiple category loops?
  20. How can I improve the performance of this query_posts loop?
  21. Saving contact form 7 data into custom Table
  22. get_delete_post_link() inside Loop stubbornly returns nothing
  23. Integrating WordPress with Your Website
  24. Pagination for two loops
  25. Displaying member join date on page
  26. Custom Database Table and foreach
  27. How to use multiple check-box values to work in a function and insert values in database
  28. WordPress finding posts on 404 page
  29. What is my error trying to create a new table in the database?
  30. Creating a User-Adjustable chart in WordPress
  31. How to edit custom table data in frontend
  32. Use the loop to check if DB record exists?
  33. How do I aproach this?(for sale, for lease, sold->move something from a category to another)
  34. Database custom table issues – incorrect result displayed
  35. trying to write a variable into a wp_query, need help!
  36. Combine Query and Select Database to create directory loop
  37. display only parent replies count in index.php
  38. Change the way wordpress outputs images or image galleries
  39. Displaying posts limit: can’t get pagination to display [duplicate]
  40. How wp maps urls into files
  41. Custom Page Template and Category Exclusion
  42. Limitless amount of posts in custom archive page
  43. Delete tables from database when deleting plugin
  44. Custom form that store input in database
  45. Retrieve each widget separately from a sidebar
  46. how to upload image using wp_handle_upload
  47. Avoiding using a loop to access a single post
  48. Adding ‘current_post_item’ class to current post in the loop
  49. Where should I use post_class()?
  50. Landing Page – Redirect Loop?
  51. Sort Popular Posts by Views for the Last Week
  52. Is it possible to display previous post revision?
  53. How to retrieve an image from a post and display it before excerpt of a post? [duplicate]
  54. What’s the proper way to use a custom table? [closed]
  55. How to retrieve the value stored in a multi-dimensional array and SUM the entries?
  56. Adding Pagination on a Custom Author Page
  57. Adding shortcode closing tag after a loop
  58. Get Pagination (WP-PageNavi) not to work
  59. Filtering The Loop For Single Page and Blog Page
  60. Removing the_content() from the page
  61. CPT Loop with ACF and passing ID between Loops
  62. Duplicated posts on category page
  63. WordPress loop: exclude if it is the latest post
  64. query_posts() vs get_posts() multiple loops [duplicate]
  65. How do I make a variable available inside partials?
  66. WordPress: Loop Help
  67. Display Post Author Link above the loop
  68. Enabling users to control custom loop’s query
  69. Loop counter style
  70. Loop Problem: Displays same set of post for all categories
  71. Displaying multiple post types on home page
  72. display post format text in loop
  73. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  74. Remove any product that is featured from regular display loop [WooCommerce]
  75. Use BuddyPress data in loop (mkdir)
  76. Wrap every four posts within a div [duplicate]
  77. Get most recent post for every term in a given taxonomy type
  78. Magazine style frontpage with multiple categories/loops and no duplicate posts
  79. Open Graph in Index Loop
  80. How to get post category and author name for cusmot API?
  81. How to add Default Level-0 parent and Level-1 class in WordPress Category in li element?
  82. wordpress custom fields loop
  83. How to add pagination in Terms
  84. How do I add a dropdown menu to a form?
  85. WordPress next post by ajax call on button click
  86. Use admin-post to submit form data to external database
  87. How do i can data from my custom form to a custom table
  88. Include only one category but Exclude if is in a category from loop
  89. WordPress Pages in an Array
  90. numberposts not responding to wp_reset_postdata()
  91. My loop of random posts drags in comments of said random post
  92. Why my title change the last post title in my loop?
  93. One page loop issue with posts
  94. Building theme so user can change header image [closed]
  95. Carrying information from button click into form [closed]
  96. Accessing + retrieving custom database in WordPress
  97. get_page() unlike Loop returns the post content without html tags. How can I fix this?
  98. Display all posts in a page code for template
  99. Divide loop into several columns based on post custom field and enable infinite scrolling
  100. Query Loop Block: possible to restrict just child pages?