Home >> PHP >> How to update data from mysql database in PHP

How to update data from mysql database in PHP

include_once("connection.php");

if(isset($_POST['submit'])){
      $name=$_POST['name'];
      $email=$_POST['email'];
      $password=$_POST['password'];
      $update="UPDATE users SET name='".$name."',email='".$email."',password='".$password."' WHERE       user_id='".$_GET['user_id']."'";
      //PHP 5.X
      $result=mysql_query($insert);
      //PHP 7.X
      $result=mysqli_query($conn,$insert);
      if($result>0){
           echo "Data updated successfully";
      } else {
           echo "Data not saved";
      }
}

Post Your Comment

Next Questions
How to delete data from mysql database
How to list data from mysql database
error_reporting
error_reporting(E_ALL)
What is object oriented programming (oops)
What is class
What is object
What is static variable
What is static method
What is constructor
Why use constructor
Predefined constructor
Parameterized constructor
What is destructor
What is Polymorphism
What is Polymorphism types
What is overloading
What is overriding
What is abstraction
What is abstract class
Implementation of abstract method
What is interface
What is difference between abstract class and interface
What is inheritance
Inheritance types

Copyright ©2022 coderraj.com. All Rights Reserved.