mysqli_info(): additional info on 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
QueryPossible 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 studentRecords: 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+2Rows matched: 35 Changed: 35 Warnings: 0

MYSQLI Functions mysqli_update() Update Records
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com







    Post your comments , suggestion , error , requirements etc here





    PHP video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer