在WordPress中使用wpdb查询没有结果

除非我将字符串标题改为“Gocomma 10W QI无线快速充电器车载支架”，否则我不会得到任何结果。。。

   $title1="Gocomma 10W QI Wireless Fast Charger Car Mount Holder - 2pcs (it)";  

     $sql = $wpdb->prepare("SELECT * FROM $wpdb->posts WHERE post_title LIKE \'%%%s%%\' and post_status=\'publish\'",$title1);

     $post_if = $wpdb->get_results($sql);

感谢您的帮助！

编辑：

Well i had to save the text from $title1=get_the_title(); to .txt file and i noticed that the – saved as – in the txt file ...then i replaced str_replace("–","-","Holder – 2pcs") and it works! the problem is that in my wordpress databse the title contains - char as it should but then when i use get_the_title(); function of wordpress in my code to retrieve the title i get the - char as – which is eventually – i dont know why get_the_title(); causing this issue! any thoughts?

$title1 = \'Gocomma 10W QI Wireless Fast Charger Car Mount Holder - 2pcs (it)\'; $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE post_title LIKE %s AND post_status = \'publish\'", \'%\' . $wpdb->esc_like($title1) . \'%\' ); $post_if = $wpdb->get_results( $sql );

使users.php搜索包含特定的用户元数据字段，而不会影响SQL查询本身

我想让管理员通过wordpress/wp admin/users中一个名为“indice de busqueda”的元值来搜索用户。php页面如何以这种方式连接到搜索框中，以便将查询更改为如下所示？ $query = get_users([ \'meta_key\' => \'indice de busqueda\', \'meta_value\' => $search_value, \'meta_compare\'=>\

相关推荐

使users.php搜索包含特定的用户元数据字段，而不会影响SQL查询本身