$result = $mysqli->query("SELECT * FROM users WHERE clientnumber = '".$clientnumber."'");
if($result->num_rows > 0 ){
echo $sql = "UPDATE users SET username='$username', company='$company' WHERE clientnumber='$clientnumber'";
if (mysqli_query($mysqli, $sql)) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . mysqli_error($mysqli);
}
mysqli_close($mysqli);
}
else {
$sql = "INSERT INTO users (username, company)
VALUES ('$username', '$company')";
if ($mysqli->query($sql) === TRUE) {
echo "
New client created successfully";
} else {
echo "Error: " . $sql . "
" . $mysqli->error;
}
}
