Tag Archives: mysql

Using Cursors with PHP MySQLi and Multiple Prepared Statements

By | Published: March 30, 2010
After my post on using PHP MySQLi and multiple prepared statements at the same time someone commented that using cursors could do the same thing. With that comment I dug some more and found that modifying the cursor type that is used under the covers will indeed let you execute multiple prepared statements concurrently on [...]
Posted in programming | Also tagged , , | Leave a comment

PHP MySQLi and Multiple Prepared Statements

By | Published: February 9, 2010
While sprucing up the PHP code I use to provide my own Stack Overflow API for GeeQe I ran into an error caused by trying to use multiple prepared statements with MySQLi. It turned up when I tried to execute one prepared statement while looping over the result set from another prepared statement that were [...]
Posted in programming | Also tagged , | 4 Comments

Full Text Search with Sphinx

By | Published: October 20, 2009
While developing my GeeQE iPhone application I decided I needed a way to let users search posts so I started looking around for a simple search engine that I could use with PHP. I took a look at a number of different options like MySQL Full Text search, Sphinx, Solr and others based on Lucene. [...]
Posted in programming | Also tagged , | 3 Comments

A lesson in on the limits of administrating your way out of problems: Shared MySQL

By | Published: January 29, 2007
I just finished reading a post to the Media Temple blog about their MySQL problems . I think it is an excellent example of what happens when you only have one side of the house trying to fix a problem. The post leaves out some details but they make it clear that they believe their [...]
Posted in system administration | Also tagged | Leave a comment