Category Archives: PHP & MySQL

Category of post related to PHP & MySQL developement

Generate random birth date in MySQL table and get Age by select

Posted on July 23, 2011 by Lukáš Gavenda

Today I was solving generating of random data for testing and manipulation with the date of the birth. Here are two simple SQL queries solving both: Query for generate random date of birth in whole table UPDATE people SET date_of_birth=CONCAT_WS(‘-’,(FLOOR( … Continue reading →

Posted in MySQL, PHP & MySQL | Leave a comment

Joomla: get category ID in template

Posted on May 16, 2011 by Lukáš Gavenda

I just needed to specify special layout for the articles of selected categories. I was looking for some solution online, but none of them worked. Mostly you can find this: JRequest::getInt(‘catid’); or JRequest::getInt(‘catid’, ”, ‘get’);

Posted in Joomla | Tagged , , , , , | 4 Comments

Magento: Changing Tax class on all products

Posted on May 3, 2011 by Lukáš Gavenda

I was just asked to update tax classes on products in the catalogue. I found a easy and fast solution.

Posted in Magento | Tagged , , , , , , , | Leave a comment

SOLVED: Magento keeps logging out from administration

Posted on January 3, 2011 by Lukáš Gavenda

I just spent couple of hours by finding out, why is my Magento administration logging me out after moving my Magento store to new server. I found many hacks, modification and setup tips on the Google, but anything helped to … Continue reading →

Posted in Magento | Tagged , , , , , , , , | 22 Comments

Google Maps API & PHP+MySQL – working with radius and distance

Posted on June 6, 2010 by Lukáš Gavenda

I needed to find out how to work with Google Geo API in my last project and especially with calculating a radius and distance between two geo points. Another goal was to get a latitude and longtitude from the address … Continue reading →

Posted in Google, PHP & MySQL, Tutorials & guides | Tagged , , , | 1 Comment

MySQL visual database design

Posted on December 4, 2009 by Lukáš Gavenda

I was looking for some nice freeware visual mysql database designer couple of weeks ago. I found two of them: DBDesigner 4 and MySQL Workbench. I must say, that both programs are really very similar, I mean from the view … Continue reading →

Posted in PHP & MySQL | Tagged , , | Leave a comment

MySQL WITH ROLLUP modifier

Posted on November 30, 2009 by Lukáš Gavenda

Yesterday, I was solving simple database Query, where I needed to get some specific data. And while browsing thru MySQL documentation I found a very nice GROUP BY modifier which allows me make less queries and save some CPU on … Continue reading →

Posted in PHP & MySQL | Tagged , | Leave a comment