Snippet PHP unzipper

PHP >= 5.2

<?php $zip = new ZipArchive; $zip->open(‘fileToUnzip.zip’); $zip->extractTo(‘./’); $zip->close();

Fastest way to switch profiles on Google Chrome

Once there was a time when Google Chrome was user friendly…

Then came the new ‘profile switcher logic’ monster … it encountered the profile icon on the cosy left side of the title bar, swallowed it and moved itself somewhere to that odd place on the right side of the title bar… making the mouse distance almost a search for the holy grail and forcing you with that extra click to move your pointer to the ‘switch person’ link and then continuing the mouse travel to the ‘what’s your quest’ bridgekeeper.

But then suddenly a fairy came by and accidently

Continue reading Fastest way to switch profiles on Google Chrome

Getting started with WAMP: setting up

Memory exhausted problem

“Allowed memory size of 134217728 bytes exhausted” I encountered this problem a few times, and setting memory_limit to a higher value didn’t seem to work

In php.ini: memory_limit = -1;

Changing www root on WAMP

Open httpd.conf

Change

Listen 0.0.0.0:80 Listen [::0]:80

to

Listen 127.0.0.1:80 Listen [::1]:80

Change

DocumentRoot "C:/wamp/www/"

to

DocumentRoot "C:/Users/name/Sites/localhostwamp/"

Change

</pre> <Directory "C:/wamp/www/"> <pre>

to

</pre> <Directory "C:/Users/…/Sites/localhostwamp/"> <pre> Setting mySQL password

go to shell (right click mysql shell in taskbar)

update mysql.user set Password = password(‘yourPasword’) where User = ‘root’; flush privileges;

go to phpmyadmin directory c:\…\wamp2.5\apps\phpmyadmin4.1.14\config.inc.php

replace:

$cfg[‘Servers’][$i][‘auth_type’] = ‘config’; $cfg[‘Servers’][$i][‘user’]

Continue reading Getting started with WAMP: setting up

[SOLVED] XAMPP Row size too large, innoDB sql import

Ran into some problems recently with XAMPP. Exported a large mySQL production database and tried to import it locally in XAMPP (through Shell access).

Error: ERROR 1118 <42000> at line 437919: Row size too large <> 8126>. Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

First I tried changing table to ROW_FORMAT=COMPRESSED doing so:

ALTER TABLE <tablename> ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

No success with that. Then I changed innodb_buffer_pool_size to 32MB (default setting was 8 or 16) in my.ini (mySQL config file in

Continue reading [SOLVED] XAMPP Row size too large, innoDB sql import

Winamp 5.666 change media library location

One of my previous posts guided you to the process of moving your library location from drive X to drive Y with the aid of a HEX-editor. This was tested for Winamp version 5.61. It was a rather complex approach, since iTunes XML import did not work in that version.

I have tested this again with Winamp version 5.666 and XML export/import works perfectly.

  • Make a backup copy of your Winamp profile (c:\Users\<USERNAME>\AppData\Roaming\Winamp\*)
  • Open Winamp
  • Remove everything from your current playlist
  • On the media library tab, click local library
  • Click

    Continue reading Winamp 5.666 change media library location

PHP UTF8 test-template (jQuery, Bootstrap)

This is just a webdevelopment template for PHP (all errors, xdebug), HTML, jQuery, Bootstrap (UTF8 encoding).

<?php ini_set(‘display_errors’ , ‘On’); error_reporting(E_ALL); session_start(); header("Content-Type:text/html;charset=utf-8"); ini_set(‘xdebug.var_display_max_depth’, -1); ini_set(‘xdebug.var_display_max_children’, -1); ini_set(‘xdebug.var_display_max_data’, -1); ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>…</title> <script src="//code.jquery.com/jquery-1.11.2.min.js"></script> <script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script> <link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet"> <script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script> </script> </head> <body> </body> </html>

30 tips voor de dodentocht

Volg me op Twitter @JanVerkoyen en krijg de laatste dagen voor de start van de dodentocht nog 30 tips mee.

Jammergenoeg kan ik er zelf niet bij zijn dit jaar, maar ik hoop dat mijn ervaringen jou te hulp kunnen schieten. Veel succes!

Mijn twee uitgebreide verslagen van succesvolle tochten vind je in 2008 en 2009, maar ook die van 2007 waar ik vlak voor 50km op een domme manier opgaf.

Move your music library from Winamp to iTunes

In a previous post I helped you to switch your music library from iTunes to Winamp, without losing any metadata (such as last play date, play count, rating…). Now Winamp has stopped releasing new versions, some might want to switch back sooner or later. I’ve made the switch as a kind of experiment to see whether it would be possible to keep (the most valuable metadata). iTunes won’t be able to please me in the near future, but as time goes by, it might be the only easy way to sync with my old iPod Classic and iPad.

What do

Continue reading Move your music library from Winamp to iTunes

Facebook in perspectief

Net neutrality, and why it matters

The Document That Could Change the Internet Forever (Mashable, 20140515)