连接数据库实现删除 添加 修改操作

boss.php页面：

<a href="conn.php?&q=add">添加页面</a>
<script>
function go(su){
   if(confirm("您确定要删除吗？")){
      window.location.href='conn.php?id='+su+'&q=delete';
   }else{
      return false;
   }
}
</script>
<?php 
$con = mysqli_connect('127.0.0.1','root','','mydb');
if(!$con){
die("数据库连接失败原因是".mysqli_error($con));
}
mysqli_set_charset($con, 'utf8');
$arr = "select * from `websites`";
$result = mysqli_query($con, $arr);
    
    
    echo "<table border='1'>
          <tr>
          <th>ID</th>
          <th>网站名</th>
          <th>url</th>
          <th>alexa</th>
          <th>国家</th>
          <th>操作</th>
          </tr>";
      
    while ($row =  mysqli_fetch_array($result)){
   
?>  


    <tr>
              <td> <?php echo $row['id'] ?></td>
              <td> <?php echo $row['name']?> </td>
              <td> <?php echo $row['url'] ?></td>
              <td> <?php echo $row['alexa']?> </td>
              <td> <?php echo $row['country']?> </td>
              <td><a href='conn.php?id=<?php echo $row['id'];?>&q=update' >修改</a>||<button type='button' οnclick='go(<?php echo $row['id'];?>)'>删除</button></td>
             </tr>
             
<?php 
  }
  echo "</table>";
?>

conn.php页面：

<?php 
$con = mysqli_connect('127.0.0.1','root','','mydb');
if(!$con){
die("数据库连接失败原因是".mysqli_error($con));
}
       mysqli_set_charset($con, 'utf8');
       $id = isset($_GET['id'])?intval($_GET['id']):FALSE;
       $q = isset($_GET['q'])?$_GET['q']: FALSE;
     
       if($id && $q=='update')
{
$arr = "select * from `websites` where id='".$id."'";
$result = mysqli_query($con,$arr);
$row = mysqli_fetch_array($result);


$sub = isset($_POST['sub'])?$_POST['sub']:FALSE;
    if($sub){
    $nn = $_POST['id'];
    $na = $_POST['name'];
    $nb = $_POST['url'];
    $nc = $_POST['alexa'];
    $nd = $_POST['country'];
   
    $nf = "update `websites` SET `id`='$nn',`name`='$na',`url`='$nb',`alexa`='$nc',`country`='$nd' WHERE `id` ='$nn'";
    mysqli_query($con, $nf);
    echo "<script>alert('修改成功');location.href='boss.php'</script>";
    }
    
}elseif( $q=='add')
   {
     $row['name'] =  $row['url'] = $row['alexa'] =$row['country'] = $row['id'] = "";
     $w = isset($_POST['sub'])?$_POST['sub']:FALSE;
     if($w){
     $na = $_POST['name'];
     $nb = $_POST['url'];
     $nc = $_POST['alexa'];
     $nd = $_POST['country'];
 
     $nf = "INSERT INTO `websites`(`id`, `name`, `url`, `alexa`, `country`) VALUES ('','$na','$nb','$nc','$nd')";
     mysqli_query($con, $nf);
     echo "<script>alert('添加成功');location.href='boss.php'</script>";
   }
}elseif($id && $q=='delete')
   {
 
  $delete = "delete from `websites` where `id` = '".$id."'";
  mysqli_query($con, $delete);
  echo "<script>alert('删除成功');location.href='boss.php'</script>";
   }
 
 ?>
 
  <form action='' method='POST'>
         <input type='hidden' name='id'  value="<?php echo $row['id'];?>">
 网站名：<input type='text' name='name'  value="<?php echo $row['name'];?>"><br>
 URL地址：<input type='text' name='url'  value="<?php echo $row['url'];?>"><br>
 alexa排名：<input type='text' name='alexa'  value="<?php echo $row['alexa'];?>"><br>
 国家：<input type='text' name='country'  value="<?php echo $row['country'];?>">
 <input type='submit' name='sub'  value='提交'>
  </form>