想使用php正则表达式读取下面的文本文件,将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');
回复内容: 想使用php正则表达式读取下面的文本文件,将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');