php - 在 Codeigniter 中进行查询

Question

我在这里对 native 程序有一些疑问，任何人都可以帮助我将其转换为保存在 MODEL 文件夹中的 CODEIgniter 样式。

这是我的查询:

SELECT
CONCAT(address.firstname,' ',
            address.lastname) AS `Name`,
address.email AS Email,
items.created_at AS Date,
items.`name` AS Description,
items.store_id AS Logon,
items.`name` AS Category,
items.store_id AS FeedbackDate,
items.sku AS ProductSearchcode,
items.order_id AS Orderref,
orders.grand_total
FROM sales_flat_order AS orders
      JOIN sales_flat_order_item AS items
      ON items.order_id = orders.entity_id
      LEFT JOIN sales_flat_order_address AS address
      ON orders.entity_id = address.parent_id
WHERE   
   items .created_at BETWEEN  '2016-07-01' AND '2016-07-31'
  AND orders.status = 'complete'

我希望有人能帮助我:)问候

Answer 1

所有答案都正确，但击球手与Query Builder Class一起使用像下面这样:

$this->db->select("CONCAT(address.firstname,' ',address.lastname) AS `Name`,
address.email AS Email, items.created_at AS Date, items.`name` AS Description,
items.store_id AS Logon, items.`name` AS Category, items.store_id AS FeedbackDate,
items.sku AS ProductSearchcode, items.order_id AS Orderref, orders.grand_total");

$this->db->from("sales_flat_order AS orders");
$this->db->join("sales_flat_order_item AS items", "items.order_id = orders.entity_id");
$this->db->join("sales_flat_order_address AS address", "orders.entity_id = address.parent_id", "LEFT");
$this->db->where("items.created_at BETWEEN  '2016-07-01' AND '2016-07-31'");
$this->db->where("orders.status", "complete");

$query = $this->db->get();
$result = $query->result_array();