Zend tutorial beginner

Google Code Jam Practice Alien Numbers solved in PHP http://wp.me/p3urnF-3K

Google Code Jam Practice Alien Numbers solved in PHP Recently I stumbled upon google code jam practice page, so I wanted to solve some of those challenges using PHP. Click here Read More

Comparison between Solr and Zend Lucene http://wp.me/p3urnF-3H

Comparison between Solr and Zend Lucene Java Lucene, and all its ports to other languages, including Zend Lucene, are search libraries. This means that in order to use Zend Lucene, we have to wrap it in other (PHP) code that will integrate the search with the rest of our application. The code… [ 218 more words. ]

Integrate PHP application with Solr search engine http://wp.me/p3urnF-3B

Integrate PHP application with Solr search engine So why do you need a search engine, is database not enough? If you create a small website it might not matter. With medium or big size applications it’s often wiser to go for a search engine. Saying that, even a small websites can benefit from Solr if you… [ 137 more words. ]

Search Engine with Zend_Search_Lucene http://wp.me/p3urnF-3z

zendtutorial.wordpress.com

Fetch Total Fifty and Hundred Run in Team player

Fetch Total Fifty and Hundred Run in Team player Table Structure Query SELECT player_id,SUM(CASE WHEN total_run>=50 and total_run=150 and total_run

MySQL SUBSTRING_INDEX() function http://wp.me/p3urnF-3l

MySQL SUBSTRING_INDEX() function MySQL SUBSTRING_INDEX() returns the sub string from the given string before a specified number of occurrences of a delimiter. Syntax SUBSTRING_INDEX(str, delim, count) Example SELECT SUBSTRING_INDEX(‘www.gmail.com’,’.’,2); Output…

Truncate at space, Zend View Helper http://wp.me/p3urnF-3g

Truncate at space, Zend View Helper When writing web applications you may frequently find the need to truncate strings. In php you could just use substr but that could be dangerous. Read More [ 12 more words. ]

Parameterized Queries and Bind Parameters http://wp.me/p3urnF-3e

Parameterized Queries and Bind Parameters Bind parameters—also called dynamic parameters or bind variables—are an alternative way to pass data to the database. Instead of putting the values directly into the SQL statement, you just use a placeholder like ?, :name or and provide… [ 33 more words. ]

Difference between DDL, DML and DCL commands http://wp.me/p3urnF-3c

Difference between DDL, DML and DCL commands DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE – to create objects in the database ALTER – alters the structure of the database DROP – delete objects from the…

Avoids Unnecessary HTTP Requests http://wp.me/p3urnF-32

Avoids Unnecessary HTTP Requests Add future Expires and Cache-Control headers A first-time visitor to your page will make several HTTP requests to download all your sites files, but using the Expires and Cache-Control headers you make those files cacheable. This…

htaccess gzip for Faster Loading and Bandwidth Saving http://wp.me/p3urnF-2Z

htaccess gzip for Faster Loading and Bandwidth Saving If you can use htaccess on your server and want to use gzip for faster Page Load Times / Bandwidth Saver. You can put the following lines in the htaccess file on your server: Turn on compression mod_gzip is an external extension module for Apache… [ 178 more words. ]