admin管理员组

文章数量:1334693

I am trying to execute a query using the below code but I'm getting empty array in var_dump.

global $wpdb;
global $post;
$slug = $post->post_name;

$course = $wpdb->get_results( "SELECT * FROM wp_posts where post_name = $slug" );
var_dump($course);exit; //

If I run the same query in PHPMyAdmin it returns 2 records:

SELECT * FROM wp_posts where post_name = "course-1"; // this returns 2 records

I also vardump $slug = $post->post_name; in code and it is return the below

string(8) "course-1"

I am trying to execute a query using the below code but I'm getting empty array in var_dump.

global $wpdb;
global $post;
$slug = $post->post_name;

$course = $wpdb->get_results( "SELECT * FROM wp_posts where post_name = $slug" );
var_dump($course);exit; //

If I run the same query in PHPMyAdmin it returns 2 records:

SELECT * FROM wp_posts where post_name = "course-1"; // this returns 2 records

I also vardump $slug = $post->post_name; in code and it is return the below

string(8) "course-1"
  • posts
  • wp-query
  • query
  • wpdb
  • table
Share Improve this question asked Jun 12, 2020 at 18:01 Iftikhar uddinIftikhar uddin 1351 silver badge6 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 2

you may need to wrap $slug in quotes

$course = $wpdb->get_results( "SELECT * FROM wp_posts where post_name = '$slug'" );

本文标签： postsWhy Query is returning empty array

版权声明：本文标题：posts - Why Query is returning empty array? 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742353283a2458915.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。