Custom route and query

我正在尝试使用自定义WordPress路由和函数，但我得到一个路由和函数未找到错误。下面是我的代码，但我不确定它在哪里被破坏：

add_action(\'rest_api_init\', function () {
 register_rest_route( \'boss/v1/latest-quiz-results\',array(
            \'methods\'  => \'GET\',
            \'callback\' => \'get_latest_quiz_results\'
  ));
});
function get_latest_quiz_results() {
 $query = $wpdb->prepare(
 "SELECT post_id, 
   5PxenC_learndash_user_activity_meta.activity_meta_key, 
   5PxenC_learndash_user_activity_meta.activity_meta_value, 
   5PxenC_learndash_user_activity.activity_id, user_id, course_id
  FROM 5PxenC_learndash_user_activity
 INNER JOIN 5PxenC_learndash_user_activity_meta ON 5PxenC_learndash_user_activity_meta.activity_id = 5PxenC_learndash_user_activity.activity_id
  WHERE 5PxenC_learndash_user_activity_meta.activity_meta_key = \'pass\'");
$results = $wpdb->get_results($query);
if (empty($results)) {
return new WP_Error( \'empty_category\', \'there is no quiz data\', 
array(\'status\' => 404) );

}

$response = new WP_REST_Response($results);
$response->set_status(200);

 return $results;
 }

小码农CODE

相关推荐

如何使用unction.php更改登录URL？