数据库 test
表A 存在 aa,ab,ac 字段
表B 存在 ba,bb,bc 字段<?php
function connectDB()
{
mysql_connect("localhost","root","123456");
//connect to mysql details;
mysql_select_db("test");
}
function closeDB()
{
mysql_close();
//disconnect to mysql for release RAM;
}$read_sql="select * from A order by id";
$read_result=mysql_query($read_sql) or die ("Fail to : ".$read_sql.mysql_error());
if(!$read_result)
{
echo "Table A is empty, can't update table B! please check.";
}
else
{
while($row=mysql_fetch_object($read_result))
{
$ba=$row->aa;
$bb=$row->ab;
$bc=$row->ac;
$query_b_sql="select ba from B where ba='$ba' order by id";
$result=mysql_query($query) or die ("Fail to : ".$query.mysql_error());
if(!mysql_fetch_object($result))
{
$insert_sql="insert into B (ba,bb,bc) values ('$ba','$bb','$bc')";
$insert_result=mysql_query($insert_sql) or die ("Fail to : ".$insert_sql.mysql_error());
}
else
{
$update_sql="update B set bb='$bb',bc='$bc' where ba='$ba'";
$update_result=mysql_query(update_sql) or die ("Fail to : ".update_sql.mysql_error());
}
}
echo "date("Y-m-d H:i:s") update completed! ";
}
?>这个是我个人的一个思路。
表A 存在 aa,ab,ac 字段
表B 存在 ba,bb,bc 字段<?php
function connectDB()
{
mysql_connect("localhost","root","123456");
//connect to mysql details;
mysql_select_db("test");
}
function closeDB()
{
mysql_close();
//disconnect to mysql for release RAM;
}$read_sql="select * from A order by id";
$read_result=mysql_query($read_sql) or die ("Fail to : ".$read_sql.mysql_error());
if(!$read_result)
{
echo "Table A is empty, can't update table B! please check.";
}
else
{
while($row=mysql_fetch_object($read_result))
{
$ba=$row->aa;
$bb=$row->ab;
$bc=$row->ac;
$query_b_sql="select ba from B where ba='$ba' order by id";
$result=mysql_query($query) or die ("Fail to : ".$query.mysql_error());
if(!mysql_fetch_object($result))
{
$insert_sql="insert into B (ba,bb,bc) values ('$ba','$bb','$bc')";
$insert_result=mysql_query($insert_sql) or die ("Fail to : ".$insert_sql.mysql_error());
}
else
{
$update_sql="update B set bb='$bb',bc='$bc' where ba='$ba'";
$update_result=mysql_query(update_sql) or die ("Fail to : ".update_sql.mysql_error());
}
}
echo "date("Y-m-d H:i:s") update completed! ";
}
?>这个是我个人的一个思路。
表A 存在 aa,ab,ac 字段
表B 存在 ba,bb,bc 字段<?php
function connectDB()
{
mysql_connect("localhost","root","123456");
//connect to mysql details;
mysql_select_db("test");
}
function closeDB()
{
mysql_close();
//disconnect to mysql for release RAM;
}$read_sql="select * from A order by id";
$read_result=mysql_query($read_sql) or die ("Fail to : ".$read_sql.mysql_error());
if(!$read_result)
{
echo "Table A is empty, can't update table B! please check.";
}
else
{
while($row=mysql_fetch_object($read_result))
{
$ba=$row->aa;
$bb=$row->ab;
$bc=$row->ac;
$query_b_sql="select ba from B where ba='$ba' order by id";
$result=mysql_query($query) or die ("Fail to : ".$query.mysql_error());
if(!mysql_fetch_object($result))
{
$insert_sql="insert into B (ba,bb,bc) values ('$ba','$bb','$bc')";
$insert_result=mysql_query($insert_sql) or die ("Fail to : ".$insert_sql.mysql_error());
}
else
{
$update_sql="update B set bb='$bb',bc='$bc' where ba='$ba'";
$update_result=mysql_query(update_sql) or die ("Fail to : ".update_sql.mysql_error());
}
}
echo "date("Y-m-d H:i:s") update completed! ";
}
?>个人的一个思路。。
方案:
1.在 SqlServer 写一个调度包
2.写一个vbs文件,添加到任务计划里面
3.写一个exe,定时去请求你的网页
参数例子:c:\php5\php.exe -q e:\www\filename.php
是用.NET的
WINDOWS服务来完成的
嘎嘎