I recently had an issue sending the right headers to let IE8 know to go ahead and download a file, in this case a PDF. If you’re running into the same issue, make sure you send the following headers, at a minimum: Pragma: public Expires: 0 Cache-Control: private And then …
As we all know, one of the best ways to prevent SQL injection attacks in PHP (or any server side language for that matter) is to use parameterized queries. But how do you parameterize a WHERE … IN clause? One way is to use a user-defined function. The below example …
For a particular project, there was a need to embed some sort of barcode in a few business forms (sales order, invoice, etc), which are generated by SSRS (Microsoft’s reporting server). I decided to standardize on QR code because of the quick readability on smart phones, which will eventually be …
Here’s a method of redirecting http to https. Put the following in the directive, or in the .htaccess file in the root web directory: RewriteEngine on RewriteCond %{SERVER_PORT} !443 RewriteRule ^(.*)$ https://www.example.com/$1 [R=301,L]
Here’s a cool technique I learned from a colleague during my development at work. It basically gets a list of files from find and for each <filename>.<extension> found, searches for <search string>. You also have to option to include (exclude?) an <exclude path>. Syntax: find <start path> -name <filename>.<extension> -exec grep -li …
Blocks are simply a way of creating callback code at the time of invocation. The structure is actually very similar to how typically I would create functions in Javascript. Take the following block example in Objective-C: int (^Multiply)(int, int) = ^(int num1, int num2) { return num1 * num2; }; …
I use cron a lot in conjunction with PHP to manage my jobs on the server. So, as many PHP programmers know, the lynx text-based browser is an invaluable tool. You may encounter a situation where you’ll need to feed data from one PHP file to another via GET or …
It’s important to note that in Javascript, when you set new variable to an existing array or object, the new variable will be a reference to the original array or object. So, if there are any changes to the original array or object, these will be reflected in the new …
Here’s a method of detecting which browser you’re using and whether you’re on a mobile or desktop platform: <script type=”text/javascript”> <!– var userAgent = navigator.userAgent || window.navigator.userAgent; var nav = navigator || window.navigator; var isDesktop = nav[‘platform’].match(/(Mac|Win|Linux)/) && !userAgent.match(/Android/); if (isDesktop) { alert(“You’re on a Desktop!”); }; –> </script> Need …
Here’s a method of generating a dynamic pivot of a dataset. It first generates the columns as a string (“[ColumnHeader0],[ColumnHeader1],[ColumnHeader2], …” format), builds a dynamic SQL string and executes it using the PIVOT expression. From the code below, the @cols variable is generated by using the FOR XML PATH expression. …