Set mysql password after install

March 23rd, 2011 | posted in Tips & Tricks, blog | No Comments »
mysqladmin -u root password new-password

Formatting date values returned from MYSQL table to more readable format including time

March 1st, 2011 | posted in PHP, Tips & Tricks, blog | No Comments »
echo date("d-m-Y : G-i",strtotime('2011-02-26 09:47:11');

Easiest “check all” with jQuery

January 13th, 2011 | posted in Tips & Tricks, blog, jQuery | No Comments »

The jquery code:

<script type="text/javascript">
$(function () {
    $('.checkall').click(function () {
        $('.chk').attr('checked', this.checked);
    });
});
</script>

The html:

<input type="checkbox" class="checkall"/>
<input type="checkbox" value="1" class="chk"/>
<input type="checkbox" value="2" class="chk"/>
<input type="checkbox" value="3" class="chk"/>
<input type="checkbox" value="4" class="chk"/>

No sound in Pidgin in openSuse 11.2

August 3rd, 2010 | posted in Linux, Tips & Tricks, blog | 1 Comment »

If none of the options available produce sound in Pidgin, choose command and enter aplay %s.



CSS shorthands

December 8th, 2009 | posted in Tips & Tricks, blog | No Comments »

There is no official documentation about CSS shorthands but they are there and some of you know them, some of you not. I tried to make a list of CSS shorthands, that may be of use by anyone.

Read the rest of this entry »

Extend phpMyAdmin Session Timeout Value

December 8th, 2009 | posted in Tips & Tricks, blog | 1 Comment »

Locate your phpmyadmin installation folder. Then open config.inc.php file and enter this line:

$cfg['LoginCookieValidity'] = 3600 * 3;

This line of code extends your phpmyadmin session for 3 hours.

Make sure your config.inc.php file is writable, to do this change. Then you can make it unwritable again.