[PHP] How to list files in a directory
The glob() function is used to get an array of filenames or directories. Then, array_multisort() function is sorting filenames according to the file’s created time. Lastly, it can be presented as intended with foreach looping.
[DB] How to select random rows from a table
It is needed to select some records randomly to take sample data from a table. MySQL can accomplish this task by using rand() function in order by clause as below. In case selecting 20 users randomly. In case it has to be ordered by name
[PHP] How to Upload a file
Not like any other post variables, file element information is posted as two dimensional array. So, getting post data for a file element can be accomplished as below.
[Story] Janitor’s Key Box
As a time patroller, we are supposed to carry this collection of keys all the time. This collection contains all of keys used on every computer on Earth and we call it Janitor’s key box. After patrol duty is over, we are supposed to cross check our JKB to the master copy of JKB to […]
[Story] Push pin
“Father! I crafted the Universe but I am not able to hang it in space.” “Son! Ask your mom for a help.” “Mom! How to hang the Universe in space.” “Son! Use one or two of push pins. They are in the drawer labelled as ‘Black hole’.” “Mom! I found them. I may use two […]
[PHP] mail accented or special characters in subject field
The problem I had was that email with French subject was sent with no subject. Because subject field is one part of header in email, accented characters in header seemed to cause problem. First attempt to fix this problem was to encode the subject field in unicode as below but the issue persisted. [code language=”PHP”] […]
[PHP] How to retrieve credit card payment reports from Bambora
First of all, make sure if API access passcode under “administration -> account settings -> order settings” is generated and obtainable. Payment reports are retrieved by transaction dates. So, it should be cross checked with local DB transaction data in order to get one transaction information out of order number, customer’s name or other information […]
[PHP] How to upload a file to other server using POST method with CURL
For me, it was required to send a uploaded file on application server to web server So, I googled, tested and implemented this solution. Basically, this is not purely my work as usual as. First, make sure CURL is installed on your PHP. Installation might be different according your setup. From Server will have a page like […]
[DB] How to sort non-numeric field numerically in MySQL
It is common to store numeric values on Varchar or non-numeric field for developer’s convenience. However, it can cause a problem when sorting. For example, 10 comes prior to 9 when sorted. Here are three tricks thatcan be found on various websites as below. 1. Casting It is possible to sort while casting non-numeric value […]
[OS] How to enable CUPS Printer Web Interface on Mac
First, try to go to the link as below. [code] http://localhost:631/printers/ [/code] If the link does not work, open terminal and type the command as below. [code] $sudo cupsctl WebInterface=yes [/code] Then, you will be able to see printers on your machine.