<?php
 
// your code goes here
//the function 
function update($data,$where)
{
    try {
        $dns ="mysql:dbname=students;host=127.0.0.1;port=3306;";
        $usre="root";
        $password ="";
 
        $db =new PDO($dns, $usre, $password);
 
        $query = "UPDATE `student' SET $data WHERE $where";
       // print($query);
        $stmt=$db->prepare($query);
        // $stmt->bindParam(":x", $us, PDO::PARAM_STR);
 
        $stmt->execute();
       echo $stmt->rowCount();
        if($stmt->rowCount()>0)
  {return 'updated';}
  else
  return 'unupdated';
 
    } catch(PDOException $e) {
        echo "Error: " . $e->getMessage();
        return null;
      }
}
// the upsatedo
var_dump($_POST['username']);
    $data = "'fname' = '" . $_POST['first'] . "'";
 
    $where = "'user' = '" . $_POST['username'] . "'";
include_once("functions.php");
    $res = update($data, $where);
    echo $res;

PD9waHAKCi8vIHlvdXIgY29kZSBnb2VzIGhlcmUKLy90aGUgZnVuY3Rpb24gCmZ1bmN0aW9uIHVwZGF0ZSgkZGF0YSwkd2hlcmUpCnsKICAgIHRyeSB7CiAgICAgICAgJGRucyA9Im15c3FsOmRibmFtZT1zdHVkZW50cztob3N0PTEyNy4wLjAuMTtwb3J0PTMzMDY7IjsKICAgICAgICAkdXNyZT0icm9vdCI7CiAgICAgICAgJHBhc3N3b3JkID0iIjsKICAgICAgICAKICAgICAgICAkZGIgPW5ldyBQRE8oJGRucywgJHVzcmUsICRwYXNzd29yZCk7CiAgICAgCiAgICAgICAgJHF1ZXJ5ID0gIlVQREFURSBgc3R1ZGVudCcgU0VUICRkYXRhIFdIRVJFICR3aGVyZSI7CiAgICAgICAvLyBwcmludCgkcXVlcnkpOwogICAgICAgICRzdG10PSRkYi0+cHJlcGFyZSgkcXVlcnkpOwogICAgICAgIC8vICRzdG10LT5iaW5kUGFyYW0oIjp4IiwgJHVzLCBQRE86OlBBUkFNX1NUUik7CiAgICAgCiAgICAgICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgICAgIGVjaG8gJHN0bXQtPnJvd0NvdW50KCk7CiAgICAgICAgaWYoJHN0bXQtPnJvd0NvdW50KCk+MCkKICB7cmV0dXJuICd1cGRhdGVkJzt9CiAgZWxzZQogIHJldHVybiAndW51cGRhdGVkJzsKICAgICAgICAKICAgIH0gY2F0Y2goUERPRXhjZXB0aW9uICRlKSB7CiAgICAgICAgZWNobyAiRXJyb3I6ICIgLiAkZS0+Z2V0TWVzc2FnZSgpOwogICAgICAgIHJldHVybiBudWxsOwogICAgICB9Cn0KLy8gdGhlIHVwc2F0ZWRvCnZhcl9kdW1wKCRfUE9TVFsndXNlcm5hbWUnXSk7CiAgICAkZGF0YSA9ICInZm5hbWUnID0gJyIgLiAkX1BPU1RbJ2ZpcnN0J10gLiAiJyI7CgogICAgJHdoZXJlID0gIid1c2VyJyA9ICciIC4gJF9QT1NUWyd1c2VybmFtZSddIC4gIiciOwppbmNsdWRlX29uY2UoImZ1bmN0aW9ucy5waHAiKTsKICAgICRyZXMgPSB1cGRhdGUoJGRhdGEsICR3aGVyZSk7CiAgICBlY2hvICRyZXM7