1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
$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 "<br>New client created successfully"; } else { echo "Error: " . $sql . "<br>" . $mysqli->error; } } |
