以XAMPP+VSCode+XDebug 建構 PHP 網頁開發環境

一、參考資料 : https://dotblogs.com.tw/ianchiu28/2017/06/15/180900

二、實作紀錄


1. 安裝 XAMPP :
  1.1 下載 : https://www.apachefriends.org/zh_tw/download.html

  1.2  安裝:
   

2. 安裝 VS Code :

  2.1 下載 :  https://code.visualstudio.com/download

 2.2 安裝 

      

3. 於 VSCode 安裝 XDebug

  3.1 啟動 XAMPP 

  3.2 開啟 VSCode

     3.2.1 安裝 Debug

•     XDebug installation wizard => OPEN=>  https://xdebug.org/wizard.php

在這個頁面按全選 ( Ctrl + A )，然後按複製 ( Ctrl + C )，然後貼到 XDebug installation wizard

    

然後直接按下 "Analyse my phpinfo() output"，它就會告訴你要安裝什麼

------------------------------------------------

摘要

• 已安裝Xdebug：否

• 服務器API： Apache 2.0處理程序

• Windows：是-編譯器：MS VC 15-體系結構：x64

• Zend服務器：否

• PHP版本： 7.4.5

• Zend API編號： 320190902

• PHP API編號： 20190902

• 調試版本：否

• 線程安全構建：是

• 已加載OPcache：否

• 配置文件路徑： C：\ WINDOWS

• 配置文件： D：\ xampp \ php \ php.ini

• 擴展目錄： D：\ xampp \ php \ ext

使用說明

1. 下載php_xdebug-2.9.5-7.4-vc15-x86_64.dll

1. 將下載的文件移到D：\ xampp \ php \ ext

1. 編輯D:\xampp\php\php.ini 並添加行

1. zend_extension = D:\xampp\php\ext\php_xdebug-2.9.5-7.4-vc15-x86_64.dll

1. 重新啟動網絡服務器

------------------------------------------------

再來修改 php.ini 檔案，整個檔案的最下面加上這段文字：

; XDebugzend_extension = D:\xampp\php\ext\php_xdebug-2.5.4-5.6-vc11.dll

[XDebug]xdebug.remote_enable = 1xdebug.remote_autostart = 1

4.  VSCode 設定

把  "php.validate.executablePath" 給予 php.exe 這檔案的所在位置，以筆者的 xampp 預設為例 ，就是 "D:/xampp/php/php.exe"

4.  VSCode 開始第一次 Debug

5. VSCode => Debug

MySql 按日期進行統計

今天的紀錄筆數 : SELECT COUNT(*) FROM `log` WHERE (to_days(now()) - to_days(`time`) =0);

昨天的紀錄筆數 : SELECT COUNT(*) FROM `log` WHERE (to_days(now()) - to_days(`time`) =1);

前天的紀錄筆數 : SELECT COUNT(*) FROM `log` WHERE (to_days(now()) - to_days(`time`) =2);

• 統計各CH 的 Event 次數，

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="CTV" and `AlarmOnOff`="1" )

UNION

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="PTS" and `AlarmOnOff`="1"  )

UNION

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="FTV" and `AlarmOnOff`="1" )

UNION

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="HiHd" and `AlarmOnOff`="1" )

UNION

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="TTV" and `AlarmOnOff`="1" )

UNION

( SELECT `ChName`, 

    SUM( IF((to_days(now()) - to_days(`time`) =1),1 ,0 ) ) as yesterday, 

    SUM( IF((to_days(now()) - to_days(`time`) =2),1 ,0 ) ) as today_2, 

    SUM( IF((to_days(now()) - to_days(`time`) =3),1 ,0 ) ) as today_3,

    SUM( IF((to_days(now()) - to_days(`time`) =4),1 ,0 ) ) as today_4, 

    SUM( IF((to_days(now()) - to_days(`time`) =5),1 ,0 ) ) as today_5, 

    SUM( IF((to_days(now()) - to_days(`time`) =6),1 ,0 ) ) as today_6, 

    SUM( IF((to_days(now()) - to_days(`time`) =7),1 ,0 ) ) as today_7 

  FROM `log` WHERE `ChName`="CTS" and `AlarmOnOff`="1" )

 

• 若建成 PHP: Stored Procedures 可更簡化並加速

function WeeklyReport(){

    $sql = "CALL `getLog7Day`();";

    $result = SqlCommand($sql);

    showTable($result);

    //釋放查詢結果所佔用的記憶體

    mysql_free_result($result);

}

 

---

以下資料聲明:

聲明：原創文章，轉載時必須以超鏈接的形式註明作者和原始出處。 作者：YoviSun
標題：MySql按日期進行統計（前一天、本週、某一天）
鏈接：http://www.yovisun.com/mysql-date-statistics.html

---

在mysql數據庫中，常常會遇到統計當天的內容。

例如，在user表中，日期字段為：log_time

• 統計當天

sql語句為：

select  *  from user where date (log_time) = curdate();    

curdate() 表示當天日期

 

• 統計前一天

如果表示前一天的數據，則不能使用curdate()-1，因為當日期為月初時，curdate()-1 日期就不是上一個月的月末日期。

例如：今天是6月1日，理論上curdate()-1為5月31日，但是curdate()-1得到不是5月31日，而是6月0日。那麼統計前一天的日期就不能使用curdate()-1了，mysql數據庫又有一個新方法統計前一天的數據。

統計前一天的日誌sql語句：

 

select  *  from  bean  where date (log_time) = date_sub(curdate(),interval 1  day );  

 

括號中為當天時間的前一天，如果統計前幾天就將括號中的'1'改成相應的天數。如果要算月或年，直接將day改為month或year即可

 

• 統計本週

要求： 統計從昨天開始統計前7天的日誌包括昨天

select  *  from user where date (log_time) >= date_sub(curdate(),interval 7  day ) and date (log_time) <= date_sub(curdate(),interval 1  day )  

在網上找的使用week統計一周信息，只能統計到5天的信息，不符合要求，所以改用這種方法。

 

• 統計某一天

統計歷史某一天的日誌，將date_sub(curdate(),interval 0 day)函數中的curdate()替換為某一天的日期
比如：要統計2012-05-25日期的信息

date_sub('2012-05-25',interval 0 day) 

關於 date_sub() 函數的例子：

今天是2013年5月20日。

date_sub('2012-05-25',interval 1 day)表示2012-05-24
date_sub('2012-05-25',interval 0 day)表示2012-05-25
date_sub('2012-05-25', interval -1 day)表示2012-05-26
date_sub('2012-05-31',interval -1 day)表示2012-06-01
date_sub(curdate(),interval 1 day)表示2013-05-19
date_sub( curdate(),interval -1 day)表示2013-05-21
date_sub(curdate(),interval 1 month)表示2013-04-20
date_sub(curdate(),interval -1 month)表示2013-06-20
date_sub( curdate(),interval 1 year)表示2012-05-20
date_sub(curdate(),interval -1 year)表示2014-05-20

XAMPP : 設定 phpMyAdmin 登入密碼

參考 : http://blog.xuite.net/kchin/technic/4847839

安裝好 XAMPP 進入 phpMyAdmin 發現root 沒有密碼保護，訊息如下:

設定檔內有關設定 (root登入及沒有密碼) 與預設的 MySQL 權限戶口相同。 MySQL 伺服器在這預設的設定運行的話會很容易被入侵，您應更改有關設定去防止安全漏洞。

1. 進入 "使用者" | "編輯權限" | "修改密碼"

PS: 三個使用者為 root 的都要修改

2. 修改 C:\xampp\phpMyAdmin\config.inc.php

2.1 auth_type = ‘http’

/* Authentication type and info */

$cfg['Servers'][$i]['auth_type'] = 'http';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Lang'] = '';

登入畫面如下:

2.1 auth_type = ‘kookie’

/* Authentication type and info */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Lang'] = '';

登入畫面如下(個人較喜好該方式)