Zend tutorial beginner

11/07/2014

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

Recently I stumbled upon google code jam practice page, so I wanted to solve some of those challenges using PHP. Click here Read More

08/07/2014

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

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. ]

08/07/2014

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

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. ]

08/07/2014

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

10/03/2014

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

10/03/2014

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

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…

23/01/2014

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

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. ]

23/01/2014

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

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. ]

23/01/2014

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

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…

15/11/2013

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

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…

14/11/2013

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

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. ]