4,250
社区成员
发帖
与我相关
我的任务
分享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);$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
}
?>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);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>";
}
}
<?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
}
?>
$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);
}
//从数据库里去数据
$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
}
?>$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);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);$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);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);