个人中心
gpt4 book ai didi

php - mysql 和 codeigniter 更新多行

转载 作者：行者123 更新时间：2023-11-29 22:38:13 25 4
gpt4 key购买 nike

我有一张包含可用房间的表格
表格看起来像这样(抱歉片段)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
  <head>
    <title>availability</title>
    <meta name="GENERATOR" content="HeidiSQL 9.1.0.4936">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
      thead tr {background-color: ActiveCaption; color: CaptionText;}
      th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; }
      table, td {border: 1px solid silver;}
      table {border-collapse: collapse;}
      thead .col0 {width: 106px;}
      .col0 {text-align: right;}
      thead .col1 {width: 80px;}
      .col1 {text-align: right;}
      thead .col2 {width: 79px;}
      .col2 {text-align: right;}
      thead .col3 {width: 80px;}
      .col3 {text-align: right;}
      thead .col4 {width: 91px;}
      thead .col5 {width: 51px;}
      .col5 {text-align: right;}
      thead .col6 {width: 113px;}
      .col6 {text-align: right;}
      thead .col7 {width: 113px;}
      .col7 {text-align: right;}
      thead .col8 {width: 78px;}
      .col8 {text-align: right;}
      thead .col9 {width: 79px;}
      .col9 {text-align: right;}
    </style>
  </head>

  <body>

<p style="font-family: monospace; white-space: pre;">SELECT * FROM `availability` WHERE today between '2015-04-10' and '2015-04-18'
and idroom = 28 LIMIT 1000</p>

    <table caption="jos_bookitavailability (9 rows)">
      <thead>
        <tr>
          <th class="col0">idavailability</th>
          <th class="col1">idoffer</th>
          <th class="col2">idbook</th>
          <th class="col3">idroom</th>
          <th class="col4">today</th>
          <th class="col5">price</th>
          <th class="col6">price_deviation_1</th>
          <th class="col7">price_deviation_2</th>
          <th class="col8">availability</th>
          <th class="col9">idcategory</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td class="col0">149631</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-18</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149630</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-17</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149629</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-16</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149628</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-15</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149627</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-14</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149626</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-13</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149625</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-12</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149624</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-11</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
        <tr>
          <td class="col0">149623</td>
          <td class="col1">0</td>
          <td class="col2">0</td>
          <td class="col3">28</td>
          <td class="col4">2015-04-10</td>
          <td class="col5">0</td>
          <td class="col6"></td>
          <td class="col7"></td>
          <td class="col8">0</td>
          <td class="col9">1</td>
        </tr>
      </tbody>
    </table>

    <p>
      <em>generated 2015-04-06 13:09:39      by <a href="http://www.heidisql.com/">HeidiSQL 9.1.0.4936</a></em>
    </p>

  </body>
</html>

我想要做的是:当我有新预订时，将“idbook”字段更改为预订 ID，并将每行的可用性更改为 1，具体取决于预订日期(参见:今天字段)和 idroom。< br/>在模型中我有这段代码(注意“调试”)

function updateAvailability($data)
    {<p></p>

<pre><code>    $this->db->select('idbook');
    $this->db->where('idguests',$data['guestid']);
    $this->db->where('valid_from',$data['from_date']);
    $this->db->where('valid_to',$data['to_date']);
    $this->db->where('idroom',$data['idroom']);
    $query = $this->db->get('bookitbooking');

    $result = $query->row();
    $idbook = $result->idbook;

    $changes = array(
        'idbook' => $idbook,
        'availability' => 1
    );
    $where = array(
        'today' => "BETWEEN '{$data['from_date']}' AND '{$data['to_date']}'",
        'idroom' => $data['idroom']
    );

    $update = $this->db->update('bookitavailability',$changes,$where);
    if( $update === TRUE){
        echo "done";
    } else {
        echo "wrong";
    }

}
</code></pre>

<p></p>
由于某种原因，上面的代码不起作用，我有一个“完成”返回回显，但我的数据库没有更改。

最佳答案

尝试仔细检查该字符串:

"BETWEEN '{$data['from_date']}' AND '{$data['to_date']}'"

至

"BETWEEN ".$data['from_date']." AND ".$data['to_date']

关于php - mysql 和 codeigniter 更新多行，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/29469338/

25 4 0
文章推荐： java - 如何使用sqlite制作android测验应用程序？
文章推荐： mysql - 为什么只有 if 语句有效？我的代码(count() 语句)中有任何错误吗？
文章推荐： php - 从注册表查询后我的 session 自动销毁
文章推荐： mysql - 为什么 MongoDB 和 MySQL 比 grep 慢？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com