$result = $sql->execute();
//Check if its succesful
if ($result) {
echo "image upload successfully";
$dbconn->commit();
header('location: ../myuploads.php');
} else {
$dbconn->rollback();
}
} else {
$dbconn->commit();
header('location: ../myuploads.php');
}
} else {
echo "failed";
$dbconn->rollback();
}
//End if
} catch (PDOException $e) {
echo $e->getMessage();
$dbconn->rollback();
}
//End try&catch
} else {
setErrArray($errmsg_arr);
session_write_close();
header('location: ../uploadbookpage.php');
}
//End if
}
//End if
$camp = trim($_POST['camp']);
$opass = trim($_POST['opass']);
$npass = trim($_POST['npass']);
$cpass = trim($_POST['cpass']);
$userid = activeUser();
$errors = validateUserDetails($fname, $sname, $email, $phone, $uni, $camp, $userid);
echo "33";
if ($errors == false) {
echo "t";
$query = $dbconn->prepare("UPDATE `user-details` SET `Firstname`=:fname, `Surname`=:sname,\r\n\t\t\t`Email`=:email, `PhoneNumber`=:phone, `UniId`=:uni, `CampusId`=:camp WHERE \r\n\t\t\t`UserId`=:userid");
$query->bindParam(":fname", $fname);
$query->bindParam(":sname", $sname);
$query->bindParam(":email", $email);
$query->bindParam(":phone", $phone);
$query->bindParam(":uni", $uni);
$query->bindParam(":camp", $camp);
$query->bindParam(":uni", $uni);
$query->bindParam(":userid", $userid);
$result = $query->execute();
if ($result) {
setNotice("Your account has been succesfully updated!", "alert alert-success");
} else {
setNotice("Oops! There seems to be a problem. Try again and if the problem persists contact our team.");
}
header("location: ../my_profile.php");
} else {
echo "string";
setErrArray($errors);
header("location: ../edit_profile.php");
}
}
