http://phpist.net by Umut AYDIN Tue, 06 Jan 2009 12:44:13 +0000 http://backend.userland.com/rss092 en In Linux, installing Apache2 and PHP5 is easy. Always there is a related package to your distribution. But in many case, you're not gonna prefer that environment. Because there may be some compile-time limits in your environment. For example, in Ubuntu, Apache2 comes with 256 ServerLimit configuration. # apt-get install apache2 ... http://phpist.net/2009/01/06/compile-apache2-with-php5/ We're living with our cell phones. Wherever we go all these portable devices are with us. We are more mobile these days. With all these devices and the situation that covers us, we made an eternal market: Mobile Data Synchronization. Actually, for years, some players -really big ones- are already playing ... http://phpist.net/2008/12/20/mobile-data-synchronization/ In Symfony Framework, there is a pagination class written for Propel Database Abstraction Library: sfPropelPager. Generally, that class works fine but unfortunately, there will be a serious problem when you call addGroupByColumn method by the Criteria which is passed to sfPropelPager class. As you can see, there won't be Group By ... http://phpist.net/2008/12/17/sfpropelpager-has-a-problem-with-group-by/ /** * DB Connection * ... */ $result = mysql_query("SHOW TABLES;"); $rows = mysql_num_rows($result); if ($rows) { while ($item = mysql_fetch_array($result)) { mysql_query("ALTER TABLE {$item[0]} DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci"); $sub = mysql_query("SHOW FIELDS IN {$item[0]}"); $nums = mysql_num_rows($sub); if ($nums) { while ($field = mysql_fetch_array($sub)) { if (substr_count($field['Type'], 'char') or substr_count($field['Type'], 'enum')) { if (trim($field['Null']) == 'YES') $nn = null; else $nn = ... http://phpist.net/2008/12/11/script-for-altering-charset-of-a-mysql-database/ Main purpose of software projects is that making useful, user-friendly and qualified solutions for customers. According to market research companies, many of software projects can't see the end of river. There are 5 important truths that I'm gonna say about that kind of projects. First analysis and report part takes long ... http://phpist.net/2008/12/07/common-problems-in-planning-a-project/