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

How to Embed Arrays, $_POST, and $_GET Directly in a PHP String (SQL Query)

Over the past few days, while writing a small program, I ran into a problem. I wanted to put a $_POST variable directly into my SQL query string instead of using the concatenation operator. But because of quoting issues, it took me quite a while to figure out how. Here is a brief introduction. I also want to thank Bu and Cang Shixian for teaching me this method! If it weren’t for them, I might still not know about it. Also, this method isn’t limited to $_POST; it works with other arrays too. ...

Programming
#PHP #SQL
August 1, 2011 · 2 min

[iOS App] SyncSpace: A Handy Synced Whiteboard and Handwritten Note App

 Several years ago, I remember reading in a magazine about so-called “distance learning,” which uses information technology so that students can take classes without going to school. SyncSpace, the app I’m introducing today, is quite similar to distance learning. It’s an app made exclusively for iPad, and its main function is a synced whiteboard! Over the internet, it lets many iPads sync with each other. For example, if you write an A on your screen, other users who have joined the same whiteboard will see an A appear on their iPads. This can be used in many places, such as the distance learning I just mentioned. Or, say you’re a business owner who suddenly comes up with an idea while on a business trip. You can use SyncSpace to jot it down right away, then sync it back to the office. ...

Software
#IOS #App Store
July 29, 2011 · 3 min

Did You Know You Can Write Evernote Notes Through Twitter?

Today I’m sharing a neat trick: writing notes directly on Twitter. I got the idea from Plurk. Lots of people like to reply “note” to Plurk posts when they come across gossip or news, so I started wondering whether notes and microblogging could be combined. After looking into it, I found that they can! The well-known Evernote offers a similar feature. Just follow its official Twitter account, and it checks your tweets and does the note-taking for you. Even if you don’t use Twitter, that’s fine. Several sites, including Facebook and Plurk, can sync their content to Twitter! ...

Web Apps
#Twitter #Evernote
July 27, 2011 · 2 min

TinyUmbrella Helps You Back Up the SHSH of Your iPad and iPhone for Downgrading

Sometimes when you want to downgrade your iPad or iPhone (hereafter iOS Device), you find that the downgrade keeps failing. This is because newer iOS devices have a built-in protection mechanism that blocks you from downgrading the device. This design exists to prevent users from jailbreaking. When a new iOS version comes out, some people accidentally tap update… Usually the latest iOS version cannot be jailbroken, so users who have updated can only downgrade in order to jailbreak. This is when a big problem appears: you cannot downgrade…… The TinyUmbrella introduced today is software that can help you downgrade successfully. It can back up something called SHSH for you. Once you have backed up the SHSH, you can downgrade successfully~ ...

Hardware
#IOS #Jailbreak
July 26, 2011 · 2 min

How to Compute an MD5 Hash in VB.NET (System.Security.Cryptography)

Recently I was writing a password generator and needed to compute an MD5 hash. In PHP I can just call md5() to get an MD5 hash, but I had never actually tried MD5 in VB. I was worried that .NET might not have any MD5 support, in which case I would have to write it myself…. Orz. Luckily, when I checked MSDN, it turned out to be there. The process was a bit of a hassle, but fortunately MSDN provides a getMD5hash function, so I simply reused it. ...

Programming
#VB #.NET #MD5
July 26, 2011 · 2 min

Solving Pascal's Triangle with a Formula! (Thanks to Cang Hai)

The image above is from Wikipedia and is used to explain Pascal’s triangle. Today’s topic is the so-called Pascal’s triangle. Some people also call it Yang Hui’s triangle or Jia Xian’s triangle. The first row’s first entry is “1”. Each number below equals the sum of the number to its upper left and the number to its upper right. If there is no number to the upper left or upper right, it counts as 0. For example, the second row has two numbers, “1, 1”. The third row is “1, 2, 1”. And this triangle can extend infinitely. ...

Programming
#Math #PHP
July 24, 2011 · 2 min

Poedit: A Handy Helper for Multilingual (GNU Gettext) Work

Today I want to introduce a very handy tool for making multilingual software: Poedit. I think many people have come across the term “Chinese localization” online, right? In short, Poedit is a program that helps you with localization work. In Taiwan this kind of work is called “Chinese localization,” but in other countries it could be called “English localization” or “Japanese localization,” so the general term for all of these is “multilingualization”~ ...

Software
#Gettext
July 21, 2011 · 4 min

doPDF: Easily Convert Documents and Web Pages to PDF

Sometimes we want to convert a Word document into PDF format, or we come across something funny or useful online that we want to keep. That’s when you’ll use doPDF! Unlike ordinary conversion software, which requires opening a main program, doPDF works through “printing.” Normally, when you print a file, you get a physical document, but with doPDF, “printing” produces a PDF file instead. ...

Software
#PDF
July 21, 2011 · 2 min

[Android] Zhengdian Toolbox – Battery, Data Usage, App Lock, App Management, and More Essential Tools in One Install!

 Zhengdian Toolbox really is handy! It bundles the features that most Android users need, including data usage, app lock, and app management, and you can put its widget on your home screen for quick management. Things that would normally require installing a bunch of separate apps, it handles all at once! This is very convenient for people who just got an Android phone, since they don’t need to download a pile of apps to get the everyday features working~ And even though it packs in so many features, the app itself is only about 2 MB. ...

Software
#Android
July 20, 2011 · 3 min

Quickly Building a Multilingual Program with Gettext for PHP

Gettext is a… um, I’m not sure how to describe it. It’s something like a specification, but it’s also a set of libraries. Anyway, it makes it easy to make your program multilingual~ This article is about using Gettext with PHP to develop multilingual programs and websites. ...

Programming
#PHP #Gettext
July 18, 2011 · 4 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