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; } } |
Latest Snippets
- Firefox 133 Toolbars – Tabs on Bottom – Update Nov 24 29th November 2024
- Exclude category from blog while adding them to sitemap.xml 16th January 2024
- What Router can I use with Onestream Broadband? 28th June 2023
- Disable buying – Woocommerce 25th April 2023
- Windows Desktop Wallpaper Background for OCD users with shelves 13th April 2023
- Featured Image Admin Thumb – Working Plugin (WordPress 6.2) 6th April 2023
- Create a gallery in a Posts page 3rd March 2023
- Clickable elements too close together – Solved 21st February 2023
- Best ChatGPT Prompts 24th January 2023
- Make Elementor Accordion Closed by Default 13th January 2023
LINKS