foreach - PHP 匯入文字檔的Regex提取部分內容 變成數組 然後存入到mysql資料庫中

想使用PHPRegex讀取下面的文字檔,將date,time讀取 並加上當前的年 寫成: 2013-07-03 17:22,還有NMBR的電話號碼讀出,並產生一個迴圈的mysql語句 並存入到mysql資料庫中.

RINGRINGDATE = 0703 TIME = 1722NMBR = 13332415858RINGRINGDATE = 0704 TIME = 0812 NMBR = 04124834444RINGRING

變成:

insert into calllog (datetime,phonenumber ) values ('2013-07-03 17:22','13332415858');insert into calllog (datetime,phonenumber ) values ('2013-07-04 08:12','04124834444');

回複內容：

想使用PHPRegex讀取下面的文字檔,將date,time讀取 並加上當前的年 寫成: 2013-07-03 17:22,還有NMBR的電話號碼讀出,並產生一個迴圈的mysql語句 並存入到mysql資料庫中.

RINGRINGDATE = 0703 TIME = 1722NMBR = 13332415858RINGRINGDATE = 0704 TIME = 0812 NMBR = 04124834444RINGRING

變成:

insert into calllog (datetime,phonenumber ) values ('2013-07-03 17:22','13332415858');insert into calllog (datetime,phonenumber ) values ('2013-07-04 08:12','04124834444');

