$update_query = "UPDATE users SET email='example@email.com' WHERE id=1"; mysqli_query($conn, $update_query);
$update_query = "UPDATE products SET price=price*0.9 WHERE category='sale'"; mysqli_query($conn, $update_query);This code updates the price of all products in the "sale" category by reducing it by 10%. The most commonly used PHP package libraries for working with databases are PDO and MySQLi. They both provide similar functionalities but differ in their APIs. PDO is more flexible as it supports multiple database types, while MySQLi is designed specifically for MySQL databases.