Lin's Blog
|
  • Zh-Tw
  • Ja
  • Posts
  • Categories
  • About

SQL Notes: The Difference Between the ` and ' Symbols

Recently, while writing a program in PHP, I ran into some SQL code, so I looked into it a bit and discovered something beginners easily get wrong: the ` and ’ symbols do different things. When I didn’t know this, and the book’s print was small, it took me two hours to find out it was this small problem…. So I wrote this post to tell everyone that these two really are different. ...

Programming
#SQL
February 11, 2011 · 1 min

Code::Blocks 10.05 - A C/C++ Compiler That Rivals Dev C++, Cross-Platform (Ubuntu, Windows, Mac)

I'm sure you know the Dev C++ compiler. Many schools use it as the platform for teaching C. For example, the computer classes at Taiwan's top high schools seem to use it. But here I want to introduce not Dev C++, but Code::Blocks. Code::Blocks and Dev C++ are both compilers for C (both C and C++). However, if you have been following Dev C++, you may have noticed that it has not been updated in a long time. Code::Blocks is free and open source, just like Dev C++, but it also supports multiple operating systems, including Windows and Linux. So if you want to write C programs on Ubuntu, you can try this software. This tutorial is for Windows only. ...

Programming
#C++ #IDE
February 11, 2011 · 3 min

How to Read Windows Environment Variables (System Variables) in a .NET Program - VB.NET Example

Anyone who has written CMD knows about environment variables. They let you easily get information that differs from one computer to another, such as the user name. In CMD, using an environment variable is simple: you just write it in the %environment variable name% format. In a .NET program, though, it isn't that simple. You need to use the Environ function. ...

Programming
#VB #.NET #Windows
February 11, 2011 · 2 min

OpenHardwareMonitor: Check the Temperature of Your Hard Drive, Graphics Card, and CPU

After a painful experience where my graphics card gave off a burning smell and I found out it had died, I realized the hardware temperature program I was using wasn't enough. It could only detect CPU temperature. So I went looking for something else and found OpenHardwareMonitor. It can read the temperatures of many components in your computer, such as the hard drive, graphics card, CPU, and motherboard, and it can also plot temperature changes as a chart or export them to a file....

Hardware
#PC Hardware #Temperature
February 11, 2011 · 2 min

[VPS] Tips for Buying a VPS, and a Recommended Provider: PhotonVPS

In this article, I'll show you how to choose a VPS. For an explanation of what a VPS is, see [VPS] What Is a VPS? What Are the Benefits of Using One?. This article also introduces PhotonVPS, the provider I'm currently using. If you're thinking about buying a VPS, you might want to give it a try~ ...

SRE
#VPS
February 9, 2011 · 6 min

[Android] Barcode Scanner – A Handy QR Code Reader for Quickly Installing Android Apps

You often see people recommend Android apps online without giving a URL, just a barcode to scan for the download. That barcode is actually a QR Code, and a decoder app on Android can read the download link stored inside it. Apple Daily’s Animated News app also offers a square barcode like this. It’s also a QR Code, so you need special software to decode it into a URL. ...

Software
#Android #QR Code
February 7, 2011 · 2 min

[VPS] What Is a VPS? What Are the Benefits of Using One?

If you've been reading this site's "About" page, or following me on Plurk and Facebook, you'll know this site recently switched to a VPS~ In fact, it's been about three weeks since the switch. On the day I switched, I meant to write a post introducing VPS, but midterms were coming up and I didn't have time. After midterms, I went back to classes at Beishang, and I kept putting it off until now, when I finally have time to write this. 0.0...

SRE
#VPS
February 5, 2011 · 10 min

[PHP] mb_convert_encoding: Some API Returned the Wrong Encoding? Convert It!

↑↑This is viewed in Chrome with Big5 encoding. The top is before conversion, and the bottom is after conversion. Yesterday, while playing with the Google Weather API, I found that it has a parameter for setting your language. If you don’t set it, the API returns English in UTF-8 encoding. But if you set zh-TW, it returns Chinese, encoded in Big5. So when using this API, I had to re-encode its return value to UTF-8 before I could use it. After all, there aren’t many Big5 websites left, so yesterday I went looking for the mb_convert_encoding function to do the encoding conversion for me~ ...

Programming
#PHP #Encoding
February 4, 2011 · 2 min

Google Weather API - Get a Full Week of Weather Data

Google Weather API is something I discovered today. I wanted to add a weather lookup feature to the Plurk bot I've been developing recently, so I searched online for ways to get weather data. My original plan was to read the Central Weather Bureau's web pages and parse the data there. But then I found that both Google and Yahoo offer weather APIs. I preferred the Google Weather API, because it returns XML, which is easier to parse. Yahoo, on the other hand, returns HTML... Also, the Google Weather API lets you specify a city name directly. For example, if I want the weather for Taipei City, I just pass "Taipei" to the API. Yahoo's weather API isn't that simple, though. You have to enter a city code, which means I'd need to look up the code for the city I want before I could use Yahoo's API. ...

Programming
#Google API #PHP
February 4, 2011 · 2 min

How to Install and Uninstall Android Apps (Android Market Tutorial)

Most of the well-known smartphones today have a built-in market. For example, iOS has the App Store and Cydia, and Android has the Android Market. A market makes it easy to install programs on your phone or tablet, and the process is simple: installing an app takes little more than a tap of a finger. Today I'll introduce the market built into the Android operating system. Recently, the Android Market released a new version that changed the trial period for apps to 15 minutes. The interface was also completely overhauled and looks much better than before....

Hardware
#Android
February 3, 2011 · 2 min
« Prev  Next 

Categories

All Programming AI SRE Life Hardware Software Blog Travel Web Apps Games Security
© 2026 Lin's Blog · Powered by Hugo & PaperMod