01.<?
02.$host="localhost";
03.$user="root";
04.$pass="";
05.$db="4digits";
06.
07.mysql_connect( $host,$user,$pass) or die ("�Դ��͡Ѻ�ҹ������ Mysql ����� ");
08.mysql_select_db($db) or die ("�������ö��Ҷ֧���ҧ��");
09.mysql_query("SET NAMES UTF8");
10.$sql = "select * from renew" ;
11.
12.
13.$db_query=mysql_db_query($db,$sql);
14.$a=0;
15.
16.while ( $result = mysql_fetch_array($db_query) )
17.{
18.$e=$result[enddate];
19.$s=$result[startdate];
20.$id = $result[id];
21.$ss = strtotime( $s );
22.$ee = strtotime( $e );
23.while (date('Y', $ss) < 2012 )
24.{
25.$startdate = mktime(0,0,0,date('m', $ss),date('d',$ss),date('y', $ss)+1);
26.$startdate = date( 'Y-m-d', $startdate );
27.$enddate = mktime(0,0,0,date('m', $ee),date('d',$ee),date('y', $ee)+1);
28.$enddate = date( 'Y-m-d', $enddate );
29.echo $id;
30.echo "/";
31.echo $startdate;
32.echo $enddate;
33.echo "<BR>";
34.$strSQL="INSERT INTO renew (id, startdate, enddate,) VALUES ('$id', '$startdate', '$enddate')";
35.echo $strSQL;
36.
37.$result=mysql_db_query($db,$strSQL);
38.$ss = strtotime( $startdate);
39.$ee = strtotime( $enddate);
40.$b++;
41.}
42.
43.
44.$a++;
45.}
46.mysql_close() ;
47.
48.?>
