-1

Code/process to get option dropdown menu selection to open page in WordPress with php?

Tried all kinds of plug-ins, widgets, but none will make menu that fits requirements of project so far.

Selections are page titles that are dynamically loaded from a table of address and other data. Based on previous selection of state, then city, then place, the next step is to open WordPress page from selected title, called place.

This is a normal option-select box:

<input type="submit" name="submit" value="place">

The selections are WordPress page titles. When submit is pressed, the issue is to go to page selected, a page for the selected business.

What I'm actually trying to do is produce a menu that can select among pages by state, city, and choose the place - the page belonging to that place. Eventually this will expand to country but right now the US. Each place has its own page. Tried a lot of plug ins and widgets and none has so far been up to this. I don't know beans about java so I went with php.

Improve this question
5
  • What is your question? What have you tried? What didn’t work? Add your code to the question please.
    – fuxia ♦
    Commented Jan 2, 2013 at 6:29
  • Question re-written.
    – ED Chou III
    Commented Jan 2, 2013 at 13:10
  • You say the page titles are loaded from a non-WordPress table, but then you say they're WordPress page titles, which one is it?
    – Milo
    Commented Jan 2, 2013 at 18:42
  • Both. They are WordPress page titles loaded from a non-WordPress table.
    – ED Chou III
    Commented Jan 2, 2013 at 19:24
  • Essentially I'm needing to load the page by its title. These titles will match due to the pages having been created and titled originally from these lists. I can choose a state and get its list of cities which will give a list of businesses in that city, from which I can choose(This part of the select is called "place"). This is where the selection needs to open the page. Each business has its own page. The selection needs to take one to that page on submit.
    – ED Chou III
    Commented Jan 3, 2013 at 1:00

1 Answer 1

Reset to default
0

Looks like not many folks do this. Anyway here's something that works for me to get drop-down select to go to WordPress page"

<?php
$my_title = $_POST['place'];
global $wpdb;
$mypost = $wpdb->get_row( "SELECT * FROM wp_posts WHERE post_title = '" . $my_title . "' " );
$permalink = get_permalink($mypost->ID);
echo "<a href=$permalink><BR>Click Here to Go to Selection</a>";
?>

"place" is the name of the select. Once the selection is made and submitted, this opens the page with the same name as selected. The names in the select box have to be the same as page names. If it can't find the page, you will get a 404, or whatever your item-not-found response is.

Improve this answer
2
  • 1
    Please do not use a second account to answer your own question.
    – fuxia ♦
    Commented Jan 7, 2013 at 16:16
  • 1
    two things- 1. never hardcode table names into queries, 2. WordPress has a function to fetch a post by title: get_page_by_title, no need for raw SQL
    – Milo
    Commented Jan 7, 2013 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.