Skip to content
Related Articles

Related Articles

Improve Article

PHP | MySQL UPDATE Query

  • Difficulty Level : Basic
  • Last Updated : 01 Aug, 2021
Geek Week

The MySQL UPDATE query is used to update existing records in a table in a MySQL database.

  • It can be used to update one or more field at the same time.
  • It can be used to specify any condition using the WHERE clause.



    Syntax :
    The basic syntax of the Update Query is –

    Implementation of Where Update Query :

    Let us consider the following table “Data” with four columns ‘ID’, ‘FirstName’, ‘LastName’ and ‘Age’.

    To update the “Age” of a person whose “ID” is 201 in the “Data” table, we can use the following code :

    Update Query using Procedural Method :






    <?php
    $link = mysqli_connect("localhost", "root", "", "Mydb");
      
    if($link === false){
        die("ERROR: Could not connect. " 
                    . mysqli_connect_error());
    }
      
    $sql = "UPDATE data SET Age='28' WHERE id=201";
    if(mysqli_query($link, $sql)){
        echo "Record was updated successfully.";
    } else {
        echo "ERROR: Could not able to execute $sql. " 
                                . mysqli_error($link);
    mysqli_close($link);
    ?>

    Output :
    Table After Updation –

    The output on Web Browser :

    Update Query using Object Oriented Method :




    <?php
    $mysqli = new mysqli("localhost", "root", "", "Mydb");
      
    if($mysqli === false){
        die("ERROR: Could not connect. "
                . $mysqli->connect_error);
    }
      
    $sql = "UPDATE data SET Age='28' WHERE id=201";
    if($mysqli->query($sql) === true){
        echo "Records was updated successfully.";
    } else{
        echo "ERROR: Could not able to execute $sql. " 
                                            . $mysqli->error;
    }
    $mysqli->close();
    ?>

    Output :
    Table After Updation –

    The output on Web Browser :

    Update Query using PDO Method :




    <?php
    try{
        $pdo = new PDO("mysql:host=localhost;
                        dbname=Mydb", "root", "");
        $pdo->setAttribute(PDO::ATTR_ERRMODE, 
                            PDO::ERRMODE_EXCEPTION);
    } catch(PDOException $e){
        die("ERROR: Could not connect. " 
                        . $e->getMessage());
    }
      
    try{
        $sql = "UPDATE data SET Age='28' WHERE id=201";
        $pdo->exec($sql);
        echo "Records was updated successfully.";
    } catch(PDOException $e){
        die("ERROR: Could not able to execute $sql. "
                                    . $e->getMessage());
    }
    unset($pdo);
    ?>

    Output :
    Table After Updation –

    The output on Web Browser :

    PHP is a server-side scripting language designed specifically for web development. You can learn PHP from the ground up by following this PHP Tutorial and PHP Examples.

    Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.




    My Personal Notes arrow_drop_up
  • Recommended Articles
    Page :