golden hour

/home/phakp/public_html/bkp_full/old_site_bkp/form

File/Folder	Size	Actions
connect.php	340 B
display.php	912 B
error_log	2.41 KB
insert.php	1.25 KB
update.php	1.61 KB

Edit: update.php

<?php
include("connect.php");

$_GET['id'];
$_GET['nm'];
$_GET['em'];
$_GET['ph'];

?>
<html>
    <head>
        <title>Update Page</title>
    </head>
    
    <body>
        <br /> <br />
        <form action="" method="GET">
            
            <input type="hidden" name="id" value="<?php echo $_GET['id']; ?>"/> <br /><br />
            
            Name: &nbsp<input type="text" name="name" value="<?php echo $_GET['nm']; ?>"/> <br /><br />
            
            Email: &nbsp<input type="text" name="email" value="<?php echo $_GET['em']; ?>"/> <br /><br />
            
            Phone# <input type="text" name="phone" value="<?php echo $_GET['ph']; ?>"/> <br /><br />
            
                    &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp <input type="submit" name="submit" value="Update"/>
            
            
        </form>
        
        <?php
        if($_GET['submit'])
        {
            $id = $_GET['id'];
            $name = $_GET['name'];
            $email = $_GET['email'];
            $phone = $_GET['phone'];
            $query = "UPDATE `members` SET name = '$name', email = '$email', phone = '$phone' WHERE id = '$id' ";
            $data = mysqli_query($conn, $query);
            if($data)
            {
                echo "Record Updated Successfully";
            }
            else
            {
                echo "<font color=red>Record not Updated</font>";
            }
        }
        
        else
        {
            echo "To save the data, Please Click on the <font color=green><b>Update</b></font> button";
        }
        
        ?>
        
        
    </body>
    
    
    
</html>