致命错误：在非对象上调用成员函数 get_results()（jQuery 来自插件和 WordPress）

发布于 2024-12-05 18:50:52 字数 851 浏览 0 评论 0原文

我正在尝试在 Wordpress 插件中使用 jQuery 的 Form 插件。我正在关注这个示例。我已经将我的脚本排入队列并构建了我的表单。在 csf_form_handler.php（相当于示例的 json-echo.php）中，我可以访问表单中选择的项目（我有一个单选按钮组）。

我的目标是使用 SELECT 语句中表单中选择的值从自定义 WordPress 数据库表返回数据。

$csf_selected_sport = $_POST['csf_radiobutton_group_sport'];

global $wpdb;

$csf_db_table = $wpdb->prefix . "activity";


$csf_data = $wpdb->get_results($wpdb->prepare("
            SELECT *
            FROM " .$csf_db_table. "
            WHERE  " . $csf_selected_sport ." "));

不幸的是，我得到：

注意：尝试获取非对象的属性（在 $wpdb-> 前缀上）线）
致命错误：在非对象上调用成员函数 get_results() （在 $csf_data 行上）

csf_form_handler.php 中的上述代码不在函数中。我不知道这是否有什么不同。

如何更改代码以便可以使用 $wpdb？

谢谢。

原文

I'm trying to use jQuery's Form plugin with in a Wordpress plugin. I'm following this example. I've enqueued my scripts and built my form. In csf_form_handler.php, the equivalent of the example's json-echo.php, I can access the items selected in my form (I have a radiobutton group).

My goal is to use the values selected in the form in a SELECT statement to return data from a custom wordpress database table.

$csf_selected_sport = $_POST['csf_radiobutton_group_sport'];

global $wpdb;

$csf_db_table = $wpdb->prefix . "activity";


$csf_data = $wpdb->get_results($wpdb->prepare("
            SELECT *
            FROM " .$csf_db_table. "
            WHERE  " . $csf_selected_sport ." "));

Unfortunately, I'm getting:

Notice: Trying to get property of non-object (on the $wpdb->prefix
line)
Fatal error: Call to a member function get_results() on a non-object
(on the $csf_data line)

The code above in csf_form_handler.php isn't in a function. I don't know if that makes a difference.

How can I change the code so that I can use $wpdb?

Thank you.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

古镇旧梦 2024-12-12 18:50:52

我遇到了同样的问题，但我通过包含 WordPress 文件夹根目录中的 wp-config.php 文件解决了这个问题，如下所示：

require_once('../../../wp-config.php');
global $wpdb;

我希望这会有所帮助。

I came across the same issue but I got it resolved by including the wp-config.php file from the root of the WordPress folder like this:

require_once('../../../wp-config.php');
global $wpdb;

I hope this helps.

回复收藏 0 原文

浅语花开 2024-12-12 18:50:52

编写插件时，最好将数据处理保留在插件的主文件中（即不将其发送到单独的文件），并激活函数来相应地处理它。基本上，您可以将表单的操作设置为指向插件的文件或包含表单的页面。

假设您正在处理的此表单显示在网站前端的侧边栏上。要在用户单击“提交”时处理来自该表单的数据，您可以在我们的插件文件中创建一个函数，例如：

function $csf_get_data(){

global $wpdb; //since your this function is in your plugin’s file, $wpdb should be available, so no errors here! =)

$csf_selected_sport = $_POST['csf_radiobutton_group_sport'];

$csf_db_table = $wpdb->prefix . "activity";

$csf_data = $wpdb->get_results($wpdb->prepare("
            SELECT *
            FROM " .$csf_db_table. "
            WHERE  " . $csf_selected_sport ." ")); 

    //do your stuff with $csf_data
}

//now run it everytime the plugin is run
if(isset($_POST[‘submit’])){
    $csf_get_data();
}

现在，您可以设置表单操作的属性以将数据发送到同一页面，这将能够使用上面的函数来处理它。您可以使用：

    action=””

或

    action="<?php the_permalink()?>"

请注意：为了确保数据来自您的网站（尤其是公共表单），请记住使用 wp_nonce_field() 创建一个可由 wordpress 通过 wp_nonce() 验证的随机数字段： http://codex.wordpress.org/Function_Reference/wp_nonce_field

希望有帮助，

Vq。

When writing plugins, it's a good idea to keep your data-handling within the plugin's main file (i.e. not sending it to a separate file), and activate functions to handle it accordingly. Basically, you can set your form's action to point to either the plugin's file, or the page that contains the form.

Let’s assume this form you are working on is displayed on the front end of the site, on the sidebar. To handle data coming from that form when a user clicks “submit”, you could create a function in our plugin's file such as:

function $csf_get_data(){

global $wpdb; //since your this function is in your plugin’s file, $wpdb should be available, so no errors here! =)

$csf_selected_sport = $_POST['csf_radiobutton_group_sport'];

$csf_db_table = $wpdb->prefix . "activity";

$csf_data = $wpdb->get_results($wpdb->prepare("
            SELECT *
            FROM " .$csf_db_table. "
            WHERE  " . $csf_selected_sport ." ")); 

    //do your stuff with $csf_data
}

//now run it everytime the plugin is run
if(isset($_POST[‘submit’])){
    $csf_get_data();
}

Now, you can set up your form action’s property to send the data to the same page, which will be able to handle it using the function above. You could use either:

    action=””

    action="<?php the_permalink()?>"

Please note: to make sure the data is coming from your site (especially public forms), remember to use wp_nonce_field() to create a nonce field that can be validated byt wordpress via wp_nonce(): http://codex.wordpress.org/Function_Reference/wp_nonce_field

Hope that helps,

Vq.

回复收藏 0 原文