Working with custom table in wordpress database

Question

I have been trying for hours to simply call a table in a wordpress dbase through a .ajax post, and return the value I want, but I get this error on the returning page: "Call to a member function get_results() on a non object".

here is my php file:

<?php 
global $wpdb;


if (isset($_POST['state'])) {
    $results=$wpdb->get_results("SELECT DISTINCT make FROM cz_cars ORDER BY make ASC");
    echo $results[0][0];

exit;
}

?>

Here is the jquery i am using:


jQuery(document).ready(function() 
{

        jQuery("#caryear").change(function() 
        { 
            jQuery.ajax(
            { 
                type: "POST", 
                url: "wp-content/themes/storefront/includes/post-yearmakel.php",        
                data: ({ 'state' : jQuery("#caryear").val() }), 
                success: function(msg)
                {
                    jQuery('#carmake').append('' + msg + '');
                }
            });
        });

});

This code works fine when I comment out the database stuff in the php file, and just echo back a string. I have the php file with the other includes and it is being recognized by wordpress. No idea whats going on here...I thought having global $wpdb; would make this work!

Any ideas?

Shad · Accepted Answer · 2011-03-02 05:46:47Z

1

declaring something global is only meaningful outside of the global scope.

The first script doesn't see an initialized $wpdb. You need to include the WordPress engine or at least the part the sets up $wpdb

answered Mar 2, 2011 at 5:46

Shad

15.5k2 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mike Muta Over a year ago

Hi! thanks the reply! isnt there a place I can just save my php file so it has access to the wp global database? I changed my php so it has <?php include "../../../../wp-includes/wp-db.php"; $wpdb = new wpdb("root","******","pro","localhost");?> in it but now i get the error : use of undefined constant WP_DEBUG". I cant believe how frustrating this is!

Shad Over a year ago

np. Unfortunately WP isn't my specialty, but suffice it to say, that WP creates $wpdb somewhere in it's includes. If you aren't prepared to include wherever it's created (CMS's can be picky about how they permit including parts of themselves), you can just create your own one-off DB connection for the sake of this script.

Shad Over a year ago

In that case, I would recommend creating your own DB Connection: <a href="php.net/manual/en/function.mysql-connect.php">mysql_connect</a> <a href="php.net/manual/en/function.mysql-select-db.php">mysql_select_db</a> <a href="php.net/manual/en/function.mysql-query.php">mysql_query</a>

David Register · Accepted Answer · 2011-12-28 18:59:07Z

0

I am not sure if the question has been answered or not but I believe you need to include the wp-load.php file.

It should be in the wordpress root install. It will give you access to wp globals.

answered Dec 28, 2011 at 18:59

David Register

611 silver badge9 bronze badges

Collectives™ on Stack Overflow

Working with custom table in wordpress database

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related