Gets the number of affected rows in a previous MySQL operation (original) (raw)

<?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }/* Insert rows */ $mysqli->query("CREATE TABLE Language SELECT * from CountryLanguage"); printf("Affected rows (INSERT): %d\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>m</mi><mi>y</mi><mi>s</mi><mi>q</mi><mi>l</mi><mi>i</mi><mo>−</mo><mo>></mo><mi>a</mi><mi>f</mi><mi>f</mi><mi>e</mi><mi>c</mi><mi>t</mi><mi>e</mi><msub><mi>d</mi><mi>r</mi></msub><mi>o</mi><mi>w</mi><mi>s</mi><mo stretchy="false">)</mo><mo separator="true">;</mo></mrow><annotation encoding="application/x-tex">mysqli->affected_rows);</annotation></semantics></math>mysqli−>affectedrows);mysqli->query("ALTER TABLE Language ADD Status int default 0");/* update rows */ $mysqli->query("UPDATE Language SET Status=1 WHERE Percentage > 50"); printf("Affected rows (UPDATE): %d\n", $mysqli->affected_rows);/* delete rows */ $mysqli->query("DELETE FROM Language WHERE Percentage < 50"); printf("Affected rows (DELETE): %d\n", $mysqli->affected_rows);/* select all rows */ <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mi>u</mi><mi>l</mi><mi>t</mi><mo>=</mo></mrow><annotation encoding="application/x-tex">result = </annotation></semantics></math>result=mysqli->query("SELECT CountryCode FROM Language"); printf("Affected rows (SELECT): %d\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>m</mi><mi>y</mi><mi>s</mi><mi>q</mi><mi>l</mi><mi>i</mi><mo>−</mo><mo>></mo><mi>a</mi><mi>f</mi><mi>f</mi><mi>e</mi><mi>c</mi><mi>t</mi><mi>e</mi><msub><mi>d</mi><mi>r</mi></msub><mi>o</mi><mi>w</mi><mi>s</mi><mo stretchy="false">)</mo><mo separator="true">;</mo></mrow><annotation encoding="application/x-tex">mysqli->affected_rows);</annotation></semantics></math>mysqli−>affectedrows);result->close();/* Delete table Language */ $mysqli->query("DROP TABLE Language");/* close connection */ $mysqli->close(); ?>

`<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

if (!

$link) {
printf("Can't connect to localhost. Error: %s\n", mysqli_connect_error());
exit();
}/* Insert rows /
mysqli_query($link, "CREATE TABLE Language SELECT * from CountryLanguage");
printf("Affected rows (INSERT): %d\n", mysqli_affected_rows($link));mysqli_query($link, "ALTER TABLE Language ADD Status int default 0");/ update rows /
mysqli_query($link, "UPDATE Language SET Status=1 WHERE Percentage > 50");
printf("Affected rows (UPDATE): %d\n", mysqli_affected_rows($link));/ delete rows /
mysqli_query($link, "DELETE FROM Language WHERE Percentage < 50");
printf("Affected rows (DELETE): %d\n", mysqli_affected_rows($link));/* select all rows */ result=mysqliquery(result = mysqli_query(result=mysqliquery(link, "SELECT CountryCode FROM Language");
printf("Affected rows (SELECT): %d\n", mysqli_affected_rows($link));mysqli_free_result($result);/ Delete table Language /
mysqli_query($link, "DROP TABLE Language");/ close connection */
mysqli_close($link);
?> `

Affected rows (INSERT): 984 Affected rows (UPDATE): 168 Affected rows (DELETE): 815 Affected rows (SELECT): 169