$host="localhost";
$user="root";
$password="";
$db="schoolproject";
$data=mysqli_connect($host,$user,$password,$db);
$name=$_SESSION['username'];
$sql="SELECT * FROM user WHERE username='$name' ";
$result=mysqli_query($data,$sql);
$info=mysqli_fetch_assoc($result);
if(isset($_POST['update_profile']))
{
$s_email=$_POST['email'];
$s_phone=$_POST['phone'];
$s_password=$_POST['password'];
$sql2=" UPDATE user SET email='$s_email',phone='$s_phone',passowrd='$s_password' WHERE username='$name'";
$result2=mysqli_query($data,$sql2);
if($result2)
{
echo "Update successfully";
}
}
