<!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=utf-8" /> <title>无标题文档</title> </head> <body> <form action="toupiaocl.php" method="post"> <?php require_once "../dbda/DBDA.class.php"; $db = new DBDA(); $sql = "select * from diaoyantimu"; $arr = $db->query($sql); foreach($arr as $v){ echo "<div>{$v[1]}</div>"; $sqlxx = "select * from diaoyanxuanxiang where timudaihao='{$v[0]}'"; $arrxx = $db->query($sqlxx); foreach($arrxx as $vxx){ //数组的方式提交复选框 echo "<div><input type='checkbox' name='ck[]' value='{$vxx[0]}' />{$vxx[1]}</div>"; } } ?> <input type="submit" value="提交" /> </form> </body> </html>
form表单提交列出,复选框用数组方式提交给checkbox设置name值‘ck[]’
<?php $arr = $_POST["ck"]; require_once "../dbda/DBDA.class.php"; $db = new DBDA(); $str = implode("','",$arr); $sql = "update diaoyanxuanxiang set numbers = numbers+1 where ids in ('{$str}')"; var_dump($sql); $result = $db->query($sql,1); if($result){ header("location:jieguo.php"); }else{ echo "提交失败"; }
$arr 用数组方式接收,造一个$str,用','拼接成条件update biaoming set numbers = numbers+1修改,添加完成后跳转到jieguo。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=utf-8" /> <title>无标题文档</title> <style type="text/css"> .wai{ 200px; height:10px; border:1px solid #000;} </style> </head> <body> <?php require_once "../dbda/DBDA.class.php"; $db = new DBDA(); $sql = "select * from diaoyantimu"; $arr = $db->query($sql); foreach($arr as $v){ echo "<div>{$v[1]}</div>"; $sqlxx = "select * from diaoyanxuanxiang where timudaihao='{$v[0]}'"; $arrxx = $db->query($sqlxx); var_dump($arrxx); foreach($arrxx as $vxx){ //数组的方式提交复选框 echo "<div>{$vxx[1]}<div class='wai'><div class='nei'></div></div></div>"; } } ?> </body> </html>