How does object-oriented programming affect the usage of "affected_rows" in mysqli?

In object-oriented programming with mysqli, the affected_rows property is accessed through the object's method rather than as a standalone function. To get the number of affected rows after executing a query, you can use the mysqli object's affected_rows property. This property will return the number of rows affected by the most recent query. 

// Create a new mysqli object
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Execute a query
$mysqli->query("UPDATE table SET column = 'value' WHERE condition");

// Get the number of affected rows
$affected_rows = $mysqli->affected_rows;

echo "Number of affected rows: " . $affected_rows;

// Close the connection
$mysqli->close();

Keywords

object-oriented programming affected_rows mysqli PHP usage

Related Questions