PHP+MYSQL网站信息的增删改查代码

最新推荐文章于 2023-06-16 09:36:12 发布

Homsune

最新推荐文章于 2023-06-16 09:36:12 发布

阅读量1.2k

点赞数

分类专栏： php+mysql基础文章标签： php 增删改查修改信息删除信息

本文链接：https://blog.csdn.net/homsune/article/details/54429446

版权

php+mysql基础专栏收录该内容

13 篇文章 1 订阅

订阅专栏

文件列表（根据实际情况修改）
wtcl_add.php
wtcl_adddo.php
wtcl_edit.php
wtcl_editdo.php
wtcl_del.php
index.php

文件内容
加入信息wtcl_add.php

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>加入售后记录</title>
<link rel="shortcut icon" href="../wtcl/tb.ico" />
<script type="text/javascript" src="../js/showdate.js"></script>
</head>
<body>
<?php 
@session_start();
$username=isset($_SESSION['wtcl_user'])?$_SESSION['wtcl_user']:"";//判断session是否为空
if(!empty($username)){
    $yhming=$_SESSION['wtcl_user'];}
else{echo '<SCRIPT LANGUAGE="javascript">location.href="login_err.php"</SCRIPT>';}
?>
<form ACTION="wtcl_adddo.php" METHOD="POST" id="form1" name="form1"><table width="1400" border="0" align="center" cellpadding="0" cellspacing="1" >
  <tr>
    <td>&nbsp;</td>
    <td height="30">&nbsp;</td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr align="center" bgcolor="#CCCCCC" style="font-size: 14px">
    <td>售后日期</td>
    <td height="30">买家ID</td>
    <td>订单编号</td>
    <td>原因</td>
    <td>处理结果</td>
    <td>金额</td>
    <td>发货单号</td>
    <td>退回单号</td>
    <td>下单日期</td>
    <td>问题类型</td>
    <td>处理状态</td>
    <td>备注</td>
    <td>店铺名称</td>
    <td>客服</td>
    <td><a href="index.php" target="_parent">返回</a></td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td valign="top"><textarea name="wtcl_f" cols="10" rows="5" class="text" id="wtcl_f"  onclick="return Calendar('wtcl_f');"><?php echo date('Y-m-d'); ?></textarea></td>
    <td valign="top"><textarea name="wtcl_b" cols="12" rows="5" id="wtcl_b" required oninvalid="setCustomValidity('请输入买家ID~');" oninput="setCustomValidity('');"></textarea></td>
    <td valign="top"><textarea name="wtcl_d" cols="12" rows="5" id="wtcl_d"></textarea></td>
    <td valign="top"><textarea name="wtcl_c" cols="20" rows="5" id="wtcl_c" required oninvalid="setCustomValidity('请输入原因~');" oninput="setCustomValidity('');"></textarea></td>
    <td valign="top"><textarea name="wtcl_k" cols="18" rows="5" id="wtcl_k"></textarea></td>
    <td valign="top"><textarea name="wtcl_m" cols="5" rows="5" id="wtcl_m"></textarea></td>
    <td valign="top"><textarea name="wtcl_g" cols="12" rows="5" id="wtcl_g"></textarea></td>
    <td valign="top"><textarea name="wtcl_h" cols="12" rows="5" id="wtcl_h"></textarea></td>
      <td valign="top"><label for="wtcl_i"></label>
      <textarea name="wtcl_e" cols="10" rows="5" class="text" id="wtcl_e"  onclick="return Calendar('wtcl_e');"><?php echo date("Y-m-d",strtotime("-4 day")); ?></textarea>
      </td>
    <td valign="top"><select name="wtcl_l" size="9" id="wtcl_l">
      <option value="补发." selected="selected">补发.</option>
      <option value="换货.">换货.</option>
      <option value="退货.">退货.</option>
      <option value="快递.">快递.</option>
      <option value="发票.">发票.</option>
      <option value="维修.">维修.</option>
      <option value="定制.">定制.</option>
      <option value="其他.">其他.</option>
    </select></td>
    <td valign="top"><select name="wtcl_i" size="5" id="wtcl_i">
      <option value="待处理" selected="selected">待处理</option>
      <option value="处理中">处理中</option>
      <option value="已处理">已处理</option>
    </select></td>
    <td valign="top"><textarea name="wtcl_n" cols="10" rows="5" id="wtcl_n"></textarea></td>
    <td valign="top"><select name="wtcl_a" size="7" id="wtcl_a">
      <option value="店1" selected="selected">店1</option>
      <option value="店2">店2</option>
      <option value="店3">店3</option>
      <option value="店4">店4</option>
      <option value="店5">店5</option>
      <option value="店6">店6</option>
    </select></td>
    <td valign="top"><textarea name="wtcl_j" cols="7" rows="5" id="wtcl_j" required oninvalid="setCustomValidity('用户账号为空，请返回重试~');" oninput="setCustomValidity('');"><?=$yhming?></textarea></td>
    <td valign="top">
      <input type="submit" name="button" id="button" value="确定加入" />
      <br />
      <br />
      <input type="reset" name="button2" id="button2" value="重新填写" />
    </p></td>
  </tr>
</table>
  <input type="hidden" name="MM_insert" value="form1" />
  <input name="wtcl_time" type="hidden" id="wtcl_time" value="<?php date_default_timezone_set('PRC'); echo date('Y-m-d H:i:s'); ?>" />
</form>
</body>
</html>

加入信息验证wtcl_adddo.php

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
require_once 'comm.php';
function replace_specialChar($strParam){
     $regex = "/\/|\~|\!|\@|\ |\#|\￥|\\$|\%|\^|\&|\*|\(|\)|\_|\+|\{|\}|\:|\：|\<|\>|\?|\[|\]|\,|\.|\，|\/|\;|\。|\；|\“|\'|\`|\-|\=|\\\|\快递|\单号|\运|/"; // \.|
    return preg_replace($regex,"",$strParam);}
$wtcl_id = $_POST['wtcl_id'];
$wtcl_a = $_POST['wtcl_a'];
$wtcl_b = $_POST['wtcl_b'];
$wtcl_c = $_POST['wtcl_c'];
$wtcl_d = $_POST['wtcl_d'];
$wtcl_e = $_POST['wtcl_e'];
$wtcl_f = $_POST['wtcl_f'];
$wtcl_g = replace_specialChar($_POST['wtcl_g']);//清除用户输入的非标准字符
$wtcl_h = replace_specialChar($_POST['wtcl_h']);
$wtcl_i = $_POST['wtcl_i'];
$wtcl_j = $_POST['wtcl_j'];
$wtcl_k = $_POST['wtcl_k'];
$wtcl_l = $_POST['wtcl_l'];
$wtcl_m = $_POST['wtcl_m'];
$wtcl_n = $_POST['wtcl_n'];
$wtcl_time = $_POST['wtcl_time'];
mysql_query("set names 'utf8'");
mysql_select_db($database_wtcl_comm); 
$sql = "insert into wtcl_nr(wtcl_a,wtcl_b,wtcl_c,wtcl_d,wtcl_e,wtcl_f,wtcl_g,wtcl_h,wtcl_i,wtcl_j,wtcl_k,wtcl_l,wtcl_m,wtcl_n,wtcl_time) values('$wtcl_a','$wtcl_b','$wtcl_c','$wtcl_d','$wtcl_e','$wtcl_f','$wtcl_g','$wtcl_h','$wtcl_i','$wtcl_j','$wtcl_k','$wtcl_l','$wtcl_m','$wtcl_n','$wtcl_time')";
  //echo $sql;
  // 执行sql语句
  mysql_query($sql);
  // 获取影响的行数
  $rows = mysql_affected_rows();
  // 返回影响行数
  // 如果影响行数>=1,则判断添加成功,否则失败
  if($rows >= 1)
  {
    //alert("编辑成功");
    $jieguo='加入成功';
    href("index.php");
  }else{
    $jieguo='没有加入';
    href("index.php");
    }
    echo $jieguo;
function alert($title){
  echo "<script type='text/javascript'>alert('$title');</script>";
}
function href($url){
  echo "<script type='text/javascript'>window.location.href='$url'</script>";
}
?>

修改信息wtcl_edit.php

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>修改售后记录</title>
<link rel="shortcut icon" href="../wtcl/tb.ico" />
<script type="text/javascript" src="../js/showdate.js"></script>
</head>
<body>
<?php 
require "comm.php";
$wtclid=$_GET['wtclid'];
date_default_timezone_set("PRC");
mysql_query("set names 'utf8'");
mysql_select_db($database_wtcl_comm); 
  $sql = "select * from wtcl_nr where wtcl_id='$wtclid'";
  $result = mysql_query($sql) or die(mysql_error());
  $nr = mysql_fetch_array($result);
?>
<form action="wtcl_editdo.php" METHOD="POST" id="form1" name="form1">
<table width="1400" border="0" align="center" cellpadding="0" cellspacing="1" >
  <tr>
    <td>&nbsp;</td>
    <td height="30">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr align="center" bgcolor="#CCCCCC" style="font-size: 14px">
    <td>售后日期</td>
    <td height="30">买家ID</td>
    <td>订单编号</td>
    <td>原因</td>
    <td>处理结果</td>
    <td>金额</td>
    <td>发货单号</td>
    <td>退回单号</td>
    <td>下单日期</td>
    <td>问题类型</td>
    <td>处理状态</td>
    <td>备注</td>
    <td>店铺名称</td>
    <td>客服</td>
    <td>编号</td>
    <td>时间</td>
    <td><a href="index.php" target="_parent">返回</a></td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td valign="top"><textarea name="wtcl_f" cols="10" rows="5" class="text" id="wtcl_f"  onclick="return Calendar('wtcl_f');"><?=$nr['wtcl_f']?></textarea></td>
    <td valign="top"><textarea name="wtcl_b" cols="12" rows="5" id="wtcl_b" required oninvalid="setCustomValidity('请输入买家ID~');" oninput="setCustomValidity('');"><?=$nr['wtcl_b']?></textarea></td>
    <td valign="top"><textarea name="wtcl_d" cols="12" rows="5" id="wtcl_d"><?=$nr['wtcl_d']?></textarea></td>
    <td valign="top"><textarea name="wtcl_c" cols="20" rows="5" id="wtcl_c" required oninvalid="setCustomValidity('请输入原因~');" oninput="setCustomValidity('');"><?=$nr['wtcl_c']?></textarea></td>
    <td valign="top"><textarea name="wtcl_k" cols="18" rows="5" id="wtcl_k"><?=$nr['wtcl_k']?></textarea></td>
    <td valign="top"><textarea name="wtcl_m" cols="5" rows="5" id="wtcl_m"><?=$nr['wtcl_m']?></textarea></td>
    <td valign="top"><textarea name="wtcl_g" cols="12" rows="5" id="wtcl_g"><?=$nr['wtcl_g']?></textarea></td>
    <td valign="top"><textarea name="wtcl_h" cols="12" rows="5" id="wtcl_h"><?=$nr['wtcl_h']?></textarea></td>
      <td valign="top"><label for="wtcl_i"></label>
      <textarea name="wtcl_e" cols="10" rows="5" class="text" id="wtcl_e"  onclick="return Calendar('wtcl_e');"><?=$nr['wtcl_e']?></textarea>
      </td>
    <td valign="top"><select name="wtcl_l" size="9" id="wtcl_l">
      <option value="补发." selected="selected" <?php if (!(strcmp("补发.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>补发.</option>
      <option value="换货." <?php if (!(strcmp("换货.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>换货.</option>
      <option value="退货." <?php if (!(strcmp("退货.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>退货.</option>
      <option value="快递." <?php if (!(strcmp("快递.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>快递.</option>
      <option value="发票." <?php if (!(strcmp("发票.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>发票.</option>
      <option value="维修." <?php if (!(strcmp("维修.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>维修.</option>
      <option value="定制." <?php if (!(strcmp("定制.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>定制.</option>
      <option value="其他." <?php if (!(strcmp("其他.", $nr['wtcl_l']))) {echo "selected=\"selected\"";} ?>>其他.</option>
    </select></td>
    <td valign="top"><select name="wtcl_i" size="5" id="wtcl_i">
      <option value="待处理" selected="selected" <?php if (!(strcmp("待处理", $nr['wtcl_i']))) {echo "selected=\"selected\"";} ?>>待处理</option>
      <option value="处理中" <?php if (!(strcmp("处理中", $nr['wtcl_i']))) {echo "selected=\"selected\"";} ?>>处理中</option>
      <option value="已处理" <?php if (!(strcmp("已处理", $nr['wtcl_i']))) {echo "selected=\"selected\"";} ?>>已处理</option>
    </select></td>
    <td valign="top"><textarea name="wtcl_n" cols="8" rows="5" id="wtcl_n"><?=$nr['wtcl_n']; ?></textarea></td>
    <td valign="top"><select name="wtcl_a" size="7" id="wtcl_a">
      <option value="店1" selected="selected" <?php if (!(strcmp("店1", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店1</option>
      <option value="店2" <?php if (!(strcmp("店2", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店2</option>
      <option value="店3" <?php if (!(strcmp("店3", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店3</option>
      <option value="店4" <?php if (!(strcmp("店4", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店4</option>
      <option value="店5" <?php if (!(strcmp("店5", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店5</option>
      <option value="店6" <?php if (!(strcmp("店6", $nr['wtcl_a']))) {echo "selected=\"selected\"";} ?>>店6</option>
    </select></td>
    <td valign="top"><textarea name="wtcl_j" cols="6" rows="5" id="wtcl_j" required oninvalid="setCustomValidity('用户账号为空，请返回重试~');" oninput="setCustomValidity('');"><?=$nr['wtcl_j']; ?></textarea></td>
    <td valign="top"><textarea name="wtcl_id" cols="1" rows="5" id="wtcl_id"><?=$nr['wtcl_id']?></textarea></td>
    <td valign="top"><textarea name="wtcl_time" cols="6" rows="5" id="wtcl_time"><?=$nr['wtcl_time']?></textarea></td>
    <td valign="top">
      <input type="submit" name="button" id="button" value="确定修改" />
      <br />
      <br />
      <input type="reset" name="button2" id="button2" value="重新填写" />
    </p></td>
  </tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
</form>
</body>
</html>

修改信息处理wtcl_editdo.php

<?php
require_once('comm.php');
header("Content-Type: text/html; charset=utf-8");
function replace_specialChar($strParam){
    $regex = "/\/|\~|\!|\@|\ |\#|\￥|\\$|\%|\^|\&|\*|\(|\)|\_|\+|\{|\}|\:|\：|\<|\>|\?|\[|\]|\,|\.|\，|\/|\;|\。|\；|\“|\'|\`|\-|\=|\\\|\快递|\单号|\运|/"; // \.|
    return preg_replace($regex,"",$strParam);} 
$wtclid = $_POST['wtcl_id'];
$wtcl_a = $_POST['wtcl_a'];
$wtcl_b = $_POST['wtcl_b'];
$wtcl_c = $_POST['wtcl_c'];
$wtcl_d = $_POST['wtcl_d'];
$wtcl_e = $_POST['wtcl_e'];
$wtcl_f = $_POST['wtcl_f'];
$wtcl_g = replace_specialChar($_POST['wtcl_g']);
$wtcl_h = replace_specialChar($_POST['wtcl_h']);
$wtcl_i = $_POST['wtcl_i'];
$wtcl_j = $_POST['wtcl_j'];
$wtcl_k = $_POST['wtcl_k'];
$wtcl_l = $_POST['wtcl_l'];
$wtcl_m = $_POST['wtcl_m'];
$wtcl_n = $_POST['wtcl_n'];
$wtcl_time = $_POST['wtcl_time'];
mysql_query("set names 'utf8'");
mysql_select_db($database_wtcl_comm); 
$sql = "update wtcl_nr set wtcl_f='$wtcl_f',wtcl_b='$wtcl_b',wtcl_d='$wtcl_d',wtcl_c='$wtcl_c',wtcl_k='$wtcl_k',wtcl_m='$wtcl_m',wtcl_g='$wtcl_g',wtcl_h='$wtcl_h',wtcl_e='$wtcl_e',wtcl_l='$wtcl_l',wtcl_i='$wtcl_i',wtcl_n='$wtcl_n',wtcl_a='$wtcl_a',wtcl_j='$wtcl_j',wtcl_time='$wtcl_time' where wtcl_id='$wtclid'";
  //echo $sql;
  // 执行sql语句
  mysql_query($sql) or die(mysql_error());
  // 获取影响的行数
  $rows = mysql_affected_rows();
  // 返回影响行数
  // 如果影响行数>=1,则判断添加成功,否则失败
  if($rows >= 1)
  {
    //alert("编辑成功");
    $jieguo='修改成功';
    href("index.php");
  }else{
    $jieguo='没有修改';
    href("index.php");
    }
    echo $jieguo;
function alert($title){
  echo "<script type='text/javascript'>alert('$title');</script>";
}
function href($url){
  echo "<script type='text/javascript'>window.location.href='$url'</script>";
}
?>

删除信息wtcl_del.php

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
// 包含数据库文件
require_once 'comm.php';
// 获取删除的id
$wtclid = $_GET['wtclid'];
mysql_query("set names 'utf8'"); 
mysql_select_db($database_wtcl_comm); 
$exec="delete from wtcl_nr where wtcl_id='$wtclid'"; 
    mysql_query($exec) or die(mysql_error()); 
    $mark  = mysql_affected_rows();
    if($mark>0){
    echo "删除成功~<script language='javascript'>location.href='index.php';</script>"; }
    else{
    echo  "删除失败~<script language='javascript'>location.href='index.php';</script>";}
    mysql_close(); 
?>

信息显示页index.php

<?php require_once('comm.php'); ?>
<?php
set_time_limit(0);
@session_start();
$username=isset($_SESSION['wtcl_user'])?$_SESSION['wtcl_user']:"";//判断session是否为空
if(!empty($username)){
    $yhming=$_SESSION['wtcl_user'];
    mysql_query("set names 'utf8'"); //数据库输出编码 应该与你的数据库编码保持一致,建议用UTF-8 国际标准编码.
mysql_select_db($database_wtcl_comm); //打开数据库
$sql="select * from wtcl_yh where yh_ming='$yhming'";//从数据库中取出用户信息
$rs_yh = mysql_query($sql) or die(mysql_error()); 
$yonghu = mysql_fetch_assoc($rs_yh); 
$_SESSION['wtcl_user']=$yonghu['yh_ming'];}
else{echo '<SCRIPT LANGUAGE="javascript">location.href="login_err.php"</SCRIPT>';}
require_once('page.class.php'); //页码显示 分页类  
$showrow = 80; //一页显示的行数  
$curpage = empty($_GET['page']) ? 1 : $_GET['page']; //当前的页,还应该处理非数字的情况  
$url = "?page={page}"; //分页地址，如果有检索条件 ="?page={page}&q=".$_GET['q']  
mysql_select_db($database_wtcl_comm);
mysql_query("set names 'utf8'");
$sql = "SELECT * FROM wtcl_nr ORDER BY wtcl_f DESC,wtcl_time DESC"; //按用户显示WHERE wtcl_j='$yhming' 
$total = mysql_num_rows(mysql_query($sql)); //记录总条数  
if (!empty($_GET['page']) && $total != 0 && $curpage > ceil($total / $showrow))  
    $curpage = ceil($total_rows / $showrow); //当前页数大于最后页数，取最后一页  
//获取数据  
$sql .= " LIMIT " . ($curpage - 1) * $showrow . ",$showrow;";  
$row_nr = mysql_query($sql) or die(mysql_error());
//页面文字显示
mysql_select_db($database_wtcl_comm);
$query_wtcl_admin = "SELECT * FROM wtcl_admin";
$wtcl_admin = mysql_query($query_wtcl_admin) or die(mysql_error());
$row_admin = mysql_fetch_assoc($wtcl_admin);
//重复买家ID显示
$chongfu_sql = "Select wtcl_b, Count(*) As wtcl_b From wtcl_nr Group By wtcl_b order by wtcl_time desc";
$chongfu_rs = mysql_query($chongfu_sql);
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>售后记录表</title>
<link rel="shortcut icon" href="../wtcl/tb.ico" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="../js/jquery-ui.css" rel="stylesheet"><!--点击修改显示日历引用的css文件 -->
<link href="../js/red-datepicker.css" rel="stylesheet"><!--点击修改显示日历引用的css文件 -->
<script type="text/javascript" src="../js/jquery.js"></script> <!--点击修改引用的js文件 -->
<script type="text/javascript" src="../js/jquery.jeditable.js"></script><!--点击修改引用的js文件 -->
<script type="text/javascript" src="../js/jquery-ui.js"></script><!--点击修改显示日历引用的js文件 -->
<script type="text/javascript" src="../js/dateinput-ch-ZN.js"></script><!--点击修改显示日历引用的js文件 -->
<script type="text/javascript"> //点击修改引用java
$(function(){
     $('.edit').editable('save.php', { 
         width     :120,
         height    :20,
         //onblur    : "ignore",
         cancel    : '取消',
         submit    : '修改',
         //style     : 'height:10px',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         callback  : function(value, settings) {
             $("#xinka_time").html("刚刚");
         }
      });
      $('.edit1').editable('save.php', { 
         width     :40,
         height    :20,
         //onblur    : "ignore",
         cancel    : '取消',
         submit    : '修改',
         //style     : 'height:10px',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         callback  : function(value, settings) {
             $("#xinka_time").html("刚刚");
         }
      });
      $('.edit2').editable('save.php', { 
         width     :220,
         height    :20,
         //onblur    : "ignore",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         callback  : function(value, settings) {
             $("#xinka_time").html("刚刚");
         }
      });
     $('.edit_select1').editable('save.php', { 
         loadurl   : 'json1.php',
         type      : "select",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         style     : 'display: inline'
     });
     $('.edit_select2').editable('save.php', { 
         loadurl   : 'json2.php',
         type      : "select",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         style     : 'display: inline'
     });
      $('.edit_select3').editable('save.php', { 
         loadurl   : 'json3.php',
         type      : "select",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         style     : 'display: inline'
     });
     $(".datepicker").editable('save.php', { 
         width     : 40,
         type      : "datepicker",
         onblur    : "ignore",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">',
         tooltip   : '单击修改',
         style     : 'display: inline'
     });
     $(".textarea").editable('save.php', { 
         type      : "textarea",
         rows      : 3,
         cols      : 33,
         onblur    : "ignore",
         cancel    : '取消',
         submit    : '修改',
         indicator : '<img src="css/loader.gif">'
     });    
});
  //调用jquery ui的datepicker日历插件
$.editable.addInputType('datepicker', {
    element : function(settings, original) {
        var input = $('<input class="input" />');
        input.attr("readonly","readonly");
        $(this).append(input);
        return(input);
    },
    plugin : function(settings, original) {
        var form = this;
        $("input",this).datepicker();
    }
});
$(function() {
 $("#datepicker1").datepicker();
 $("#datepicker2").datepicker();
 $("#datepicker3").datepicker();
}); 
</script>
<script type="text/javascript"> 
function copyUrl2(obj) 
{ 
var Url2=obj;//复制对象 
Url2.select(); //选择对象 
document.execCommand("Copy"); //执行浏览器复制命令
window.status="复制成功,可直接粘贴"         
setTimeout("window.status=''",1000)
alert("复制成功,直接粘贴即可"); 
} 
</script>
</head>
<body>
<table width="1380" border="0" align="center" cellpadding="0" cellspacing="1" >
  <tr >
    <td height="20"></td>
    <td colspan="16"><?=$row_admin['admin_wz1']; ?></td>
    <td></td>
  </tr>
  <tr >
    <td height="50">&nbsp;</td>
    <td colspan="2" style="font-size: 13px">
    <?php $yhming=$_SESSION['wtcl_user'];
    if($yhming==$yonghu['yh_ming']&&$yonghu['yh_add'] == 1){echo '欢迎你：'.$yonghu['yh_mingzi'].'，<a href="logout.php">退出</a>|<a href=../wtcl/admin/index.html target="_blank">管理</a>';}
        elseif($yhming==$yonghu['yh_ming']&&$yonghu['yh_add'] != 1){echo '欢迎你：'.$yonghu['yh_mingzi'].'，<a href="logout.php">退出</a>';}
        elseif(!$yhming){echo '<SCRIPT LANGUAGE="javascript">location.href="login_err.php"</SCRIPT>';}
echo '<br />';
$yhsql = "Select wtcl_i, Count(*) As wtcl_i From wtcl_nr where wtcl_j like '%$yhming%' Group By wtcl_i order by wtcl_i asc ";
$yhrs = mysql_query($yhsql) or die(mysql_error());
while (list($wtcl_i, $count) = mysql_fetch_row($yhrs)){
    if($count>=1 & $wtcl_i<>''){
 echo '<span style="color: #2828FF; font-size: 12px;"><a href="chaxun.php?yonghu='.$yhming.'&zhuangtai='.$wtcl_i.'" target="_blank">'.$wtcl_i.'</a></span><span style="color: #EA0000; font-size: 16px;">'.$count.',</span>';
}}
?></td>
    <td><a href="index.php?xinxi=add" style="width: 1280px; text-align: center; font-size: 25px;">★加入记录</a><br><?php $week=array('日','一','二','三','四','五','六');echo date('y年n月j日').',星期'.$week[date('w')];?></td>
    <td colspan="6">【<a href="index_user.php">本人记录</a>】<?=$row_admin['admin_wz3']; ?></td>
    <td colspan="7" style="font-size: 13px"><form action="chaxun.php" method="post" name="form1" target="_blank" id="form1">
<input name="keyword" type="text" id="keyword" size="37" /><input name="button" type="submit" class="btn" id="button" value="搜索内容" /></form>
<form name="form1" method="post" action="../dao/shouhou.php">开始：
         <input name="kaishi" type="text" id="kaishi" onClick="return Calendar('kaishi');" value="<?=date('Y-m-01',strtotime('-1 month'))?>" size="7">，截止：<input name="jiezhi" type="text" id="jiezhi" onClick="return Calendar('jiezhi');" value="<?=date('Y-m-t',strtotime('-1 month'))?>" size="7"><input type="submit" class="btn"  value="导出记录" ></form></td>
    <td>共<?=ceil($total/80)?>页<?=$total?>条</td>
  </tr>
  <tr align="center" bgcolor="#CCCCCC" style="font-size: 13px">
    <td width="40" height="10">售后<br />
    日期</td>
    <td width="83">买家ID</td>
    <td width="95">订单<br />
    编号</td>
    <td width="230">原因</td>
    <td width="230">处理<br />
    结果</td>
    <td width="35">退款<br />
    金额</td>
    <td width="110">发货<br />
    单号</td>
    <td width="110">退回<br />
    单号</td>
    <td width="40">下单<br />
    日期</td>
    <td width="40">问题<br />
    类型</td>
    <td width="50">处理<br />
    状态</td>
    <td width="60">备注</td>
    <td width="65">店铺<br />
    名称</td>
    <td width="30">客服</td>
    <td width="28">复制1</td>
    <td width="28">复制2</td>
    <td width="50">时间</td>
    <td width="60">编辑</td>
  </tr>
  <tr align="left"><?php 
    $editxin = $_GET['xinxi'];
    //echo $addxin;
    if($editxin=='add'){require_once('wtcl_add1.php');}elseif($editxin=='edit'){require_once('wtcl_edit1.php');}else{'';}
    ?></tr>
<?php 
$wangwang1='http://amos.alicdn.com/getcid.aw?v=2&uid=';
$wangwang2='&site=cntaobao&s=2&groupid=0&charset=utf-8';
$wangwang3='http://amos.alicdn.com/online.aw?v=2&uid=';
$wangwang4='&site=cntaobao&s=2&charset=utf-8';
?>
<?php while($row = mysql_fetch_array($row_nr)){
$wtcl_id = $row['wtcl_id'];
mysql_select_db($database_wtcl_comm);
mysql_query("set names 'utf8'");
$query=mysql_query("select * from wtcl_nr where wtcl_id='$wtcl_id'") or die(mysql_error());
$rs=mysql_fetch_array($query);
$wtcl_id=$rs['wtcl_id'];
$wtcl_a=$rs['wtcl_a'];
$wtcl_b=$rs['wtcl_b'];
$wtcl_c=$rs['wtcl_c'];
$wtcl_d=$rs['wtcl_d'];
$wtcl_e=$rs['wtcl_e'];
$wtcl_f=$rs['wtcl_f'];
$wtcl_g=$rs['wtcl_g'];
$wtcl_h=$rs['wtcl_h'];
$wtcl_i=$rs['wtcl_i'];
$wtcl_j=$rs['wtcl_j'];
$wtcl_k=$rs['wtcl_k'];
$wtcl_l=$rs['wtcl_l'];
$wtcl_m=$rs['wtcl_m'];
$wtcl_n=$rs['wtcl_n'];
$wtcl_time=$rs['wtcl_time'];
?>
  <?php 
if($wtcl_i == '待处理'){
       $wtcl_i_bg="#FFCCCC";}
       elseif($wtcl_i == '处理中'){
      $wtcl_i_bg="#C7EDCC";}
      else{$wtcl_i_bg="#66CCFF";}
if($wtcl_a == '店1'){
       $wtcl_a_bg="#66CCFF";}
       elseif($wtcl_a == '店2'){
      $wtcl_a_bg="#EED2EE";}
      elseif($wtcl_a == '店3'){
      $wtcl_a_bg="#9b95c9";}
      elseif($wtcl_a == '店4'){
      $wtcl_a_bg="#EEE9BF";}
      elseif($wtcl_a == '店5'){
      $wtcl_a_bg="#a3cf62";}
      elseif($wtcl_a == '店6'){
      $wtcl_a_bg="#E0FFFF";}
     else{$wtcl_a_bg="#66CCFF";}
if($wtcl_l == '退货.'){
        $wtcl_l_bg="#FF3030";}
       elseif($wtcl_l == '维修.'){
      $wtcl_l_bg="#EED2EE";}
      else{$wtcl_l_bg="#66CCFF";}
if($yhming == $wtcl_j & $wtcl_i == '待处理'){
          $kf_bg='bgcolor="#FF0000" style="font-size: 18px; color: #FFF;"';}
          elseif($yhming == $wtcl_j & $wtcl_i == '处理中'){
          $kf_bg='bgcolor="#FF0000" style="color: #FFF;"';}
          elseif($yhming == $wtcl_j & $wtcl_i == '已处理'){
              $kf_bg='bgcolor="#ff5959"';}else{$kf_bg='';}?>
<tr height="25" bgcolor="<?=$wtcl_i_bg;?>" >
<td align="left" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''"><?php if($wtcl_f){echo date('n-j', strtotime($wtcl_f));};?></td>
  <td bgcolor="<?=$wtcl_a_bg?>" style="font-size:12px"><a target="_blank" href="<?=$wangwang1.$wtcl_b.$wangwang2?>"><img border="0" src="<?=$wangwang3.$wtcl_b.$wangwang4?>" /></a><input type="text" id="<?=$wtcl_id.'a'; ?>" onClick="copyUrl2(document.getElementById('<?=$wtcl_id.'a'; ?>'))"  value="<?=$wtcl_b?>" size="5"></td>
  <td class="edit" id="wtcl_d#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''"><?=$wtcl_d?></td>
     <td class="textarea" id="wtcl_c#<?=$wtcl_id?>"><?=$wtcl_c?></td>
     <td class="textarea" id="wtcl_k#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="line-height: 20px;"><?=$wtcl_k?></td>
     <td class="edit1" id="wtcl_m#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" ><?=$wtcl_m?></td>
     <td onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="font-size: 12px;"><a href="https://www.baidu.com/s?wd=<?=$wtcl_g?>" target="_blank"><div class="edit" id="wtcl_g#<?=$wtcl_id?>"><?=$wtcl_g?></div></a></td>
     <td onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="font-size: 12px;"><a href="https://www.baidu.com/s?wd=<?=$wtcl_h?>" target="_blank"><div class="edit" id="wtcl_h#<?=$wtcl_id?>"><?=$wtcl_h?></div></a></td>
     <td class="datepicker" id="wtcl_e#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="font-size: 11px;"><?php if($wtcl_e){echo date('n-j', strtotime($wtcl_e));};?></td>
     <td bgcolor="<?=$wtcl_l_bg;?>" class="edit_select1" id="wtcl_l#<?=$wtcl_id?>"><?=$wtcl_l?></td>
     <td class="edit_select2" id="wtcl_i#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''"><?=$wtcl_i; ?></td>
     <td class="edit" id="wtcl_n#<?=$wtcl_id?>" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''"><?=$wtcl_n?></td>
     <td bgcolor="<?php echo $wtcl_a_bg;?>" class="edit_select3" id="wtcl_a#<?=$wtcl_id?>" style="font-size:10px;"><?=$wtcl_a?></td>
     <td <?=$kf_bg;?>><?=$wtcl_j?></td>
     <td align="left" valign="middle" ><div id="fuzhi"><input type="text" class="d_out" onMouseOver="this.className='d_over'" onMouseOut="this.className='d_out'" value="<?=$wtcl_a?>，ID：<?=$wtcl_b?>，<?=$wtcl_k?>，<?php if($wtcl_h){echo $wtcl_h.',';}else{echo '';}?>(<?=$wtcl_c?>，订单号:<?=$wtcl_d?>)" onClick="copyUrl2(document.getElementById('<?=$wtcl_id?>'))" size="1" maxlength="10" id="<?=$wtcl_id?>"></td>
    <td align="left" ><div id="fuzhi"><input type="text" class="d_out" onMouseOver="this.className='d_over'" onMouseOut="this.className='d_out'" value="<?=$wtcl_k?>，<?php if($wtcl_g){echo $wtcl_g.'，请注意查收快递~';}else{echo '';} ?>" onClick="copyUrl2(document.getElementById('<?=$wtcl_id.'b';?>'))" size="1" maxlength="10" id="<?=$wtcl_id.'b';?>"></td>
      <td align="left" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="font-size:12px;"><?php if($wtcl_time){echo date('m-d H:i:s', strtotime($wtcl_time));};?></td>
      <td align="center" onMouseOver="this.bgColor='#99ffff'" onMouseOut="this.bgColor=''" style="font-size:12px;"><a href="index.php?xinxi=edit&wtclid=<?=$wtcl_id?>" >【改】</a><script type="text/javascript" language="javascript"> 
function confirmAct() 
{ 
  if(confirm('确定要删除本条记录吗?')) 
  { 
  return true; 
  } 
  return false; 
} 
</script> 
<a href="wtcl_del.php?wtclid=<?=$wtcl_id?>" onclick="return confirmAct();">删</a></td>
  </tr><?php } ?>
  <tr>
     <td height="20" colspan="18" align="center">
     <div class="showPage">  
                    <?php  
                    if ($total > $showrow) {//总记录数大于每页显示数，显示分页  
                        $page = new page($total, $showrow, $curpage, $url, 2);  
                        echo $page->myde_write();  
                    }  
                    ?>  
                </div></td></tr>
  <tr>
     <td height="30" colspan="18" ></td>
    </tr>
</table>
<div id="chongfu">
<?php
/* $chongfu_sql = "Select wtcl_b, Count(*) As wtcl_b From wtcl_nr Group By wtcl_b order by wtcl_time desc";
$chongfu_rs = mysql_query($chongfu_sql);  复制到head上面*/
if(!$chongfu_rs){echo '';}else{
while (list($wtcl_b, $count) = mysql_fetch_row($chongfu_rs)){
    if($count>=2){
 echo '<span style="color: #333; font-size: 12px;"><a href="chaxun.php?keyword='.$wtcl_b.'" target="_blank">'.$wtcl_b.'</a>['.$count.'],</span>';
}}}
?>
</div><div id="tongji"><iframe src="tongji_ce.php"   id="myiframe" scrolling="no" frameborder="0" style="overflow: hidden; width: 220px; height: 240px;"></iframe></div>
<script type="text/javascript">var cnzz_protocol = (("https:" == document.location.protocol) ? " https://" : " http://");document.write(unescape("%3Cspan id='cnzz_stat_icon_1260128351'%3E%3C/span%3E%3Cscript src='" + cnzz_protocol + "s4.cnzz.com/z_stat.php%3Fid%3D1260128351%26show%3Dpic1' type='text/javascript'%3E%3C/script%3E"));</script>
</body>
</html>

Homsune

关注

0
点赞
踩
5

收藏

觉得还不错? 一键收藏
0
评论
PHP+MYSQL网站信息的增删改查代码

文件列表（根据实际情况修改） wtcl_add.php wtcl_adddo.php wtcl_edit.php wtcl_editdo.php wtcl_del.php index.php文件内容加入信息wtcl_add.php<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/ht
复制链接

扫一扫