PHP Development Enterprise Website Tutorial Modification Contact Us Information

Let’s implement the modification function below

Query the information in the database through id , then display the information in the form, then modify the content of the form, click Modify, and implement the modification function

Let’s take a look at the code:

<?php
    require_once('conn.php');
    $id = $_GET['id'];
    $sql = "SELECT * from contact where id='$id'";
    $res = mysql_query($sql);
    $row = mysql_fetch_array($res);
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>修改公司信息</title>
    <style type="text/css">
        .ipt{width:180px;height:30px;border-radius:5px;
            outline:none;border:1px solid #eee;box-sizing:border-box;padding-left:15px;}
        .txt{width:250px;height:200px;}
        .sub{width:50px;height:20px;border:1px solid #eee;background:#eee;color:#ff7575;}
    </style>
</head>
<body>
    <form method="post" action="modifyontact.php?id=<?php echo $id;?>">
        公司地址:<input type="text" name="site" class="ipt" value="<?php echo $row['site'];?>">
        </br></br>
        公司电话:<input type="text" name="tel" class="ipt" value="<?php echo $row['tel'];?>">
        </br></br>
        技术支持:<input type="text" name="suppot" class="ipt" value="<?php echo $row['suppot'];?>">
        </br></br>
        售后电话:<input type="text" name="nexttel" class="ipt" value="<?php echo $row['nexttel'];?>">
        </br></br>
        公司传真:<input type="text" name="fax" class="ipt" value="<?php echo $row['fax'];?>">
        </br></br>
        公司主页:<input type="text" name="home" class="ipt" value="<?php echo $row['home'];?>">
        </br></br>
        电子邮件:<input type="text" name="email" class="ipt" value="<?php echo $row['email'];?>">
        </br></br>
        <input type="submit" value="修改" class="sub">
    </form>
</body>
</html>

As shown in the above code, click the modify button to pass the id, receive it on this page, query and display the information in the database based on the id

Modified After the content, the form is submitted to the modifyontact.php page

Let’s look at the code of the following modifyontact.php page:

<?php
    require_once('conn.php');
    $id = $_GET['id'];
    $site    = $_POST['site']; //地址
    $tel     = $_POST['tel'];    //电话
    $suppot  = $_POST['suppot'];//技术支持
    $nexttel = $_POST['nexttel'];//售后电话
    $fax     = $_POST['fax'];        //公司传真
    $home    = $_POST['home'];        //公司首页
    $email   = $_POST['email'];    //电子邮件
    $sql = "UPDATE contact set site='$site',tel='$tel',suppot='$suppot',nexttel='$nexttel',fax='$fax',home='$home',email='$email' where id='$id'";

    // echo $sql;die;
    $res = mysql_query($sql);
    if($res){
        echo "<script>alert('修改公司信息成功');location.href='contact.php'</script>";
    }else{
        echo "<script>alert('修改公司信息失败');history.go(-1);</script>";
    }
?>

Get the form information, then write the updated statement and execute the sql statement Determine whether it is successful. If successful, we will complete the modification and jump to the display page. If the modification fails, we will return to the previous page

Continuing Learning

new file

<?php require_once('conn.php'); $id = $_GET['id']; $sql = "SELECT * from contact where id='$id'"; $res = mysql_query($sql); $row = mysql_fetch_array($res); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>修改公司信息</title> <style type="text/css"> .ipt{width:180px;height:30px;border-radius:5px; outline:none;border:1px solid #eee;box-sizing:border-box;padding-left:15px;} .txt{width:250px;height:200px;} .sub{width:50px;height:20px;border:1px solid #eee;background:#eee;color:#ff7575;} </style> </head> <body> <form method="post" action="modifyontact.php?id=<?php echo $id;?>"> 公司地址:<input type="text" name="site" class="ipt" value="<?php echo $row['site'];?>"> </br></br> 公司电话:<input type="text" name="tel" class="ipt" value="<?php echo $row['tel'];?>"> </br></br> 技术支持:<input type="text" name="suppot" class="ipt" value="<?php echo $row['suppot'];?>"> </br></br> 售后电话:<input type="text" name="nexttel" class="ipt" value="<?php echo $row['nexttel'];?>"> </br></br> 公司传真:<input type="text" name="fax" class="ipt" value="<?php echo $row['fax'];?>"> </br></br> 公司主页:<input type="text" name="home" class="ipt" value="<?php echo $row['home'];?>"> </br></br> 电子邮件:<input type="text" name="email" class="ipt" value="<?php echo $row['email'];?>"> </br></br> <input type="submit" value="修改" class="sub"> </form> </body> </html>

submit Reset Code

Automatic operation

PHP Development Enterprise Website Tutorial Modification Contact Us Information

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]