php showresult,PHP Get result of SHOW WARNINGS

marcus at synchromedia dot co dot uk (2009-08-19 07:13:58)

I'm not sure how useful this function is as implemented. Take this example:

CREATE TABLE `blah` (

`x` varchar(100) NOT NULL,

`y` varchar(100) NOT NULL,

`z` varchar(100) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO blah SET z = '1';

Query OK, 1 row affected, 2 warnings (0.00 sec)

mysql> show warnings;

+---------+------+----------------------------------------+

| Level | Code | Message |

+---------+------+----------------------------------------+

| Warning | 1364 | Field 'x' doesn't have a default value |

| Warning | 1364 | Field 'y' doesn't have a default value |

+---------+------+----------------------------------------+

Doing the same from PHP using mysqli_get_warnings(), you get this instead:

object(mysqli_warning)#4 (3) {

["message"]=>

string(38) "Field 'x' doesn't have a default value"

["sqlstate"]=>

string(5) "HY000"

["errno"]=>

int(1364)

}

i.e. it only returns the first warning. I suspect it should return an array of these objects rather than just one. At least you know what the return value looks like now, since the docs don't say!