#To close all instances of excel: $Workbook->Close; unset($Worksheet); unset($Workbook); $excel_app->Workbooks->Close(); $excel_app->Quit(); unset($excel_app);
?> .xls文件里面一列存需要改的数据一列存新的数据 思路跟这个差不多UPDATE PRODUCTS SET MODEL='新号' WHERE MODEL=‘旧号’ 就是用循环做了
比如: 知道有model号(1、2、3)我想把model号用批量的改成model(01、02、03)
update products set products_model = '01' WHERE products_model = '1';就行了 我想用批量的
看行不行
update products
set modele=stuff(model,1,0,'0')
你是想每行加一个还是????
model 好像SQL不认识 是不是还要另外定义
是要批量更改的
比如select里面的in()这种
where [model] in(1,2,3,4,5)
给大家分享下
<?PHP
if(ini_get('max_execution_time')<>0)ini_set('max_execution_time',0);
if (@ini_get('com.allow_dcom') != true) @ini_set('magic_quotes_sybase', true);
$host="数据库服务器";
$user="数据库用户名";
$pwd="数据库密码";
$db="数据库名";
$tb="表名";
$filename = "E:\AppServ\www\\球衣对应表.xls";
$sheet1 = "sheet2";
$excel_app = new COM("Excel.application") or Die ("Did not connect");
$Workbook = $excel_app->Workbooks->Open("$filename") or Die("Did not open $filename $Workbook");
$con1=mysql_connect($host,$user,$pwd);
$db_query=mysql_select_db($db,$con1); for($i=2;$i>0;$i++)
{
$Worksheet = $Workbook->Worksheets($sheet1);
$Worksheet->activate;
$excel_cell = $Worksheet->Range("A".$i);
$excel_cell->activate;
$excel_result1 = $excel_cell->value;
$excel_cell = $Worksheet->Range("B".$i);
$excel_cell->activate;
$excel_result2 = $excel_cell->value;
if($excel_result1<>""&&$excel_result2<>"")
{
$sql="update `".$tb."` set `products_image` = '".$excel_result1."' WHERE `products_image` = '".$excel_result2."'";
$query=mysql_query($sql);
}else
{
break;
}
}
#To close all instances of excel:
$Workbook->Close;
unset($Worksheet);
unset($Workbook);
$excel_app->Workbooks->Close();
$excel_app->Quit();
unset($excel_app);
?>
.xls文件里面一列存需要改的数据一列存新的数据
思路跟这个差不多UPDATE PRODUCTS SET MODEL='新号' WHERE MODEL=‘旧号’ 就是用循环做了