MySQL Affected Rows vs Rows Matched
PHP’s mysql_affected_rows() is used to get the number of rows that were “affected” by the last query executed using mysql_query(). Therefore, an UPDATE query that set the value of a …
Preventing Duplicate Local Names with Zip Archive
When creating a zip archive with PHP’s ZipArchive utility, you have the option of specifying a local name for each file so that when the zip is downloaded and extracted, …
Secure Password Encryption using BCrypt with PHP
Implementing login functionality in your application comes with the responsibility of securely storing your users’ passwords in your database. Storing the password as plain text is highly irresponsible since a …
Getting the Name of a Font from a TTF, OTF File
Font files such as TTF and OTF have metadata embedded in them with information such as the font’s name, what font family it belongs to and so forth. I wrote …
Calculating Dimensions of a Rotated Rectangle in PHP
When you rotate a rectangle, you might want to find the bounding box that the rotated rectangle is contained in. The code below will give you the width and height …
Find What Word Occurs First Inside a String
From a list of words, we want to find what word occurrs first inside a given input string. Solution
Android Uploading a File to a PHP Server
The following script allows you to upload a file from your Android application by sending the file to the PHP server, which can then save the file to the disk. …
Merging CSS Files Into One File / Browser Call
In order to decrease page loading time, it is wise to combine all CSS that is loaded on a page into a single file so that the browser has to …
Using PHP Variables in .htaccess
My solution to using PHP variables in the .htaccess file was to create a htaccess.php file which would write the .htaccess file whenever needed. htaccess.php
PHP Date Format vs MySQL Date Format
Today I had the pleasure of discovering (through an hour of annoying debugging) that PHP’s formatting of dates is not exactly identical to MySQL’s date formatting. I was using a …