PHP+MYSQL网站信息的增删改查代码_php增删改查网页系统-优快云博客

本文链接：https://blog.youkuaiyun.com/Homsune/article/details/54429446

本文档列举了PHP结合MySQL进行网站信息管理的代码示例，包括添加信息（wtcl_add.php, wtcl_adddo.php）、编辑信息（wtcl_edit.php, wtcl_editdo.php）、删除信息（wtcl_del.php）以及信息展示页面（index.php）的相关功能实现。" 129531694,10540271,使用Jira REST API搜索Confluence页面,"['Jira', 'API', 'Confluence']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文件列表（根据实际情况修改）
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[