87,910
社区成员
发帖
与我相关
我的任务
分享新手刚接触php，求大神帮忙解决一下页面传参数问题
mypay.php界面如下
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="format-detection" content="telephone=no" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<title>我的订单</title>
<link href="img/icon.ico" rel="shortcut icon">
<link href="css/base.css" type="text/css" rel="stylesheet"/>
<link href="css/common.css" type="text/css" rel="stylesheet"/>
<link href="css/style.css" type="text/css" rel="stylesheet"/>
<script type="text/javascript" src="js/jquery.js"></script></head>
<body>
<style>
td{
height:30px;
width:33%;
}
</style>
<script type="text/javascript" >
var t=2 ;
</script>
<?
$ttt="<script type=text/javascript>document.write(t)</script>";
echo $ttt;
?>
<div class="main">
<div class="list">
<ul class="list-head wd90 texC mA clearfix font15 cfff mT20" style="height:45px;line-height:45px;">
<li class="fl wd100 mA">我的订单<span id="myDiv"></span></li>
</ul>
<!--<ul class="wd80 texC mA clearfix font14 cfff borB">
<li class="fl wd33">京A66666</li>
<li class="fl wd33">123</li>
<li class="fl wd33"><a href="../offer/info?id=25">详情<img height=10px class="pB2 pL5x" src="img/list_triangle.png"></a></li>
</ul>-->
<?php
session_start();
$link=mysql_connect('localhost','root','root')or die("数据库连接失败");
//连接数据库
mysql_select_db('dbtest',$link);//选择数据库
mysql_query("set names utf8");//设置编码格式
$email=$_SESSION['user2'];
$q="select * from myguests WHERE email='$email'";//设置查询指令
$result=mysql_query($q);//执行查询
while($row=mysql_fetch_assoc($result))//将result结果集中查询结果取出一条
{
echo"
<table style=\"color:#FFEDBC;border:2px solid #944C6F;\" class=\"texC font14 wd90 mA\">
<tr><td>车牌号码</td><td>".$row["car_area"]."</td><td> ".$row["car_num"]. "</td></tr>
<tr><td>车主姓名</td><td></td><td>".$row["vehicle_owner"]."</td></tr>
</table>
";
$area=$row["car_area"];
$number=$row["car_num"];
$q2="select * from pay WHERE car_area='$area' AND car_num='$number' order by id desc limit 1";
$result2=mysql_query($q2);//执行查询
while($row2=mysql_fetch_assoc($result2))//将result结果集中查询结果取出一条
{
echo"<table style=\"color:#FFEDBC;\" class=\"texC font14 wd90 mA hide\">
<tr><td>乘客座位险</td><td></td><td>".$row2["ckzuowei"]."</td></tr>
<tr><td>第三者责任险</td><td></td><td>".$row2["zeren"]."</td></tr>
<tr><td>司机座位险</td><td></td><td>".$row2["sjzuowei"]."</td></tr>
<tr><td>抢盗险</td><td></td><td>".$row2["qiangdao"]."</td></tr>
<tr><td>车窗险</td><td></td><td>".$row2["chechuang"]."</td></tr>
<tr><td>车损险</td><td></td><td>".$row2["chesun"]."</td></tr>
</table>
<table style=\"color:#FFEDBC;\" class=\"texC font14 wd90 mA\">
<tr><td> <span class='tog font12'style='color:gray;'> 展开详细信息</span> </td>
<form action=\"\" method=\"post\"><td><input class=\"del\" style=\"background:#944C6F\" type=\"submit\" value=\"删除此订单\" name='del2' />
</td></form>
</tr>
</table>
";
}
}
?>
<div class="texC">
<a href="center.php" class="btn home_btn mA cfff texC font15 mT50 a-bouncein">返回</a>
</div>
</div>
</div>
</body>
<script>
$('.tog').click(function () {
if($(this).parents('table').prev().hasClass('hide')&&$(this).parents('table').prev().css('display')=="none"){
$(this).html("收起详细信息");
}
else{
$(this).html("展开详细信息")
}
$(this).parents('table').prev().slideToggle("fast")
})
$(".del").click(function(){
var car_num=$(this).parents("table").prev().prev().find("td :eq(2)").html();
var car_area=$(this).parents("table").prev().prev().find("td :eq(1)").html();
var car_num2=JSON.stringify(car_num);
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
/* document.getElementById("myDiv").innerHTML=xmlhttp.responseText;*/
console.log(123);
}
}
xmlhttp.open("POST","del.php?fname="+car_area,true);
/* xmlhttp.open("POST","del.php?fname2="+car_num,true);*/
xmlhttp.send();
console.log(car_num,car_area)
})
</script>
</html>
del.php代码如下：
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2017/2/12 0012
* Time: 下午 10:12
*/
$link=mysql_connect('localhost','root','root')or die("数据库连接失败");
//连接数据库
mysql_select_db('dbtest',$link);//选择数据库
mysql_query("set names utf8");//设置编码格式
$q=@$_GET["fname"];
/*$q2=$_GET["fname2"];*/
$sql1 = "delete from pay where car_area='$q'";
mysql_query($sql1);
$sql2 = "delete from myguests where car_area='$q'";
mysql_query($sql2);
$sql3 = "delete from information where car_area='$q'";
mysql_query($sql3);
header("Location: mypay.php");
echo 123;
?>
当mypay.php把car_area传过来的时候可以执行删除操作，但是传car_num就不行 car_area为一个汉字，比如京，浙，car_num为车牌比如A88888,我 最终是要执行delete from XX where car_area='$q AND car_num='$q2'';
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="format-detection" content="telephone=no" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<title>我的订单</title>
<link href="img/icon.ico" rel="shortcut icon">
<link href="css/base.css" type="text/css" rel="stylesheet"/>
<link href="css/common.css" type="text/css" rel="stylesheet"/>
<link href="css/style.css" type="text/css" rel="stylesheet"/>
<script type="text/javascript" src="js/jquery.js"></script></head>
<body>
<style>
td{
height:30px;
width:33%;
}
</style>
<script type="text/javascript" >
var t=2 ;
</script>
<?
$ttt="<script type=text/javascript>document.write(t)</script>";
echo $ttt;
?>
<div class="main">
<div class="list">
<ul class="list-head wd90 texC mA clearfix font15 cfff mT20" style="height:45px;line-height:45px;">
<li class="fl wd100 mA">我的订单<span id="myDiv"></span></li>
</ul>
<!--<ul class="wd80 texC mA clearfix font14 cfff borB">
<li class="fl wd33">京A66666</li>
<li class="fl wd33">123</li>
<li class="fl wd33"><a href="../offer/info?id=25">详情<img height=10px class="pB2 pL5x" src="img/list_triangle.png"></a></li>
</ul>-->
<?php
session_start();
$link=mysql_connect('localhost','root','root')or die("数据库连接失败");
//连接数据库
mysql_select_db('dbtest',$link);//选择数据库
mysql_query("set names utf8");//设置编码格式
$email=$_SESSION['user2'];
$q="select * from myguests WHERE email='$email'";//设置查询指令
$result=mysql_query($q);//执行查询
while($row=mysql_fetch_assoc($result))//将result结果集中查询结果取出一条
{
echo"
<table style=\"color:#FFEDBC;border:2px solid #944C6F;\" class=\"texC font14 wd90 mA\">
<tr><td>车牌号码</td><td>".$row["car_area"]."</td><td> ".$row["car_num"]. "</td></tr>
<tr><td>车主姓名</td><td></td><td>".$row["vehicle_owner"]."</td></tr>
</table>
";
$area=$row["car_area"];
$number=$row["car_num"];
$q2="select * from pay WHERE car_area='$area' AND car_num='$number' order by id desc limit 1";
$result2=mysql_query($q2);//执行查询
while($row2=mysql_fetch_assoc($result2))//将result结果集中查询结果取出一条
{
echo"<table style=\"color:#FFEDBC;\" class=\"texC font14 wd90 mA hide\">
<tr><td>乘客座位险</td><td></td><td>".$row2["ckzuowei"]."</td></tr>
<tr><td>第三者责任险</td><td></td><td>".$row2["zeren"]."</td></tr>
<tr><td>司机座位险</td><td></td><td>".$row2["sjzuowei"]."</td></tr>
<tr><td>抢盗险</td><td></td><td>".$row2["qiangdao"]."</td></tr>
<tr><td>车窗险</td><td></td><td>".$row2["chechuang"]."</td></tr>
<tr><td>车损险</td><td></td><td>".$row2["chesun"]."</td></tr>
</table>
<table style=\"color:#FFEDBC;\" class=\"texC font14 wd90 mA\">
<tr><td> <span class='tog font12'style='color:gray;'> 展开详细信息</span> </td>
<form action=\"\" method=\"post\"><td><input class=\"del\" style=\"background:#944C6F\" type=\"submit\" value=\"删除此订单\" name='del2' />
</td></form>
</tr>
</table>
";
}
}
?>
<div class="texC">
<a href="center.php" class="btn home_btn mA cfff texC font15 mT50 a-bouncein">返回</a>
</div>
</div>
</div>
</body>
<script>
$('.tog').click(function () {
if($(this).parents('table').prev().hasClass('hide')&&$(this).parents('table').prev().css('display')=="none"){
$(this).html("收起详细信息");
}
else{
$(this).html("展开详细信息")
}
$(this).parents('table').prev().slideToggle("fast")
})
$(".del").click(function(){
var car_num=$(this).parents("table").prev().prev().find("td :eq(2)").html();
var car_area=$(this).parents("table").prev().prev().find("td :eq(1)").html();
var car_num2=JSON.stringify(car_num);
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
/* document.getElementById("myDiv").innerHTML=xmlhttp.responseText;*/
console.log(123);
}
}
xmlhttp.open("POST","del.php?fname="+car_area,true);
/* xmlhttp.open("POST","del.php?fname2="+car_num,true);*/
xmlhttp.send();
console.log(car_num,car_area)
})
</script>
</html>
del.php代码如下：
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2017/2/12 0012
* Time: 下午 10:12
*/
$link=mysql_connect('localhost','root','root')or die("数据库连接失败");
//连接数据库
mysql_select_db('dbtest',$link);//选择数据库
mysql_query("set names utf8");//设置编码格式
$q=@$_GET["fname"];
/*$q2=$_GET["fname2"];*/
$sql1 = "delete from pay where car_area='$q'";
mysql_query($sql1);
$sql2 = "delete from myguests where car_area='$q'";
mysql_query($sql2);
$sql3 = "delete from information where car_area='$q'";
mysql_query($sql3);
header("Location: mypay.php");
echo 123;
?>
当mypay.php把car_area传过来的时候可以执行删除操作，但是传car_num就不行 car_area为一个汉字，比如京，浙，car_num为车牌比如A88888,我 最终是要执行delete from XX where car_area='$q AND car_num='$q2'';
...全文
请发表友善的回复…
发表回复
武大大 2017-02-16
- 打赏
- 举报
php是这个板块吗楼主。。
wangjianan0502 2017-02-16
- 打赏
- 举报
随便来个人 我把分给你吧
wangjianan0502 2017-02-16
- 打赏
- 举报
妈的搞了我这么多天我终于发现了，car_num读取text()的时候多了一个空格，怪不得匹配不到，我的天
wangjianan0502 2017-02-14
- 打赏
- 举报
php1
xmlhttp.open("POST","del.php?fname="+car_area+"&fname2="+car_num,true);
del.php
$q=$_GET["fname"];
$q2=$_GET["fname2"];
$sql1 = "delete from pay where car_area='$q' AND car_num='$q2'";
mysql_query($sql1,$link);
del.php 里面echo $q,$q2;可以得到京 A88888的数据，也就是说参数传过来了， 可是数据库里面就是删不掉，如果条件只改成
$sql1 = "delete from pay where car_area='$q' ;也是可以删掉的，应该是car_num出了问题 但是我找不到问题所在了 求大神帮忙
