sys_data_replace.php

这是matlab的一个小程序

<?php
require_once(dirname(__FILE__).'/config.php');
CheckPurview('sys_Data');
if(empty($action))
{
	$action = '';
}
if(empty($action))
{
	require_once(DEDEADMIN."/templets/sys_data_replace.htm");
	exit();
}

/*-------------------------------
//列出数据库表里的字段
function __getfields()
--------------------------------*/
else if($action=='getfields')
{
	AjaxHead();
	$dsql->GetTableFields($exptable);
	echo "<div style='border:1px solid #ababab;background-color:#FEFFF0;margin-top:6px;padding:3px;line-height:160%'>";
	echo "表(".$exptable.")含有的字段：<br>";
	while($row = $dsql->GetFieldObject())
	{
		echo "<a href=\"javascript:pf('{$row->name}')\"><u>".$row->name."</u></a>\r\n";
	}
	echo "</div>";
	exit();
}

/*-------------------------------
//保存用户设置，清空会员数据
function __Apply()
--------------------------------*/
else if($action=='apply')
{
	$validate = empty($validate) ? '' : strtolower($validate);
	$svali = GetCkVdValue();
	if($validate=="" || $validate!=$svali)
	{
		ShowMsg("安全确认码不正确!","javascript:;");
		exit();
	}
	if($exptable==''||$rpfield=='')
	{
		ShowMsg("请指定数据表和字段！","javascript:;");
		exit();
	}
	if($rpstring=='')
	{
		ShowMsg("请指定被替换内容！","javascript:;");
		exit();
	}
	if($rptype=='replace')
	{
		$condition = empty($condition) ? '' : " where $condition ";
		$rs = $dsql->ExecuteNoneQuery("Update $exptable set $rpfield=Replace($rpfield,'$rpstring','$tostring') $condition ");
		$dsql->executenonequery("OPTIMIZE TABLE `$exptable`");
		if($rs)
		{
			ShowMsg("成功完成数据替换！","javascript:;");
			exit();
		}
		else
		{
			ShowMsg("数据替换失败！","javascript:;");
			exit();
		}
	}
	else
	{
		$condition = empty($condition) ? '' : " And $condition ";
		$rpstring = stripslashes($rpstring);
		$rpstring2 = str_replace("\\","\\\\",$rpstring);
		$rpstring2 = str_replace("'","\\'",$rpstring2);
		$dsql->SetQuery("Select $keyfield,$rpfield From $exptable where $rpfield REGEXP '$rpstring2'  $condition ");
		$dsql->Execute();
		$tt = $dsql->GetTotalRow();
		if($tt==0)
		{
			ShowMsg("根据你指定的正则，找不到任何东西！","javascript:;");
			exit();
		}
		$oo = 0;
		while($row = $dsql->GetArray())
		{
			$kid = $row[$keyfield];
			$rpf = eregi_replace($rpstring,$tostring,$row[$rpfield]);
			$rs = $dsql->ExecuteNoneQuery("Update $exptable set $rpfield='$rpf' where $keyfield='$kid' ");
			if($rs)
			{
				$oo++;
			}
		}
		$dsql->executenonequery("OPTIMIZE TABLE `$exptable`");
		ShowMsg("共找到 $tt 条记录，成功替换了 $oo 条！","javascript:;");
		exit();
	}
}

?>