PHP Freelancer PHP Freelancer India PHP Programmer India PHP Freelancer Indian Freelancer Freelance Programmer Freelance Developer Freelance Web Developer Freelance Programmer India Hire PHP Developer India Wordpress Developer India CakePHP Developer India
Clustered indexes Vs Non-clustered indexes
A clustered index is a special type of index that reorders the records in the table are physically stored. In non-technical way, you are telling the database to store close values to one another on the disk. This means, a table can have only one clustered index. This has the benefit of rapid scan / retrieval of records on any operation with clustered index values.
Difference Between Primary Key and Unique Key
Everybody knows about difference between Primary key and Unique key who is/was working with SQL. This is silly question but still in lots of interview, interviewer asking this question starting from Fresher post to Experience post. This is a basic question and you must be aware with all the differences. You may know the difference but may be not know all.
SMTP -> ERROR: Failed to connect to server: Connection timed out (110)
SMTP -> ERROR: Failed to connect to server: Connection timed out (110). Connection time-out means the mail server cannot be reached anymore. If the mail server is different from your web server (i.e. not localhost) I had check with your hosting provider whether they enabled some sort of firewall that blocks connections on the SMTP port.
Multiple MYSQL Database Connection with Zend Framework
Do you want to make a connection with multiple database in Zend Framework? Today i worked on multiple MYSQL database connection in Zend Framework as my client wants separate database to reduce the load of site. Its very easy to manage multiple database connection with ZF. You just need to add below code in bootstrap.php file and use the db object accordingly.
Find a Lat/Long with in x miles/kilometer Radius
You are at the right place if you are looking for solution to get or check latitude and longitude is with in x miles of radius with given latitude and longitude. This is very easy with a single equation. Get all lat/long list from database if current lat/long is with in x miles of radius.
MYSQL Split/Explode function
Do you know any MYSQL split function or Explode function ? I guess no, as MYSQL does not have any function for split string or explode string. Today i need to explode one of my database field which contains latitude and longitude.
Parse/Get XML attribute using PHP SimpleXMLElement
Today i write something about xml parsing using PHP. I am taking xml file contents using file_get_contents function. Now parsing file contents by creating object of SimpleXMLElement. I can easily get all elements of xml using $xml->name or if it is an array than $xml->name[0]->fname. But the problem is with attributes. I have one array which have attributes. Below is the simple way to get/parse xml attributes.
Go to top of webpage with jQuery Dialog box/model box
Today i was working with jQuery model box, everything was fine but the problem with page length. Page was long and i need to open jQuery Model box when visitor click on link which is at the bottom of the page. So when visitor click on the link, jQuery model box opens but it opens at the top of the page. I can not make simple back to page anchor tag.
I am 
Recent Comments