<commit_before><?php
session_start();

$conn = mysqli_connect("localhost", "USERNAME", "PASSWORD", "DATABASE");

if (!$conn) {
	die("Connection failed: " . mysqli_connect_error());
}

mysqli_query($conn,"SET NAMES utf8");

$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$display_name = $_POST['display_name'];
$email = $_POST['email'];
$password = $_POST['<PASSWORD>_password'];
$street = $_POST['Street'];
$street_num = $_POST['Street_num'];
$City = $_POST['City'];
$country_name = $_POST['country_name'];
$phone = $_POST['phone']; 

$id = $_SESSION['id'];
$sql =  "UPDATE UserSimple SET Username='$display_name', Password='$password', Name='$first_name', Surname='$last_name', Email='$email' WHERE Username='$id'";
$result = mysqli_query($conn, $sql);
$sql3 = "UPDATE UserExtended SET Username='$display_name', PrivatePhone='$phone', ANumber='$street_num', AStreet='$street', ACity='$City', ACountry='$country_name' WHERE Username='$id'";
$result3 = mysqli_query($conn, $sql3); 

mysqli_close($conn);
$_SESSION['updatedBroker'] = "You've successfully updated your profile!";
header("Location: broker_manage.php");
?><commit_msg>Update updateBroker.php<commit_after><?php
session_start();

$conn = mysqli_connect("localhost", "USERNAME", "PASSWORD", "<PASSWORD>");

if (!$conn) {
	die("Connection failed: " . mysqli_connect_error());
}

mysqli_query($conn,"SET NAMES utf8");

$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$display_name = $_POST['display_name'];
$email = $_POST['email'];
$password = <PASSWORD>($_POST['<PASSWORD>_password']);
$street = $_POST['Street'];
$street_num = $_POST['Street_num'];
$City = $_POST['City'];
$country_name = $_POST['country_name'];
$phone = $_POST['phone']; 

$id = $_SESSION['id'];
$sql =  "UPDATE UserSimple SET Username='$display_name', Password='$password', Name='$first_name', Surname='$last_name', Email='$email' WHERE Username='$id'";
$result = mysqli_query($conn, $sql);
$sql3 = "UPDATE UserExtended SET Username='$display_name', PrivatePhone='$phone', ANumber='$street_num', AStreet='$street', ACity='$City', ACountry='$country_name' WHERE Username='$id'";
$result3 = mysqli_query($conn, $sql3); 

mysqli_close($conn);
$_SESSION['updatedBroker'] = "You've successfully updated your profile!";
header("Location: broker_manage.php");
?>
{'fraction_non_alphanumeric': 0.21502145922746782, 'fraction_numerical': 0.0034334763948497852, 'mean_word_length': 9.643835616438356, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6181437', 'n_tokens_mistral': 830, 'n_tokens_neox': 789, 'n_words': 151}