时间戳

首页 > 解决方案 > 更新当前行的列

php - 更新当前行的列

问题描述

我正在遍历联系人，提取特定数据然后想要更新当前行上的特定列。我怎样才能做到这一点？

该行位于最底部，我只想将其从 0 更改为 1。

    require('../mailin.php');
    $mailin = new Mailin("https://api.sendinblue.com/v2.0","Your access key");


  $customer_data = $wpdb->get_results("SELECT * FROM imp_customer_log WHERE updated_in_sib = '0'");
    foreach( $customer_data as $customer ) {

        $customer_id = $customer[0];
    $customer_event = $customer[1];
    $customer_data = $customer[2];
    $customer_sib = $customer[3];

        $user = get_user_by( 'id', $customer_id );
        $user_email = $user->user_email;

        $data = array(
            "email" => $user_email,
            "attributes" => array(
                $customer_event => $customer_data,
            ),
        );

        var_dump($mailin->create_update_user($data));
        // Change updated_in_sib to 1 for current row

  }

标签： phpsqlwordpress

解决方案

我假设这是一个wordpress。您可以使用 wpdb 中的更新功能，如下所示。

$wpdb->update('imp_customer_log', ['customer_sib' => 1], ['id' => $customer_id]);

您可以在文档上查看它。 https://codex.wordpress.org/Class_Reference/wpdb#UPDATE_rows

对于 php（不是 wordpress）

$sql = "UPDATE imp_customer_log SET customer_sib=1 WHERE id=" . $customer_id;
$connection->query($sql);

推荐阅读