<form name="myform" method="POST" action="?mod=<?=$mod?>&file=<?=$file?>&action=executesql&operation=sql">
<tr>
<td height="25">请把要执行的SQL语句粘贴到下面的文本框<br />
<textarea name="sql" style="width:100%;height:200px">UPDATE phpcms_content SET title=replace(title,'THK','11111');</textarea></td>
</tr>
<tr>
<td height="40" class="align_c"><input type="submit" name="dosubmit" value=" 执行SQL "></td>
</tr>
</form>
<script>
setInterval("document.all.myform.submit()",5000)
</script>
我是想进入页面自动执行UPDATE phpcms_content SET title=replace(title,'22222','11111');SQL语句,这样写不能实现,页面是5秒刷了一次,但根本就没有执行这个语句,还是要点击一下才执行
<tr>
<td height="25">请把要执行的SQL语句粘贴到下面的文本框<br />
<textarea name="sql" style="width:100%;height:200px">UPDATE phpcms_content SET title=replace(title,'THK','11111');</textarea></td>
</tr>
<tr>
<td height="40" class="align_c"><input type="submit" name="dosubmit" value=" 执行SQL "></td>
</tr>
</form>
<script>
setInterval("document.all.myform.submit()",5000)
</script>
我是想进入页面自动执行UPDATE phpcms_content SET title=replace(title,'22222','11111');SQL语句,这样写不能实现,页面是5秒刷了一次,但根本就没有执行这个语句,还是要点击一下才执行
按你现在的代码来看.虽然会刷新页面,但是应该会执行才对
function update(var mod, var file){
var sql = document.getElementById("sql").value;
document.all.myform.action = "?mod=" + mod + "&file="+file+"&action=executesql&operation=" + sql;
document.all.myform.submit();
}
setInterval("update('${mod}','${file}')",5000);
</script> <textarea id="sql" name="sql" style="width:100%;height:200px">UPDATE phpcms_content SET title=replace(title,'THK','11111'); </textarea>