Posts made in September, 2006

  • PriadoBlender.com- Compiling Your PHP Scripts Into Executables Compiling Your PHP Scripts Into Executables (tags: compiler php) Sphider – a php spider and search engine Sphider is a lightweight web spider and search engine written in PHP, using MySQL as its back end database. It is suitable for adding search functionality to small or medium sites [...]

    Read More...
  • FOSS.IN/2006 | Registrations for Speakers Open

    The FOSS team is gearing up for the annual FOSS.IN/2006 event to be held in November at Bangalore. The dates for the event as of now are November 24th to 26th. This year’s FOSS.IN event will be held over at the National Science Symposium Centre, IISc, Bangalore. Speaker registrations are open at present. So if [...]

    Read More...
  • EnterpriseDB

    EnterpriseDB is an open source database system which allows you to port most Oracle applications over to their database server with almost no change to your code. They allow you to use the database free of cost, while providing paid support. So if you’re planning to reduce your TCO costs on your applications look at [...]

    Read More...
  • An interesing article which explains what can go wrong when you’re handing UTF-8 character sets in PHP. The current versions of PHP do mangle up UTF-8 characters when you use the built in string functions in PHP. “When I discovered that the popular web development tool PHP has almost complete ignorance of character encoding issues, [...]

    Read More...
  • Another did you know in PHP. < ? function test() { echo "This function can be called dynamically!"; } $function_name = "test"; $function_name(); ?> What is the output of the code show above? If you guessed that the output is “This function can be called dynamically!”, you may be a PHP guru. The code shows [...]

    Read More...
  • Did you know that PHP has a built in function to detect which browser your visitor is running? Well neither did I till one of my collegues, Ansar, pointed out PHP’s get_browser function. Here’s how to use this function: < ? $visitorbrowser = get_browser(null,true); print_r($visitorbrowser); ?> The output of this function is an object which [...]

    Read More...
  • GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Where it can be useful? For example to get PHP array without looping inside PHP: CREATE TABLE services ( id INT UNSIGNED NOT NULL, client_id INT UNSIGNED NOT NULL, KEY (id)); INSERT INTO services VALUES (1,1),(1,2),(3,5),(3,6),(3,7); SELECT id,client_id FROM [...]

    Read More...
  • An interesting read from Peter Zaitsev about optimizing MySQL queries which use ORDER BY with LIMIT. Suboptimal ORDER BY implementation, especially together with LIMIT is often the cause of MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid these problems Read on: MySQL Performance Blog » [...]

    Read More...