www.gusucode.com > 38:【198-4180】(自适应手机端)响应式HTML5高端电子机械企业织梦模板 > 38:【198-4180】(自适应手机端)响应式HTML5高端电子机械企业织梦模板/dede/sys_data_replace.php
<?php /** * 数据库操作替换 * * @version $Id: sys_data_replace.php 1 22:28 2010年7月20日Z tianya $ * @package DedeCMS.Administrator * @copyright Copyright (c) 2007 - 2010, DesDev, Inc. * @license http://help.dedecms.com/usersguide/license.html * @link http://www.dedecms.com */ 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 = preg_replace("#".$rpstring."#i", $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(); } }