Articles tagged with #php




Put CalDav Events to Calendar in PHP

Toying around with php and pushing events at first seems a bit advanced. However after some digging around it turns out to be quite simple concept. First you must create a string containing an iCalendar format. Then push the contents of that file to the server with fsockopen or curl …



jQuery Litelighter - Light Weight Syntax Highlighter

Need a super light weight syntax highlighter for jQuery? This is it, jQuery Litelighter. It's extremely small, and very easy to use and extend. It has a fully functional api. It comes with two themes built in, and 4 languages: Javascript, Html, CSS, and Generic C-like syntax for C, C …



Using Subqueries as Fields in CakePHP

From time to time when querying the database, you have to break the mold. CakePHP gives many options when it comes to complex conditions, but sometimes you need to push the boundaries. Recently I needed to return a subquery as a field name. It wasn't a high demand query, so …



Install PHP Pear Spreadsheet in Ubuntu and Mint

If you've ever had to work with spreadsheets on a linux system, you may have stumbled across the PEAR Excel Spreadsheet Writer. Its a quite useful too, but installing it on your system may be a little misleading. Here's the quick rundown: # install php-pear sudo apt-get install php-pear # install PEAR …



Return Multiple Result Sets with PHP and PostgreSQL Functions

A while back I discussed how to use the new sqlsrv extension for php to retrieve multiple result sets at a time from stored proceedures. This was indeed helpful when you need to retrieve related data and avoid multiple calls to stored proceedures. The down side is this was using …



Inspect and Debug with Email Dissector

Everyone needs to test emails for web applications, but it turns your inbox into a mess. Not to mention constantly refreshing your web mail and clicking Send/Receive. You struggle to find the broken html, and viewing your text and html alternate versions just takes too much time. This is …



Making Sense of Stored Procedures with PHP, PDO, and Sqlsrv

Stored Procedures seem to be a rare bird in web development. But one thing is for sure, when you need them, its likely critical. With the last few versions of PHP we have some new arrivals: Sqlsrv data base extension for SQL Server, and PDO. While they don't still have …



PHP MSSQL Charset Issues, Resolved

Recently I had an annoying little bug. Of course against the golden rule of php I was developing with SQL Server and using php's mssql functions. All was working well except there were a few records which had special characters within the returned result which php complained about: Some character …



ColdFusion Style Dumps in PHP

Just wondering around the internet and one site led to another when I tripped over a nice debugging utility that creates ColdFusion style dumps. Its called dBug. The syntax is pretty darn simple. Of course make sure the dBug class file is included, then just create an instance of the …



Incorporating Regex into ORM's and Database Abstractions

Almost on a daily basis I come across using regular expressions rather convenient. I first toyed with regular expressions in my Compiler Design classes during my undergrad studies, and little did I know they can be used for everyday things like submitting forms. I've even toyed with them to create …