Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Using MySQL with PHP MySQLi: Connections, Options, Pooling

DZone's Guide to

Using MySQL with PHP MySQLi: Connections, Options, Pooling

· Web Dev Zone
Free Resource

Add user login and MFA to your next project in minutes. Create a free Okta developer account, drop in one of our SDKs to your application and get back to building.

The next post in Ulf Wendel's tutorial series on MySQLi recently surfaced.  This post deals with parameter defauls in MySQLi database connections, built-in connection library defaults, and connection pooling.  There's also a sizable section devoted to persistent connection and the issues they can cause:

A common complain about persistent connections is that their state is not reset before reuse. For example, open, unfinished transactions are not automatically rolled back. But also, authorization changes which happened in the time between putting the connection into the pool and reusing it are not reflected. This may be seen as an unwanted side-effect. On the contrary, the name persistent may be understood as a promise that the state is persisted.

Check out the full post for all the MySQLi goodness.  If you want to catch up, make sure you check out part 1 on stored procedures, part 2 on prepared statements and part 3 on multiple statements in one statement string. 

Launch your application faster with Okta’s user management API. Register today for the free forever developer edition!

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}