用php简单实现银行进度审核-优快云博客

本文链接：https://blog.youkuaiyun.com/Chengxuyuannixi/article/details/52776424

创建表单yihang.php

<html>
<meta http-equiv="content-type"content="text/html;charset=utf-8"/>
<body>

<form method="post" action="yihang2.php">
   <table>
   <tr>
       <td>申请人姓名</td>
       <td><input type="text" name="name"></td>
   </tr>
   <tr>
       <td>申请银行</td>
       <td><select name="yin">
           <option value="民生">民生
           <option value="人民">人民
       </select></td>
   </tr>
   <tr>
       <td>银行卡号</td>
       <td><input type="text" name="ka"></td>
   </tr>
   <tr>
       <td>申请额度</td>
       <td><input type="text" name="du"></td>
   </tr>
   <tr>
       <td>申请手机号</td>
       <td><input type="text" name="shou"></td>
   </tr>
   <tr>
       <td><input type="submit"value="提交"></td>
       <td></td>
   </tr>
   </table>
</form>
</body>
</html>

创建表单yihang2.php

<?php
header("content-type:text/html;charset=utf-8");
empty($_POST['name'])?$name="":$name=$_POST['name'];
//echo "name";die;
empty($_POST['yin'])?$yin="":$yin=$_POST['yin'];
empty($_POST['ka'])?$ka="":$ka=$_POST['ka'];
empty($_POST['du'])?$du="":$du=$_POST['du'];
empty($_POST['shou'])?$shou="":$shou=$_POST['shou'];
//验证姓名
if($name==""){
echo "姓名不能为空";die;}

if(strlen($ka)!=18){
echo "卡号不能小于18位";die;}
if($shou==""){
   echo "手机号不能为空";die;}
if(strlen($shou)!=11){
echo "手机号不能小于11";die;}

//连接数据库
$link=mysql_connect('127.0.0.1','root','root');
//echo $link;
//选择数据库
mysql_select_db('yuekao',$link);

//sql语句
$sql="insert into yi(name,yin,ka,du,shou)values('$name','$yin','$ka','$du','$shou')";
//echo $sql;
//执行
$re=mysql_query($sql);
//echo $re;
//判断
if($re){
       echo "<a href='yihang3.php'>成功</a>";
       }else
           {
           echo "<a href='yihang3.php'>失败</a>";
           }
?>

创建表单yihang3.php

<?php
header("content-type:text/html;charset=utf-8");
//$id=$_POST['id'];
//连接数据库
$link=mysql_connect('127.0.0.1','root','root');
//选择数据库
mysql_select_db('yuekao',$link);
//sql语句
$sql="select* from yi ";
//echo $sql;
//执行
$res=mysql_query($sql);
?>
<table border=1>
<tr>
   <td>序号</td>
   <td>申请人姓名</td>
   <td>申请银行</td>
   <td>银行卡号</td>
   <td>申请额度</td>
   <td>申请手机号</td>
   <td>申请进度</td>
   <td>操作</td>
</tr>
<?php
while($rec=mysql_fetch_array($res)){
?>
<tr>
   <td><?php echo $rec['id']?></td>
   <td><?php echo $rec['name']?></td>
   <td><?php echo $rec['yin']?></td>
   <td><?php echo $rec['ka']?></td>
   <td><?php echo $rec['du']?></td>
   <td><?php echo $rec['shou']?></td>
   <td><?php
   if($rec['s']==0){
                   ?>
       <a href="yihang5.php?id=<?php echo $rec['id']?>">正在处理</a>
                   <?php
                   }
                   ?>
       <?php
   if($rec['s']==1){
                   ?>
       <a href="yihang6.php?id=<?php echo $rec['id']?>">通过申请</a>
                   <?php
                   }
                   ?>
   </td>
   <td><a href="yikang4.php?id=<?php echo $rec['id']?>">删除</a></td>
</tr>
<?php
}
?>
</table>

创建表单yihang4.php

<?php
header("content-type:text/html;charset=utf-8");
if(!empty($_GET['id'])){

                   $id = $_GET['id'];
           }else{
               echo "非法访问!";
           }
//连接数据库
$link=mysql_connect('127.0.0.1','root','root');
//选择数据库
mysql_select_db('yuekao',$link);
//sql语句
$sql="delete from yi where id='$id' ";
//echo $sql;
//执行
$res=mysql_query($sql);
//判断
if($res){
echo "<a href='yihang3.php'>删除成功</a>";}else{
echo "删除失败";}
?>

创建表单yihang5.php

<?php
header("content-type:text/html;charset=utf-8");
if(!empty($_GET['id'])){

                   $id = $_GET['id'];
           }else{
               echo "非法访问!";
           }
//连接数据库
$link=mysql_connect('127.0.0.1','root','root');
//选择数据库
mysql_select_db('yuekao',$link);
//sql语句
$sql="update yi set s='1' where id='$id' ";
//echo $sql;
//执行
$res=mysql_query($sql);
if($res===false){
   echo "已通过申请失败";
               }
   else{
   echo "已通过申请";
         }
?>

创建表单yihang6.php

<?php
header("content-type:text/html;charset=utf-8");
if(!empty($_GET['id'])){

                   $id = $_GET['id'];
           }else{
               echo "非法访问!";
           }
//连接数据库
$link=mysql_connect('127.0.0.1','root','root');
//选择数据库
mysql_select_db('yuekao',$link);
//sql语句
$sql="update yi set s='0' where id='$id' ";
//echo $sql;
//执行
$res=mysql_query($sql);
if($res===false){
   echo "正在处理失败";
               }
   else{
   echo "正在处理成功";
         }
?>