Lol what a surprise..

Byemino Wednesday December 11th, 2013Saturday June 6th, 2015

I’ve been pulling my hair why my custom cursor wouldnt work. Turns out, IE (yes, big surprise) takes site url instead of stylesheet as baseurl when it comes to cursors.

Coding

Change all mysql db tables and sub tables collation to utf8
Byemino Thursday August 27th, 2015

SELECT CONCAT(‘ALTER TABLE `’, TABLE_NAME,’` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;’) AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= “myschema” AND TABLE_TYPE=”BASE TABLE” Change “myschema” to your db_name , phpmyadmin will print out the commands you need to run… If any of them are trimmed with a “…” click “print view” select all commands and run.

Read More Change all mysql db tables and sub tables collation to utf8
Note to self | wordpress

Page template pagination fix
Byemino Friday February 7th, 2014Saturday June 6th, 2015

If you are using “page-template”s you’ll have problems with pagination since pages are not meant to display posts and some people frown upon using page-templates for custom archive display, but it’s sometimes the simplest way. Anyway the solution is 1.) to nullify the global $wpquery 2.) adding ‘paged’ => $paged arg. before displaying your posts…

Read More Page template pagination fix
Coding | Note to self

Türkçe karakter sayım problemleri
Byemino Tuesday December 10th, 2013Saturday June 6th, 2015

Türkçe veya diğer özel -multibyte- karakterler için malesef PHP str_word_count(), strlen() gibi fonksiyonlarda yanlış sayım veriyor, her özel karakter 2 kelime / karakter sayılıyor. Bunu aşmak için iconv() transliteration da denedim ama kâr etmedi. Araştırmalarımda da tek -garanti- çözümün şüpheli karakterleri replace etmek olduğunu buldum ama her Türkçe karakteri (ve muhtemel diğer yabancı karakterleri) hardcode…

Read More Türkçe karakter sayım problemleri
Coding | Note to self

Local timestamp problem
Byemino Tuesday December 10th, 2013Saturday June 6th, 2015

Always check for local time Despite the fact that my server timezone was set correctly, somehow time() was giving wrong ( UTC) hour. So i ended up using wp’s functions to make sure. $now = current_time( ‘timestamp’, 0 ) ;$local_ts = get_the_time(‘U’,$post->ID);

Read More Local timestamp problem
Note to self | wordpress

You can not use conditional tags on init
Byemino Saturday February 1st, 2014Saturday June 6th, 2015

Queries are only available after “wp” action hook, so ‘init’ is too early to check for it.

Read More You can not use conditional tags on init
Coding | Note to self

Problems with multibyte characters
Byemino Tuesday December 10th, 2013Saturday June 6th, 2015

There are mb_strlen() and mb_substr() for multibyte characters however there is no mb_str_word_count. Hence my previous post.

Read More Problems with multibyte characters

Similar Posts

Leave a Reply Cancel reply