<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-6263492266218651079</id><updated>2024-08-30T06:52:20.801+07:00</updated><category term="myself"/><category term="Apple iPhone"/><category term="MySQL"/><category term="blogger"/><category term="introduction"/><category term="optimization"/><category term="query"/><category term="unlocking"/><title type='text'>Sikachu!&#39;s Playground</title><subtitle type='html'>Just a blog of a crazy web programmer</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>5</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-6263492266218651079.post-1127356407689773284</id><published>2007-10-01T00:55:00.000+07:00</published><updated>2007-10-01T01:21:55.660+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apple iPhone"/><category scheme="http://www.blogger.com/atom/ns#" term="unlocking"/><title type='text'>Wait for iPhone to be able to unlock again</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji8L1UPtRt9KSb3_qUEr7OJuveOruart5OD9yhZtXgbZetWiaLWFv_0q7-fmYGrppee0v_kJqHh_JZuUPmg8nB3sdAIYPlrlCUOIF69ALe5Z1XP1abSNrKzyp_XGCfcWavnB0pyQ9v6alt/s1600-h/unlocked-iphone-new.jpg&quot;&gt;&lt;img style=&quot;float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji8L1UPtRt9KSb3_qUEr7OJuveOruart5OD9yhZtXgbZetWiaLWFv_0q7-fmYGrppee0v_kJqHh_JZuUPmg8nB3sdAIYPlrlCUOIF69ALe5Z1XP1abSNrKzyp_XGCfcWavnB0pyQ9v6alt/s320/unlocked-iphone-new.jpg&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5116064120995080578&quot; /&gt;&lt;/a&gt;&lt;br /&gt;I wish I could be in US, since Apple still puts a lock on iPhone with AT&amp;T carrier. It&#39;s some kind of pain about I can&#39;t use that phone in Thailand when it first came available.&lt;br /&gt;&lt;br /&gt;My hope was got up when unlock software first became available last two or three weeks. I think I would come and get one from US, unlock it, then use it in Thailand. I was so excited, since I don&#39;t have to wait until next year to use it.&lt;br /&gt;&lt;br /&gt;Well, seems out that party didn&#39;t last that long. Apple posted a firmware update with version 1.1.1. That firmware update kills homebrew apps and so the unlocking software. So, apparently nobody can use the phone with another carrier except AT&amp;T for the time being.&lt;br /&gt;&lt;br /&gt;Come on guys, get another unlocking software available. I want to play with this kid real bad!</content><link rel='replies' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/1127356407689773284/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/6263492266218651079/1127356407689773284' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/1127356407689773284'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/1127356407689773284'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/2007/10/wait-for-iphone-to-be-able-to-unlock.html' title='Wait for iPhone to be able to unlock again'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji8L1UPtRt9KSb3_qUEr7OJuveOruart5OD9yhZtXgbZetWiaLWFv_0q7-fmYGrppee0v_kJqHh_JZuUPmg8nB3sdAIYPlrlCUOIF69ALe5Z1XP1abSNrKzyp_XGCfcWavnB0pyQ9v6alt/s72-c/unlocked-iphone-new.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6263492266218651079.post-4959851542218023370</id><published>2007-06-21T03:48:00.000+07:00</published><updated>2007-06-21T03:59:32.287+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MySQL"/><category scheme="http://www.blogger.com/atom/ns#" term="optimization"/><category scheme="http://www.blogger.com/atom/ns#" term="query"/><title type='text'>How to get number of rows in MySQL while using LIMIT cause</title><content type='html'>Normally, in MySQL, if you want to get number of rows to render page list while limit the output to pages, you would have to execute them as two queries like these:&lt;br /&gt;&lt;br /&gt;&lt;pre&gt;SELECT COUNT(*) FROM foo WHERE bar = 1&lt;br /&gt;SELECT * FROM foo WHERE bar = 1 LIMIT 15&lt;/pre&gt;&lt;br /&gt;&lt;br /&gt;However, I was curious about how to optimize this process. I think there must be a better way that I can count the number of rows that matching my condition and limiting number of rows returned at the same time.&lt;br /&gt;&lt;br /&gt;After I google a bit, I found the answer using &lt;code&gt;SQL_CALC_FOUND_ROWS&lt;/code&gt;. I think this is better than the above example.&lt;br /&gt;&lt;br /&gt;&lt;pre&gt;SELECT SQL_CALC_FOUND_ROWS * FROM foo WHERE bar = 1 LIMIT 15&lt;br /&gt;SELECT FOUND_ROWS();&lt;/pre&gt;&lt;br /&gt;&lt;br /&gt;Thanks &lt;a href=&quot;http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-using-limit.html&quot; target=&quot;_blank&quot;&gt;Array Studio Workshop&lt;/a&gt; for this wonderful tip!</content><link rel='replies' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/4959851542218023370/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/6263492266218651079/4959851542218023370' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/4959851542218023370'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/4959851542218023370'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/2007/06/how-to-get-number-of-rows-in-mysql.html' title='How to get number of rows in MySQL while using LIMIT cause'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6263492266218651079.post-6467890028367856963</id><published>2007-06-15T02:35:00.000+07:00</published><updated>2007-06-20T18:01:48.063+07:00</updated><title type='text'>My 10 reasons why I switched to mac</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtDX6DhGufcaUCKarmfFv02sbumaXzjcynPiIteSl_MyHRNCbAtbzQ8yAbEBW8WRREUA2f6tInOJ5Wc-m7P_8t04GDljo3jVop-MU21pTfWw8XyI4PXXg4H2hnbmXKSmDYIfqAUKDrAXpr/s1600-h/applelogo.gif&quot;&gt;&lt;img style=&quot;float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtDX6DhGufcaUCKarmfFv02sbumaXzjcynPiIteSl_MyHRNCbAtbzQ8yAbEBW8WRREUA2f6tInOJ5Wc-m7P_8t04GDljo3jVop-MU21pTfWw8XyI4PXXg4H2hnbmXKSmDYIfqAUKDrAXpr/s320/applelogo.gif&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5076008063437243138&quot; /&gt;&lt;/a&gt;&lt;br /&gt;I think everybody has a reason on why they do such thing. After 3 months of switching to my first mac, I think this is the time that I should shout to the world what&#39;s my decision to do such thing, without looking back!&lt;br /&gt;&lt;br /&gt;&lt;b&gt;1. I write platform-independent program&lt;/b&gt;&lt;br /&gt;I&#39;m a PHP programmer, and PHP is platform-independent. So, it means that I don&#39;t have to stick around only one OS to write my code. There&#39;re so many IDEs and editors for PHP avaliable today on every platform, and my favorite is &lt;a href=&quot;www.zend.com&quot; target=&quot;_blank&quot;&gt;Zend Studio&lt;/a&gt;. I think Zend Studio did a really great job as an IDE for PHP programmer. I think it also make my website becoming web-standard, since I have more concern on running it on Firefox and Safari, not only in IE as usual.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;2. Java is so slow on Windows&lt;/b&gt;&lt;br /&gt;As I mentioned above, I use Zend as my main IDE for my development. I used to use Zend under Windows. However, it usually took forever for IDE window to refresh. After I tried Zend Studio on the mac, the speed is so fast! I don&#39;t think I want to go back and use Zend on Windows anymore!&lt;br /&gt;&lt;br /&gt;&lt;b&gt;3. I love OSX interfaces&lt;/b&gt;&lt;br /&gt;Someone said that, the more great working environment, the more productivity will be. I love Aqua style of Mac OSX. I think it gives me a lot of idea on how to implements a wonderful program interface, because even you didn&#39;t do anything fancy with the CSS by the way, it would still looks great when you open it on Safari.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;4. It&#39;s secure (I think)&lt;/b&gt;&lt;br /&gt;I had an experience when I was in sophomore. My friend own a notebook with lots of viruses and connected to the same AP as I did. What was the result? His notebook was trying to spawn viruses on my computer. However, on the mac, I really doesn&#39;t have to care about that at all.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;5. Everything is so simple&lt;/b&gt;&lt;br /&gt;I remembered once when I have to install some program and I have to wait around 30 min for the installation of that program to complete. On mac, I just download that program as disk image, mount it, drag it to my Application folder, eject that image, and that&#39;s it! Also, when I want to uninstall that program, I just drag it to the trash and it just gone. No worry about leftover DLL and stuff.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;6. Exposé&lt;/b&gt;&lt;br /&gt;I like to open more than 3 apps one time. How would you navigate between applications? Alt+Tab? There&#39;s a thing on the mac called Exposé which will preview all windows which are currently open. I love to press F9 and navigate to the application I like on that way!&lt;br /&gt;&lt;br /&gt;&lt;b&gt;7. Spotlight&lt;/b&gt;&lt;br /&gt;It&#39;s such a killer feature of OS X Tiger. I usually save my work in the well-organized folder. However, sometime I can&#39;t say it &#39;well&#39; organized because I couldn&#39;t find the file I want. However, after I have Spotlight, I don&#39;t have that problem anymore. I just press the shortcut to bring Spotlight on, type the file name in, and my file is in the list! It&#39;s such an easy way to find stuff in computer.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;8. I can live on the same world with Windows&lt;/b&gt;&lt;br /&gt;All of my friend still using Microsoft Windows. If I made a switch, I still have to be able to share my file with them. Mac OS X allows me to do that. I can turn on Windows File Sharing, and my friend would see my computer as if it&#39;s Windows computer. It&#39;s just so compatible.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;9. I love the machine design&lt;/b&gt;&lt;br /&gt;I can&#39;t resist that, I was impressed by mac because of its design. I&#39;m using Macbook Pro since I love its aluminium case. I don&#39;t really taking care of my notebook very well, so if I use an aluminium-case notebook, I don&#39;t have to worry about the scratches anymore. It&#39;s so-good.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;10. Everything!&lt;/b&gt;&lt;br /&gt;I don&#39;t know, I think from the first day that I switched to mac, I think my life couldn&#39;t be more wonderful than this. I love to work on my machine, carry it with my anywhere, as it is my own child! I think this switching is worth, and I won&#39;t look back to get a Windows PC for a long long time. ;-)</content><link rel='replies' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/6467890028367856963/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/6263492266218651079/6467890028367856963' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/6467890028367856963'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/6467890028367856963'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/2007/06/my-10-reasons-why-i-switched-to-mac.html' title='My 10 reasons why I switched to mac'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtDX6DhGufcaUCKarmfFv02sbumaXzjcynPiIteSl_MyHRNCbAtbzQ8yAbEBW8WRREUA2f6tInOJ5Wc-m7P_8t04GDljo3jVop-MU21pTfWw8XyI4PXXg4H2hnbmXKSmDYIfqAUKDrAXpr/s72-c/applelogo.gif" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6263492266218651079.post-3506275967204852605</id><published>2007-06-05T23:47:00.000+07:00</published><updated>2007-06-20T16:53:55.052+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="blogger"/><category scheme="http://www.blogger.com/atom/ns#" term="myself"/><title type='text'>No free Blogger desktop blog-posting client?</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAqCIbhwVGWiWfX4tw9h56mNaOWXzii1cwmwIn5FwtiY0zxO3tvIHEq8MLpkEEQAiw4ViA1U1WlPmya4X9rr7nalXHzh6tNzUnJass6OIqpX61a3293g2eZ1rv8VlXDgNamrl3Jzv6IZNB/s1600-h/money.jpg&quot;&gt;&lt;img style=&quot;float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAqCIbhwVGWiWfX4tw9h56mNaOWXzii1cwmwIn5FwtiY0zxO3tvIHEq8MLpkEEQAiw4ViA1U1WlPmya4X9rr7nalXHzh6tNzUnJass6OIqpX61a3293g2eZ1rv8VlXDgNamrl3Jzv6IZNB/s320/money.jpg&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5072630243457630962&quot; /&gt;&lt;/a&gt;&lt;br /&gt;I have looked at the list of the third-party apps in Blogger&#39;s Help page today for a blog-posting client which I can use it on my mac. However, I couldn&#39;t find any of them to be freeware. So, I think I&#39;ll have to open Safari every time I want to publish my blog.&lt;br /&gt;&lt;br /&gt;I wish I could write one application like this by myself ..&lt;br /&gt;&lt;br /&gt;&lt;b&gt;UPDATE: &lt;/b&gt; I was able to find Blogger widget on Blogger&#39;s front page. However, the widget doesn&#39;t have a field to tag my post. So, for now, I would still have to update this blog on Safari ..</content><link rel='replies' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/3506275967204852605/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/6263492266218651079/3506275967204852605' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/3506275967204852605'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/3506275967204852605'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/2007/06/no-free-blogger-desktop-blog-posting.html' title='No free Blogger desktop blog-posting client?'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAqCIbhwVGWiWfX4tw9h56mNaOWXzii1cwmwIn5FwtiY0zxO3tvIHEq8MLpkEEQAiw4ViA1U1WlPmya4X9rr7nalXHzh6tNzUnJass6OIqpX61a3293g2eZ1rv8VlXDgNamrl3Jzv6IZNB/s72-c/money.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6263492266218651079.post-5914463606319485013</id><published>2007-05-24T17:27:00.000+07:00</published><updated>2007-05-25T21:00:57.788+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="introduction"/><category scheme="http://www.blogger.com/atom/ns#" term="myself"/><title type='text'>My playground!</title><content type='html'>Hello and welcome to my playground !!&lt;br /&gt;&lt;br /&gt;My name is Sikachu, and I&#39;m a PHP web developer.&lt;br /&gt;I&#39;m currently a junior at KMITL, with Computer Science as my major.&lt;br /&gt;So, my interests would be everything about web programming and algorithm stuff.&lt;br /&gt;&lt;br /&gt;Currently I&#39;m interest in writing a PHP code, but I think no later than next month I would point my interest to Ruby On Rails (RoR). I have read the books about it, and I think it&#39;s a good language to learn. I looked at current Rails examples, and I think I like it! I think I would study this one for my another programming language. Yes, BTW, I won&#39;t throw my PHP skill away for sure!&lt;br /&gt;&lt;br /&gt;I&#39;ll keep posting interesting stuff about programming and computer here, so stay tuned!</content><link rel='replies' type='application/atom+xml' href='http://sikachu-playground.blogspot.com/feeds/5914463606319485013/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/6263492266218651079/5914463606319485013' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/5914463606319485013'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6263492266218651079/posts/default/5914463606319485013'/><link rel='alternate' type='text/html' href='http://sikachu-playground.blogspot.com/2007/05/my-playground.html' title='My playground!'/><author><name>Sikachu!</name><uri>http://www.blogger.com/profile/12579256401970240428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOQv-FIGOOhVz6tBzVepNSq-WBDxyt6OypKVWWSVb8rykGkVe8jLZSI67h97mkcumguuzTk81LzVi_y9v4OPZ6npyzrZO_0T0H-6-QqlweO-Q45SV_VYUa0Ju5c-_kSEc/s220/+.JPG'/></author><thr:total>0</thr:total></entry></feed>