找到一个函数,不过没验证过
<?
function update($field1,$field2,$field3)
{
mysql_pconnect("localhost","","");
mysql_select_db("DATABASENAME");
mysql_query("insert into tablename (field1,field2,field3) values ('$field1','$field2','$field3')");
}
$connectodbc=odbc_pconnect("DSN","USERNAME","PASSWORD");
$queryodbc="select field1,field2,field3 from tablename";
$resultodbc=odbc_do($connectodbc,$queryodbc);
echo "Open successfully!!";
while(odbc_fetch_row($resultodbc))
{
$spbh=odbc_result($resultodbc,1);
$spmc=odbc_result($resultodbc,2);
$cplx=odbc_result($resultodbc,3);
update($spbh,$spmc,$cplx);
}
echo "Converted successfully!";
?>
<?
function update($field1,$field2,$field3)
{
mysql_pconnect("localhost","","");
mysql_select_db("DATABASENAME");
mysql_query("insert into tablename (field1,field2,field3) values ('$field1','$field2','$field3')");
}
$connectodbc=odbc_pconnect("DSN","USERNAME","PASSWORD");
$queryodbc="select field1,field2,field3 from tablename";
$resultodbc=odbc_do($connectodbc,$queryodbc);
echo "Open successfully!!";
while(odbc_fetch_row($resultodbc))
{
$spbh=odbc_result($resultodbc,1);
$spmc=odbc_result($resultodbc,2);
$cplx=odbc_result($resultodbc,3);
update($spbh,$spmc,$cplx);
}
echo "Converted successfully!";
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货