如何使用wpdb插入数据 [英] How to insert data using wpdb

问题描述

我有以下内容

$name="Kumkum";
$email="[e-mail]";
$phone="3456734567";
$country="India";
$course="Database";
$message="hello i want to read db";
$now = new DateTime();
$datesent=$now->format('Y-m-d H:i:s');    
global $wpdb;
$sql = $wpdb->prepare(
 "INSERT INTO `wp_submitted_form`      (`name`,`email`,`phone`,`country`,`course`,`message`,`datesent`) values ("
 $name, $email, $phone, $country, $course, $message, $datesent. ')")';

$wpdb->query($sql);

它不起作用...它引发错误...请帮助我进行更正.

It's not working... It throws error... Please help me in correcting it.

推荐答案

使用$wpdb->insert().

$wpdb->insert('wp_submitted_form', array(
    'name' => 'Kumkum',
    'email' => '[e-mail]',
    'phone' => '3456734567', // ... and so on
));

这篇关于如何使用wpdb插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！