3.4.2 提问:如何使⽤ WordPress ⾃带的函数来执⾏⾃定义的数据库查询?
使⽤WordPress⾃带的函数执⾏⾃定义的数据库查询可以通过wpdb类中的⽅法来实现。⾸先,使⽤global $wpdb;来获取wpdb类的实例。然后,可以使⽤$wpdb->query()⽅法执⾏⾃定义的SQL查询,或者使⽤$wpdb->get_results()⽅法执⾏查询并返回结果集。另外,可以使⽤$wpdb->prepare()⽅法来预处理SQL语句,以防⽌SQL注⼊攻击。以下是⼀个简单的⽰例:// 获取wpdb实例 global $wpdb;// 查询所有⽂章的标题和内容$results = $wpdb->get_results($query);// 循环输出结果集foreach ($results as $result) {
10 Screens$8,029
I will design rough sketches for upto 5 Screens of your website/Mobile app.
3 Days
Delivery
1
Revision
- Source File
- Commercial Use
- Interactive Mockup
- 10 Pages
20 Screens$16,029
I will design rough sketches for upto 5 Screens of your website/Mobile app.
- Source File
- Commercial Use
- Interactive Mockup
- 10 Pages
30 Screens$24,029
I will design rough sketches for upto 5 Screens of your website/Mobile app.
- Source File
- Commercial Use
- Interactive Mockup
- 10 Pages