Update query for database in PHP not working

Question

I am having trouble updating my database data. I put the data that I want to update but when I click on the "Update" button it does nothing. I have called the file on another php file by using <a href="updateinfo.php?edit=<?php echo $row['id']; ?>"> Update </a>

It also shows this error

Notice: Undefined variable: fname in C:\xampp\htdocs\project\change1.php on line 71

Can someone help me figure this issue, please?

 <?php include("config.php"); ?>
    <?php


        if (isset($_GET['edit'])) {

            $update = true;
            $record = mysqli_query($con, "SELECT * FROM employee WHERE id='".$_GET['edit']."'");
            $row = mysqli_fetch_array($record,MYSQLI_BOTH);
        }

        if (isset($_POST['update'])) {

        $fname = $_POST['fname'];
        $lname = $_POST['lname'];
        $password = $_POST['password'];
        $addr = $_POST['addr'];
        $phone = $_POST['phone'];

        $id=$_GET['edit'];

        $query = "UPDATE employee SET fname='".$fname."',lname='".$lname."',password='".$password."',addr='".$addr."',phone='".$phone."' WHERE id='".$id."'";
        $result = mysqli_query($con,$query) or die ("problem inserting new record into database");
        if($result){
        header('location: show_db.php');
        }
        else {echo "Update not successful"; }
        }



    ?>
    <!DOCTYPE html>
    <html>
    <head>    
        <title>Update Data</title>
    </head>

    <body>


        <a href="show_db.php">Home</a>
        <br/><br/>

        <input type="hidden" name="id" value="<?php echo $id; ?>">

        Name:<input type="text" name="fname" value="<?php echo $fname ; ?>">
        Surname:<input type="text" name="lname" value="<?php echo $lname; ?>">
        Password:<input type="text" name="password" value="<?php echo $password; ?>">
        Address:<input type="text" name="addr" value="<?php echo $addr; ?>">
        Contact:<input type="text" name="phone" value="<?php echo $phone; ?>">
        <input type="submit" name="update" value="Update">
    </body>
    </html>

You need to enclose your inputs with form tags. You'll wanna set the method to POST. Read the intro into forms from w3 — IsThisJavascript
– IsThisJavascript, Commented May 3, 2018 at 12:33

Rp9 · Accepted Answer · 2018-05-03 12:35:00Z

1

Put the html inputs inside a form

  <form name ="form1" method ="get" action="">
    <input type="hidden" name="id" value="<?php echo $id; ?>">

            Name:<input type="text" name="fname" value="<?php echo $fname ; ?>">
            Surname:<input type="text" name="lname" value="<?php echo $lname; ?>">
            Password:<input type="text" name="password" value="<?php echo $password; ?>">
            Address:<input type="text" name="addr" value="<?php echo $addr; ?>">
            Contact:<input type="text" name="phone" value="<?php echo $phone; ?>">
            <input type="submit" name="update" value="Update">
    </form>

answered May 3, 2018 at 12:35

Rp9

1,9612 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daphne Over a year ago

Thank you a lot for the help

Collectives™ on Stack Overflow

Update query for database in PHP not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related