时间戳

首页 > 解决方案 > 如何在 PHP 中使用 MONTH("2020-02-25") 从数据库中获取数据

php - 如何在 PHP 中使用 MONTH("2020-02-25") 从数据库中获取数据

问题描述

这是我的代码

  $result_sales = $db->prepare("SELECT * FROM sales_invoice a LEFT JOIN customer b ON b.cus_tkn=a.cus_tkn WHERE MONTH(a.sales_invodate) = '$month_no'  AND a.invoice_year = '$year'   GROUP  BY a.sbill_no ");
    $result_sales ->execute();
    } else {
    $result_sales = $db->prepare("SELECT * FROM sales_invoice a LEFT JOIN sales_invoice_prdct_detail b ON b.sales_invono=a.sales_invono  WHERE MONTH(a.sales_invodate) = '$month_no' AND a.invoice_year= '$year'   ");
    $result_sales ->execute();}
    for ($i=0; $rows_sales  = $result_sales ->fetch(); $i++){
    $order_no = $rows_sales['order_no'];
   echo  $norm_date = $rows_sales['sales_invodate'];

没有输出显示这有什么问题吗？

标签： phpmysqlpdo

解决方案

尝试这个。

$result_sales = $db->prepare("SELECT * FROM sales_invoice a LEFT JOIN customer b ON b.cus_tkn=a.cus_tkn WHERE MONTH(a.sales_invodate) = $month_no AND a.invoice_year = $year  GROUP BY a.sbill_no");
$result_sales ->execute();

Month() 的返回值不是字符串。

推荐阅读