UpdateGoalRecord.php

<?php
   $servername = "seekt.asia";
   $username = "seektasi_fitness";
   $password = "fitness53300";
   $dbname = "seektasi_bus";
   
   $con = mysqli_connect($servername,$username,$password,$dbname);
   
   $goalRecordID = $_POST["id"];
   $userID = $_POST["user_id"];
   $goal_desc = $_POST["goal_desc"];
   $goal_duration = $_POST["goal_duration"];
   $goal_target = $_POST["goal_target"];
   $createdAt = $_POST["createdAt"];
   $updateAt = $_POST["updateAt"];
   

   $statement = mysqli_prepare($con, " UPDATE Goal Set goal_desc = '$goal_desc' , goal_duration = '$goal_duration' , goal_target = '$goal_target' 
                                     , created_at = '$created_at', updated_at = '$updateAt' WHERE id = '$goalRecordID' AND user_id = '$userID' ");
  

   mysqli_stmt_execute($statement);
   mysqli_stmt_close($statement);
   
   mysqli_close($con);
?>