Earlier, say 1.5 years back I have created a project in cakephp and my experience is good with CakePHP.Now when i try to create another project with cakePHP version 1.2 i am unable to do that. I unable to generate files from console it is giving me error regarding PHP that some of the functions ...Read more..
Only three steps are require to remove index.php from url in Codeigniter in WAMP environment. 1) Create .htacess file in parallel to application holder and just copy past the following code:Read more..
You can write query in number of ways, but i list few of them which are easy to write and understand. Mysql having advantage of writing query with “limit”, by which you can handle start and end point.Read more..
After a long time i used variable in SQL queries. This time i have to calculate time/days difference between added date of a particular news and current date, so that viewers get how old a particular news is.Read more..
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..
A way to delimit strings is the heredoc syntax:Read more..
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..
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..
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 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..