Dgsmile
新手上路
UID 77195
精华
0
积分 24
帖子 13
金钱 24 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2006-7-28
状态 离线
|
php批处理问题请大家帮忙！
本人php新手，在处理php进行批处理更新数据时，发现必须从第一条开始选择更新才可以
比如我从第四条记录下始选择处理，仍然是从第一条开始，研究了一上午终于发现是for循环$i=0的问题，$i=0就限定了必须从第一条开始更新，
假设我不想从第一条开始批量更新，而是从中间开始批量更新，请问下各位php大侠们有没什么办法实现？
还有我程序中的不妥的地方也请各位指点指点!
代码如下
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>首页处理</title>
<link href="css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
background-image: url(bg.gif);
}
-->
</style></head>
<body>
<a href="loginok.php?action=out"></a>
<form id="form1" name="form1" method="post" action="">
<label> </label>
<table width="780" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr>
<td align="center"><label><span class="STYLE2"><a href="manage.php">返回管理首页</a> 请选择要管理的排序页</span>
<select name="mselect" id="mselect">
<option value="num">数字</option>
<option value="a">A</option>
<option value="b">B</option>
<option value="c">C</option>
<option value="d">D</option>
<option value="e">E</option>
<option value="f">F</option>
<option value="g">G</option>
<option value="h">H</option>
<option value="i">I</option>
<option value="k">J</option>
<option value="l">L</option>
<option value="m">M</option>
<option value="n">N</option>
<option value="o">O</option>
<option value="p">P</option>
<option value="q">Q</option>
<option value="r">R</option>
<option value="s">S</option>
<option value="t">T</option>
<option value="u">U</option>
<option value="v">V</option>
<option value="w">W</option>
<option value="x">X</option>
<option value="y">Y</option>
<option value="z">Z</option>
<option value="2y">二级域名</option>
</select>
</label>
<label>
<input type="submit" name="Submit1" value="确定" />
<a href="useraurl.php">插入网站</a></label></td>
</tr>
</table>
<label></label>
</form>
<form id="form2" name="form2" method="post" action="">
<table width="786" height="66" border="0" align="center" class="tableborder">
<tr>
<td width="25" align="center">选中</td>
<td width="269" align="center">网站名称</td>
<td width="315" align="center">网站网址</td>
<td width="37" align="center">排序号</td>
<td width="116" align="center">处理</td>
</tr>
<tr>
<?php
if(isset($_POST['Submit1']))
require_once('../include/config.php');
require_once('../include/fconfig.php');
require_once('../include/function.php');
$db = new mysql();
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname,$mydbcharset);
$sql = "SELECT * FROM `message` WHERE xuanze = '".html($_POST['mselect'])."'";
$result1 = $db->query($sql);
while($rs1 = $db->fetch_array($result1)){
?>
<td>
<input name='plck[]' type='checkbox' id="plck[]" value="<?=$rs1['mid']?>"/></td>
<td height="28" align="center"><label>
<input name="mname[]" type="text" id="mname[]" value="<?=$rs1['mname']?>" size="45" />
</label></td>
<td align="center"><label>
<input name="murl[]" type="text" id="murl[]" value="<?=$rs1['murl'] ?>" size="60" />
</label></td>
<td align="center"><label>
<input name="mpaixu[]" type="text" id="mpaixu[]" value="<?=$rs1['mpaixu']?>" size="5" />
</label></td>
<td align="center"><a href="manage1ed.php?action=del&mid=
<?=$rs1['mid']?>">删除</a> <a href="manage1ed.php?action=eds&mid=<?=$rs1['mid']?>">
<label></label>
</a> <a href="edurl.php?mid=
<?=$rs1['mid']?>">详细编辑</a></td>
</tr>
<?php
}
if(isset($_POST['Submit2'])){
require_once('../include/config.php');
require_once('../include/fconfig.php');
require_once('../include/function.php');
$db = new mysql();
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname,$mydbcharset);
for( $i=0; $i<count($_POST['plck']); $i++ ){
$getnum = $_POST['murl'][$i];//取得输入的网址
$xuanze = substr($getnum,7,3);//取http://后面的3个字串.
$xuanze1 = substr($getnum,11,1);//取http://www.后面的1个字串.
if($xuanze !=='www'){
$zxuanze = '2y';
}
elseif($xuanze1 =='0' || $xuanze1 =='1' || $xuanze1 =='2' || $xuanze1 =='3' || $xuanze1 =='4' || $xuanze1 =='5' || $xuanze1 =='6' || $xuanze1 =='7' || $xuanze1 =='8' || $xuanze1 =='9'){
$zxuanze = 'num';
}
else{
$xuanze1 = strtolower($xuanze1);
$zxuanze = $xuanze1;
}
$sql="update message set mname='".html($_POST["mname"][$i])."',murl='".html($_POST["murl"][$i])."',mpaixu='".html($_POST["mpaixu"][$i])."',`xuanze` = '$zxuanze' where mid='".$_POST["plck"][$i]."'";
echo $sql."<br>";
//$db->query($sql);
}
}
?>
<?php
if(isset($_POST['Submit3'])){
require_once('../include/config.php');
require_once('../include/fconfig.php');
require_once('../include/function.php');
$db = new mysql();
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname,$mydbcharset);
for( $i=0; $i<count($_POST['plck']); $i++ ){
$sql="delete from message where mid='".$_POST["plck"][$i]."'";
echo $sql."<br>";
$db->query($sql);
}
}
?>
<label></label>
</table>
<div align="center">
<p>
<input type="submit" name="Submit2" value="批量更新" />
<label>
<input name="Submit3" type="submit" id="Submit3" value="批量删除" />
</label>
</p>
</div>
</form>
</body>
</html>
|
|
