谁能解决PHP传送参数。。。。。。

buhao_110 2010-08-06 10:00:01
这是删除页PHP
session_start();
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=43");
$content = mysql_fetch_array($sql1);
//$hotel_id=mysql_fetch_row($sql1);
echo $sql1;
if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);

$query="delete from hotel_activities_2 where h_id=$hid";
if (mysql_query($query)){
echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";
}else{
echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>";
}
}
function writedblog($data){
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values
('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}
mysql_close($connection);




这是编辑页php
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
if(isset($_POST['job']) && $_POST['job']=="edit"){
$MySql_update="update hotel_activities_2 set hotel_id='{$_POST['hotel_id']}',start_date='{$_POST['start_date']}',end_date='{$_POST['end_date']}',content='{$_POST['content']}',source='{$_POST['source']}',s_type='{$_POST['s_type']}' where h_id='$hid'";
$result=mysql_query($MySql_update);
echo mysql_errno();

if ($result) {
echo "<script>alert('数据更新成功');window.location='chaxun.php';</script>";exit();
}else {
echo "<script>alert('数据更新失败');window.location='chaxun.php';</script>";
}
}else{
$sql = "SELECT * FROM hotel_activities_2 where h_id='$hid'";
$result=mysql_query($sql) or die("查询失败");
$row=mysql_fetch_array($result);
if(!$row)exit("数据不存在");
?>
<form action="" method="post">
<table border=1 height=100 width=400 align="center">
<tr>
<td>hotel_id:</td>
<td> <input name="hotel_id" type="text" value='<?php echo $row[hotel_id]; ?>' size=45 /> </td>
</tr>
<tr>
<td>start_date:</td>
<td> <input name="start_date" type="text" value='<?php echo $row[start_date];?>' size=45/> </td>
</tr>
<tr>
<td>end_date: </td>
<td> <input name="end_date" type="text" value='<?php echo $row[end_date];?>' size=45/> </td>
</tr>
<tr>
<td>content: </td>
<td> <input name="content" type="text" value='<?php echo $row[content];?>' size=45/> </td>
</tr>
<tr>
<td>source: </td>
<td> <input name="source" type="text" value='<?php echo $row[source];?>' size=45/> </td>
</tr>
<tr>
<td>s_type:</td>
<td> <input name="s_type" type="text" value='<?php echo $row[s_type]; ?>' size=45/> </td>
</tr>
<tr>
<td> </td>
<td><input name="job" type="hidden" value='edit'/><input name="submit" type="submit" value="用户更新" /> <input name="fanhui" type="button" value="返回" onClick="window.location='chaxun.php'"/></td>
</tr>
</table>
<?php
}
?>

参数传不过去
...全文
150 20 打赏 收藏 转发到动态 举报
写回复
用AI写文章
20 条回复
切换为时间正序
请发表友善的回复…
发表回复
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 15 楼 dingsongtao 的回复:]
0Array
你没看见echo $hid;
是0吗??

多自己想下吧,不要一有点不对就来问。
自己不多想想,多找找问题所在,恐怕几年以后你都还是在问个不停的。
[/Quote]
我就是想不出来才问的
Dleno 2010-08-06
  • 打赏
  • 举报
回复
0Array
你没看见echo $hid;
是0吗??

多自己想下吧,不要一有点不对就来问。
自己不多想想,多找找问题所在,恐怕几年以后你都还是在问个不停的。
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
删除的hotel_id 传不过去
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
添加页的hotel_id和centent都传不上
session_start();
$hot=$_POST["hot"];
$start=$_POST["start"];
$end=$_POST["end"];
$ctn=$_POST["ctn"];
$sre=$_POST["sre"];
$s_tp=$_POST["s_tp"];

$query= "insert into hotel_activities_2 (hotel_id,start_date,end_date,content,source,s_type) values
('$hot','$start','$end','$ctn', '$sre','$s_tp')";

if(mysql_query($query)){

$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="insert";
writedblog($logdata);

echo "<script>alert('保存数据成功');</script>";exit();

}else{
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
function writedblog($data){
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values
('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}

mysql_free_result($result);
mysql_close($connection);
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 10 楼 dingsongtao 的回复:]
那是你的查询结果为空!

<?php
session_start();
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
echo $hid;//你看下这个$hid是否传过来了?
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content,hotel……
[/Quote]

这样写之后
session_start();
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
echo $hid;
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=1");
$content = mysql_fetch_array($sql1);
print_r($content);//
if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);
/*********开始删除*******/
$query="delete from hotel_activities_2 where h_id=$hid";
if (mysql_query($query)){
echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";
}else{
echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>";
}
}

还是出现
X-Powered-By: PHP/5.2.5
Set-Cookie: PHPSESSID=824fdce77d9f3061756125a8f525f621; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Content-type: text/html

0Array
(
[0] =>
[content] =>
[1] => 0
[hotel_id] => 0
)
<script>alert('数据删除成功');window.location='chaxun.php';</script>
Dleno 2010-08-06
  • 打赏
  • 举报
回复
<form action="?hid=<?php echo $hid;?>" method="post">
这个是向当前页提交。后面的参数比不可少!
Dleno 2010-08-06
  • 打赏
  • 举报
回复
那是你的查询结果为空!

<?php
session_start();
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
echo $hid;//你看下这个$hid是否传过来了?
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id='$hid'");
$content = mysql_fetch_array($sql1);
if($content){
$logdata['hotel_id']=$content['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);

$query="delete from hotel_activities_2 where h_id='$hid'";
if (mysql_query($query)){
echo "<script>alert('数据删除成功');window.location='chaxun.php';</script>";
}else{
echo "<script>alert('数据删除失败');window.location='chaxun.php';</script>";
}
}else{
echo "<script>alert('数据不存在');window.location='chaxun.php';</script>";
}
mysql_close($connection);

function writedblog($data){
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values
('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}
?>
无笔秀才 2010-08-06
  • 打赏
  • 举报
回复
貌似 action里没有写提交的页面呢、、、
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 6 楼 dingsongtao 的回复:]
删除:


PHP code

$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);
//print_r($content……
[/Quote]

删除:print_r($content);测试后:
X-Powered-By: PHP/5.2.5
Set-Cookie: PHPSESSID=df1b1c1141a1e3fe883e4615d9811fd9; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Content-type: text/html

Array
(
[0] =>
[content] =>
[1] => 0
[hotel_id] => 0
)
<script>alert('数据删除成功');window.location='chaxun.php';</script>


添加hotel_id不是自增的也不是主键,主键是h_id.hotel_id跟centent字段一样。
Dleno 2010-08-06
  • 打赏
  • 举报
回复

<?php
function writedblog($data){//函数不要放到if里去了
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values ('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}
session_start();
//从数据库里去数据
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
if(isset($_POST['job']) && $_POST['job']=="edit"){
$MySql_update="update hotel_activities_2 set hotel_id='{$_POST['hotel_id']}',start_date='{$_POST['start_date']}',end_date='{$_POST['end_date']}',content='{$_POST['content']}',source='{$_POST['source']}',s_type='{$_POST['s_type']}' where h_id='$hid'";
$result=mysql_query($MySql_update);

$_SESSION['adminuser']="wang";
/*$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id='$hid'");
$content = mysql_fetch_array($sql1);//前面已经在$_POST里得到数据了,这里就不用查询了
*/

$logdata['hotel_id']=$_POST['hotel_id'];
$logdata['content']=$_POST['content'];
$logdata['operating']="delete";
writedblog($logdata);

if ($result) {
echo "<script>alert('数据更新成功');window.location='chaxun.php';</script>";exit();
}else {
echo "<script>alert('数据更新失败');window.location='chaxun.php';</script>";exit();
}
}else{
$sql = "SELECT * FROM hotel_activities_2 where h_id='$hid'";
$result=mysql_query($sql) or die("查询失败");
$row=mysql_fetch_array($result);
if(!$row)exit("数据不存在");}
?>
<form action="?hid=<?php echo $hid;?>" method="post">
<table border=1 height=100 width=400 align="center">
<tr>
<td>hotel_id:</td>
<td> <input name="hotel_id" type="text" value='<?php echo $row[hotel_id]; ?>' size=45 /> </td>
</tr>
<tr>
<td>start_date:</td>
<td> <input name="start_date" type="text" value='<?php echo $row[start_date];?>' size=45/> </td>
</tr>
<tr>
<td>end_date: </td>
<td> <input name="end_date" type="text" value='<?php echo $row[end_date];?>' size=45/> </td>
</tr>
<tr>
<td>content: </td>
<td> <input name="content" type="text" value='<?php echo $row[content];?>' size=45/> </td>
</tr>
<tr>
<td>source: </td>
<td> <input name="source" type="text" value='<?php echo $row[source];?>' size=45/> </td>
</tr>
<tr>
<td>s_type:</td>
<td> <input name="s_type" type="text" value='<?php echo $row[s_type]; ?>' size=45/> </td>
</tr>
<tr>
<td> </td>
<td><input name="job" type="hidden" value='edit'/><input name="submit" type="submit" value="用户更新" /> <input name="fanhui" type="button" value="返回" onClick="window.location='chaxun.php'"/></td>
</tr>
</table>
</form>
<?php
}
?>
Dleno 2010-08-06
  • 打赏
  • 举报
回复
删除:


$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);
//print_r($content);//这里最好先看下是否正确将结果查询出来?
if($content){
$logdata['hotel_id']=$content['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);
}


添加:


$query= "insert into hotel_activities_2 (hotel_id,start_date,end_date,content,source,s_type) values
('$hot','$start','$end','$ctn', '$sre','$s_tp')";// hotel_id是自增的吗?是的话,你怎么要指定它的值??

if(mysql_query($query)){

$logdata['hotel_id']=$hot;
$logdata['content']=$ctn;
$logdata['operating']="insert";
writedblog($logdata);
}
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 3 楼 dingsongtao 的回复:]
<form action="?hid=<?php echo $hid;?>" method="post">
把结束的</form>也加上
[/Quote]
//从数据库里去数据 
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
if(isset($_POST['job']) && $_POST['job']=="edit"){
$MySql_update="update hotel_activities_2 set hotel_id='{$_POST['hotel_id']}',start_date='{$_POST['start_date']}',end_date='{$_POST['end_date']}',content='{$_POST['content']}',source='{$_POST['source']}',s_type='{$_POST['s_type']}' where h_id='$hid'";
$result=mysql_query($MySql_update);
echo mysql_errno();
session_start();
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);

if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);

if ($result) {
echo "<script>alert('数据更新成功');window.location='chaxun.php';</script>";exit();
}else {
echo "<script>alert('数据更新失败');window.location='chaxun.php';</script>";
}
}else{
$sql = "SELECT * FROM hotel_activities_2 where h_id='$hid'";
$result=mysql_query($sql) or die("查询失败");
$row=mysql_fetch_array($result);
if(!$row)exit("数据不存在");}

function writedblog($data){
$time=date('Y-m-d H:i:s',time());
return mysql_query("insert into hotel_rizhi(hotel_id,name,content,operating,time) values
('$data[hotel_id]','$_SESSION[adminuser]','$data[content]','$data[operating]','$time')");
}
?>
<form action="" method="post">
<table border=1 height=100 width=400 align="center">
<tr>
<td>hotel_id:</td>
<td> <input name="hotel_id" type="text" value='<?php echo $row[hotel_id]; ?>' size=45 /> </td>
</tr>
<tr>
<td>start_date:</td>
<td> <input name="start_date" type="text" value='<?php echo $row[start_date];?>' size=45/> </td>
</tr>
<tr>
<td>end_date: </td>
<td> <input name="end_date" type="text" value='<?php echo $row[end_date];?>' size=45/> </td>
</tr>
<tr>
<td>content: </td>
<td> <input name="content" type="text" value='<?php echo $row[content];?>' size=45/> </td>
</tr>
<tr>
<td>source: </td>
<td> <input name="source" type="text" value='<?php echo $row[source];?>' size=45/> </td>
</tr>
<tr>
<td>s_type:</td>
<td> <input name="s_type" type="text" value='<?php echo $row[s_type]; ?>' size=45/> </td>
</tr>
<tr>
<td> </td>
<td><input name="job" type="hidden" value='edit'/><input name="submit" type="submit" value="用户更新" /> <input name="fanhui" type="button" value="返回" onClick="window.location='chaxun.php'"/></td>
</tr>
</table>
</form>
<?php
}
?>
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 3 楼 dingsongtao 的回复:]
<form action="?hid=<?php echo $hid;?>" method="post">
把结束的</form>也加上
[/Quote]
加上了
Dleno 2010-08-06
  • 打赏
  • 举报
回复
<form action="?hid=<?php echo $hid;?>" method="post">
把结束的</form>也加上
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
删除页的hotel_id传不过去
删除页
$sql1 = mysql_query(
"SELECT content,hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);
//$hotel_id=mysql_fetch_row($sql1);
//echo $sql1;
if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);


添加页的hotel_id和content字段都没传过去
session_start();
$hot=$_POST["hot"];
$start=$_POST["start"];
$end=$_POST["end"];
$ctn=$_POST["ctn"];
$sre=$_POST["sre"];
$s_tp=$_POST["s_tp"];

$query= "insert into hotel_activities_2 (hotel_id,start_date,end_date,content,source,s_type) values
('$hot','$start','$end','$ctn', '$sre','$s_tp')";

if(mysql_query($query)){

$logdata['hotel_id']=$hotel_id;
$logdata['content']=$content;
$logdata['operating']="insert";
writedblog($logdata);
LuciferStar 2010-08-06
  • 打赏
  • 举报
回复
表单是用form发送的,你只有<form>没有</form>
buhao_110 2010-08-06
  • 打赏
  • 举报
回复

[Quote=引用 18 楼 dingsongtao 的回复:]
你仔细看下我前面的回复,你说的问题都在里面。。
[/Quote]

谢谢你 问题解决了
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
[Quote=引用 18 楼 dingsongtao 的回复:]
你仔细看下我前面的回复,你说的问题都在里面。。
[/Quote]
这样的变动hotel_id传为0,centent传递正常
$sql1 = mysql_query(
"SELECT content
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);
//print_r($content);
if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);
Dleno 2010-08-06
  • 打赏
  • 举报
回复
你仔细看下我前面的回复,你说的问题都在里面。。
buhao_110 2010-08-06
  • 打赏
  • 举报
回复
现在就是删除页的问题了hotel_id和content字段就是传不过来 帮帮忙吧大侠们
session_start();
$hid = !empty($_GET['hid'])?intval($_GET['hid']):0;
$_SESSION['adminuser']="wang";
$sql1 = mysql_query(
"SELECT content hotel_id
FROM `hotel_activities_2`
WHERE h_id=$hid");
$content = mysql_fetch_array($sql1);
//print_r($content);
if($content){
$logdata['hotel_id']=$hotel_id['hotel_id'];
$logdata['content']=$content['content'];
$logdata['operating']="delete";
writedblog($logdata);

4,250

社区成员

发帖
与我相关
我的任务
社区描述
国内外优秀PHP框架讨论学习
社区管理员
  • Framework
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧