Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45742
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain hexon.cx from 82.94.237.14 cause and error)
Message-ID: <4AD34538.8050202@hexon.cx>
Date: Mon, 12 Oct 2009 17:03:20 +0200
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: internals@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: [patch] mysql_warning_count() for ext/mysql
From: jille@hexon.cx (Jille Timmermans)

Hello all,

Not sure whether this is the right place to post; but it seemed a little bit
better than php-db@.

I have 'implemented' MySQL's mysql_warning_count() function. (
http://dev.mysql.com/doc/refman/5.1/en/mysql-warning-count.html )
mysql_warning_count() is available in MySQL's C-api in >3.23, >4.1 and >5

This function returns the number of warnings from the previous query. In some
queries (INSERT INTO .. VALUES (..), (..); INSERT INTO .. SELECT; etc)
mysql_info() was usable to return the number of warnings; but for single-row
inserts mysql_info() returns false.

The function is very straightforward, almost the same as mysql_thread_id().

The patch is available at http://jille.hexon.cx/mysql-warning-count.diff
It is based on PHP 5.3.0 and at least works for me.

-- Jille