mysqli_info(): gives additional info about the recently executed query

//$query="INSERT INTO student_max SELECT * from student ";
/*$query ="INSERT INTO `student_max` (`id`, `name`, `class`, `mark`, `sex`) VALUES
(35, 'John Alex', 'Five', 80, 'male'),
(35, 'John Alex', 'Five', 80, 'female')";
*/
//$query ="ALTER TABLE  `student_max` CHANGE  `id`  `id` INT( 4 ) NOT NULL DEFAULT  '0'";

$query ="UPDATE   `student_max` SET mark = mark+2"; // affect all rows 
if($connection->query($query)){
echo "No of records Updated : ".$connection->affected_rows;
}else{
echo $connection->error;
}
echo "<br>";
echo $connection->info;

Output

Rows matched: 35 Changed: 35 Warnings: 0

The above output is based on query UPDATE `student_max` set mark = mark+2 You can try other queries.

$mysqli->info

mysqli_info ( mysqli $link )

$mysqli : database connection string or Link

Output of this function is ( string ) information about the most recently executed query

Query	Possible mysqli_info return values
INSERT INTO `student_max` (`id`, `name`, `class`, `mark`, `sex`) VALUES (35, 'John Alex', 'Five', 80, 'male'), (35, 'John Alex', 'Five', 80, 'female')	Records: 2 Duplicates: 0 Warnings: 0
INSERT INTO student_max SELECT * from student	Records: 35 Duplicates: 0 Warnings: 0
LOAD DATA INFILE ...	Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
ALTER TABLE `student_max` CHANGE `id` `id` INT( 3 ) NOT NULL DEFAULT '0'	Records: 0 Duplicates: 0 Warnings: 0
UPDATE `student_max` set mark=mark+2	Rows matched: 35 Changed: 35 Warnings: 0

MYSQLI Functions mysqli_update() Update Records

Subscribe to our YouTube Channel here

mysqli_info(): additional info on query

Subscribe