While you can easily fabricate your own functions to do this element by element, you can simply resort to the php function array_change_key_case() to do it for you: $new_array = array_change_key_case($old_array, CASE_UPPER); Changes all the keys in $old_array to upper case and $new_array = array_change_key_case($old_array, CASE_LOWER); Changes all the keys in $old_array to lower case.
Array is probably the simplest compound data type every language supports. It’s basically a set of ordered values (text strings, numbers or booleans and even a child array). You can create an array in PHP by: $companies = array(‘Microsoft’, ‘Google’, ‘IBM’, ‘Apple’); Now array $companies contains 4 text string values. You can append one more …
Every HTTP requests made by any client web browsers to an Apache should conform to the HTTP specification and provide certain set of headers information for the server to parse and understand. Useful headers information that can be retrieved in PHP by function apache_request_headers() includes: User-Agent: Operating System, browser and its version number, … Accept-Language: …
Apache, PHP: Get Client Browser HTTP Request Headers Information Read More »
To get the PHP version as well as the Apache version of the current host build, you will need the PHP function apache_get_version(): $ver = apache_get_version(); Sample output: Apache/2.2.6 (Win32) PHP/5.2.5 Which returns a string containing the Apache version number (2.2.6) as well as that of PHP (5.2.5). You can also get the PHP version …
Apache, PHP: Function to Get and Return PHP Version Number and Apache Version Read More »
Sometimes you will need to detect if a certain Apache module is installed dynamically from PHP so as to determine for proper actions to take. For example, if you write inherent functionalities for optional SEO friendly URLs, you will want to know if the client host has the famous Apache module mod_rewrite installed and enabled, …
2 functions exist in PHP to convert special characters to HTML entities (a kind of representations defined as in XML for web client such as browsers to recognize and render as special characters such as a spade: â™ , which can be represented as ♠ in HTML), namely htmlspecialchars() and htmlentities(). But what’s the difference? The …
PHP: Difference between htmlspecialchars() and htmlentities() Functions Read More »
A number’s absolute value is the distance from the origin of the axis to itself. In PHP, you can get the absolute value of any numeric value by the help of abs() function: $a = abs(-19.7); // $a = 19.7
The open_basedir directive in php.ini limits PHP file accesses (such as file opening, writing and deleting) within a designated directory such as /home/www/public_html so that it doesn’t endanger the rest of the system in any way. With proper Apache permissions and PHP installed as an Apache module, PHP inherits whatever privileges Apache has. As Apache …
Well it depends on the Linux distribution you are using, the version of php and the way you install it with Apache web server. Php.ini may be here: /etc/php.ini Or here: /etc/php/php.ini /etc/php5/php.ini Or here: /usr/bin/php5/bin/php.ini Anyway, you can always find any file named php.ini in this manner find / -name php.ini The simplest yet …
Ctrl+S happens to be a rather handy and popular combination as it’s used in Windows applications to save your current working data. I accidentally used it several times in Vim and it keeps locking the screen up and halting the interactivity — basically, after Ctrl+S I can’t do anything to the terminal (window). I use …
Accidental Ctrl+S Locks and Freezes Linux Terminal / SSH / Telnet Read More »
Unbuntu has auto-configured Vim to use syntax highlighting for text (mostly, programs and configuration files of course) editing, the problem however, is that some of the colors appear to be darker than wanted on SSH console and it’s a little hard to recognize comfortably. So how can we change the default colors of the syntax …
Unmanaged hosting provided by Rackspace acquisition Mosso, Cloud Servers can be really a bargain considering their dedicated support and ease of use from the control panel. The pain lies in the server administration and stuff which I’m still learning my ropes with. But hey, for less than $15 a month, it’s fun! I’ll throw in …
Back when WordPress was pretty young there’s some loopholes that enable hackers to inject unauthorized and dangerous HTML code into your website pages, thus promoting the distribution of malware that damages the end users computer. I was once there and got penalized by Google for one of my sites. However, they are gentle enough to …
A quick tip — I kind of have the feeling that I’ve covered this before, but whatever — well, just the simple SQL query below will do: CREATE TABLE temp SELECT id, COUNT(id) FROM `book` GROUP BY isbn, subject HAVING COUNT(id) > 1 Wherein each combination of column isbn and column subject in each of …
Today I’m optimizing some MySQL tables with large number of records — 1 million of them, yeah, I know — , it’s simply impossible to deal with such big chunks of data without proper indexing. So there I was, adding a variety of indexes to a few of the columns. It’s expected it’d take a …
MySQL: Huge Table Not Responding after Adding Index Read More »
PHP can execute shell commands, which means it can compress selected files into a archive or zipped package: exec(‘tar zcf files.tar.gz file1 file2 file3’); Or make a zip file: exec(‘zip files.zip file1 file2 file3’); You can then use PHP to render and supply download of the zip file to your visitor.
There are times when you need to store a file (such as one that you sell for profit) outside of the document root of your domain and let the buyers download it via a PHP script so as to hide the real path, web address or URL to that file. Use of this approach enables …
PHP: Hide the Real File URL and Provide Download via a PHP Script Read More »
Well, MySQL doesn’t actually have anything called Foreign Key, it’s just my way of saying a alien column from another table. Let’s say 2 tables are related, 1 is books and the other is subjects. Any book in book table falls into one of the subjects, thus having a subject column referencing the ID of …
MySQL: Counting Number of Records or Rows by a Foreign Column (from Another Table) Read More »
As MySQL doesn’t have inherent support for updating more than one rows or records with a single update query as it does for insert query, in a situation which needs us to perform updating to tens of thousands or even millions of records, one update query for each row seems to be too much. Reducing …
MySQL: Update Multiple Rows or Records with One Single Query Read More »
To find / identify a part of an original string and replace it with another string in a SQL query with MySQL, use REPLACE(), the string replace function. For example, you may want to replace all spaces in one of the varchar or text fields to a single dash: UPDATE `table` SET `old_field` = REPLACE(`old_field`, …
MySQL: Replace Substring with Another String – the MySQL String Replace Function Read More »
