JustOnePlanet

One thing I really like about CakePHP is that when it’s in debug mode it prints out a list of all the database queries used to generate a page, along with the time it took to run each query. This makes it really easy to find problem queries that are slowing down your site. It’s such a great feature that I wanted something similar for projects that don’t use CakePHP. What I came up with was a LoggedPDO class that extends PHP’s PDO class. If you’re already using PDO in your project you only>>Read More

[Related Article]

http://www.coderholic.com/php-database-query-logging-with-pdo/

[Posted On]

07:47:38 02-27-2009

Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1247767389' for key 1' in /homez.116/routesli/library/Zend/Db/Statement/Pdo.php:238 Stack ...>>Read More

[Related Article]

http://www.routes-libertines.fr/2008/11/l-antre-2-saint-jean-d-angely.html

[Posted On]

14:08:00 02-19-2009

Show links to browse query results using PDO. This class can be used to show links to browse database query results using PDO. It can generate links to browse the results of a given database query assuming a given limit number of ...>>Read More

[Related Article]

http://www.phpclasses.org/browse/package/5150.html

[Posted On]

16:59:59 02-15-2009

这几天在使用MySQL的PDO时，老是被“Call to a member function bindParam() on a non-object” 这个问题给困扰，上网找了蛮长时间终于找到一个老外写的解决方案。现附在下面： Contributed by Carrie Liu, InovaOne Web Developer Most web developers ...>>Read More

[Related Article]

http://blog.163.com/wys8211@126/blog/static/3615333520091133959582/

[Posted On]

16:13:14 02-13-2009

Many developers asked me how I count the result rows from a PDO statement.I asked them how they do it.They answered me the following example of...>>Read More

[Related Article]

http://php.dzone.com/tips/counting-results-pdo?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Fphp+(PHP+Zone)

[Posted On]

02:11:33 02-07-2009