EyedMax’s Pit

If you love Robot Chicken, you must love this one:

Stupid Monkey!

Popularity: 35%

My Logitech keyboard was fed with a half cup of cofee - while typing previous post…
Now I’m waiting for response

Popularity: 2%

Hmmmm…
The previous piece of code is a scrap if you have to deal with MySql4 server with all-defaults.
So… I continued my challenge - I want my data back (and workin’) Stay tuned for next round…

P.S. For MySql5 all works great…

Popularity: 12%

Situation: you have MySQL 5 database with tables which claimed to have Latin1 charset. You filled the base (with MySQL Front, PhpMyAdmin or any other tool) with info. There IS non alnum chars (like TM, (c), long –, ellipsis etc.)

Now you want it back, and your pages are utf-8 encoded, but when you queries the base, �??’ sign returned instead of your cute symbols. Shit.

Never mind, if you can see those chars with PhpMyAdmin – I’ll help you to convert them to use them.

First, mysql5 seems to be utf-8 lover (even if other charset is claimed). So – it’s simple. Just exec SET NAMES utf8 right after database initialisation.

Second, query all the data you need into array.

Third, just do utf8_encode on data with your loved scrap

Forth, exec SET NAMES latin1

Fifth – write your data back

Sixth – tell your application to use utf8_decode when reading and utf8_encode when writing those data.

That’s all – now you can easilly transfer your data to MySQL4* or MySQL5 servers – and your app will work there!

Example:

// init skipped 
 
/*********************************** 
 * Database connect 
 **********************************/ 
$o_db = new myDB(DB::connect(DB_DSN)); 
$o_db->db_setFetchMode(DB_FETCHMODE_ASSOC); 
$o_db->db_query('SET NAMES utf8'); 
 
$q = 'SELECT page_id, page_head_title, page_head_description, page_head_keywords 
  FROM '.DB_PREFIX.'pages 
'; 
foreach ($page as $k => $p) 
  foreach (array('page_head_title', 'page_head_description', 'page_head_keywords') as $field) 
    $page[$k][$field] = utf8_encode($p[$field]); 
$o_db->db_query('SET NAMES latin1'); 
 
foreach ($page as $p) 
{ 
  $up = 'UPDATE '.DB_PREFIX.'pages 
    SET 
    page_head_title = '.$o_db->db_quote($p['page_head_title']).', 
    page_head_description = '.$o_db->db_quote($p['page_head_description']).', 
    page_head_keywords = '.$o_db->db_quote($p['page_head_keywords']).', 
    WHERE page_id = '.$o_db->db_quote($p['page_id']).' 
  '; 
  $o_db->db_query($up); 
}

*see next post

Popularity: 11%

Oops, WordPress 2.2.1 is out, and I’m still not ready!

Ok, I upgraded all the blogs with my plugs, and let’s see what happens.

Popularity: 2%

Yesterday I had an car-crash accident. I was in a bus, I stayed and played Solitaire on my phone. The bus crashed into another vehicle, then into the shop. Brain shaking did not happen, because i haven’t one

And I’m happy – I’m alive

And this chinese guy is much lucky and happier than I

Popularity: 2%

Why always they think that coding - it’s an instant process?

Just another little quote:

We were under the understanding that coding would have been complete and we were to have seen your work late last week

Yeah, right. Do you mean next week?

Popularity: 8%