Blogs

How Mysql reduce overhead from PHP!!!!!

August 10, 2013
I enjoy to play with Mysql queries. what i learn from my past experience is,if you are doing a maintainance project or you are handling a project which is developed by some other developer and he mess up with the database definitions, than you “WILL LEARN A LOT NEW THINGS”…………. How?
Read more..

HEREDoc in PHP

August 10, 2013
A way to delimit strings is the heredoc syntax:
Read more..

MySql Function Between.. AND in LEFT JOIN

August 10, 2013
If we are storing range of values in a field in a table and we want to see what are the values falling between these range, we can use “Between.. and” function along with Left Join in Mysql.
Read more..

CodeIgniter : Loosing session data after login

August 10, 2013
In Codeigniter after login I am storing all the data into session and redirecting to some controller.But i am loosing all values in that controller and code redirect back to login page. I try every trick to debug this issue but fail!!!
Read more..

Implementation of User permission with PHP & Mysql Bitwise operators.

August 10, 2013
Another way to implement user permission in your application and also a good use of bitwise operator. This can be done with PHP as well as Mysql. Here I am showing how we can implement it with Mysql.
Read more..

Maximum Number of Columns Per Table – Mysql

August 10, 2013
Maximum we can have 4096 columns per table, but exact limit depends on several factors, listed below: 1) Every table has a maximum row size of 65,535 bytes. This maximum applies to all storage engines, but a given engine might have additional constraints that result in a lower effective maximum row size.        The maximum ...
Read more..

PHP-Mysql Interview Questions

August 10, 2013
Some PHP interview question i am sharing with you, which are really interesting and upgraded my knowledge. It might help you out…:)
Read more..

Htaccess and Modrewrite

August 10, 2013
In Windows, links will get to your pages regardless of capitalization (or lack of it). So if the search engine indexed your page when it was www.example.com/page01.htm, it will still find it even if you renamed it www.example.com/PAGE01.htm (but read on, as there ARE ways that capitalization might effect you). In a Linux or Unix-based ...
Read more..

PHP: Calculating Business days from given dates or for particular period.

August 10, 2013
Whenever i get time i used to answers in PHP related questions in Stackoverflow. Today i come across common question being ask by number of developers, is to get the “Bussiness days” in a specific period. Developer write unneccessary of lines of codes, which we can get easily by using Datetime functions available with PHP.
Read more..

PHP Interview Questions – Magic Contant,Methods and Quotes

August 9, 2013
PHP provides a large number of predefined constants to any script which it runs.There are seven magical constants that change depending on where they are used. For example, the value of __LINE__ depends on the line that it’s used on in your script. These special constants are case-insensitive and are as follows:
Read more..