[wp-hackers] Access custom table using global wpdb not working
chris.hearn01 at ntlworld.com
Tue Dec 27 20:30:17 UTC 2016
I am changing my code to do as you suggested. But yes, I am saying that
the $wpdb->custom_tablename used to work!
I am going through the code, because its a long time since I wrote it!
Thanks for your reply
On 27/12/2016 18:27, David F. Carr wrote:
> As far as I know, custom table names are not automatically populated in the
> $wpdb object (never worked when I tried it). I usually do something like
> $custom_tablename = $wpdb->prefix.'custom_tablename' and then use that
> variable in my sql.
> You're saying this used to work. Is it a plugin of your design? Could there
> have been something in the plugin code (now changed or deleted) that added
> an additional property to the $wpdb object?
> On Tue, Dec 27, 2016 at 1:17 PM, Chris Hearn <chris.hearn01 at ntlworld.com>
>> Just recently a custom plugin on my site stopped working properly (after
>> several years).
>> The following line that fails is simply getting a count from a custom
>> (non-wp) table.
>> global $wpdb;
>> $num = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->custom_tablename"); //
>> result is null because it appears that $wpdb->custom_tablename is also null.
>> $num_wpUsers = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->users"); //
>> this works as expected!
>> If there some change that only allows "standard" wordpress table names now?
>> Thanks for any help!
>> This email has been checked for viruses by Avast antivirus software.
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
This email has been checked for viruses by Avast antivirus software.
More information about the wp-hackers