Title: Database not working
Last modified: August 31, 2016

---

# Database not working

 *  [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/)
 * I have created my own table on my wordpress database and created the filter search
   form, I also created result.php to my wordpress to output all searched products.
   Now, my problem is that, I dont know how to connect my database to my search 
   filter form in wordpress.
 * I already created some of it but its not running..
 * Here’s my sample code
 *     ```
       <?php
       define('WP_USE_THEMES', false);
       global $wpdb;
       $destination = $_POST["destination"];
   
       echo "Welcome test" . $destination;
   
       $sql = "SELECT * FROM rates WHERE location = '" . $destination ."';";
   
       echo $sql;
       echo "search this";
   
       foreach ( $wpdb->get_results($sql) as $result ) {
        echo "search for". $result->location;
       }
   
       ?>
       ```
   
 * [https://goo.gl/photos/bqqAPiAkxF5dXCxY7](https://goo.gl/photos/bqqAPiAkxF5dXCxY7)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249033)
 * Your code appears OK as far as it goes. There’s some improvements that need to
   be introduced eventually, but it should basically work if your query is correct.
   You can verify the query by running it directly in phpMyAdmin under the SQL tab.
 * To catch many errors, define `WP_DEBUG` as true in wp-options.php.
 * Where is your results.php placed? Theme folder? And it contains the above code?
   How is this page requested and/or where does your form submit to?
 * FWIW, the improvements eventually needed include passing the input through `stripslashes()`
   to account for possible escaped apostrophes, quotes, etc. Validate and sanitize
   all form input. Use `$wpdb->prepare()` to construct your SQL query.
 *  Thread Starter [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249055)
 * Hi **bcworkz**, thanks for your response…what do you mean by that??That code 
   I wrote in there is a sample to call from phpmyadmin, that’s not actually the
   code to “search form submit” from my own created table in wp database.
 * **Where is your results.php placed? Theme folder? And it contains the above code?
   How is this page requested and/or where does your form submit to?**
 * I placed my result.php on my theme folder and yeah, it contains the code stated
   above to test if my result.php calls phpmyadmin. My form submits to results.php.
 * here is my codes: [https://drive.google.com/folderview?id=0B0Je1_NFqcfXNUdPMU1Udm9qRnM&usp=sharing](https://drive.google.com/folderview?id=0B0Je1_NFqcfXNUdPMU1Udm9qRnM&usp=sharing)
 * …
 * Hope to hear from you soon..!
 *  Thread Starter [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249056)
 * This is actually how I call it….I don’t know if I’m doing the right syntax.
 * <?php
 * require_once( $_SERVER[‘DOCUMENT_ROOT’] . ‘/wp-load.php’ );
 * global $wpdb;
 * $sql = “SELECT * FROM rates”;
 * if(isset($_POST[‘destination’])){
    $search_term = mysql_real_escape_string($_POST[‘
   destination’]); $sql .=”WHERE location = ‘{search_term}'”; $sql .=” OR level 
   ='{search_term}’ “;
 *  $query = mysql_query($sql) or die(mysql_error());
    } echo “your search term”.
   $query; ?>
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249081)
 * Yeah, the `require_once` path is wrong. Without wp-load.php, nothing related 
   to WP, like `$wpdb` will work. Directly requiring wp-load.php is considered a
   bad practice because it needs to be referenced relative to your code page and
   since the /wp-content/ folder can be moved in any WP installation, your code 
   is not portable to other installations.
 * If you don’t care about portability, then requiring wp-load.php will work, once
   you get the path correct that is. I believe the proper relative reference for
   default installations is `../../../wp-load.php`, untested though, I may be off
   a level. I do not load WP this way.
 * If you plan to develop more code for WP, I recommend getting in the habit of 
   invoking the WP environment correctly. There’s several ways to do this, the following
   link is an article about the options available.
    [http://glennmessersmith.com/pages/wpenviro.html](http://glennmessersmith.com/pages/wpenviro.html)
 *  Thread Starter [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249099)
 * Thank you so much for your response **bcworks**…I have a solution to my problem..
   I used search all plugin to search the products I need. But I have several problems
   on my search form, I think I will search the solution on the internet or else
   I will go back here and ask question again…
    🙂
 * Thanks for your response anyway…

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Database not working’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [filter](https://wordpress.org/support/topic-tag/filter/)
 * [website](https://wordpress.org/support/topic-tag/website/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 5 replies
 * 2 participants
 * Last reply from: [mae48](https://wordpress.org/support/users/mae48/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/database-not-working-1/#post-7249099)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics