Vancouver Web Consultants

November 9, 2009

Triggering File Downloads with jQuery

Filed under: Tutorials, jQuery — Tags: , , , — Nelson @ 11:56 am

jQuery Download CSV

I previously posted this method for Mootools, and now here it is for jQuery.

Clients often ask to have a sorted list exportable via a link to a CSV file that they can open in Excel or whatever spreadsheet software they use. I could find two jQuery plugins for exporting table data to Excel, but I wasn’t comfortable with their reliance on producing popups (that could easily be blocked), or sending data as a querystring to a javascript function that sorts and formats the CSV. Here is a simple, plugin free way of asynchronously generating a .csv file using jQuery and PHP.

(more…)

July 10, 2009

Validating a URI with PHP

Filed under: PHP — Tags: , — Nelson @ 4:34 pm

If you find yourself needing to validate a URI, not just checking that it’s well formed with a regular expression like this:

/^(http|https|ftp):\/\/([A-Z0-9][A-Z0-9_-]*(?:\.[A-Z0-9][A-Z0-9_-]*)+):?(\d+)?\/?/i

…but actually verifying that the URI points to a functioning web page, the following code will do the trick. (more…)

June 5, 2009

Secure Javascript Form Validation with Mootools

Filed under: Mootools, Tutorials, Usability — Tags: , , , — Nelson @ 8:33 am

Did I get you with the title? That’s right, it’s not possible to securely validate a form with Javascript. That is, you can’t prevent invalid data from being submitted to the server by using Javascript for validation. We’ve all seen Javascript-based form validation classes (and classes for Javascript libraries like Mootools, which is my favourite, so I’ll be making reference to it here), but it’s all too often not made clear enough to those who might use such classes that javascript validation alone provides no security against invalid data being sent to your back-end processing script and making it into your database.

(more…)

Powered by WordPress