最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

database - $wpdb->get_results($wpdb->prepare(... You have an error in your SQL syntax;

programmeradmin1浏览0评论

I am making a database request in wordpress to make this question: select * from tc_chat_clt;

How ever a error appears, what am I doing wrong?

$users = $wpdb->get_results($wpdb->prepare('SELECT * FROM %s',`tc_chat_clt`));

I am making a database request in wordpress to make this question: select * from tc_chat_clt;

How ever a error appears, what am I doing wrong?

$users = $wpdb->get_results($wpdb->prepare('SELECT * FROM %s',`tc_chat_clt`));
Share Improve this question asked Dec 13, 2020 at 1:51 tiago caladotiago calado 6324 silver badges17 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 1

PHP views backticks (ie, ``) as delimiting something that should be executed, not as a quotation character. Use single quotes (') instead.

$users = $wpdb->get_results($wpdb->prepare('SELECT * FROM %s', 'tc_chat_clt'));
发布评论

评论列表(0)

  1. 暂无评论