Query Methods

You can query the database using SQL statements using these methods.

• query($sql)

• affected_rows()

• info()

query( $sql )

Execute the query. Returns true if the query was successful or reversely false.

$user = $sqli->query('UPDATE users SET email = "[e-mail]" WHERE id=3');

Result

true

affected_rows()

Return the number of rows changed with the latest query.

$affected_rows = $sqli->affected_rows();

Result

1

info()

Return info about the latest query.

$info = $sqli->info();

Result

"Rows matched: 1  Changed: 1  Warnings: 0"